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

Test for bug 6310


diffs (35 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
@@ -51,3 +51,4 @@ nestedoperators.Bug-6292
 not_plus.Bug-6294
 distinct_minus_count_distinct.Bug-6296
 all_minus_count_star.Bug-6297
+lateral.Bug-6310
diff --git a/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql 
b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2017/Tests/lateral.Bug-6310.sql
@@ -0,0 +1,22 @@
+select
+  ref_0.message as c0
+from
+  sys.rejects as ref_0,
+  lateral (select
+               (select name from sys.objects)
+                  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;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to