sqllogictest

Check-in [577c81ab01]
Login

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

Overview
Comment:Added .test versions of random\select\slt_good*.proto scripts as all cases pass SQLite, MSSQL, and MySQL.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 577c81ab01b8789945eaa53324d11da0fa3ec922
User & Date: shaneh 2008-12-08 01:29:59.000
Context
2008-12-11
05:16
Test cases for SQLite, MSSQL, and MySQL stressing GROUP BY, HAVING, and aggregate functions. check-in: e3edcb9099 user: shaneh tags: trunk
2008-12-08
01:29
Added .test versions of random\select\slt_good*.proto scripts as all cases pass SQLite, MSSQL, and MySQL. check-in: 577c81ab01 user: shaneh tags: trunk
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
Changes
Unified Diff Ignore Whitespace Patch
Added test/random/select/slt_good_0.test.

more than 10,000 changes

Added test/random/select/slt_good_1.test.

more than 10,000 changes

Added test/random/select/slt_good_10.test.

more than 10,000 changes

Added test/random/select/slt_good_100.test.

more than 10,000 changes

Added test/random/select/slt_good_101.test.

more than 10,000 changes

Added test/random/select/slt_good_102.test.

more than 10,000 changes

Added test/random/select/slt_good_103.test.

more than 10,000 changes

Added test/random/select/slt_good_104.test.

more than 10,000 changes

Added test/random/select/slt_good_105.test.

more than 10,000 changes

Added test/random/select/slt_good_106.test.

more than 10,000 changes

Added test/random/select/slt_good_107.test.

more than 10,000 changes

Added test/random/select/slt_good_108.test.

more than 10,000 changes

Added test/random/select/slt_good_109.test.

more than 10,000 changes

Added test/random/select/slt_good_11.test.

more than 10,000 changes

Added test/random/select/slt_good_110.test.

more than 10,000 changes

Added test/random/select/slt_good_111.test.

more than 10,000 changes

Added test/random/select/slt_good_112.test.

more than 10,000 changes

Added test/random/select/slt_good_113.test.

more than 10,000 changes

Added test/random/select/slt_good_114.test.

more than 10,000 changes

Added test/random/select/slt_good_115.test.

more than 10,000 changes

Added test/random/select/slt_good_116.test.

more than 10,000 changes

Added test/random/select/slt_good_117.test.

more than 10,000 changes

Added test/random/select/slt_good_118.test.

more than 10,000 changes

Added test/random/select/slt_good_119.test.

more than 10,000 changes

Added test/random/select/slt_good_12.test.

more than 10,000 changes

Added test/random/select/slt_good_120.test.

more than 10,000 changes

Added test/random/select/slt_good_121.test.

more than 10,000 changes

Added test/random/select/slt_good_122.test.

more than 10,000 changes

Added test/random/select/slt_good_123.test.

more than 10,000 changes

Added test/random/select/slt_good_124.test.

more than 10,000 changes

Added test/random/select/slt_good_125.test.












































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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
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)

Added test/random/select/slt_good_126.test.












































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
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
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)

Added test/random/select/slt_good_13.test.

more than 10,000 changes

Added test/random/select/slt_good_14.test.

more than 10,000 changes

Added test/random/select/slt_good_15.test.

more than 10,000 changes

Added test/random/select/slt_good_16.test.

more than 10,000 changes

Added test/random/select/slt_good_17.test.

more than 10,000 changes

Added test/random/select/slt_good_18.test.

more than 10,000 changes

Added test/random/select/slt_good_19.test.

more than 10,000 changes

Added test/random/select/slt_good_2.test.

more than 10,000 changes

Added test/random/select/slt_good_20.test.

more than 10,000 changes

Added test/random/select/slt_good_21.test.

more than 10,000 changes

Added test/random/select/slt_good_22.test.

more than 10,000 changes

Added test/random/select/slt_good_23.test.

more than 10,000 changes

Added test/random/select/slt_good_24.test.

more than 10,000 changes

Added test/random/select/slt_good_25.test.

more than 10,000 changes

Added test/random/select/slt_good_26.test.

more than 10,000 changes

Added test/random/select/slt_good_27.test.

more than 10,000 changes

Added test/random/select/slt_good_28.test.

more than 10,000 changes

Added test/random/select/slt_good_29.test.

more than 10,000 changes

Added test/random/select/slt_good_3.test.

more than 10,000 changes

Added test/random/select/slt_good_30.test.

more than 10,000 changes

Added test/random/select/slt_good_31.test.

more than 10,000 changes

Added test/random/select/slt_good_32.test.

more than 10,000 changes

Added test/random/select/slt_good_33.test.

more than 10,000 changes

Added test/random/select/slt_good_34.test.

more than 10,000 changes

Added test/random/select/slt_good_35.test.

more than 10,000 changes

Added test/random/select/slt_good_36.test.

more than 10,000 changes

Added test/random/select/slt_good_37.test.

more than 10,000 changes

Added test/random/select/slt_good_38.test.

more than 10,000 changes

Added test/random/select/slt_good_39.test.

more than 10,000 changes

Added test/random/select/slt_good_4.test.

more than 10,000 changes

Added test/random/select/slt_good_40.test.

more than 10,000 changes

Added test/random/select/slt_good_41.test.

more than 10,000 changes

Added test/random/select/slt_good_42.test.

more than 10,000 changes

Added test/random/select/slt_good_43.test.

more than 10,000 changes

Added test/random/select/slt_good_44.test.

more than 10,000 changes

Added test/random/select/slt_good_45.test.

more than 10,000 changes

Added test/random/select/slt_good_46.test.

more than 10,000 changes

Added test/random/select/slt_good_47.test.

more than 10,000 changes

Added test/random/select/slt_good_48.test.

more than 10,000 changes

Added test/random/select/slt_good_49.test.

more than 10,000 changes

Added test/random/select/slt_good_5.test.

more than 10,000 changes

Added test/random/select/slt_good_50.test.

more than 10,000 changes

Added test/random/select/slt_good_51.test.

more than 10,000 changes

Added test/random/select/slt_good_52.test.

more than 10,000 changes

Added test/random/select/slt_good_53.test.

more than 10,000 changes

Added test/random/select/slt_good_54.test.

more than 10,000 changes

Added test/random/select/slt_good_55.test.

more than 10,000 changes

Added test/random/select/slt_good_56.test.

more than 10,000 changes

Added test/random/select/slt_good_57.test.

more than 10,000 changes

Added test/random/select/slt_good_58.test.

more than 10,000 changes

Added test/random/select/slt_good_59.test.

more than 10,000 changes

Added test/random/select/slt_good_6.test.

more than 10,000 changes

Added test/random/select/slt_good_60.test.

more than 10,000 changes

Added test/random/select/slt_good_61.test.

more than 10,000 changes

Added test/random/select/slt_good_62.test.

more than 10,000 changes

Added test/random/select/slt_good_63.test.

more than 10,000 changes

Added test/random/select/slt_good_64.test.

more than 10,000 changes

Added test/random/select/slt_good_65.test.

more than 10,000 changes

Added test/random/select/slt_good_66.test.

more than 10,000 changes

Added test/random/select/slt_good_67.test.

more than 10,000 changes

Added test/random/select/slt_good_68.test.

more than 10,000 changes

Added test/random/select/slt_good_69.test.

more than 10,000 changes

Added test/random/select/slt_good_7.test.

more than 10,000 changes

Added test/random/select/slt_good_70.test.

more than 10,000 changes

Added test/random/select/slt_good_71.test.

more than 10,000 changes

Added test/random/select/slt_good_72.test.

more than 10,000 changes

Added test/random/select/slt_good_73.test.

more than 10,000 changes

Added test/random/select/slt_good_74.test.

more than 10,000 changes

Added test/random/select/slt_good_75.test.

more than 10,000 changes

Added test/random/select/slt_good_76.test.

more than 10,000 changes

Added test/random/select/slt_good_77.test.

more than 10,000 changes

Added test/random/select/slt_good_78.test.

more than 10,000 changes

Added test/random/select/slt_good_79.test.

more than 10,000 changes

Added test/random/select/slt_good_8.test.

more than 10,000 changes

Added test/random/select/slt_good_80.test.

more than 10,000 changes

Added test/random/select/slt_good_81.test.

more than 10,000 changes

Added test/random/select/slt_good_82.test.

more than 10,000 changes

Added test/random/select/slt_good_83.test.

more than 10,000 changes

Added test/random/select/slt_good_84.test.

more than 10,000 changes

Added test/random/select/slt_good_85.test.

more than 10,000 changes

Added test/random/select/slt_good_86.test.

more than 10,000 changes

Added test/random/select/slt_good_87.test.

more than 10,000 changes

Added test/random/select/slt_good_88.test.

more than 10,000 changes

Added test/random/select/slt_good_89.test.

more than 10,000 changes

Added test/random/select/slt_good_9.test.

more than 10,000 changes

Added test/random/select/slt_good_90.test.

more than 10,000 changes

Added test/random/select/slt_good_91.test.

more than 10,000 changes

Added test/random/select/slt_good_92.test.

more than 10,000 changes

Added test/random/select/slt_good_93.test.

more than 10,000 changes

Added test/random/select/slt_good_94.test.

more than 10,000 changes

Added test/random/select/slt_good_95.test.

more than 10,000 changes

Added test/random/select/slt_good_96.test.

more than 10,000 changes

Added test/random/select/slt_good_97.test.

more than 10,000 changes

Added test/random/select/slt_good_98.test.

more than 10,000 changes

Added test/random/select/slt_good_99.test.

more than 10,000 changes