Tcl Source Code

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 }

Fixed in Tcl/Tk 8.6.10, thanks.

This is (after a bit of digging around in the SQLite sources) a duplicate of [cc1e91552c].

It's not a bug in tdbc::sqlite3 at all.
It's also not a bug in SQLite, though I'd have loved to have known about it when they found it.

Thank you for the ticket.

I think, it should better be placed within the tdbc::sqlite tracker.
I have moved it there:

[https://core.tcl.tk/tdbcsqlite3/info/145df89159588c56]

Speak up, if not ok.

Thanks,
Harald