On 22.01.2019 22:52, Branko Čibej wrote:
> [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
I've filed this as issue #4804, it looks like a bug in our tests.
-- Brane
Received on 2019-01-22 23:10:20 CET