Re: wc-queries-test test failure with -DSQLITE_ENABLE_STMT_SCANSTATUS

innnz...@hotmail.com Mon, 28 Jan 2019 02:21:50 -0800

On 2019/01/22 21:18:54, Thomas Deutschmann wrote: 
> 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> 
>


Sent from my iPhone
Re: wc-queries-test test failure with -DSQLITE_ENABLE_STMT_SCANSTATUS

Reply via email to
