Changeset: 1f1b4b8c07d5 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1f1b4b8c07d5 Added Files: sql/test/BugTracker-2017/Tests/sqlsmith01.sql sql/test/BugTracker-2017/Tests/sqlsmith01.stable.out sql/test/BugTracker-2017/Tests/sqlsmith02.sql sql/test/BugTracker-2017/Tests/sqlsmith02.stable.out sql/test/BugTracker-2017/Tests/sqlsmith03.sql sql/test/BugTracker-2017/Tests/sqlsmith03.stable.out sql/test/BugTracker-2017/Tests/sqlsmith04.sql sql/test/BugTracker-2017/Tests/sqlsmith04.stable.out Modified Files: sql/test/BugTracker-2017/Tests/All Branch: default Log Message:
Crashes triggered by SQLsmith diffs (194 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 @@ -18,3 +18,7 @@ group-by-on-constant.Bug-6082 rel2bin_project-assert.Bug-6080 str2decimal.Bug-6202 integer_addition_overflow.Bug-6205 +sqlsmith01 +sqlsmith02 +sqlsmith03 +sqlsmith04 diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith01.sql b/sql/test/BugTracker-2017/Tests/sqlsmith01.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith01.sql @@ -0,0 +1,34 @@ +--after 17K queries starting from empty db + +select + ref_20.sm as c0, + cast(coalesce(ref_20.file_id, + ref_20.file_id) as bigint) as c1 +from + bam.rg as ref_20 +where ref_20.fo is not NULL; +select + cast(coalesce(subq_0.c0, + subq_0.c0) as int) as c0, + subq_0.c0 as c1, + subq_0.c0 as c2, + subq_0.c0 as c3 +from + (select + ref_20.id as c0 + from + sys.querylog_history as ref_11 + inner join sys.users as ref_18 + inner join sys.geometry_columns as ref_19 + on (ref_18.default_schema = ref_19.srid ) + right join tmp.keys as ref_20 + on (ref_18.fullname = ref_20.name ) + left join sys._columns as ref_21 + inner join sys.columns as ref_22 + on (ref_21.type_scale = ref_22.id ) + on (ref_20.rkey = ref_21.id ) + on (ref_11.arguments = ref_19.f_table_catalog ) + where ref_22.type is not NULL) as subq_0 +where false +limit 132; + diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith01.stable.out b/sql/test/BugTracker-2017/Tests/sqlsmith01.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith01.stable.out @@ -0,0 +1,1 @@ +Causes a crash diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith02.sql b/sql/test/BugTracker-2017/Tests/sqlsmith02.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith02.sql @@ -0,0 +1,44 @@ +--Another round. After 116K queries + +--Seems geom related: +--!42S02!SELECT: no such table 'spatial_ref_sys' + +select + ref_78.mod as c0, + ref_79.name as c1 +from + sys.columns as ref_38 + right join sys.args as ref_72 + right join sys.spatial_ref_sys as ref_75 + right join sys.geometry_columns as ref_76 + on (ref_75.proj4text = ref_76.f_table_schema ) + right join sys.spatial_ref_sys as ref_77 + inner join sys.functions as ref_78 + on (ref_77.proj4text = ref_78.name ) + on (ref_76.srid = ref_78.id ) + on (ref_72.id = ref_75.srid ) + left join tmp.objects as ref_79 + on (ref_75.srid = ref_79.id ) + on (ref_38.type_digits = ref_75.srid ) + left join sys.schemas as ref_80 + inner join sys.schemas as ref_81 + left join sys.netcdf_vardim as ref_95 + inner join sys._columns as ref_96 + on (ref_95.dim_id = ref_96.id ) + on (ref_81.owner = ref_96.id ) + on (ref_80.authorization = ref_81.id ) + right join sys.dependencies as ref_125 + left join tmp.idxs as ref_126 + inner join sys.sequences as ref_155 + inner join tmp.idxs as ref_156 + inner join sys.types as ref_157 + on (ref_156.type = ref_157.id ) + on (ref_155.name = ref_157.systemname ) + on (ref_126.id = ref_156.id ) + on (ref_125.id = ref_155.id ) + on (ref_96.type = ref_156.name ) + on (ref_79.name = ref_157.systemname ) + left join sys.queue as ref_158 + on (ref_125.depend_id = ref_158.progress ) +where ref_38.table_id is NULL +limit 63; diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith02.stable.out b/sql/test/BugTracker-2017/Tests/sqlsmith02.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith02.stable.out @@ -0,0 +1,1 @@ +Causes a crash diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith03.sql b/sql/test/BugTracker-2017/Tests/sqlsmith03.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith03.sql @@ -0,0 +1,40 @@ +-- And a new run after 234K queries +-- !42S02!SELECT: no such table 'querylog_calls' + + +select + 8 as c0 +from + tmp.keys as ref_68 + left join sys.auths as ref_70 + inner join sys._columns as ref_86 + inner join tmp.keys as ref_101 + inner join sys.querylog_calls as ref_102 + on (ref_101.type = ref_102.cpu ) + inner join sys.idxs as ref_103 + on (ref_102.io = ref_103.id ) + on (ref_86.table_id = ref_102.cpu ) + right join sys.privileges as ref_111 + left join sys.systemfunctions as ref_112 + left join sys.querylog_calls as ref_113 + on (ref_112.function_id = ref_113.cpu ) + on (ref_111.privileges = ref_112.function_id ) + right join sys.schemas as ref_114 + inner join sys.geometry_columns as ref_115 + right join sys.users as ref_116 + on (ref_115.f_table_name = ref_116.name ) + on (ref_114.owner = ref_115.srid ) + on (ref_111.obj_id = ref_116.default_schema ) + on (ref_103.id = ref_113.cpu ) + on (ref_70.id = ref_111.obj_id ) + on (ref_68.rkey = ref_114.id ) + left join sys.columns as ref_121 + inner join sys.types as ref_122 + on (ref_121.type_digits = ref_122.id ) + inner join tmp._tables as ref_123 + on (ref_122.schema_id = ref_123.id ) + on (ref_116.default_schema = ref_123.id ) +where cast(coalesce(cast(coalesce(ref_101.table_id, + ref_121.number) as int), + ref_68.table_id) as int) is NULL +limit 164; diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith03.stable.out b/sql/test/BugTracker-2017/Tests/sqlsmith03.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith03.stable.out @@ -0,0 +1,1 @@ +Causes a crash diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith04.sql b/sql/test/BugTracker-2017/Tests/sqlsmith04.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith04.sql @@ -0,0 +1,21 @@ +-- After 154K queries. + +select + ref_696.id as c0, + ref_699.tag as c1 +from + sys.functions as ref_678 + left join sys._columns as ref_695 + right join tmp._columns as ref_696 + inner join sys.geometry_columns as ref_697 + left join sys.users as ref_698 + on (ref_697.f_geometry_column = ref_698.name ) + on (ref_696.storage = ref_698.name ) + on (ref_695.storage = ref_698.name ) + on (ref_678.language = ref_698.default_schema ) + left join sys.queue as ref_699 + on (ref_678.language = ref_699.progress ) + left join sys.columns as ref_700 + on (ref_698.fullname = ref_700.name ) +where ref_700.id is not NULL +limit 77; diff --git a/sql/test/BugTracker-2017/Tests/sqlsmith04.stable.out b/sql/test/BugTracker-2017/Tests/sqlsmith04.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2017/Tests/sqlsmith04.stable.out @@ -0,0 +1,1 @@ +Causes a crash _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
