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: |
7d346250e8a212880c4635a455cc9c98 |
| 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
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);
|