Changeset: 1cf8078d98c7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1cf8078d98c7
Modified Files:
sql/test/BugTracker-2017/Tests/All
sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.out
sql/test/BugTracker-2017/Tests/limit.Bug-6322.sql
sql/test/BugTracker-2017/Tests/limit.Bug-6322.stable.out
sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.sql
sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.stable.out
sql/test/BugTracker-2017/Tests/push_subslice.Bug-6322.sql
sql/test/BugTracker-2017/Tests/push_subslice.Bug-6322.stable.out
sql/test/BugTracker-2017/Tests/rel2bin_project-assert.Bug-6080.sql
sql/test/BugTracker-2017/Tests/rel2bin_project-assert.Bug-6080.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith-semijoin-constant.bug-6417.sql
sql/test/BugTracker-2017/Tests/sqlsmith-semijoin-constant.bug-6417.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6216.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6216.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6217.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6217.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6219.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6219.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6418.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6418.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6424.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6425.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6425.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.sql
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.stable.err
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6432.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith01.sql
sql/test/BugTracker-2017/Tests/sqlsmith01.stable.out
sql/test/BugTracker-2017/Tests/sqlsmith04.sql
sql/test/BugTracker-2017/Tests/sqlsmith04.stable.out
Branch: default
Log Message:
Using local tables instead of system tables at sqlsmith tests. Therefore we can
compare the correctness of results, plus require less dependencies to run these
tests
diffs (truncated from 1826 to 300 lines):
diff --git a/sql/test/BugTracker-2017/Tests/All
b/sql/test/BugTracker-2017/Tests/All
--- a/sql/test/BugTracker-2017/Tests/All
+++ b/sql/test/BugTracker-2017/Tests/All
@@ -21,23 +21,23 @@ complicated_logic.Bug-105
crash_on_count_div_count.Bug-6201
oidx-on-strings.Bug-6202
group-by-on-constant.Bug-6082
-HAVE_GEOM&HAVE_NETCDF?rel2bin_project-assert.Bug-6080
+rel2bin_project-assert.Bug-6080
str2decimal.Bug-6206
integer_addition_overflow.Bug-6205
dce_bug-6177
default-insert-update.Bug-6249
crash_on_NULL_ptr.Bug-6130
-HAVE_GEOM&HAVE_SAMTOOLS?sqlsmith01
+sqlsmith01
HAVE_GEOM&HAVE_NETCDF?sqlsmith02
HAVE_GEOM?sqlsmith03
-HAVE_GEOM?sqlsmith04
+sqlsmith04
nested_with.Bug-6187
prepare.Bug-6133
null-quantile.Bug-6218
sqlsmith.Bug-6216
sqlsmith.Bug-6217
real-power.Bug-6228
-HAVE_NETCDF?sqlsmith.Bug-6219
+sqlsmith.Bug-6219
create_view_order_by.Bug-3465
cast_boolean_to_string.Bug-6110
modulo.Bug-6225
@@ -56,15 +56,15 @@ nestedoperators.Bug-6292
not_plus.Bug-6294
distinct_minus_count_distinct.Bug-6296
all_minus_count_star.Bug-6297
-HAVE_NETCDF?lateral.Bug-6310
+lateral.Bug-6310
limit_clause.Bug-6312
HAVE_GEOM?type-resolution-error.Bugs-6313
lateral02.Bug-6314
exist-bigint-missing.Bug-6315
coalesc-limit.Bug-6316
-HAVE_GEOM?limit.Bug-6322
+limit.Bug-6322
simplify_math.Bug-6324
-HAVE_GEOM?push_subslice.Bug-6322
+push_subslice.Bug-6322
create_table_as-missing_not_null.Bug-6329
crash-dce.Bug-6330
delete_from_merge_table.Bug-3743
@@ -89,11 +89,11 @@ sqlitelogictest-having-with-not-in.Bug-6
sqlitelogictest-having-with-in.Bug-6410
sqlitelogictest-aggregation-distinct.Bug-6411
sqlitelogictest-aggregation-not-in.Bug-6416
-HAVE_NETCDF?sqlsmith-semijoin-constant.bug-6417
+sqlsmith-semijoin-constant.bug-6417
sqlsmith.Bug-6418
-HAVE_SAMTOOLS?sqlsmith.Bug-6423
-HAVE_SAMTOOLS&HAVE_NETCDF?sqlsmith.Bug-6424
-HAVE_NETCDF?sqlsmith.Bug-6425
+sqlsmith.Bug-6423
+sqlsmith.Bug-6424
+sqlsmith.Bug-6425
double-groupby-column.Bug-6207
sqlitelogictest-aggregation-having-avg.Bug-6428
sqlitelogictest-aggregation-distinct-coalesce.Bug-6431
diff --git a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
--- a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
+++ b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
@@ -1,3 +1,21 @@
+START TRANSACTION;
+CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6
INT, col7 INT, col8 INT);
+INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88),
(111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888);
+CREATE TABLE LongTable (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6
INT, col7 INT, col8 INT);
+INSERT INTO LongTable VALUES (1,7,2,1,1,909,1,1), (2,7,2,2,3,4,4,6),
(NULL,5,4,81,NULL,5,-10,1), (-90,NULL,0,NULL,2,0,1,NULL);
+CREATE TABLE integers(i INTEGER);
+INSERT INTO integers VALUES (1), (2), (3), (NULL);
+CREATE TABLE tbl_ProductSales (col1 INT, col2 varchar(64), col3 varchar(64),
col4 INT, col5 REAL, col6 date);
+INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200, 1.2, date
'2015-12-12'),(2,'Game','PKO Game',400, -1.0, date
'2012-02-10'),(3,'Fashion','Shirt',500, NULL, date '1990-01-01'),
+(4,'Fashion','Shorts',100, 102.45, date '2000-03-08'),(5,'Sport','Ball',0,
224.78, NULL);
+CREATE TABLE analytics (aa INT, bb INT, cc BIGINT);
+INSERT INTO analytics VALUES (15, 3, 15), (3, 1, 3), (2, 1, 2), (5, 3, 5),
(NULL, 2, NULL), (3, 2, 3), (4, 1, 4), (6, 3, 6), (8, 2, 8), (NULL, 4, NULL);
+CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+INSERT INTO tab0 VALUES (97,1,99), (15,81,47),(87,21,10);
+CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68);
+CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+INSERT INTO tab2 VALUES (64,77,40), (75,67,58),(46,51,23);
CREATE TABLE PART ( P_PARTKEY INTEGER NOT NULL,
P_NAME VARCHAR(55) NOT NULL,
@@ -18,26 +36,27 @@ CREATE TABLE PARTSUPP ( PS_PARTKEY I
PRIMARY KEY (PS_PARTKEY,PS_SUPPKEY),
FOREIGN KEY (PS_PARTKEY) references PART );
-
select
- ref_0.message as c0
+ ref_0.i as c0
from
- sys.rejects as ref_0,
+ integers as ref_0,
lateral (select
- (select name from sys.objects)
+ (select col1 from tab0)
as c0
from
- sys.args as sample_1
- right join tmp._columns as ref_4
- inner join sys.part as ref_6
- inner join sys.types as sample_5
- on (ref_6.p_comment = sample_5.systemname )
- right join sys.netcdf_vars as ref_7
- on (sample_5.digits = ref_7.var_id )
- on (ref_4.name = sample_5.systemname )
- right join sys.user_role as sample_8
- inner join sys.partsupp as ref_10
- on (sample_8.role_id = ref_10.ps_partkey )
- on (ref_4.name = ref_10.ps_comment )
- on (sample_1.name = ref_10.ps_comment )
- ) as subq_0;
+ tab1 as sample_1
+ right join tab2 as ref_4
+ inner join part as ref_6
+ inner join tbl_ProductSales as sample_5
+ on (ref_6.p_comment = sample_5.col3 )
+ right join LongTable as ref_7
+ on (sample_5.col1 = ref_7.col1 )
+ on (ref_4.col0 = sample_5.col4 )
+ right join another_t as sample_8
+ inner join partsupp as ref_10
+ on (sample_8.col1 = ref_10.ps_partkey )
+ on (ref_4.col0 = ref_10.ps_suppkey )
+ on (sample_1.col0 = ref_10.ps_partkey )
+ ) as subq_0; --empty
+
+ROLLBACK;
diff --git a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
--- a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
+++ b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
@@ -29,23 +29,25 @@ stderr of test 'lateral.Bug-6310` in dir
MAPI = (monetdb) /var/tmp/mtest-4110/.s.monetdb.34271
QUERY = select
- ref_0.message as c0
+ ref_0.i as c0
from
- sys.rejects as ref_0,
+ integers as ref_0,
lateral (select
- (select name from sys.objects)
+ (select col1 from tab0)
as c0
from
- sys.args as sample_1
- right join tmp._columns as ref_4
- inner join sys.part as ref_6
- inner join sys.types as sample_5
- on (ref_6.p_comment =
sample_5.systemname )
- right join sys.netcdf_vars as ref_7
- on (sample_5.digits = ref_7.var_id )
- on (ref_4.name = sample_5.systemname )
- right join sys.user_role as sample_8
- inner join sys.partsupp as ref_10
+ tab1 as sample_1
+ right join tab2 as ref_4
+ inner join part as ref_6
+ inner join tbl_ProductSales as
sample_5
+ on (ref_6.p_comment = sample_5.col3 )
+ right join LongTable as ref_7
+ on (sample_5.col1 = ref_7.col1 )
+ on (ref_4.col0 = sample_5.col4 )
+ right join another_t as sample_8
+ inner join partsupp as ref_10
+ on (sample_8.col1 = ref_10.ps_partkey )
+ on (ref_4.col0 = ref_10.ps_suppkey )
ERROR = !Cardinality violation, scalar value expected
CODE = 21000
diff --git a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.out
b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.out
--- a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.out
+++ b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.out
@@ -19,10 +19,32 @@ stdout of test 'lateral.Bug-6310` in dir
# MonetDB/SQL module loaded
-# 16:49:27 >
-# 16:49:27 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-31693" "--port=34067"
-# 16:49:27 >
-
+#START TRANSACTION;
+#CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT,
col6 INT, col7 INT, col8 INT);
+#INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88),
(111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888);
+[ 4 ]
+#CREATE TABLE LongTable (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT,
col6 INT, col7 INT, col8 INT);
+#INSERT INTO LongTable VALUES (1,7,2,1,1,909,1,1), (2,7,2,2,3,4,4,6),
(NULL,5,4,81,NULL,5,-10,1), (-90,NULL,0,NULL,2,0,1,NULL);
+[ 4 ]
+#CREATE TABLE integers(i INTEGER);
+#INSERT INTO integers VALUES (1), (2), (3), (NULL);
+[ 4 ]
+#CREATE TABLE tbl_ProductSales (col1 INT, col2 varchar(64), col3 varchar(64),
col4 INT, col5 REAL, col6 date);
+#INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200, 1.2, date
'2015-12-12'),(2,'Game','PKO Game',400, -1.0, date
'2012-02-10'),(3,'Fashion','Shirt',500, NULL, date '1990-01-01'),
+#(4,'Fashion','Shorts',100, 102.45, date '2000-03-08'),(5,'Sport','Ball',0,
224.78, NULL);
+[ 5 ]
+#CREATE TABLE analytics (aa INT, bb INT, cc BIGINT);
+#INSERT INTO analytics VALUES (15, 3, 15), (3, 1, 3), (2, 1, 2), (5, 3, 5),
(NULL, 2, NULL), (3, 2, 3), (4, 1, 4), (6, 3, 6), (8, 2, 8), (NULL, 4, NULL);
+[ 10 ]
+#CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+#INSERT INTO tab0 VALUES (97,1,99), (15,81,47),(87,21,10);
+[ 3 ]
+#CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+#INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68);
+[ 3 ]
+#CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+#INSERT INTO tab2 VALUES (64,77,40), (75,67,58),(46,51,23);
+[ 3 ]
#CREATE TABLE PART ( P_PARTKEY INTEGER NOT NULL,
# P_NAME VARCHAR(55) NOT NULL,
# P_MFGR CHAR(25) NOT NULL,
diff --git a/sql/test/BugTracker-2017/Tests/limit.Bug-6322.sql
b/sql/test/BugTracker-2017/Tests/limit.Bug-6322.sql
--- a/sql/test/BugTracker-2017/Tests/limit.Bug-6322.sql
+++ b/sql/test/BugTracker-2017/Tests/limit.Bug-6322.sql
@@ -1,13 +1,21 @@
+START TRANSACTION;
+CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+INSERT INTO tab0 VALUES (97,1,99), (15,81,47),(87,21,10);
+CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68);
+
select
subq_0.c3 as c2
from
(select
- sample_0.proj4text as c3,
- sample_0.auth_name as c7
+ sample_0.col0 as c3,
+ sample_0.col1 as c7
from
- sys.spatial_ref_sys as sample_0
+ tab0 as sample_0
where true
limit 14) as subq_0
where (true)
- or ((select stmt from sys.tracelog)
+ or ((select col1 from tab1 where col1=51)
is not NULL);
+
+ROLLBACK;
diff --git a/sql/test/BugTracker-2017/Tests/limit.Bug-6322.stable.out
b/sql/test/BugTracker-2017/Tests/limit.Bug-6322.stable.out
--- a/sql/test/BugTracker-2017/Tests/limit.Bug-6322.stable.out
+++ b/sql/test/BugTracker-2017/Tests/limit.Bug-6322.stable.out
@@ -19,10 +19,13 @@ stdout of test 'limit.Bug-6322` in direc
# MonetDB/SQL module loaded
-# 12:52:04 >
-# 12:52:04 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-19106" "--port=36358"
-# 12:52:04 >
-
+#START TRANSACTION;
+#CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+#INSERT INTO tab0 VALUES (97,1,99), (15,81,47),(87,21,10);
+[ 3 ]
+#CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
+#INSERT INTO tab1 VALUES (51,14,96), (85,5,59), (91,47,68);
+[ 3 ]
#select
# subq_0.c3 as c2
#from
@@ -38,20 +41,12 @@ stdout of test 'limit.Bug-6322` in direc
# is not NULL);
% .subq_0 # table_name
% c2 # name
-% varchar # type
-% 93 # length
-[ "+proj=longlat +ellps=bessel
+towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs" ]
-[ "+proj=longlat +ellps=aust_SA +no_defs" ]
-[ "+proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs" ]
-[ "+proj=longlat +ellps=bessel +towgs84=682,-203,480,0,0,0,0 +no_defs" ]
-[ "+proj=longlat +ellps=airy +no_defs" ]
-[ "+proj=longlat +ellps=mod_airy +no_defs" ]
-[ "+proj=longlat +ellps=bessel +no_defs" ]
-[ "+proj=longlat +a=6377492.018 +b=6356173.508712696 +no_defs" ]
-[ "+proj=longlat +ellps=bess_nam +no_defs" ]
-[ "+proj=longlat +a=6378293.645208759 +b=6356617.987679838 +no_defs" ]
-[ "+proj=longlat +ellps=clrk66 +no_defs" ]
-[ "+proj=longlat +a=6378450.047548896 +b=6356826.621488444 +no_defs" ]
+% int # type
+% 2 # length
+[ 97 ]
+[ 15 ]
+[ 87 ]
+#ROLLBACK;
# 12:52:04 >
# 12:52:04 > "Done."
diff --git a/sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.sql
b/sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.sql
--- a/sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.sql
+++ b/sql/test/BugTracker-2017/Tests/limit_clause.Bug-6312.sql
@@ -1,10 +1,16 @@
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
