[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: Branko Čibej <brane_at_apache.org>
Date: Tue, 22 Jan 2019 22:52:34 +0100

[Moving to the correct list.]

On 22.01.2019 22:18, 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
>
>
Received on 2019-01-22 22:52:45 CET

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

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