Hi, in Gentoo Linux, wc-queries-test test is failing (verified against v1.9.7-1.11.1:
> START: wc-queries-test > DBG: Using Sqlite 3.25.3 > PASS: wc-queries-test 1: sqlite up-to-date > PASS: wc-queries-test 2: queries are parsable > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MERGE' in explanation > DBG: Unhandled sqlite operation 'LEFT' in explanation > DBG: Unhandled sqlite operation 'RIGHT' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' > DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation > DBG: Unhandled sqlite operation 'UNION' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' > DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation > DBG: Unhandled sqlite operation 'UNION' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' > DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'UNION' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'MERGE' in explanation > DBG: Unhandled sqlite operation 'LEFT' in explanation > DBG: Unhandled sqlite operation 'RIGHT' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'MERGE' in explanation > DBG: Unhandled sqlite operation 'LEFT' in explanation > DBG: Unhandled sqlite operation 'RIGHT' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'SCALAR' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Expected 'SUBQUERIES', got 'QUERY' in 'COMPOUND QUERY' > DBG: Unhandled sqlite operation 'LEFT-MOST' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'UNION' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CO-ROUTINE' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MERGE' in explanation > DBG: Unhandled sqlite operation 'LEFT' in explanation > DBG: Expected 'TABLE', got 'CONSTANT' in 'SCAN CONSTANT ROW' > DBG: Unhandled sqlite operation 'RIGHT' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MERGE' in explanation > DBG: Unhandled sqlite operation 'LEFT' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'RIGHT' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > DBG: Unhandled sqlite operation 'CORRELATED' in explanation > DBG: Unhandled sqlite operation 'MULTI-INDEX' in explanation > svn_tests: E200006: STMT_FINALIZE_UPDATE_MOVE: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS update_move_list > svn_tests: E200006: STMT_FINALIZE_UPDATE_MOVE: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS update_move_list > svn_tests: E200006: STMT_FINALIZE_UPDATE_MOVE: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS update_move_list > svn_tests: E200006: STMT_FINALIZE_DELETE: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS delete_list > svn_tests: E200006: STMT_FINALIZE_DELETE: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS delete_list > svn_tests: E200006: STMT_FINALIZE_DELETE: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS delete_list > svn_tests: E200006: STMT_DROP_REVERT_LIST: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS revert_list > svn_tests: E200006: STMT_DROP_REVERT_LIST: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS revert_list > svn_tests: E200006: STMT_DROP_REVERT_LIST: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE IF EXISTS revert_list > svn_tests: E200006: STMT_DROP_TARGETS_LIST: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE targets_list > svn_tests: E200006: STMT_DROP_TARGETS_LIST: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE targets_list > svn_tests: E200006: STMT_DROP_TARGETS_LIST: Uses sqlite_master with only 0 > index component: ((null)) > DROP TABLE targets_list > svn_tests: E200042: Additional errors: > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > svn_tests: E200035: |SCAN TABLE sqlite_master > FAIL: wc-queries-test 3: test query expectations > PASS: wc-queries-test 4: test query duplicates > PASS: wc-queries-test 5: test schema statistics > PASS: wc-queries-test 6: verify queries are parsable > END: wc-queries-test > ELAPSED: wc-queries-test 0:00:00.167083 After some research we found the problem causing the test failure: In Gentoo we are building sqlite with > -DSQLITE_ENABLE_STMT_SCANSTATUS option set. If we disable that option, the test is passing. Downstream-bug: https://bugs.gentoo.org/605438 -- Regards, Thomas Deutschmann / Gentoo Linux Developer C4DD 695F A713 8F24 2AA1 5638 5849 7EE5 1D5D 74A5
