Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Skip MSSQL for several tests that are incompatible with it. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | bf3dafd972a708d10aded9b63d04b93d9e94bc3e |
| User & Date: | mistachkin 2014-02-11 07:54:58 |
Context
|
2014-03-05
| ||
| 19:27 | Update the built-in SQLite to 3.8.4 beta. check-in: ba3a2680e0 user: drh tags: trunk | |
|
2014-02-11
| ||
| 07:54 | Skip MSSQL for several tests that are incompatible with it. check-in: bf3dafd972 user: mistachkin tags: trunk | |
| 07:40 | Use standard engine naming for PostgreSQL as the tests already rely on it. check-in: b5e970313f user: mistachkin tags: trunk | |
Changes
Changes to test/evidence/slt_lang_dropindex.test.
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
statement ok CREATE INDEX t1i1 ON t1(x) # EVIDENCE-OF: R-42037-15614 The DROP INDEX statement removes an index # added with the CREATE INDEX statement. statement ok DROP INDEX t1i1; # this should error, as already dropped statement error DROP INDEX t1i1; # this should error, as never existed statement error DROP INDEX tXiX; |
> > > |
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
statement ok CREATE INDEX t1i1 ON t1(x) # EVIDENCE-OF: R-42037-15614 The DROP INDEX statement removes an index # added with the CREATE INDEX statement. skipif mssql statement ok DROP INDEX t1i1; # this should error, as already dropped skipif mssql statement error DROP INDEX t1i1; # this should error, as never existed skipif mssql statement error DROP INDEX tXiX; |
Changes to test/evidence/slt_lang_update.test.
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 |
---- 3 # EVIDENCE-OF: R-34751-18293 If a single column-name appears more than # once in the list of assignment expressions, all but the rightmost # occurrence is ignored. statement ok UPDATE t1 SET x=3, x=4, x=5 query I rowsort SELECT count(*) FROM t1 WHERE x=3 ---- 0 query I rowsort SELECT count(*) FROM t1 WHERE x=4 ---- 0 query I rowsort SELECT count(*) FROM t1 WHERE x=5 ---- 3 # EVIDENCE-OF: R-40472-60438 Columns that do not appear in the list of # assignments are left unmodified. |
> > > > |
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 |
---- 3 # EVIDENCE-OF: R-34751-18293 If a single column-name appears more than # once in the list of assignment expressions, all but the rightmost # occurrence is ignored. skipif mssql statement ok UPDATE t1 SET x=3, x=4, x=5 skipif mssql query I rowsort SELECT count(*) FROM t1 WHERE x=3 ---- 0 skipif mssql query I rowsort SELECT count(*) FROM t1 WHERE x=4 ---- 0 skipif mssql query I rowsort SELECT count(*) FROM t1 WHERE x=5 ---- 3 # EVIDENCE-OF: R-40472-60438 Columns that do not appear in the list of # assignments are left unmodified. |
Changes to test/random/groupby/slt_good_11.test.
68657 68658 68659 68660 68661 68662 68663 68664 68665 68666 68667 68668 68669 68670 |
onlyif mysql # CAST syntax: SIGNED type: DIV for integer division: query III rowsort label-9684 SELECT col0 DIV - - 41 * - col0 col1, + col0 * + col0, - 3 * + CAST( NULL AS SIGNED ) AS col1 FROM tab2 cor0 GROUP BY col0 ---- 9 values hashing to 28d1a296c6990b10de76d21db8c99739 skipif mysql # not compatible skipif postgresql # PostgreSQL requires AS when renaming output columns query III rowsort label-9684 SELECT col0 / - - 41 * - col0 col1, + col0 * + col0, - 3 * + CAST ( NULL AS INTEGER ) AS col1 FROM tab2 cor0 GROUP BY col0 ---- 9 values hashing to 28d1a296c6990b10de76d21db8c99739 |
> |
68657 68658 68659 68660 68661 68662 68663 68664 68665 68666 68667 68668 68669 68670 68671 |
onlyif mysql # CAST syntax: SIGNED type: DIV for integer division:
query III rowsort label-9684
SELECT col0 DIV - - 41 * - col0 col1, + col0 * + col0, - 3 * + CAST( NULL AS SIGNED ) AS col1 FROM tab2 cor0 GROUP BY col0
----
9 values hashing to 28d1a296c6990b10de76d21db8c99739
skipif mssql # not compatible
skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query III rowsort label-9684
SELECT col0 / - - 41 * - col0 col1, + col0 * + col0, - 3 * + CAST ( NULL AS INTEGER ) AS col1 FROM tab2 cor0 GROUP BY col0
----
9 values hashing to 28d1a296c6990b10de76d21db8c99739
|