Changeset: fce43614aeb3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fce43614aeb3 Added Files: sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out.int128 Modified Files: sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out Branch: default Log Message:
Re-approved test. We have to implement table column casts yet e.g. select t2.c from t1 as t2(c) diffs (240 lines): 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 --- a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql +++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.sql @@ -2,7 +2,7 @@ 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 t.value, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; 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); +select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; rollback; diff --git a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err --- a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err +++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.err @@ -31,18 +31,6 @@ stderr of test 'lateral-join-crash.Bug-6 # 00:28:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13250" "--port=34098" # 00:28:47 > -MAPI = (monetdb) /var/tmp/mtest-13250/.s.monetdb.34098 -QUERY = select t.meter, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t(meter); -ERROR = !SELECT: no such column 't.meter' -CODE = 42S22 -MAPI = (monetdb) /var/tmp/mtest-13250/.s.monetdb.34098 -QUERY = select * from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1); -ERROR = !Current transaction is aborted (please ROLLBACK) -CODE = 25005 -MAPI = (monetdb) /var/tmp/mtest-13250/.s.monetdb.34098 -QUERY = select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t(meter); -ERROR = !Current transaction is aborted (please ROLLBACK) -CODE = 25005 # 00:28:47 > # 00:28:47 > "Done." diff --git a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out --- a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out +++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out @@ -29,7 +29,7 @@ stdout of test 'lateral-join-crash.Bug-6 #select t.* from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; % .t # table_name % value # name -% hugeint # type +% bigint # type % 2 # length [ 1 ] [ 2 ] @@ -55,6 +55,93 @@ stdout of test 'lateral-join-crash.Bug-6 [ 16 ] [ 17 ] [ 18 ] +#select t.value, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; +% .t, sys.s, sys.s # table_name +% value, distance, speed # name +% bigint, int, int # type +% 2, 1, 1 # length +[ 1, 1, 1 ] +[ 2, 1, 1 ] +[ 9, 1, 1 ] +[ 10, 1, 1 ] +[ 11, 1, 1 ] +[ 12, 1, 1 ] +[ 13, 1, 1 ] +[ 14, 1, 1 ] +[ 15, 1, 1 ] +[ 16, 1, 1 ] +[ 17, 1, 1 ] +[ 18, 1, 1 ] +[ 1, 9, 9 ] +[ 2, 9, 9 ] +[ 9, 9, 9 ] +[ 10, 9, 9 ] +[ 11, 9, 9 ] +[ 12, 9, 9 ] +[ 13, 9, 9 ] +[ 14, 9, 9 ] +[ 15, 9, 9 ] +[ 16, 9, 9 ] +[ 17, 9, 9 ] +[ 18, 9, 9 ] +#select * from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1); +% sys.s, sys.s, sys.s, .L2 # table_name +% meter, distance, speed, value # name +% int, int, int, bigint # type +% 1, 1, 1, 2 # length +[ 1, 1, 1, 1 ] +[ 1, 1, 1, 2 ] +[ 1, 1, 1, 9 ] +[ 1, 1, 1, 10 ] +[ 1, 1, 1, 11 ] +[ 1, 1, 1, 12 ] +[ 1, 1, 1, 13 ] +[ 1, 1, 1, 14 ] +[ 1, 1, 1, 15 ] +[ 1, 1, 1, 16 ] +[ 1, 1, 1, 17 ] +[ 1, 1, 1, 18 ] +[ 9, 9, 9, 1 ] +[ 9, 9, 9, 2 ] +[ 9, 9, 9, 9 ] +[ 9, 9, 9, 10 ] +[ 9, 9, 9, 11 ] +[ 9, 9, 9, 12 ] +[ 9, 9, 9, 13 ] +[ 9, 9, 9, 14 ] +[ 9, 9, 9, 15 ] +[ 9, 9, 9, 16 ] +[ 9, 9, 9, 17 ] +[ 9, 9, 9, 18 ] +#select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; +% .t, sys.s, sys.s # table_name +% value, distance, speed # name +% bigint, int, int # type +% 2, 1, 1 # length +[ 1, 1, 1 ] +[ 2, 1, 1 ] +[ 9, 1, 1 ] +[ 10, 1, 1 ] +[ 11, 1, 1 ] +[ 12, 1, 1 ] +[ 13, 1, 1 ] +[ 14, 1, 1 ] +[ 15, 1, 1 ] +[ 16, 1, 1 ] +[ 17, 1, 1 ] +[ 18, 1, 1 ] +[ 1, 9, 9 ] +[ 2, 9, 9 ] +[ 9, 9, 9 ] +[ 10, 9, 9 ] +[ 11, 9, 9 ] +[ 12, 9, 9 ] +[ 13, 9, 9 ] +[ 14, 9, 9 ] +[ 15, 9, 9 ] +[ 16, 9, 9 ] +[ 17, 9, 9 ] +[ 18, 9, 9 ] #rollback; # 00:28:47 > diff --git a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out.int128 copy from sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out copy to sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out.int128 --- a/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out +++ b/sql/test/BugTracker-2018/Tests/lateral-join-crash.Bug-6613.stable.out.int128 @@ -55,6 +55,93 @@ stdout of test 'lateral-join-crash.Bug-6 [ 16 ] [ 17 ] [ 18 ] +#select t.value, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; +% .t, sys.s, sys.s # table_name +% value, distance, speed # name +% hugeint, int, int # type +% 2, 1, 1 # length +[ 1, 1, 1 ] +[ 2, 1, 1 ] +[ 9, 1, 1 ] +[ 10, 1, 1 ] +[ 11, 1, 1 ] +[ 12, 1, 1 ] +[ 13, 1, 1 ] +[ 14, 1, 1 ] +[ 15, 1, 1 ] +[ 16, 1, 1 ] +[ 17, 1, 1 ] +[ 18, 1, 1 ] +[ 1, 9, 9 ] +[ 2, 9, 9 ] +[ 9, 9, 9 ] +[ 10, 9, 9 ] +[ 11, 9, 9 ] +[ 12, 9, 9 ] +[ 13, 9, 9 ] +[ 14, 9, 9 ] +[ 15, 9, 9 ] +[ 16, 9, 9 ] +[ 17, 9, 9 ] +[ 18, 9, 9 ] +#select * from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1); +% sys.s, sys.s, sys.s, .L2 # table_name +% meter, distance, speed, value # name +% int, int, int, hugeint # type +% 1, 1, 1, 2 # length +[ 1, 1, 1, 1 ] +[ 1, 1, 1, 2 ] +[ 1, 1, 1, 9 ] +[ 1, 1, 1, 10 ] +[ 1, 1, 1, 11 ] +[ 1, 1, 1, 12 ] +[ 1, 1, 1, 13 ] +[ 1, 1, 1, 14 ] +[ 1, 1, 1, 15 ] +[ 1, 1, 1, 16 ] +[ 1, 1, 1, 17 ] +[ 1, 1, 1, 18 ] +[ 9, 9, 9, 1 ] +[ 9, 9, 9, 2 ] +[ 9, 9, 9, 9 ] +[ 9, 9, 9, 10 ] +[ 9, 9, 9, 11 ] +[ 9, 9, 9, 12 ] +[ 9, 9, 9, 13 ] +[ 9, 9, 9, 14 ] +[ 9, 9, 9, 15 ] +[ 9, 9, 9, 16 ] +[ 9, 9, 9, 17 ] +[ 9, 9, 9, 18 ] +#select t.*, s.distance, s.speed from segments as s, lateral generate_series(s.meter, s.meter+s.distance+1) as t; +% .t, sys.s, sys.s # table_name +% value, distance, speed # name +% hugeint, int, int # type +% 2, 1, 1 # length +[ 1, 1, 1 ] +[ 2, 1, 1 ] +[ 9, 1, 1 ] +[ 10, 1, 1 ] +[ 11, 1, 1 ] +[ 12, 1, 1 ] +[ 13, 1, 1 ] +[ 14, 1, 1 ] +[ 15, 1, 1 ] +[ 16, 1, 1 ] +[ 17, 1, 1 ] +[ 18, 1, 1 ] +[ 1, 9, 9 ] +[ 2, 9, 9 ] +[ 9, 9, 9 ] +[ 10, 9, 9 ] +[ 11, 9, 9 ] +[ 12, 9, 9 ] +[ 13, 9, 9 ] +[ 14, 9, 9 ] +[ 15, 9, 9 ] +[ 16, 9, 9 ] +[ 17, 9, 9 ] +[ 18, 9, 9 ] #rollback; # 00:28:47 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list