wc-queries-test test failure with -DSQLITE_ENABLE_STMT_SCANSTATUS

From: Thomas Deutschmann <whissi_at_gentoo.org>
Date: Tue, 22 Jan 2019 22:18:54 +0100

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

Received on 2019-01-22 22:19:11 CET

This message: [ Message body ]
Next message: Troy Curtis: "[CVE-2018-11803] Apache Subversion Denial of Service Vulnerability"
Previous message: Branko Čibej: "Re: Subversion 1.10.4"
Next in thread: innnzzz6_at_hotmail.com: "Re: wc-queries-test test failure with -DSQLITE_ENABLE_STMT_SCANSTATUS"
Maybe reply: innnzzz6_at_hotmail.com: "Re: wc-queries-test test failure with -DSQLITE_ENABLE_STMT_SCANSTATUS"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ] [ by messages with attachments ]