tdbc::sqlite3

View Ticket
Login
2018-12-17
10:21 New ticket [145df89159] SQLite TCL Test suite regressions. artifact: 532287603d user: oehhar

Ticket Hash: 145df89159588c565bc1ee20769385889b6095ae
Title: SQLite TCL Test suite regressions
Status: Open Type: Code_Defect
Severity: Critical Priority:
Subsystem: Resolution:
Last Modified: 2018-12-17 10:21:10
Version Found In: 8.6.9
User Comments:
oehhar added on 2018-12-17 10:21:10:
HaO: Moved from tcl ticket: [https://core.tcl.tk/tcl/info/2c154a40be9e1dd8]

I updated Tcl to 8.6.9 on OpenIndiana 2018.10 (illumos kernel, an OpenSolaris fork) and noticed that SQLite 3.26.0 TCL test suite fails in some 30 cases, 27 of them fail like this:

! window1-13.5 expected: [
]
! window1-13.5 got:      []

However, those 27 work with Tcl 8.6.7.

Here's the OpenIndiana shipped Tcl 8.6.7 sources: https://github.com/OpenIndiana/oi-userland/tree/oi/hipster/components/tcl/tcl.

Here are my Tcl 8.6.9 changes, which exhibit the problem: https://github.com/OpenIndiana/oi-userland/pull/4650/commits/aa001b7c1bdde0cbf7b834b348872485f92404e1.

You can run the SQLite test suite by `make test`, test cases are in tests/.

Here's the window1-13.5 test case from sqlite-src-3260000/test/window1.test:

590 do_execsql_test 13.5 {
591   SELECT a, rank() OVER(ORDER BY b) FROM t1
592     INTERSECT
593   SELECT a, rank() OVER(ORDER BY b DESC) FROM t1;
594 } {
595 }