Changeset: e2b06df98a23 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e2b06df98a23
Added Files:
        sql/test/BugTracker-2017/Tests/lateral02.Bug-6314.sql
Modified Files:
        sql/test/BugTracker-2017/Tests/All
Branch: default
Log Message:

Added another sqlsmith crash


diffs (34 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
@@ -54,3 +54,4 @@ all_minus_count_star.Bug-6297
 lateral.Bug-6310
 limit_clause.Bug-6312
 type-resolution-error.Bugs-6313
+lateral02.Bug-6314
diff --git a/sql/test/BugTracker-2017/Tests/lateral02.Bug-6314.sql 
b/sql/test/BugTracker-2017/Tests/lateral02.Bug-6314.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/lateral02.Bug-6314.sql
@@ -0,0 +1,21 @@
+select
+  (select id from sys.schemas) as c0
+from 
+  (select  subq_0.c3 as c4
+          from 
+            lateral (select
+                  ref_0.ndim as c3
+                from 
+                  tmp._tables as sample_1
+                where ((select index_type_id from sys.index_types) is not NULL)
+                  or (true)) as subq_0
+          where (select n_regionkey from sys.nation) is not NULL) as subq_1
+      inner join sys.idxs as ref_1
+      on (subq_1.c2 = ref_1.id )
+    inner join sys.netcdf_attrs as sample_15
+        inner join sys.dependency_types as ref_20
+        on (sample_15.att_name = ref_20.dependency_type_name )
+      right join sys.privilege_codes as sample_16
+      on (sample_15.att_type = sample_16.privilege_code_name )
+    on (ref_1.type = sample_16.privilege_code_id )
+where sample_16.privilege_code_id is NULL;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to