Tcl Source Code

View Ticket
Login
2020-01-05
09:55 • Ticket [2c154a40be] SQLite TCL Test suite regressions status still Closed wi... artifact: c2bde0d8fe user: mnowak
2019-05-04
07:10
Make sure we test [2c154a40be] explicitly. Part of [cc191552c] check-in: 037beb7a3c user: dkf tags: core-8-6-branch
06:57 • Ticket [2c154a40be] SQLite TCL Test suite regressions status still Closed wi... artifact: ccf8d3c360 user: dkf
06:57 • Ticket [2c154a40be]: 6 changes artifact: ce25f091b8 user: dkf
2018-12-17
10:25 • Closed ticket [2c154a40be]. artifact: aedc868e25 user: oehhar
2018-12-16
15:55 • New ticket [2c154a40be]. artifact: 95becb6e77 user: mnowak

Ticket UUID: 2c154a40be9e1dd81694485ed9558a9eb831f55b
Title: SQLite TCL Test suite regressions
Type: Bug Created on: 2018-12-16 15:55:20
Submitter: mnowak Assigned to: nobody
Subsystem: 47. Bytecode Compiler Severity: Important
Priority: 5 Medium Last modified: 2020-01-05 09:55:43
Status: Closed Closed by: mnowak
Resolution: Duplicate Closed on: 2020-01-05 09:55:43
Version: 8.6.9
Description:
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 }
User Comments:
oehhar added on 2018-12-17 10:25:30:

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


dkf added on 2019-05-04 06:57:03:

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.


mnowak added on 2020-01-05 09:55:43:
Fixed in Tcl/Tk 8.6.10, thanks.