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: | 02c4b16a7a782ca4395883d755830013 |
| User & Date: | shaneh 2008-12-08 00:58:49 |
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
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 |