SQLite
Check-in [7d346250e8]
Not logged in
Overview
SHA1 Hash:7d346250e8a212880c4635a455cc9c98a1395c4c
Date: 2013-01-30 01:46:06
User: drh
Comment:Remove some debugging logic accidently left in the limit.test module.
Tags And Properties
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/limit.test

464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
} {1 {no such column: x}}
do_test limit-12.4 {
  catchsql {
     SELECT * FROM t1 LIMIT 1 OFFSET x
  }
} {1 {no such column: x}}

db close
sqlite3_shutdown
sqlite3_config_lookaside 0 0
sqlite3_initialize
sqlite3 db :memory:
# Ticket [db4d96798da8b]
# LIMIT does not work with nested views containing UNION ALL 
#
do_test limit-13.1 {
  db eval {
    CREATE TABLE t13(x);
    INSERT INTO t13 VALUES(1),(2);







<
<
<
<
<







464
465
466
467
468
469
470





471
472
473
474
475
476
477
} {1 {no such column: x}}
do_test limit-12.4 {
  catchsql {
     SELECT * FROM t1 LIMIT 1 OFFSET x
  }
} {1 {no such column: x}}






# Ticket [db4d96798da8b]
# LIMIT does not work with nested views containing UNION ALL 
#
do_test limit-13.1 {
  db eval {
    CREATE TABLE t13(x);
    INSERT INTO t13 VALUES(1),(2);