[sqlite-dev] SQLite 3.29.0 and trunk: Test failures with ICU: vtab1-18.1.3.2 vtab1-18.1.4.2 vtabH-1.1
Arfrever Frehtes Taifersar Arahesis
vtab1-18.1.3.2 vtab1-18.1.4.2 vtabH-1.1
These tests exist in SQLite 3.28.0 and they pass in that version.
Problem probably introduced in:
https://sqlite.org/src/info/b4a9e09e60213ccf
SQLite configuration:
export CPPFLAGS="-DSQLITE_ENABLE_API_ARMOR -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_HIDDEN_COLUMNS -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_NORMALIZE -DSQLITE_ENABLE_OFFSET_SQL_FUNC -DSQLITE_ENABLE_PREUPDATE_HOOK -DSQLITE_ENABLE_RBU -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_STMT_SCANSTATUS -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION -DSQLITE_ENABLE_UNLOCK_NOTIFY -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT -DSQLITE_INTROSPECTION_PRAGMAS -DSQLITE_SOUNDEX -DSQLITE_USE_URI -DSQLITE_ENABLE_ICU -DSQLITE_SECURE_DELETE"
./configure --prefix=/usr --build=x86_64-pc-linux-gnu --host=x86_64-pc-linux-gnu --enable-load-extension --enable-threadsafe --enable-fts5 --enable-session --disable-debug --disable-editline --enable-readline --with-readline-inc=-I/usr/include/readline --disable-static --enable-tcl
Gentoo GNU/Linux, glibc 2.29, GCC 8.3.0, Tcl 8.6.9, ICU 64.2
Output of test suite:
...
Time: vacuum-into.test 73 ms
Time: vacuum.test 179 ms
Time: vacuum2.test 85 ms
Time: vacuum4.test 35 ms
Time: vacuum5.test 282 ms
Time: vacuummem.test 14346 ms
Time: varint.test 1038 ms
Time: view.test 6007 ms
! vtab1-18.1.3.2 expected: [xFilter {SELECT rowid, a, b FROM 't6' WHERE b >= ? AND b < ? AND b like ?} 8J 8k 8J%]
! vtab1-18.1.3.2 got: [xFilter {SELECT rowid, a, b FROM 't6' WHERE b like ?} 8J%]
! vtab1-18.1.4.2 expected: [xFilter {SELECT rowid, a, b FROM 't6' WHERE b >= ? AND b < ? AND b like ?} 8J 8k 8j%]
! vtab1-18.1.4.2 got: [xFilter {SELECT rowid, a, b FROM 't6' WHERE b like ?} 8j%]
Time: vtab1.test 1515 ms
Time: vtab2.test 49 ms
Time: vtab3.test 41 ms
Time: vtab4.test 47 ms
Time: vtab5.test 50 ms
Time: vtab6.test 2413 ms
Time: vtab7.test 54 ms
Time: vtab8.test 42 ms
Time: vtab9.test 37 ms
Time: vtabA.test 67 ms
Time: vtabB.test 36 ms
Time: vtabC.test 8780 ms
Time: vtabD.test 3881 ms
Time: vtabE.test 32 ms
Time: vtabF.test 37 ms
! vtabH-1.1 expected: [xBestIndex {SELECT rowid, a, b FROM 't6' WHERE b >= ? AND b < ? AND b like ?} xFilter {SELECT rowid, a, b FROM 't6' WHERE b >= ? AND b < ? AND b like ?} 8ABC 8abd 8abc]
! vtabH-1.1 got: [xBestIndex {SELECT rowid, a, b FROM 't6' WHERE b like ?} xFilter {SELECT rowid, a, b FROM 't6' WHERE b like ?} 8abc]
Time: vtabH.test 426 ms
Time: vtabI.test 49 ms
Time: vtabJ.test 53 ms
Time: vtab_alter.test 49 ms
Time: vtab_shared.test 105 ms
Time: vtabdrop.test 57 ms
...
--
Arfrever Frehtes Taifersar Arahesis
_______________________________________________
sqlite-dev mailing list
sqlit...@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev