Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add tests to ensure that this branch really does fix ticket [f8a7060ece]. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | nulls-last |
| Files: | files | file ages | folders |
| SHA3-256: |
f892066425671a8a0ac923e3ad474467 |
| User & Date: | dan 2019-08-17 18:16:59.747 |
Context
|
2019-08-19
| ||
| 17:26 | Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. (check-in: bb9767a287 user: dan tags: nulls-last) | |
|
2019-08-17
| ||
| 18:16 | Add tests to ensure that this branch really does fix ticket [f8a7060ece]. (check-in: f892066425 user: dan tags: nulls-last) | |
| 17:55 | Fix problem with DESC indexes on this branch. (check-in: b49df1fe9b user: dan tags: nulls-last) | |
Changes
Changes to test/minmax4.test.
| ︙ | ︙ | |||
195 196 197 198 199 200 201 202 203 |
CREATE TABLE t1 (a, b);
INSERT INTO t1 VALUES(123, NULL);
CREATE INDEX i1 ON t1(a, b DESC);
}
do_execsql_test 5.1 {
SELECT MIN(a) FROM t1 WHERE a=123;
} {123}
finish_test
| > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 |
CREATE TABLE t1 (a, b);
INSERT INTO t1 VALUES(123, NULL);
CREATE INDEX i1 ON t1(a, b DESC);
}
do_execsql_test 5.1 {
SELECT MIN(a) FROM t1 WHERE a=123;
} {123}
#-------------------------------------------------------------------------
# Tests for ticket f8a7060ece.
#
reset_db
do_execsql_test 6.1.0 {
CREATE TABLE t1(a, b, c);
INSERT INTO t1 VALUES(NULL, 1, 'x');
CREATE INDEX i1 ON t1(a);
}
do_execsql_test 6.1.1 {
SELECT min(a), b, c FROM t1 WHERE c='x';
} {{} 1 x}
do_execsql_test 6.1.2 {
INSERT INTO t1 VALUES(1, 2, 'y');
} {}
do_execsql_test 6.1.3 {
SELECT min(a), b, c FROM t1 WHERE c='x';
} {{} 1 x}
do_execsql_test 6.2.0 {
CREATE TABLE t0(c0 UNIQUE, c1);
INSERT INTO t0(c1) VALUES (0);
INSERT INTO t0(c0) VALUES (0);
CREATE VIEW v0(c0, c1) AS
SELECT t0.c1, t0.c0 FROM t0 WHERE CAST(t0.rowid AS INT) = 1;
}
do_execsql_test 6.2.1 {
SELECT c0, c1 FROM v0;
} {0 {}}
do_execsql_test 6.2.2 {
SELECT v0.c0, MIN(v0.c1) FROM v0;
} {0 {}}
finish_test
|