Changeset: d393e4502794 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d393e4502794 Modified Files: sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test sql/test/merge-partitions/Tests/mergepart31.test Branch: default Log Message:
approved output diffs (39 lines): diff --git a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test --- a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test +++ b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test @@ -5,7 +5,7 @@ query T nosort plan copy into cm_tmp from '/file1','/file2' ---- insert( -| table("sys"."cm_tmp") [ "cm_tmp"."i" NOT NULL UNIQUE, "cm_tmp"."%TID%" NOT NULL UNIQUE ] +| table("sys"."cm_tmp") [ "cm_tmp"."i", "cm_tmp"."%TID%" NOT NULL UNIQUE ] | union ( | | project ( | | | table ("sys"."copyfrom"(table("cm_tmp"), varchar "|", varchar "\n", varchar NULL, varchar "null", varchar "/file1", bigint(18) "-1", bigint(18) "0", int(9) "0", varchar NULL, int(9) "0", int(9) "1"), diff --git a/sql/test/merge-partitions/Tests/mergepart31.test b/sql/test/merge-partitions/Tests/mergepart31.test --- a/sql/test/merge-partitions/Tests/mergepart31.test +++ b/sql/test/merge-partitions/Tests/mergepart31.test @@ -383,11 +383,18 @@ project ( query T nosort plan select 1 from splitted where stamp > TIMESTAMP '1999-01-01 00:00:00' and stamp <= TIMESTAMP '2001-01-01 00:00:00' ---- -project ( -| select ( -| | table("sys"."first_decade") [ "first_decade"."stamp" UNIQUE as "splitted"."stamp" ] -| ) [ (timestamp(7) "1999-01-01 00:00:00.000000") < ("splitted"."stamp" UNIQUE) <= (timestamp(7) "2001-01-01 00:00:00.000000") ] -) [ tinyint(1) "1" as "%5"."%5" ] +union ( +| project ( +| | select ( +| | | table("sys"."first_decade") [ "first_decade"."stamp" UNIQUE as "splitted"."stamp" ] +| | ) [ (timestamp(7) "1999-01-01 00:00:00.000000") < ("splitted"."stamp" UNIQUE) <= (timestamp(7) "2001-01-01 00:00:00.000000") ] +| ) [ tinyint(1) "1" ], +| project ( +| | select ( +| | | table("sys"."fourth_decade") [ "fourth_decade"."stamp" UNIQUE as "splitted"."stamp" ] +| | ) [ (timestamp(7) "1999-01-01 00:00:00.000000") < ("splitted"."stamp" UNIQUE) <= (timestamp(7) "2001-01-01 00:00:00.000000") ] +| ) [ tinyint(1) "1" ] +) [ "%5"."%5" NOT NULL ] query T nosort plan select 1 from splitted where stamp = TIMESTAMP '2010-01-01 00:00:00' _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org