Changeset: 19359e42134b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=19359e42134b
Added Files:
        sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql
Modified Files:
        sql/test/BugTracker-2018/Tests/All
Branch: Aug2018
Log Message:

Added test for bug 6613.


diffs (24 lines):

diff --git a/sql/test/BugTracker-2018/Tests/All 
b/sql/test/BugTracker-2018/Tests/All
--- a/sql/test/BugTracker-2018/Tests/All
+++ b/sql/test/BugTracker-2018/Tests/All
@@ -68,6 +68,7 @@ procedure-create-table.Bug-6604
 sqlitelogictest-cast-null-not-in.Bug-6605
 sqlitelogictest-groupby-coalesce-error-message.Bug-6608
 sqlitelogictest-algebra-rangejoin-undefined.Bug-6610
+lateral-join-crash.Bug-6613
 dependency_column_on_sequence.Bug-6618
 local_replica_table_not_detected.Bug-6620
 remote-table-where-not-equal.Bug-6621
diff --git a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql 
b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql
@@ -0,0 +1,8 @@
+start transaction;
+create table segments (meter int, distance int, speed int);
+insert into segments values (1,1,1),(9,9,9);
+select t.* from segments as s, lateral generate_series(s.meter, 
s.meter+s.distance+1) as t;
+select t.meter, s.distance, s.speed from segments as s, lateral 
generate_series(s.meter, s.meter+s.distance+1) as t(meter);
+select * from segments as s, lateral generate_series(s.meter, 
s.meter+s.distance+1);
+select t.*, s.distance, s.speed from segments as s, lateral 
generate_series(s.meter, s.meter+s.distance+1) as t(meter);
+rollback;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to