******************************************************************************** conan test conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\conanfile.py sqlpp11-connector-sqlite3/0.30@#66dfa66802c986cd059a7e8ff8d4fb56 -pr C:\J\w\prod\BuildSingleReference@6\167821\2d6e3746-0757-4f47-929c-370bd447ad0d/profile_windows_15_mdd_vs_debug_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=Debug compiler=Visual Studio compiler.runtime=MDd compiler.version=15 os=Windows [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.30 (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.30 from local cache - Cache zlib/1.2.13 from 'conan-center' - Cache Packages date/3.0.1:000869eb75a4dc8f3c968cb7604950942201c9c5 - Cache libcurl/7.78.0:3cb0a338bde2212e22d082dc37315ef34f9cdda8 - Cache openssl/1.1.1s:8cf01e2f50fcd6b63525e70584df0326550364e1 - Cache sqlite3/3.40.1:8e25da653fbb0e3f07cb3452f2043ed8c19025be - Cache sqlpp11/0.60:5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9 - Cache sqlpp11-connector-sqlite3/0.30:a874612186743d329b73670d8e39d5171bb18cd4 - Cache zlib/1.2.13:8cf01e2f50fcd6b63525e70584df0326550364e1 - 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 : C:\J\w\prod\BuildSingleReference@6\.conan\data\sqlite3\3.40.1\_\_\package\8e25da653fbb0e3f07cb3452f2043ed8c19025be\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: C:\J\w\prod\BuildSingleReference@6\.conan\data\sqlpp11\0.60\_\_\package\5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9\bin sqlpp11-connector-sqlite3/0.30: Already installed! sqlpp11-connector-sqlite3/0.30 (test package): Generator txt created conanbuildinfo.txt sqlpp11-connector-sqlite3/0.30 (test package): Generator 'CMakeToolchain' calling 'generate()' sqlpp11-connector-sqlite3/0.30 (test package): Preset 'default' added to CMakePresets.json. Invoke it manually using 'cmake --preset default' sqlpp11-connector-sqlite3/0.30 (test package): If your CMake version is not compatible with CMakePresets (<3.19) call cmake like: 'cmake -G "Visual Studio 15 2017" -DCMAKE_TOOLCHAIN_FILE=C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\generators\conan_toolchain.cmake -DCMAKE_POLICY_DEFAULT_CMP0091=NEW' sqlpp11-connector-sqlite3/0.30 (test package): Generator 'VirtualRunEnv' calling 'generate()' sqlpp11-connector-sqlite3/0.30 (test package): Generator 'CMakeDeps' calling 'generate()' sqlpp11-connector-sqlite3/0.30 (test package): Aggregating env generators sqlpp11-connector-sqlite3/0.30 (test package): Generated conaninfo.txt sqlpp11-connector-sqlite3/0.30 (test package): Generated graphinfo Using lockfile: 'C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\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.30 (test package): Calling build() sqlpp11-connector-sqlite3/0.30 (test package): CMake command: cmake -G "Visual Studio 15 2017" -DCMAKE_TOOLCHAIN_FILE="C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/generators/conan_toolchain.cmake" -DCMAKE_POLICY_DEFAULT_CMP0091="NEW" "C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\." ----Running------ > cmake -G "Visual Studio 15 2017" -DCMAKE_TOOLCHAIN_FILE="C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/generators/conan_toolchain.cmake" -DCMAKE_POLICY_DEFAULT_CMP0091="NEW" "C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\." ----------------- -- Using Conan toolchain: C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build/generators/conan_toolchain.cmake -- The CXX compiler identification is MSVC 19.16.27048.0 -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Check for working CXX compiler: C:/Program Files (x86)/Microsoft Visual Studio/2017/Community/VC/Tools/MSVC/14.16.27023/bin/Hostx86/x64/cl.exe - 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 'C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/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: C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/build sqlpp11-connector-sqlite3/0.30 (test package): CMake command: cmake --build "C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build" --config Debug ----Running------ > cmake --build "C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build" --config Debug ----------------- Microsoft (R) Build Engine version 15.9.21+g9802d43bc3 for .NET Framework Copyright (C) Microsoft Corporation. All rights reserved. Checking Build System Building Custom Rule C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/CMakeLists.txt test_package.cpp C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\test_package.cpp(127): warning C4244: 'initializing': conversion from '__int64' to 'int', possible loss of data [C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\test_package.vcxproj] C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\test_package.cpp(128): warning C4244: 'initializing': conversion from '__int64' to 'int', possible loss of data [C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\test_package.vcxproj] C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\test_package.cpp(226): warning C4244: 'initializing': conversion from '__int64' to 'int', possible loss of data [C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\test_package.vcxproj] test_package.vcxproj -> C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\Debug\test_package.exe Building Custom Rule C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/CMakeLists.txt sqlpp11-connector-sqlite3/0.30 (test package): Running test() ----Running------ > "C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\build\generators\conanrun.bat" && Debug\test_package ----------------- Last Insert ID: 1 Last Insert ID: 2 1, 0 2, 0 3, 0 sqlpp11-connector-sqlite3/0.30 (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 00000232C4EA3F20 Sqlite3 debug: Accessing next row of handle at 00000232C4EA3F20 C:\J\w\prod\BuildSingleReference@6\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 00000232C4EA4240 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4240 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 00000232C4EA4A10 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4A10 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 00000232C4EA4150 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4150 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 00000232C4EA4920 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4920 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 00000232C4EA4920 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 00000232C4EA4920 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 00000232C4EA4920 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 00000232C4EA4AB0 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4AB0 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 00000232C4EA4AB0 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4AB0 Sqlite3 debug: binding integral result 0 at index: 0 1 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4AB0 Sqlite3 debug: binding integral result 1 at index: 0 2 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4AB0 Sqlite3 debug: binding integral result 2 at index: 0 3 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4AB0 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 00000232C4EA4880 Sqlite3 debug: resetting 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 00000232C4EA4880 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4880 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 00000232C4EA4880 -------- Sqlite3 debug: Preparing: 'SELECT last_insert_rowid() AS a' Sqlite3 debug: Constructing bind result, using handle at 00000232C4EA4C40 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: resetting 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 00000232C4EA4880 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4880 -------- Sqlite3 debug: resetting 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 00000232C4EA4880 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4880 Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (beta,gamma) VALUES(?1,1)' Sqlite3 debug: Constructing prepared_statement, using handle at 00000232C4EA45B0 Sqlite3 debug: resetting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null Inserted: 4 Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=?1 WHERE (tab_sample.beta='prepared cake')' Sqlite3 debug: Constructing prepared_statement, using handle at 00000232C4EA4060 Sqlite3 debug: resetting prepared statement Sqlite3 debug: binding boolean parameter false at index: 0, being not null Updated: 4 Sqlite3 debug: Preparing: 'DELETE FROM tab_sample WHERE (tab_sample.beta<>?1)' Sqlite3 debug: Constructing prepared_statement, using handle at 00000232C4EA4010 Sqlite3 debug: resetting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null Deleted lines: 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 00000232C4EA4600 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: 'SELECT COUNT(tab_sample.alpha) AS count_ FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 00000232C4EA4510 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4510 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample WHERE tab_sample.alpha NOT IN(SELECT tab_sample.alpha FROM tab_sample)' Sqlite3 debug: Constructing bind result, using handle at 00000232C4EA43D0 Sqlite3 debug: Accessing next row of handle at 00000232C4EA43D0 Sqlite3 debug: Preparing: 'PRAGMA user_version = 1' Sqlite3 debug: Preparing: ' PRAGMA user_version' Sqlite3 debug: Constructing bind result, using handle at 00000232C4EA4B50 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4B50 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 00000232C4EA4290 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4290 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000232C4EA4290 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000232C4EA4290 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000232C4EA4290 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000232C4EA4290 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000232C4EA4290 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 00000232C4EA4C40 Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000232C4EA4C40 sqlpp11-connector-sqlite3/0.30 (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.30 (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.30@#66dfa66802c986cd059a7e8ff8d4fb56 -pr C:\J\w\prod\BuildSingleReference@6\167821\2d6e3746-0757-4f47-929c-370bd447ad0d/profile_windows_15_mdd_vs_debug_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=Debug compiler=Visual Studio compiler.runtime=MDd compiler.version=15 os=Windows [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.30 (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.30 from local cache - Cache zlib/1.2.13 from 'conan-center' - Cache Packages date/3.0.1:000869eb75a4dc8f3c968cb7604950942201c9c5 - Cache libcurl/7.78.0:3cb0a338bde2212e22d082dc37315ef34f9cdda8 - Cache openssl/1.1.1s:8cf01e2f50fcd6b63525e70584df0326550364e1 - Cache sqlite3/3.40.1:8e25da653fbb0e3f07cb3452f2043ed8c19025be - Cache sqlpp11/0.60:5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9 - Cache sqlpp11-connector-sqlite3/0.30:a874612186743d329b73670d8e39d5171bb18cd4 - Cache zlib/1.2.13:8cf01e2f50fcd6b63525e70584df0326550364e1 - 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 : C:\J\w\prod\BuildSingleReference@6\.conan\data\sqlite3\3.40.1\_\_\package\8e25da653fbb0e3f07cb3452f2043ed8c19025be\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: C:\J\w\prod\BuildSingleReference@6\.conan\data\sqlpp11\0.60\_\_\package\5ab84d6acfe1f23c4fae0ab88f26e3a396351ac9\bin sqlpp11-connector-sqlite3/0.30: Already installed! sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake created conanbuildinfo.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator txt created conanbuildinfo.txt sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3-config-version.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3-config.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3Targets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created sqlpp11-connector-sqlite3Target-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created Sqlpp11ConfigVersion.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created Sqlpp11Config.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created Sqlpp11Targets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created Sqlpp11Target-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created SQLite3ConfigVersion.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created SQLite3Target-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created SQLite3Targets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created SQLite3Config.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created date-config-version.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created dateTarget-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created dateTargets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created date-config.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created CURLConfigVersion.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created CURLTarget-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created CURLTargets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created CURLConfig.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created OpenSSLConfigVersion.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created OpenSSLTarget-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created OpenSSLTargets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created OpenSSLConfig.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created ZLIBConfigVersion.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created ZLIBConfig.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created ZLIBTargets.cmake sqlpp11-connector-sqlite3/0.30 (test package): Generator cmake_find_package_multi created ZLIBTarget-debug.cmake sqlpp11-connector-sqlite3/0.30 (test package): Aggregating env generators sqlpp11-connector-sqlite3/0.30 (test package): Generated conaninfo.txt sqlpp11-connector-sqlite3/0.30 (test package): Generated graphinfo Using lockfile: 'C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47/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.30 (test package): Calling build() ----Running------ > cd C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47 && cmake -G "Visual Studio 15 2017 Win64" -DCONAN_LINK_RUNTIME="/MDd" -DCONAN_IN_LOCAL_CACHE="OFF" -DCONAN_COMPILER="Visual Studio" -DCONAN_COMPILER_VERSION="15" -DCONAN_CXX_FLAGS="/MP8" -DCONAN_C_FLAGS="/MP8" -DCMAKE_INSTALL_PREFIX="C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47\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="C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/4b5bcd58676cfa21c296d4baedee4dd80bd90a47" -DCMAKE_MODULE_PATH="C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/4b5bcd58676cfa21c296d4baedee4dd80bd90a47" -DCMAKE_EXPORT_NO_PACKAGE_REGISTRY="ON" -DCONAN_EXPORTED="1" -Wno-dev C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package ----------------- -- The C compiler identification is MSVC 19.16.27048.0 -- The CXX compiler identification is MSVC 19.16.27048.0 -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working C compiler: C:/Program Files (x86)/Microsoft Visual Studio/2017/Community/VC/Tools/MSVC/14.16.27023/bin/Hostx86/x64/cl.exe - 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: C:/Program Files (x86)/Microsoft Visual Studio/2017/Community/VC/Tools/MSVC/14.16.27023/bin/Hostx86/x64/cl.exe - 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 C:/J/w/prod/BuildSingleReference@6/s/b0beb9/1/lib/sqlpp11-connector-sqlite3.lib -- Library sqlite3 found C:/J/w/prod/BuildSingleReference@6/.conan/data/sqlite3/3.40.1/_/_/package/8e25da653fbb0e3f07cb3452f2043ed8c19025be/lib/sqlite3.lib -- Library date-tz found C:/J/w/prod/BuildSingleReference@6/.conan/data/date/3.0.1/_/_/package/000869eb75a4dc8f3c968cb7604950942201c9c5/lib/date-tz.lib -- Library libcurl found C:/J/w/prod/BuildSingleReference@6/.conan/data/libcurl/7.78.0/_/_/package/3cb0a338bde2212e22d082dc37315ef34f9cdda8/lib/libcurl.lib -- Library libssld found C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libssld.lib -- Library libcryptod found C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libcryptod.lib -- Library zlib found C:/J/w/prod/BuildSingleReference@6/.conan/data/zlib/1.2.13/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/zlib.lib -- Conan: Adjusting default RPATHs Conan policies -- Conan: Adjusting language standard -- Library sqlpp11-connector-sqlite3 found C:/J/w/prod/BuildSingleReference@6/s/b0beb9/1/lib/sqlpp11-connector-sqlite3.lib -- Found: C:/J/w/prod/BuildSingleReference@6/s/b0beb9/1/lib/sqlpp11-connector-sqlite3.lib -- Library date-tz found C:/J/w/prod/BuildSingleReference@6/.conan/data/date/3.0.1/_/_/package/000869eb75a4dc8f3c968cb7604950942201c9c5/lib/date-tz.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/date/3.0.1/_/_/package/000869eb75a4dc8f3c968cb7604950942201c9c5/lib/date-tz.lib -- Library date-tz found C:/J/w/prod/BuildSingleReference@6/.conan/data/date/3.0.1/_/_/package/000869eb75a4dc8f3c968cb7604950942201c9c5/lib/date-tz.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/date/3.0.1/_/_/package/000869eb75a4dc8f3c968cb7604950942201c9c5/lib/date-tz.lib -- Library libcurl found C:/J/w/prod/BuildSingleReference@6/.conan/data/libcurl/7.78.0/_/_/package/3cb0a338bde2212e22d082dc37315ef34f9cdda8/lib/libcurl.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/libcurl/7.78.0/_/_/package/3cb0a338bde2212e22d082dc37315ef34f9cdda8/lib/libcurl.lib -- Library libcurl found C:/J/w/prod/BuildSingleReference@6/.conan/data/libcurl/7.78.0/_/_/package/3cb0a338bde2212e22d082dc37315ef34f9cdda8/lib/libcurl.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/libcurl/7.78.0/_/_/package/3cb0a338bde2212e22d082dc37315ef34f9cdda8/lib/libcurl.lib -- Library libssld found C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libssld.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libssld.lib -- Library libcryptod found C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libcryptod.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libcryptod.lib -- Library libcryptod found C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libcryptod.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libcryptod.lib -- Library libssld found C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libssld.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/openssl/1.1.1s/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/libssld.lib -- Library zlib found C:/J/w/prod/BuildSingleReference@6/.conan/data/zlib/1.2.13/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/zlib.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/zlib/1.2.13/_/_/package/8cf01e2f50fcd6b63525e70584df0326550364e1/lib/zlib.lib -- Dependency date already found -- Library sqlite3 found C:/J/w/prod/BuildSingleReference@6/.conan/data/sqlite3/3.40.1/_/_/package/8e25da653fbb0e3f07cb3452f2043ed8c19025be/lib/sqlite3.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/sqlite3/3.40.1/_/_/package/8e25da653fbb0e3f07cb3452f2043ed8c19025be/lib/sqlite3.lib -- Library sqlite3 found C:/J/w/prod/BuildSingleReference@6/.conan/data/sqlite3/3.40.1/_/_/package/8e25da653fbb0e3f07cb3452f2043ed8c19025be/lib/sqlite3.lib -- Found: C:/J/w/prod/BuildSingleReference@6/.conan/data/sqlite3/3.40.1/_/_/package/8e25da653fbb0e3f07cb3452f2043ed8c19025be/lib/sqlite3.lib -- Configuring done -- Generating done -- Build files have been written to: C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/build/4b5bcd58676cfa21c296d4baedee4dd80bd90a47 ----Running------ > cmake --build C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47 --config Debug -- /m:8 /verbosity:minimal ----------------- Microsoft (R) Build Engine version 15.9.21+g9802d43bc3 for .NET Framework Copyright (C) Microsoft Corporation. All rights reserved. Checking Build System Building Custom Rule C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_package/CMakeLists.txt test_package.cpp C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\test_package.cpp(127): warning C4244: 'initializing': conversion from '__int64' to 'int', possible loss of data [C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47\test_package\test_package.vcxproj] C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\test_package.cpp(128): warning C4244: 'initializing': conversion from '__int64' to 'int', possible loss of data [C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47\test_package\test_package.vcxproj] C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_package\test_package.cpp(226): warning C4244: 'initializing': conversion from '__int64' to 'int', possible loss of data [C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47\test_package\test_package.vcxproj] test_package.vcxproj -> C:\J\w\prod\BuildSingleReference@6\conan-center-index\recipes\sqlpp11-connector-sqlite3\all\test_v1_package\build\4b5bcd58676cfa21c296d4baedee4dd80bd90a47\bin\test_package.exe Building Custom Rule C:/J/w/prod/BuildSingleReference@6/conan-center-index/recipes/sqlpp11-connector-sqlite3/all/test_v1_package/CMakeLists.txt sqlpp11-connector-sqlite3/0.30 (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.30 (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 00000242E2C19F00 Sqlite3 debug: Accessing next row of handle at 00000242E2C19F00 C:\J\w\prod\BuildSingleReference@6\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 00000242E2C1A3B0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A3B0 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 00000242E2C1A4A0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A4A0 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 00000242E2C1A590 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A590 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 00000242E2C1A7C0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A7C0 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 00000242E2C1A7C0 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 00000242E2C1A7C0 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 00000242E2C1A7C0 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 00000242E2C1A5E0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 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 00000242E2C1A8B0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A8B0 Sqlite3 debug: binding integral result 0 at index: 0 1 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A8B0 Sqlite3 debug: binding integral result 1 at index: 0 2 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A8B0 Sqlite3 debug: binding integral result 2 at index: 0 3 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A8B0 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 00000242E2C1A630 Sqlite3 debug: resetting 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 00000242E2C1A630 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A630 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 00000242E2C1A630 -------- Sqlite3 debug: Preparing: 'SELECT last_insert_rowid() AS a' Sqlite3 debug: Constructing bind result, using handle at 00000242E2C1AAE0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1AAE0 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: resetting 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 00000242E2C1A630 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A630 -------- Sqlite3 debug: resetting 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 00000242E2C1A630 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A630 Sqlite3 debug: Preparing: 'INSERT INTO tab_sample (beta,gamma) VALUES(?1,1)' Sqlite3 debug: Constructing prepared_statement, using handle at 00000242E2C1A720 Sqlite3 debug: resetting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null Inserted: 4 Sqlite3 debug: Preparing: 'UPDATE tab_sample SET gamma=?1 WHERE (tab_sample.beta='prepared cake')' Sqlite3 debug: Constructing prepared_statement, using handle at 00000242E2C1ACC0 Sqlite3 debug: resetting prepared statement Sqlite3 debug: binding boolean parameter false at index: 0, being not null Updated: 4 Sqlite3 debug: Preparing: 'DELETE FROM tab_sample WHERE (tab_sample.beta<>?1)' Sqlite3 debug: Constructing prepared_statement, using handle at 00000242E2C1ADB0 Sqlite3 debug: resetting prepared statement Sqlite3 debug: binding text parameter prepared cake at index: 0, being not null Deleted lines: 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 00000242E2C1A950 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: 'SELECT COUNT(tab_sample.alpha) AS count_ FROM tab_sample' Sqlite3 debug: Constructing bind result, using handle at 00000242E2C1A220 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A220 Sqlite3 debug: binding integral result 0 at index: 0 Sqlite3 debug: Preparing: 'SELECT tab_sample.alpha,tab_sample.beta,tab_sample.gamma FROM tab_sample WHERE tab_sample.alpha NOT IN(SELECT tab_sample.alpha FROM tab_sample)' Sqlite3 debug: Constructing bind result, using handle at 00000242E2C19F00 Sqlite3 debug: Accessing next row of handle at 00000242E2C19F00 Sqlite3 debug: Preparing: 'PRAGMA user_version = 1' Sqlite3 debug: Preparing: ' PRAGMA user_version' Sqlite3 debug: Constructing bind result, using handle at 00000242E2C1A220 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A220 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 00000242E2C1A0E0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A0E0 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000242E2C1A0E0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000242E2C1A0E0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000242E2C1A0E0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000242E2C1A0E0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000242E2C1A0E0 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 00000242E2C1A5E0 Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 0 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 6 at index: 0 1Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 1 at index: 0 2Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 2 at index: 0 4Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 4 at index: 0 5Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0 Sqlite3 debug: binding integral result 5 at index: 0 6Sqlite3 debug: Accessing next row of handle at 00000242E2C1A5E0