sqllogictest

Check-in [bf3dafd972]
Login

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.510
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
Unified Diff Ignore Whitespace Patch
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