sqllogictest
Check-in [02c4b16a7a]
Not logged in

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
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Added proto/random/select/slt_bad_775.proto.

            1  +hash-threshold 8
            2  +
            3  +statement ok
            4  +CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER)
            5  +
            6  +statement ok
            7  +CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER)
            8  +
            9  +statement ok
           10  +CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER)
           11  +
           12  +statement ok
           13  +INSERT INTO tab0 VALUES(89,91,82)
           14  +
           15  +statement ok
           16  +INSERT INTO tab0 VALUES(35,97,1)
           17  +
           18  +statement ok
           19  +INSERT INTO tab0 VALUES(24,86,33)
           20  +
           21  +statement ok
           22  +INSERT INTO tab1 VALUES(64,10,57)
           23  +
           24  +statement ok
           25  +INSERT INTO tab1 VALUES(3,26,54)
           26  +
           27  +statement ok
           28  +INSERT INTO tab1 VALUES(80,13,96)
           29  +
           30  +statement ok
           31  +INSERT INTO tab2 VALUES(7,31,27)
           32  +
           33  +statement ok
           34  +INSERT INTO tab2 VALUES(79,17,38)
           35  +
           36  +statement ok
           37  +INSERT INTO tab2 VALUES(78,59,26)
           38  +
           39  +query I rowsort
           40  +SELECT + - col1 + - 3 * - col2 / + col0 AS col0 FROM tab2 AS cor0
           41  +
           42  +query I rowsort
           43  +SELECT DISTINCT - cor0.col1 / + CAST ( - 96 AS REAL ) + - col2 + - 3 FROM tab2 AS cor0
           44  +
           45  +query I rowsort
           46  +SELECT - 8 * + col1 / + ( - col2 * col0 ) FROM tab0
           47  +
           48  +query I rowsort
           49  +SELECT DISTINCT col0 + - col1 * - 8 / ( cor0.col2 + - col0 * cor0.col2 ) AS col2 FROM tab1 AS cor0
           50  +
           51  +query I rowsort
           52  +SELECT - 39 / + ( col2 + + ( - 26 ) ) AS col0 FROM tab2 AS cor0
           53  +
           54  +query I rowsort
           55  +SELECT ALL ( cor0.col1 ) + + col1 / + col2 + col2 * - col0 * CAST ( + col1 + col0 * + cor0.col0 AS REAL ) AS col2 FROM tab0 AS cor0
           56  +
           57  +query I rowsort
           58  +SELECT - cor0.col0 * + col2 / + ( - 96 + - col2 * col2 ) FROM tab1 AS cor0
           59  +
           60  +query I rowsort
           61  +SELECT - tab0.col1 / ( tab0.col2 * col2 + - tab0.col2 ) FROM tab0
           62  +
           63  +query I rowsort
           64  +SELECT - col0 * - col0 / + ( - col2 * - col0 ) AS col2 FROM tab1 AS cor0
           65  +
           66  +query I rowsort
           67  +SELECT + col1 + - CAST ( - col0 AS INTEGER ) * + col2 / CAST ( col1 AS REAL ) FROM tab2 AS cor0
           68  +
           69  +query I rowsort
           70  +SELECT ALL - col0 * - col2 * CAST ( col0 * col0 + col2 AS REAL ) AS col2 FROM tab0
           71  +
           72  +query I rowsort
           73  +SELECT ALL + col1 * + col0 * CAST ( col2 + + col2 * - col2 AS REAL ) AS col0 FROM tab0
           74  +
           75  +query I rowsort
           76  +SELECT - + col1 * - col2 / - 74 AS col2 FROM tab2 AS cor0
           77  +
           78  +query I rowsort
           79  +SELECT ALL - - col1 * + cor0.col2 / 76 FROM tab2 AS cor0
           80  +
           81  +query I rowsort
           82  +SELECT + col2 - col1 / + ( - col1 + + 97 ) AS col0 FROM tab0
           83  +
           84  +query I rowsort
           85  +SELECT col1 + - col0 / ( tab0.col0 * + col2 + - tab0.col0 ) AS col0 FROM tab0
           86  +
           87  +query I rowsort
           88  +SELECT - - 98 * - 72 / + col1 + - col1 * + 59 FROM tab2 AS cor0
           89  +
           90  +query I rowsort
           91  +SELECT DISTINCT + col2 * + col1 / - 3 FROM tab2 AS cor0
           92  +
           93  +query I rowsort
           94  +SELECT - 3 * + cor1.col2 / + cor1.col0 + cor0.col0 AS col2 FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1
           95  +
           96  +query I rowsort
           97  +SELECT - tab0.col2 / + ( ( - tab0.col1 ) + col1 * col2 ) FROM tab0
           98  +
           99  +query I rowsort
          100  +SELECT DISTINCT col0 * - col0 / ( - col0 * 61 ) + + col2 FROM tab2
          101  +
          102  +query I rowsort
          103  +SELECT + col1 * - col2 / ( 60 * col0 + - col1 ) FROM tab2 AS cor0
          104  +
          105  +query I rowsort
          106  +SELECT DISTINCT col0 * + col0 / 3 AS col2 FROM tab0 cor0
          107  +
          108  +query I rowsort
          109  +SELECT col0 * + col2 / + CAST ( + 15 AS REAL ) FROM tab0 AS cor0
          110  +
          111  +query I rowsort
          112  +SELECT col0 + cor0.col0 / ( 31 + - cor0.col1 ) FROM tab2 AS cor0
          113  +
          114  +query III rowsort
          115  +SELECT DISTINCT * FROM tab0 WHERE NOT ( - col0 + + col1 * + col1 / col0 + - col1 ) > ( + col1 )
          116  +
          117  +query I rowsort
          118  +SELECT + col2 * - col0 / ( col2 * - 86 ) FROM tab0 AS cor0
          119  +
          120  +query I rowsort
          121  +SELECT DISTINCT + col1 * + col2 / - 73 AS col1 FROM tab2
          122  +
          123  +query I rowsort
          124  +SELECT - cor0.col2 * - 9 / + col1 + - 1 + - col0 AS col2 FROM tab2 AS cor0
          125  +
          126  +query I rowsort
          127  +SELECT DISTINCT col2 * + 81 / - col1 AS col1 FROM tab2
          128  +
          129  +query I rowsort
          130  +SELECT - 7 * + col2 / - ( - col0 * col0 ) + CAST ( 10 AS REAL ) col1 FROM tab2
          131  +
          132  +query I rowsort
          133  +SELECT cor0.col1 + ( - 5 ) * + cor0.col2 / ( 74 ) FROM tab0, tab2 AS cor0
          134  +
          135  +query I rowsort
          136  +SELECT DISTINCT - col2 + - ( - col2 ) * col0 / CAST ( - col1 AS REAL ) - cor0.col0 FROM tab2 AS cor0
          137  +
          138  +query I rowsort
          139  +SELECT + CAST ( 78 AS REAL ) + - col2 * cor0.col0 * - ( col0 * 59 ) AS col0 FROM tab2 AS cor0
          140  +
          141  +query I rowsort
          142  +SELECT DISTINCT + col0 * + col2 / - ( - col2 * + cor0.col2 ) FROM tab1 AS cor0
          143  +
          144  +query I rowsort
          145  +SELECT col2 + col0 * + tab1.col0 / + ( - col1 + col1 * col2 ) FROM tab1
          146  +
          147  +query I rowsort
          148  +SELECT DISTINCT - col1 * + col2 / ( - ( + col0 ) * - col0 ) FROM tab2 AS cor0
          149  +
          150  +query I rowsort
          151  +SELECT col1 - + col1 * + col1 / 3 FROM tab2
          152  +
          153  +query I rowsort
          154  +SELECT ALL 35 * + col1 / 3 FROM tab2 AS cor0
          155  +
          156  +query III rowsort
          157  +SELECT * FROM tab2 WHERE ( + col2 ) NOT IN ( col2 * + col0 / + col1 )
          158  +
          159  +query I rowsort
          160  +SELECT DISTINCT 15 - col2 * + col1 / + ( - col2 * + col2 + col0 ) AS col0 FROM tab2
          161  +
          162  +query I rowsort
          163  +SELECT - + 2 * + col2 / col1 FROM tab2 AS cor0
          164  +
          165  +query I rowsort
          166  +SELECT + col1 * + col2 / ( 75 ) FROM tab2 AS cor0
          167  +
          168  +query I rowsort
          169  +SELECT + col0 / CAST ( 12 AS REAL ) AS col0 FROM tab0
          170  +
          171  +query I rowsort
          172  +SELECT - col1 + col0 / ( - 17 + + col1 ) FROM tab2
          173  +
          174  +query I rowsort
          175  +SELECT DISTINCT + col0 + col0 * + col0 / + ( col0 + - col2 * - col0 ) FROM tab1 AS cor0
          176  +
          177  +query I rowsort
          178  +SELECT DISTINCT - 3 * + col2 / + 75 FROM tab2 AS cor0
          179  +
          180  +query I rowsort
          181  +SELECT DISTINCT + 53 * - col0 / - 3 FROM tab0 AS cor0
          182  +
          183  +query I rowsort
          184  +SELECT - col1 * 68 * tab0.col1 + + CAST ( 9 AS REAL ) * - col0 + ( - col0 ) * + col2 * - ( + col0 * col0 ) FROM tab0
          185  +
          186  +query I rowsort
          187  +SELECT + - ( + 51 ) * - col0 / ( col1 * + col2 + - col1 ) FROM tab1 AS cor0
          188  +
          189  +query I rowsort
          190  +SELECT - col0 * - ( - 1 ) / - col2 FROM tab1 AS cor0
          191  +
          192  +query I rowsort
          193  +SELECT - col1 * + col2 / + 73 AS col2 FROM tab2 AS cor0
          194  +
          195  +query I rowsort
          196  +SELECT + col0 * + 72 / - cor0.col1 FROM tab2 AS cor0
          197  +
          198  +query I rowsort
          199  +SELECT DISTINCT - col1 * - col0 / + CAST ( + col2 * - cor0.col1 AS INTEGER ) FROM tab1 AS cor0
          200  +