[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

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

From: <innnzzz6_at_hotmail.com>
Date: Mon, 28 Jan 2019 14:43:01 +0700

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
Received on 2019-01-28 11:21:06 CET

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.