Changeset: 443209cc4b86 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=443209cc4b86 Added Files: sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.sql Modified Files: sql/test/BugTracker-2015/Tests/All Branch: Oct2014 Log Message:
added test for bug 3720 diffs (37 lines): diff --git a/sql/test/BugTracker-2015/Tests/All b/sql/test/BugTracker-2015/Tests/All --- a/sql/test/BugTracker-2015/Tests/All +++ b/sql/test/BugTracker-2015/Tests/All @@ -28,3 +28,4 @@ readonly.Bug-3709 crash_on_alter_set_not_null.Bug-3715 convert-to-bit.Bug-3719 union_project.Bug-3723 +leftjoin.Bug-3720 diff --git a/sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.sql b/sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.sql @@ -0,0 +1,24 @@ +create table two ( + id int, + name string, + istrue boolean, + joindate date, + jointime timestamp, + count int +); + +copy 6 records into two from stdin using delimiters ',','\n'; +1,null,false,2017-12-08,2014-06-30 14:05:31.000000,2 +2,vijay,false,2017-12-08,2014-06-30 14:05:59.000000,3 +3,krish,true,2017-12-08,2014-06-30 14:06:17.000000,5 +4,bat,true,null,null,null +5,gotham,false,null,null,null +6,wayne,false,null,null,3 + + +select * from two; + +select two.id, two.name, two.count, twoAlias.id as id2, twoAlias.name as name2 from two left join two as twoAlias on two.count=twoAlias.id; + +drop table two; + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list