tdbc::sqlite3

Ticket Change Details
Login
Overview

Artifact ID: 532287603df0ed4e77314643eb9de56fd04cf07bc9eef7a6f74d27353faf7cc8
Ticket: 145df89159588c565bc1ee20769385889b6095ae
SQLite TCL Test suite regressions
User & Date: oehhar 2018-12-17 10:21:10
Changes

  1. foundin changed to: "8.6.9"
  2. icomment:
    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 }
    
  3. login: "oehhar"
  4. mimetype: "text/x-fossil-plain"
  5. private_contact changed to: "826e03c82c5753e4a748e69af5b198873bd7522c"
  6. severity changed to: "Critical"
  7. status changed to: "Open"
  8. title changed to: "SQLite TCL Test suite regressions"
  9. type changed to: "Code_Defect"