[sqlite] more test suite problems on Windows

[Dennis Cote]

I'm still troubleshooting the test suite on Windows.

I'm getting two failures on tests misc7-10 and misc7-11. These test look 
like they should work on Windows without change. Can anybody suggest 
what might be wrong?

The test code in this section is:


   ifcapable vtab {
     # Run some debug code to improve reported coverage
     #

     # set sqlite_where_trace 1
     do_test misc7-10 {
       register_echo_module [sqlite3_connection_pointer db]
       execsql {
         CREATE VIRTUAL TABLE t1 USING echo(abc);
         SELECT a FROM t1 WHERE a = 1 ORDER BY b;
       }
     } {1}
     set sqlite_where_trace 0

     # Specify an ORDER BY clause that cannot be indexed.
     do_test misc7-11 {
       execsql {
         SELECT t1.a, t2.a FROM t1, t1 AS t2 ORDER BY 2 LIMIT 1;
       }
     } {1 1}

     # The whole point of this is to test an error code other than
     # SQLITE_NOMEM from the vtab xBestIndex callback.
     #
     do_ioerr_test misc7-12 -tclprep {
       sqlite3 db2 test.db
       register_echo_module [sqlite3_connection_pointer db2]
       db2 eval {
         CREATE TABLE abc(a PRIMARY KEY, b, c);
         INSERT INTO abc VALUES(1, 2, 3);
         CREATE VIRTUAL TABLE t1 USING echo(abc);
       }
       db2 close
     } -tclbody {
       register_echo_module [sqlite3_connection_pointer db]
       execsql {SELECT * FROM t1 WHERE a = 1;}
     }

     # The case where the virtual table module returns a very large number
     # as the cost of a scan (greater than SQLITE_BIG_DOUBLE in the code).
     #
     do_test misc7-13 {
       sqlite3 db test.db
       register_echo_module [sqlite3_connection_pointer db]
       set ::echo_module_cost 2.0e+99
       execsql {SELECT * FROM t1 WHERE a = 1;}
     } {1 2 3}
     unset ::echo_module_cost
   }

And my results for these tests are:

   misc7-10...
   Expected: [1]
        Got: []
   misc7-11...
   Expected: [1 1]
        Got: []
   misc7-12.1.1... Ok
   misc7-12.1.2... Ok
   misc7-12.1.3... Ok
   misc7-12.2.1... Ok
   misc7-12.2.2... Ok
   misc7-12.2.3... Ok
   misc7-12.3.1... Ok
   misc7-12.3.2... Ok
   misc7-12.3.3... Ok
   misc7-12.4.1... Ok
   misc7-12.4.2... Ok
   misc7-12.4.3... Ok
   misc7-12.5.1... Ok
   misc7-12.5.2... Ok
   misc7-12.5.3... Ok
   misc7-12.6.1... Ok
   misc7-12.6.2... Ok
   misc7-12.6.3... Ok
   misc7-12.7.1... Ok
   misc7-12.7.2... Ok
   misc7-12.7.3... Ok
   misc7-12.8.1... Ok
   misc7-12.8.2... Ok
   misc7-12.8.3... Ok
   misc7-12.9.1... Ok
   misc7-12.9.2... Ok
   misc7-12.9.3... Ok
   misc7-12.10.1... Ok
   misc7-12.10.2... Ok
   misc7-12.10.3... Ok
   misc7-12.11.1... Ok
   misc7-12.11.2... Ok
   misc7-12.11.3... Ok
   misc7-13... Ok

Thanks for any assistance.

Dennis Cote

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------