/ Check-in [7d346250]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove some debugging logic accidently left in the limit.test module.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7d346250e8a212880c4635a455cc9c98a1395c4c
User & Date: drh 2013-01-30 01:46:06
Context
2013-02-07
05:12
Add the ability to skip defining the localtime() function when being compiled for WinCE. check-in: e1640876 user: mistachkin tags: trunk
2013-01-30
01:46
Remove some debugging logic accidently left in the limit.test module. check-in: 7d346250 user: drh tags: trunk
2013-01-29
23:55
Fix LIMIT and OFFSET so that they work and do not leak memory even on complex queries involving deeply nested views of UNION ALL compounds. Ticket [db4d96798da8]. Secondary to ticket [d58ccbb3f1b7]. check-in: 497ee36c user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/limit.test.

   464    464   } {1 {no such column: x}}
   465    465   do_test limit-12.4 {
   466    466     catchsql {
   467    467        SELECT * FROM t1 LIMIT 1 OFFSET x
   468    468     }
   469    469   } {1 {no such column: x}}
   470    470   
   471         -db close
   472         -sqlite3_shutdown
   473         -sqlite3_config_lookaside 0 0
   474         -sqlite3_initialize
   475         -sqlite3 db :memory:
   476    471   # Ticket [db4d96798da8b]
   477    472   # LIMIT does not work with nested views containing UNION ALL 
   478    473   #
   479    474   do_test limit-13.1 {
   480    475     db eval {
   481    476       CREATE TABLE t13(x);
   482    477       INSERT INTO t13 VALUES(1),(2);