******************************************************************************** conan test conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/conanfile.py sqlpp11-connector-sqlite3/0.29@#34f1594a8105508d70eb54fe63a91413 -pr /home/conan/w/prod/BuildSingleReference/168206/975141b1-9d94-46dd-a4af-5cbb421384e5/profile_linux_8_libstdcpp11_gcc_release_64.sqlpp11-connector-sqlite3-shared-True.txt -c tools.system.package_manager:mode=install -c tools.system.package_manager:sudo=True ******************************************************************************** Auto detecting your dev setup to initialize the default profile (/home/conan/w/prod/BuildSingleReference/.conan/profiles/default) CC and CXX: /usr/bin/gcc, /usr/bin/g++ Found gcc 8 gcc>=5, using the major as version ************************* WARNING: GCC OLD ABI COMPATIBILITY *********************** Conan detected a GCC version > 5 but has adjusted the 'compiler.libcxx' setting to 'libstdc++' for backwards compatibility. Your compiler is likely using the new CXX11 ABI by default (libstdc++11). If you want Conan to use the new ABI for the default profile, run: $ conan profile update settings.compiler.libcxx=libstdc++11 default Or edit '/home/conan/w/prod/BuildSingleReference/.conan/profiles/default' and set compiler.libcxx=libstdc++11 ************************************************************************************ Default settings os=Linux os_build=Linux arch=x86_64 arch_build=x86_64 compiler=gcc compiler.version=8 compiler.libcxx=libstdc++ build_type=Release *** You can change them in /home/conan/w/prod/BuildSingleReference/.conan/profiles/default *** *** Or override with -s compiler='other' -s ...s*** Configuration: [settings] arch=x86_64 build_type=Release compiler=gcc compiler.libcxx=libstdc++11 compiler.version=8 os=Linux [options] sqlpp11-connector-sqlite3:shared=True [build_requires] [env] [conf] tools.system.package_manager:mode=install tools.system.package_manager:sudo=True sqlpp11/0.60: Not found in local cache, looking in remotes... sqlpp11/0.60: Trying with 'conan-center'... Downloading conanmanifest.txt Downloading conanfile.py Downloading conan_export.tgz sqlpp11/0.60: Downloaded recipe revision 3fcea908a72d6072db3dc7d8d1128753 date/3.0.1: Not found in local cache, looking in remotes... date/3.0.1: Trying with 'conan-center'... Downloading conanmanifest.txt Downloading conanfile.py Downloading conan_export.tgz date/3.0.1: Downloaded recipe revision 431370df1649196d8f2401534b06f90e libcurl/7.78.0: Not found in local cache, looking in remotes... libcurl/7.78.0: Trying with 'conan-center'... Downloading conanmanifest.txt Downloading conanfile.py Downloading conan_export.tgz libcurl/7.78.0: Downloaded recipe revision 96feb2b7c3aa83560f35f5338ac4aac1 openssl/1.1.1s: Not found in local cache, looking in remotes... openssl/1.1.1s: Trying with 'conan-center'... Downloading conanmanifest.txt Downloading conanfile.py Downloading conan_export.tgz openssl/1.1.1s: Downloaded recipe revision c6838ae653d103956aec228f7642c45a zlib/1.2.13: Not found in local cache, looking in remotes... zlib/1.2.13: Trying with 'conan-center'... Downloading conanmanifest.txt Downloading conanfile.py Downloading conan_export.tgz zlib/1.2.13: Downloaded recipe revision 13c96f538b52e1600c40b88994de240f sqlite3/3.40.1: Not found in local cache, looking in remotes... sqlite3/3.40.1: Trying with 'conan-center'... Downloading conanmanifest.txt Downloading conanfile.py Downloading conan_export.tgz sqlite3/3.40.1: Downloaded recipe revision 5cf44326389f75cd72c9b4510ed9f763 sqlpp11-connector-sqlite3/0.29 (test package): Installing package Requirements date/3.0.1 from 'conan-center' - Downloaded libcurl/7.78.0 from 'conan-center' - Downloaded openssl/1.1.1s from 'conan-center' - Downloaded sqlite3/3.40.1 from 'conan-center' - Downloaded sqlpp11/0.60 from 'conan-center' - Downloaded sqlpp11-connector-sqlite3/0.29 from local cache - Cache zlib/1.2.13 from 'conan-center' - Downloaded Packages date/3.0.1:2128dc8289b2d6a1e26080ad13bbb0aa4e561d82 - Download libcurl/7.78.0:015f97075b6c2ac297ea689620e576be75fd93ed - Download openssl/1.1.1s:1d877a3df840030e6a8abb74c5ffb9088d08b47a - Download sqlite3/3.40.1:a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8 - Download sqlpp11/0.60:5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9 - Download sqlpp11-connector-sqlite3/0.29:270effa39ab4c35a45f36d3d7d5efc19a95a9f8b - Download zlib/1.2.13:1d877a3df840030e6a8abb74c5ffb9088d08b47a - Download Installing (downloading, building) binaries... openssl/1.1.1s: Retrieving package 1d877a3df840030e6a8abb74c5ffb9088d08b47a from remote 'conan-center' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz openssl/1.1.1s: Package installed 1d877a3df840030e6a8abb74c5ffb9088d08b47a openssl/1.1.1s: Downloaded package revision 3c14faf6eb9ee210a21128c7e1b2265b sqlite3/3.40.1: Retrieving package a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8 from remote 'conan-center' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz sqlite3/3.40.1: Package installed a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8 sqlite3/3.40.1: Downloaded package revision cdc783c45bc8e72e7b67bcf2fd218eb6 zlib/1.2.13: Retrieving package 1d877a3df840030e6a8abb74c5ffb9088d08b47a from remote 'conan-center' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz zlib/1.2.13: Package installed 1d877a3df840030e6a8abb74c5ffb9088d08b47a zlib/1.2.13: Downloaded package revision b7bfcb69a497a9ffb5a039df8fe78ddd libcurl/7.78.0: Retrieving package 015f97075b6c2ac297ea689620e576be75fd93ed from remote 'conan-center' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz libcurl/7.78.0: Package installed 015f97075b6c2ac297ea689620e576be75fd93ed libcurl/7.78.0: Downloaded package revision 1a5a21161aedd63b53325d79db019b02 date/3.0.1: Retrieving package 2128dc8289b2d6a1e26080ad13bbb0aa4e561d82 from remote 'conan-center' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz date/3.0.1: Package installed 2128dc8289b2d6a1e26080ad13bbb0aa4e561d82 date/3.0.1: Downloaded package revision 990ffe9d6726e20ac37b329e13b6e8f1 sqlpp11/0.60: Retrieving package 5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9 from remote 'conan-center' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz sqlpp11/0.60: Package installed 5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9 sqlpp11/0.60: Downloaded package revision 1a0d5ae3b1f01ba58b000e9479052991 sqlpp11-connector-sqlite3/0.29: Retrieving package 270effa39ab4c35a45f36d3d7d5efc19a95a9f8b from remote 'c3i_PR-15582' Downloading conanmanifest.txt Downloading conaninfo.txt Downloading conan_package.tgz sqlpp11-connector-sqlite3/0.29: Package installed 270effa39ab4c35a45f36d3d7d5efc19a95a9f8b sqlpp11-connector-sqlite3/0.29: Downloaded package revision 0a6cb7deb37826ec66432713066cbcbd sqlite3/3.40.1: Appending PATH env var with : /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/bin sqlpp11/0.60: Appending PATH environment variable: /home/conan/w/prod/BuildSingleReference/.conan/data/sqlpp11/0.60/_/_/package/5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9/bin sqlpp11-connector-sqlite3/0.29 (test package): Generator 'CMakeDeps' calling 'generate()' sqlpp11-connector-sqlite3/0.29 (test package): Generator 'CMakeToolchain' calling 'generate()' sqlpp11-connector-sqlite3/0.29 (test package): Preset 'release' added to CMakePresets.json. Invoke it manually using 'cmake --preset release' sqlpp11-connector-sqlite3/0.29 (test package): If your CMake version is not compatible with CMakePresets (<3.19) call cmake like: 'cmake -G "Unix Makefiles" -DCMAKE_TOOLCHAIN_FILE=/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release/generators/conan_toolchain.cmake -DCMAKE_POLICY_DEFAULT_CMP0091=NEW -DCMAKE_BUILD_TYPE=Release' sqlpp11-connector-sqlite3/0.29 (test package): Generator txt created conanbuildinfo.txt sqlpp11-connector-sqlite3/0.29 (test package): Generator 'VirtualRunEnv' calling 'generate()' sqlpp11-connector-sqlite3/0.29 (test package): Aggregating env generators sqlpp11-connector-sqlite3/0.29 (test package): Generated conaninfo.txt sqlpp11-connector-sqlite3/0.29 (test package): Generated graphinfo Using lockfile: '/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release/generators/conan.lock' Using cached profile from lockfile [HOOK - conan-center.py] pre_build(): [FPIC MANAGEMENT (KB-H007)] 'fPIC' option not found [HOOK - conan-center.py] pre_build(): [FPIC MANAGEMENT (KB-H007)] OK sqlpp11-connector-sqlite3/0.29 (test package): Calling build() sqlpp11-connector-sqlite3/0.29 (test package): CMake command: cmake -G "Unix Makefiles" -DCMAKE_TOOLCHAIN_FILE="/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release/generators/conan_toolchain.cmake" -DCMAKE_POLICY_DEFAULT_CMP0091="NEW" -DCMAKE_BUILD_TYPE="Release" "/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/." ----Running------ > cmake -G "Unix Makefiles" -DCMAKE_TOOLCHAIN_FILE="/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release/generators/conan_toolchain.cmake" -DCMAKE_POLICY_DEFAULT_CMP0091="NEW" -DCMAKE_BUILD_TYPE="Release" "/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/." ----------------- -- Using Conan toolchain: /home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release/generators/conan_toolchain.cmake -- The CXX compiler identification is GNU 8.4.0 -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Check for working CXX compiler: /usr/bin/g++ - skipped -- Detecting CXX compile features -- Detecting CXX compile features - done -- Conan: Target declared 'sqlpp11-connector-sqlite3::sqlpp11-connector-sqlite3' -- Conan: Target declared 'sqlpp11::sqlpp11' -- Conan: Component target declared 'date::date-tz' -- Conan: Target declared 'date::date' -- Conan: Component target declared 'CURL::libcurl' -- Conan: Component target declared 'OpenSSL::Crypto' -- Conan: Component target declared 'OpenSSL::SSL' -- Conan: Target declared 'openssl::openssl' -- Conan: Including build module from '/home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/cmake/conan-official-openssl-variables.cmake' -- Conan: Target declared 'ZLIB::ZLIB' -- Conan: Component target declared 'SQLite::SQLite3' -- Configuring done -- Generating done -- Build files have been written to: /home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release sqlpp11-connector-sqlite3/0.29 (test package): CMake command: cmake --build "/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release" '--' '-j3' ----Running------ > cmake --build "/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release" '--' '-j3' ----------------- Scanning dependencies of target test_package [ 50%] Building CXX object CMakeFiles/test_package.dir/test_package.cpp.o [100%] Linking CXX executable test_package [100%] Built target test_package sqlpp11-connector-sqlite3/0.29 (test package): Running test() ----Running------ > . "/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/Release/generators/conanrun.sh" && ./test_package ----------------- Last Insert ID: 1 Last Insert ID: 2 1, 0 2, 0 3, 0 sqlpp11-connector-sqlite3/0.29 (test package): database is not encrypted Sqlite3 debug: Preparing: 'CREATE TABLE tab_sample ( alpha INTEGER PRIMARY KEY, beta varchar(255) DEFAULT NULL, gamma bool DEFAULT NULL )' Sqlite3 debug: Preparing: 'CREATE TABLE tab_foo ( omega bigint(20) DEFAULT NULL )' Sqlite3 debug: Preparing: 'DELETE FROM tab_sample' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x559126614f90 Sqlite3 debug: Accessing next row of handle at 0x559126614f90 /home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/test_package.cpp: 73 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55912663a120 Sqlite3 debug: Accessing next row of handle at 0x55912663a120 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma,tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x559126614f90 Sqlite3 debug: Accessing next row of handle at 0x559126614f90 no of required columns: 0 Sqlite3 debug: Preparing: 'INSERT INTO tab_sample DEFAULT VALUES' Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (gamma) VALUES(1)' Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (gamma,beta) VALUES(1,'')' Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=0 WHERE tab_sample.alpha IN(1)' Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=0 WHERE tab_sample.alpha IN(1,2,3,4)' Sqlite3 debug: Preparing: 'DELETE FROM tab_sample WHERE (tab_sample.alpha=(tab_sample.alpha+3))' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55912663aac0 Sqlite3 debug: Accessing next row of handle at 0x55912663aac0 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Accessing a field directly from the result (using the current row): 1 Can do that again, no problem: 1 Sqlite3 debug: Preparing: 'BEGIN' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma,(SELECT MAX(tab_foo.omega) AS max_ FROM tab_foo WHERE (tab_foo.omega>tab_sample.alpha)) FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55912663aaa0 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Sqlite3 debug: binding integral result 0 at index: 3 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: binding integral result 1 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Sqlite3 debug: binding integral result 0 at index: 3 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: binding integral result 2 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Sqlite3 debug: binding integral result 0 at index: 3 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: Preparing: 'COMMIT' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha FROM tab_sample INNER JOIN tab_foo ON (tab_sample.alpha=tab_foo.omega)' Sqlite3 debug: Constructing bind result, using handle at 0x55912663a140 Sqlite3 debug: Accessing next row of handle at 0x55912663a140 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha FROM tab_sample LEFT OUTER JOIN tab_foo ON (tab_sample.alpha=tab_foo.omega)' Sqlite3 debug: Constructing bind result, using handle at 0x55912663aaa0 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: binding integral result 0 at index: 0 1 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: binding integral result 1 at index: 0 2 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: binding integral result 2 at index: 0 3 Sqlite3 debug: Accessing next row of handle at 0x55912663aaa0 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample WHERE (((tab_sample.alpha<>?1) AND (tab_sample.beta<>?2)) AND (tab_sample.gamma<>?3))' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55912663a140 Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding integral parameter 7 at index: 0, being not null Sqlite3 debug: binding text parameter wurzelbrunft at index: 1, being not null Sqlite3 debug: binding boolean parameter true at index: 2, being not null Sqlite3 debug: Constructing bind result, using handle at 0x55912663a140 Sqlite3 debug: Accessing next row of handle at 0x55912663a140 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 bound result: alpha: 3 bound result: beta: bound result: gamma: 0 Sqlite3 debug: Accessing next row of handle at 0x55912663a140 -------- Sqlite3 debug: Preparing: 'SELECT last_insert_rowid() AS a' Sqlite3 debug: Constructing bind result, using handle at 0x559126639ac0 Sqlite3 debug: Accessing next row of handle at 0x559126639ac0 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding integral parameter 3 at index: 0, being not null Sqlite3 debug: binding text parameter wurzelbrunft at index: 1, being not null Sqlite3 debug: binding boolean parameter true at index: 2, being not null Sqlite3 debug: Constructing bind result, using handle at 0x55912663a140 Sqlite3 debug: Accessing next row of handle at 0x55912663a140 -------- Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding integral parameter 3 at index: 0, being not null Sqlite3 debug: binding text parameter kaesekuchen at index: 1, being not null Sqlite3 debug: binding boolean parameter true at index: 2, being not null Sqlite3 debug: Constructing bind result, using handle at 0x55912663a140 Sqlite3 debug: Accessing next row of handle at 0x55912663a140 Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (beta,gamma) VALUES(?1,1)' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55912663d6c0 Inserted: Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null 4 Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=?1 WHERE (tab_sample.beta='prepared cake')' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55912663d700 Updated: Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding boolean parameter false at index: 0, being not null 4 Sqlite3 debug: Preparing: 'DELETE FROM tab_sample WHERE (tab_sample.beta<>?1)' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55912663d720 Deleted lines: Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null 4 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample WHERE ((tab_sample.beta LIKE(?1) AND (tab_sample.alpha=?2)) OR (tab_sample.gamma<>?3))' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55912663d760 Sqlite3 debug: Preparing: 'INSERT OR REPLACE INTO tab_sample (beta,gamma) VALUES('test',1)' 5 Sqlite3 debug: Preparing: 'INSERT OR IGNORE INTO tab_sample (beta,gamma) VALUES('test',1)' 6 Sqlite3 debug: Preparing: 'PRAGMA user_version = 1' Sqlite3 debug: Preparing: ' PRAGMA user_version' Sqlite3 debug: Constructing bind result, using handle at 0x55912663d760 Sqlite3 debug: Accessing next row of handle at 0x55912663d760 Sqlite3 debug: binding integral result 0 at index: 0 1 Sqlite3 debug: Preparing: 'SELECT sub.alpha FROM (SELECT tab_sample.alpha FROM tab_sample) AS sub' Sqlite3 debug: Constructing bind result, using handle at 0x559126639700 Sqlite3 debug: Accessing next row of handle at 0x559126639700 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x559126639700 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x559126639700 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x559126639700 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x559126639700 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x559126639700 Sqlite3 debug: Preparing: 'SELECT sub.alpha FROM tab_sample INNER JOIN (SELECT tab_sample.alpha FROM tab_sample) AS sub' Sqlite3 debug: Constructing bind result, using handle at 0x55912663a180 Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55912663a180 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55912663a180 sqlpp11-connector-sqlite3/0.29 (test package): WARN: Using the new toolchains and generators without specifying a build profile (e.g: -pr:b=default) is discouraged and might cause failures and unexpected behavior sqlpp11-connector-sqlite3/0.29 (test package): WARN: Using the new toolchains and generators without specifying a build profile (e.g: -pr:b=default) is discouraged and might cause failures and unexpected behavior ******************************************************************************** conan test conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/conanfile.py sqlpp11-connector-sqlite3/0.29@#34f1594a8105508d70eb54fe63a91413 -pr /home/conan/w/prod/BuildSingleReference/168206/975141b1-9d94-46dd-a4af-5cbb421384e5/profile_linux_8_libstdcpp11_gcc_release_64.sqlpp11-connector-sqlite3-shared-True.txt -c tools.system.package_manager:mode=install -c tools.system.package_manager:sudo=True ******************************************************************************** Configuration: [settings] arch=x86_64 build_type=Release compiler=gcc compiler.libcxx=libstdc++11 compiler.version=8 os=Linux [options] sqlpp11-connector-sqlite3:shared=True [build_requires] [env] [conf] tools.system.package_manager:mode=install tools.system.package_manager:sudo=True sqlpp11-connector-sqlite3/0.29 (test package): Installing package Requirements date/3.0.1 from 'conan-center' - Cache libcurl/7.78.0 from 'conan-center' - Cache openssl/1.1.1s from 'conan-center' - Cache sqlite3/3.40.1 from 'conan-center' - Cache sqlpp11/0.60 from 'conan-center' - Cache sqlpp11-connector-sqlite3/0.29 from local cache - Cache zlib/1.2.13 from 'conan-center' - Cache Packages date/3.0.1:2128dc8289b2d6a1e26080ad13bbb0aa4e561d82 - Cache libcurl/7.78.0:015f97075b6c2ac297ea689620e576be75fd93ed - Cache openssl/1.1.1s:1d877a3df840030e6a8abb74c5ffb9088d08b47a - Cache sqlite3/3.40.1:a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8 - Cache sqlpp11/0.60:5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9 - Cache sqlpp11-connector-sqlite3/0.29:270effa39ab4c35a45f36d3d7d5efc19a95a9f8b - Cache zlib/1.2.13:1d877a3df840030e6a8abb74c5ffb9088d08b47a - Cache Installing (downloading, building) binaries... openssl/1.1.1s: Already installed! sqlite3/3.40.1: Already installed! sqlite3/3.40.1: Appending PATH env var with : /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/bin zlib/1.2.13: Already installed! libcurl/7.78.0: Already installed! date/3.0.1: Already installed! sqlpp11/0.60: Already installed! sqlpp11/0.60: Appending PATH environment variable: /home/conan/w/prod/BuildSingleReference/.conan/data/sqlpp11/0.60/_/_/package/5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9/bin sqlpp11-connector-sqlite3/0.29: Already installed! sqlpp11-connector-sqlite3/0.29 (test package): Generator txt created conanbuildinfo.txt sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3-config-version.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3-config.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3Targets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3Target-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created Sqlpp11ConfigVersion.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created Sqlpp11Config.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created Sqlpp11Targets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created Sqlpp11Target-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created SQLite3ConfigVersion.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created SQLite3Target-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created SQLite3Targets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created SQLite3Config.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created date-config-version.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created dateTarget-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created dateTargets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created date-config.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created CURLConfigVersion.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created CURLTarget-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created CURLTargets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created CURLConfig.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created OpenSSLConfigVersion.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created OpenSSLTarget-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created OpenSSLTargets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created OpenSSLConfig.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created ZLIBConfigVersion.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created ZLIBConfig.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created ZLIBTargets.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake_find_package_multi created ZLIBTarget-release.cmake sqlpp11-connector-sqlite3/0.29 (test package): Generator cmake created conanbuildinfo.cmake sqlpp11-connector-sqlite3/0.29 (test package): Aggregating env generators sqlpp11-connector-sqlite3/0.29 (test package): Generated conaninfo.txt sqlpp11-connector-sqlite3/0.29 (test package): Generated graphinfo Using lockfile: '/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1/conan.lock' Using cached profile from lockfile [HOOK - conan-center.py] pre_build(): [FPIC MANAGEMENT (KB-H007)] 'fPIC' option not found [HOOK - conan-center.py] pre_build(): [FPIC MANAGEMENT (KB-H007)] OK sqlpp11-connector-sqlite3/0.29 (test package): Calling build() ----Running------ > cd '/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1' && cmake -G "Unix Makefiles" -DCMAKE_BUILD_TYPE="Release" -DCONAN_IN_LOCAL_CACHE="OFF" -DCONAN_COMPILER="gcc" -DCONAN_COMPILER_VERSION="8" -DCONAN_CXX_FLAGS="-m64" -DCONAN_SHARED_LINKER_FLAGS="-m64" -DCONAN_C_FLAGS="-m64" -DCONAN_LIBCXX="libstdc++11" -DCMAKE_INSTALL_PREFIX="/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1/package" -DCMAKE_INSTALL_BINDIR="bin" -DCMAKE_INSTALL_SBINDIR="bin" -DCMAKE_INSTALL_LIBEXECDIR="bin" -DCMAKE_INSTALL_LIBDIR="lib" -DCMAKE_INSTALL_INCLUDEDIR="include" -DCMAKE_INSTALL_OLDINCLUDEDIR="include" -DCMAKE_INSTALL_DATAROOTDIR="share" -DCMAKE_PREFIX_PATH="/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1" -DCMAKE_MODULE_PATH="/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1" -DCMAKE_EXPORT_NO_PACKAGE_REGISTRY="ON" -DCONAN_EXPORTED="1" -Wno-dev '/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package' ----------------- -- The C compiler identification is GNU 8.4.0 -- The CXX compiler identification is GNU 8.4.0 -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working C compiler: /usr/bin/gcc - skipped -- Detecting C compile features -- Detecting C compile features - done -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Check for working CXX compiler: /usr/bin/g++ - skipped -- Detecting CXX compile features -- Detecting CXX compile features - done -- Conan: called by CMake conan helper -- Conan: Adjusting output directories -- Conan: Using cmake targets configuration -- Library sqlpp11-connector-sqlite3 found /home/conan/w/prod/BuildSingleReference/.conan/data/sqlpp11-connector-sqlite3/0.29/_/_/package/270effa39ab4c35a45f36d3d7d5efc19a95a9f8b/lib/libsqlpp11-connector-sqlite3.so -- Library sqlite3 found /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/lib/libsqlite3.a -- Library date-tz found /home/conan/w/prod/BuildSingleReference/.conan/data/date/3.0.1/_/_/package/2128dc8289b2d6a1e26080ad13bbb0aa4e561d82/lib/libdate-tz.a -- Library curl found /home/conan/w/prod/BuildSingleReference/.conan/data/libcurl/7.78.0/_/_/package/015f97075b6c2ac297ea689620e576be75fd93ed/lib/libcurl.a -- Library ssl found /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libssl.a -- Library crypto found /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libcrypto.a -- Library z found /home/conan/w/prod/BuildSingleReference/.conan/data/zlib/1.2.13/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libz.a -- Conan: Adjusting default RPATHs Conan policies -- Conan: Adjusting language standard -- Conan: Compiler GCC>=5, checking major version 8 -- Conan: Checking correct version: 8 -- Conan: C++ stdlib: libstdc++11 -- Library sqlpp11-connector-sqlite3 found /home/conan/w/prod/BuildSingleReference/.conan/data/sqlpp11-connector-sqlite3/0.29/_/_/package/270effa39ab4c35a45f36d3d7d5efc19a95a9f8b/lib/libsqlpp11-connector-sqlite3.so -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/sqlpp11-connector-sqlite3/0.29/_/_/package/270effa39ab4c35a45f36d3d7d5efc19a95a9f8b/lib/libsqlpp11-connector-sqlite3.so -- Library date-tz found /home/conan/w/prod/BuildSingleReference/.conan/data/date/3.0.1/_/_/package/2128dc8289b2d6a1e26080ad13bbb0aa4e561d82/lib/libdate-tz.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/date/3.0.1/_/_/package/2128dc8289b2d6a1e26080ad13bbb0aa4e561d82/lib/libdate-tz.a -- Library date-tz found /home/conan/w/prod/BuildSingleReference/.conan/data/date/3.0.1/_/_/package/2128dc8289b2d6a1e26080ad13bbb0aa4e561d82/lib/libdate-tz.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/date/3.0.1/_/_/package/2128dc8289b2d6a1e26080ad13bbb0aa4e561d82/lib/libdate-tz.a -- Library curl found /home/conan/w/prod/BuildSingleReference/.conan/data/libcurl/7.78.0/_/_/package/015f97075b6c2ac297ea689620e576be75fd93ed/lib/libcurl.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/libcurl/7.78.0/_/_/package/015f97075b6c2ac297ea689620e576be75fd93ed/lib/libcurl.a -- Library curl found /home/conan/w/prod/BuildSingleReference/.conan/data/libcurl/7.78.0/_/_/package/015f97075b6c2ac297ea689620e576be75fd93ed/lib/libcurl.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/libcurl/7.78.0/_/_/package/015f97075b6c2ac297ea689620e576be75fd93ed/lib/libcurl.a -- Library ssl found /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libssl.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libssl.a -- Library crypto found /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libcrypto.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libcrypto.a -- Library crypto found /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libcrypto.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libcrypto.a -- Library ssl found /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libssl.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/openssl/1.1.1s/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libssl.a -- Library z found /home/conan/w/prod/BuildSingleReference/.conan/data/zlib/1.2.13/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libz.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/zlib/1.2.13/_/_/package/1d877a3df840030e6a8abb74c5ffb9088d08b47a/lib/libz.a -- Dependency date already found -- Library sqlite3 found /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/lib/libsqlite3.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/lib/libsqlite3.a -- Library sqlite3 found /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/lib/libsqlite3.a -- Found: /home/conan/w/prod/BuildSingleReference/.conan/data/sqlite3/3.40.1/_/_/package/a0e6c9e5a908f3e3d4654a1dc1fc1f1cbfb986c8/lib/libsqlite3.a -- Configuring done -- Generating done -- Build files have been written to: /home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1 ----Running------ > cmake --build '/home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/8e347b8be91a63bb2655070e176e95773a8d28c1' '--' '-j3' ----------------- Scanning dependencies of target test_package [ 50%] Building CXX object test_package/CMakeFiles/test_package.dir/test_package.cpp.o [100%] Linking CXX executable ../bin/test_package [100%] Built target test_package sqlpp11-connector-sqlite3/0.29 (test package): Running test() ----Running------ > bin/test_package ----------------- Last Insert ID: 1 Last Insert ID: 2 1, 0 2, 0 3, 0 sqlpp11-connector-sqlite3/0.29 (test package): database is not encrypted CMake Warning: Manually-specified variables were not used by the project: CMAKE_EXPORT_NO_PACKAGE_REGISTRY CMAKE_INSTALL_BINDIR CMAKE_INSTALL_DATAROOTDIR CMAKE_INSTALL_INCLUDEDIR CMAKE_INSTALL_LIBDIR CMAKE_INSTALL_LIBEXECDIR CMAKE_INSTALL_OLDINCLUDEDIR CMAKE_INSTALL_SBINDIR Sqlite3 debug: Preparing: 'CREATE TABLE tab_sample ( alpha INTEGER PRIMARY KEY, beta varchar(255) DEFAULT NULL, gamma bool DEFAULT NULL )' Sqlite3 debug: Preparing: 'CREATE TABLE tab_foo ( omega bigint(20) DEFAULT NULL )' Sqlite3 debug: Preparing: 'DELETE FROM tab_sample' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70b4f90 Sqlite3 debug: Accessing next row of handle at 0x55d6a70b4f90 /home/conan/w/prod/BuildSingleReference/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/test_package.cpp: 73 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70da190 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da190 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma,tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70b4f90 Sqlite3 debug: Accessing next row of handle at 0x55d6a70b4f90 no of required columns: 0 Sqlite3 debug: Preparing: 'INSERT INTO tab_sample DEFAULT VALUES' Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (gamma) VALUES(1)' Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (gamma,beta) VALUES(1,'')' Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=0 WHERE tab_sample.alpha IN(1)' Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=0 WHERE tab_sample.alpha IN(1,2,3,4)' Sqlite3 debug: Preparing: 'DELETE FROM tab_sample WHERE (tab_sample.alpha=(tab_sample.alpha+3))' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70dab30 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab30 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Accessing a field directly from the result (using the current row): 1 Can do that again, no problem: 1 Sqlite3 debug: Preparing: 'BEGIN' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma,(SELECT MAX(tab_foo.omega) AS max_ FROM tab_foo WHERE (tab_foo.omega>tab_sample.alpha)) FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70dab10 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Sqlite3 debug: binding integral result 0 at index: 3 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: binding integral result 1 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Sqlite3 debug: binding integral result 0 at index: 3 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: binding integral result 2 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 Sqlite3 debug: binding integral result 0 at index: 3 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: Preparing: 'COMMIT' Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha FROM tab_sample INNER JOIN tab_foo ON (tab_sample.alpha=tab_foo.omega)' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70da1b0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1b0 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha FROM tab_sample LEFT OUTER JOIN tab_foo ON (tab_sample.alpha=tab_foo.omega)' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70dab10 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: binding integral result 0 at index: 0 1 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: binding integral result 1 at index: 0 2 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: binding integral result 2 at index: 0 3 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dab10 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample WHERE (((tab_sample.alpha<>?1) AND (tab_sample.beta<>?2)) AND (tab_sample.gamma<>?3))' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55d6a70da1b0 Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding integral parameter 7 at index: 0, being not null Sqlite3 debug: binding text parameter wurzelbrunft at index: 1, being not null Sqlite3 debug: binding boolean parameter true at index: 2, being not null Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70da1b0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1b0 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: binding text result at index: 1 Sqlite3 debug: binding boolean result at index: 2 bound result: alpha: 3 bound result: beta: bound result: gamma: 0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1b0 -------- Sqlite3 debug: Preparing: 'SELECT last_insert_rowid() AS a' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70d9b30 Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9b30 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding integral parameter 3 at index: 0, being not null Sqlite3 debug: binding text parameter wurzelbrunft at index: 1, being not null Sqlite3 debug: binding boolean parameter true at index: 2, being not null Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70da1b0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1b0 -------- Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding integral parameter 3 at index: 0, being not null Sqlite3 debug: binding text parameter kaesekuchen at index: 1, being not null Sqlite3 debug: binding boolean parameter true at index: 2, being not null Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70da1b0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1b0 Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (beta,gamma) VALUES(?1,1)' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55d6a70dd730 Inserted: Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null 4 Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=?1 WHERE (tab_sample.beta='prepared cake')' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55d6a70dd770 Updated: Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding boolean parameter false at index: 0, being not null 4 Sqlite3 debug: Preparing: 'DELETE FROM tab_sample WHERE (tab_sample.beta<>?1)' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55d6a70dd790 Deleted lines: Sqlite3 debug: reseting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null 4 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample WHERE ((tab_sample.beta LIKE(?1) AND (tab_sample.alpha=?2)) OR (tab_sample.gamma<>?3))' Sqlite3 debug: Constructing prepared_statement, using handle at 0x55d6a70dd7d0 Sqlite3 debug: Preparing: 'INSERT OR REPLACE INTO tab_sample (beta,gamma) VALUES('test',1)' 5 Sqlite3 debug: Preparing: 'INSERT OR IGNORE INTO tab_sample (beta,gamma) VALUES('test',1)' 6 Sqlite3 debug: Preparing: 'PRAGMA user_version = 1' Sqlite3 debug: Preparing: ' PRAGMA user_version' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70dd7d0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70dd7d0 Sqlite3 debug: binding integral result 0 at index: 0 1 Sqlite3 debug: Preparing: 'SELECT sub.alpha FROM (SELECT tab_sample.alpha FROM tab_sample) AS sub' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70d9770 Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9770 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9770 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9770 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9770 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9770 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55d6a70d9770 Sqlite3 debug: Preparing: 'SELECT sub.alpha FROM tab_sample INNER JOIN (SELECT tab_sample.alpha FROM tab_sample) AS sub' Sqlite3 debug: Constructing bind result, using handle at 0x55d6a70da1f0 Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 0x55d6a70da1f0