Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a test case that demonstrates ticket [c997b11c4d53a2ee9983]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
598f5f7596b0557b22f31e6643a59ff9 |
| User & Date: | drh 2013-01-09 11:25:27 |
| Original Comment: | Add a test case that demonstrates ticket [956e4d7f8958e7065f]. |
Context
|
2013-01-09
| ||
| 11:27 | Fix the date on the new orderby3.test test case. (check-in: 7249bfc2 user: drh tags: trunk) | |
| 11:25 | Add a test case that demonstrates ticket [c997b11c4d53a2ee9983]. (check-in: 598f5f75 user: drh tags: trunk) | |
|
2013-01-08
| ||
| 12:48 | Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. (check-in: cda79028 user: drh tags: trunk) | |
Changes
Added test/orderby3.test.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 |
# 2012 Sept 27
#
# The author disclaims copyright to this source code. In place of
# a legal notice, here is a blessing:
#
# May you do good and not evil.
# May you find forgiveness for yourself and forgive others.
# May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library. The
# focus of this file is testing that the optimizations that disable
# ORDER BY clauses work correctly on a 3-way join. See ticket
# http://www.sqlite.org/src/956e4d7f89
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
set ::testprefix orderby3
# Generate test data for a join. Verify that the join gets the
# correct answer.
#
do_execsql_test 1.0 {
CREATE TABLE t1(a INTEGER PRIMARY KEY);
CREATE TABLE t2(b INTEGER PRIMARY KEY, c INTEGER);
CREATE TABLE t3(d INTEGER);
INSERT INTO t1 VALUES(1),(2),(3);
INSERT INTO t2 VALUES(3, 1);
INSERT INTO t2 VALUES(4, 2);
INSERT INTO t2 VALUES(5, 3);
INSERT INTO t3 VALUES(4),(3),(5);
} {}
do_execsql_test 1.1.asc {
SELECT t1.a
FROM t1, t2, t3
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.1.desc {
SELECT t1.a
FROM t1, t2, t3
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
do_execsql_test 1.123.asc {
SELECT t1.a
FROM t1 CROSS JOIN t2 CROSS JOIN t3
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.123.desc {
SELECT t1.a
FROM t1 CROSS JOIN t2 CROSS JOIN t3
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
do_execsql_test 1.132.asc {
SELECT t1.a
FROM t1 CROSS JOIN t3 CROSS JOIN t2
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.132.desc {
SELECT t1.a
FROM t1 CROSS JOIN t3 CROSS JOIN t2
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
do_execsql_test 1.213.asc {
SELECT t1.a
FROM t2 CROSS JOIN t1 CROSS JOIN t3
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.213.desc {
SELECT t1.a
FROM t2 CROSS JOIN t1 CROSS JOIN t3
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
do_execsql_test 1.231.asc {
SELECT t1.a
FROM t2 CROSS JOIN t3 CROSS JOIN t1
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.231.desc {
SELECT t1.a
FROM t2 CROSS JOIN t3 CROSS JOIN t1
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
do_execsql_test 1.312.asc {
SELECT t1.a
FROM t3 CROSS JOIN t1 CROSS JOIN t2
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.312.desc {
SELECT t1.a
FROM t3 CROSS JOIN t1 CROSS JOIN t2
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
do_execsql_test 1.321.asc {
SELECT t1.a
FROM t3 CROSS JOIN t2 CROSS JOIN t1
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a;
} {1 2 3}
do_execsql_test 1.321.desc {
SELECT t1.a
FROM t3 CROSS JOIN t2 CROSS JOIN t1
WHERE t1.a=t2.c AND t2.b=t3.d
ORDER BY t1.a DESC;
} {3 2 1}
finish_test
|