sqllogictest

Check-in [02c4b16a7a]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Some cases that report different results between SQLite and MSSQL.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 02c4b16a7a782ca4395883d755830013d2c0f811
User & Date: shaneh 2008-12-08 00:58:49.000
Context
2008-12-08
01:02
Updated scripts so that all cases pass on SQLite, MSSQL, and MySQL. Many cases had "skipif mysql" and comparable "onlyif mysql" records added. Added labels between equivalent "onlyif mysql" and other queries. Made attempt to add "skipif postgresql" to queries with miss "AS" keywords. check-in: db2551f6d3 user: shaneh tags: trunk
00:58
Some cases that report different results between SQLite and MSSQL. check-in: 02c4b16a7a user: shaneh tags: trunk
00:57
Consistent line endings. check-in: 3200dc168f user: shaneh tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Added proto/random/select/slt_bad_775.proto.
















































































































































































































































































































































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
hash-threshold 8

statement ok
CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER)

statement ok
CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER)

statement ok
CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER)

statement ok
INSERT INTO tab0 VALUES(89,91,82)

statement ok
INSERT INTO tab0 VALUES(35,97,1)

statement ok
INSERT INTO tab0 VALUES(24,86,33)

statement ok
INSERT INTO tab1 VALUES(64,10,57)

statement ok
INSERT INTO tab1 VALUES(3,26,54)

statement ok
INSERT INTO tab1 VALUES(80,13,96)

statement ok
INSERT INTO tab2 VALUES(7,31,27)

statement ok
INSERT INTO tab2 VALUES(79,17,38)

statement ok
INSERT INTO tab2 VALUES(78,59,26)

query I rowsort
SELECT + - col1 + - 3 * - col2 / + col0 AS col0 FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT - cor0.col1 / + CAST ( - 96 AS REAL ) + - col2 + - 3 FROM tab2 AS cor0

query I rowsort
SELECT - 8 * + col1 / + ( - col2 * col0 ) FROM tab0

query I rowsort
SELECT DISTINCT col0 + - col1 * - 8 / ( cor0.col2 + - col0 * cor0.col2 ) AS col2 FROM tab1 AS cor0

query I rowsort
SELECT - 39 / + ( col2 + + ( - 26 ) ) AS col0 FROM tab2 AS cor0

query I rowsort
SELECT ALL ( cor0.col1 ) + + col1 / + col2 + col2 * - col0 * CAST ( + col1 + col0 * + cor0.col0 AS REAL ) AS col2 FROM tab0 AS cor0

query I rowsort
SELECT - cor0.col0 * + col2 / + ( - 96 + - col2 * col2 ) FROM tab1 AS cor0

query I rowsort
SELECT - tab0.col1 / ( tab0.col2 * col2 + - tab0.col2 ) FROM tab0

query I rowsort
SELECT - col0 * - col0 / + ( - col2 * - col0 ) AS col2 FROM tab1 AS cor0

query I rowsort
SELECT + col1 + - CAST ( - col0 AS INTEGER ) * + col2 / CAST ( col1 AS REAL ) FROM tab2 AS cor0

query I rowsort
SELECT ALL - col0 * - col2 * CAST ( col0 * col0 + col2 AS REAL ) AS col2 FROM tab0

query I rowsort
SELECT ALL + col1 * + col0 * CAST ( col2 + + col2 * - col2 AS REAL ) AS col0 FROM tab0

query I rowsort
SELECT - + col1 * - col2 / - 74 AS col2 FROM tab2 AS cor0

query I rowsort
SELECT ALL - - col1 * + cor0.col2 / 76 FROM tab2 AS cor0

query I rowsort
SELECT + col2 - col1 / + ( - col1 + + 97 ) AS col0 FROM tab0

query I rowsort
SELECT col1 + - col0 / ( tab0.col0 * + col2 + - tab0.col0 ) AS col0 FROM tab0

query I rowsort
SELECT - - 98 * - 72 / + col1 + - col1 * + 59 FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT + col2 * + col1 / - 3 FROM tab2 AS cor0

query I rowsort
SELECT - 3 * + cor1.col2 / + cor1.col0 + cor0.col0 AS col2 FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1

query I rowsort
SELECT - tab0.col2 / + ( ( - tab0.col1 ) + col1 * col2 ) FROM tab0

query I rowsort
SELECT DISTINCT col0 * - col0 / ( - col0 * 61 ) + + col2 FROM tab2

query I rowsort
SELECT + col1 * - col2 / ( 60 * col0 + - col1 ) FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT col0 * + col0 / 3 AS col2 FROM tab0 cor0

query I rowsort
SELECT col0 * + col2 / + CAST ( + 15 AS REAL ) FROM tab0 AS cor0

query I rowsort
SELECT col0 + cor0.col0 / ( 31 + - cor0.col1 ) FROM tab2 AS cor0

query III rowsort
SELECT DISTINCT * FROM tab0 WHERE NOT ( - col0 + + col1 * + col1 / col0 + - col1 ) > ( + col1 )

query I rowsort
SELECT + col2 * - col0 / ( col2 * - 86 ) FROM tab0 AS cor0

query I rowsort
SELECT DISTINCT + col1 * + col2 / - 73 AS col1 FROM tab2

query I rowsort
SELECT - cor0.col2 * - 9 / + col1 + - 1 + - col0 AS col2 FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT col2 * + 81 / - col1 AS col1 FROM tab2

query I rowsort
SELECT - 7 * + col2 / - ( - col0 * col0 ) + CAST ( 10 AS REAL ) col1 FROM tab2

query I rowsort
SELECT cor0.col1 + ( - 5 ) * + cor0.col2 / ( 74 ) FROM tab0, tab2 AS cor0

query I rowsort
SELECT DISTINCT - col2 + - ( - col2 ) * col0 / CAST ( - col1 AS REAL ) - cor0.col0 FROM tab2 AS cor0

query I rowsort
SELECT + CAST ( 78 AS REAL ) + - col2 * cor0.col0 * - ( col0 * 59 ) AS col0 FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT + col0 * + col2 / - ( - col2 * + cor0.col2 ) FROM tab1 AS cor0

query I rowsort
SELECT col2 + col0 * + tab1.col0 / + ( - col1 + col1 * col2 ) FROM tab1

query I rowsort
SELECT DISTINCT - col1 * + col2 / ( - ( + col0 ) * - col0 ) FROM tab2 AS cor0

query I rowsort
SELECT col1 - + col1 * + col1 / 3 FROM tab2

query I rowsort
SELECT ALL 35 * + col1 / 3 FROM tab2 AS cor0

query III rowsort
SELECT * FROM tab2 WHERE ( + col2 ) NOT IN ( col2 * + col0 / + col1 )

query I rowsort
SELECT DISTINCT 15 - col2 * + col1 / + ( - col2 * + col2 + col0 ) AS col0 FROM tab2

query I rowsort
SELECT - + 2 * + col2 / col1 FROM tab2 AS cor0

query I rowsort
SELECT + col1 * + col2 / ( 75 ) FROM tab2 AS cor0

query I rowsort
SELECT + col0 / CAST ( 12 AS REAL ) AS col0 FROM tab0

query I rowsort
SELECT - col1 + col0 / ( - 17 + + col1 ) FROM tab2

query I rowsort
SELECT DISTINCT + col0 + col0 * + col0 / + ( col0 + - col2 * - col0 ) FROM tab1 AS cor0

query I rowsort
SELECT DISTINCT - 3 * + col2 / + 75 FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT + 53 * - col0 / - 3 FROM tab0 AS cor0

query I rowsort
SELECT - col1 * 68 * tab0.col1 + + CAST ( 9 AS REAL ) * - col0 + ( - col0 ) * + col2 * - ( + col0 * col0 ) FROM tab0

query I rowsort
SELECT + - ( + 51 ) * - col0 / ( col1 * + col2 + - col1 ) FROM tab1 AS cor0

query I rowsort
SELECT - col0 * - ( - 1 ) / - col2 FROM tab1 AS cor0

query I rowsort
SELECT - col1 * + col2 / + 73 AS col2 FROM tab2 AS cor0

query I rowsort
SELECT + col0 * + 72 / - cor0.col1 FROM tab2 AS cor0

query I rowsort
SELECT DISTINCT - col1 * - col0 / + CAST ( + col2 * - cor0.col1 AS INTEGER ) FROM tab1 AS cor0