Changeset: f77039740220 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f77039740220
Modified Files:
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
Branch: default
Log Message:
Approved output
diffs (truncated from 435 to 300 lines):
diff --git
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
---
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
+++
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
@@ -34,113 +34,113 @@ stdout of test 'duplicates-not-eliminate
% 1023 # length
function user.main():void;
X_1:void := querylog.define("explain select sys.timestamp_to_str(case when
task0.\"sys_created_on\" >= \\'1999-10-31 09:00:00\\' and
task0.\"sys_created_on\" < \\'2000-04-02 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'2000-04-02 10:00:00\\' and
task0.\"sys_created_on\" < \\'2000-10-29 09:00:00\\' then
task0.\"sys_created_on\" + interval \\'-25200\\' second when
task0.\"sys_created_on\" >= \\'2000-10-29 09:00:00\\' and
task0.\"sys_created_on\" < \\'2001-04-01 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'2001-04-01 10:00:00\\' and
task0.\"sys_created_on\" < \\'2001-10-28 09:00:00\\' then
task0.\"sys_created_on\" + interval \\'-25200\\' second when
task0.\"sys_created_on\" >= \\'2001-10-28 09:00:00\\' and
task0.\"sys_created_on\" < \\'2002-04-07 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'20
02-04-07 10:00:00\\' and t
-barrier X_1047:bit := language.dataflow();
- X_892:bat[:str] := bat.pack("sys.":str);
- X_893:bat[:str] := bat.pack("yearref":str);
- X_894:bat[:str] := bat.pack("clob":str);
- X_895:bat[:int] := bat.pack(0:int);
+barrier X_947:bit := language.dataflow();
+ X_792:bat[:str] := bat.pack("sys.":str);
+ X_793:bat[:str] := bat.pack("yearref":str);
+ X_794:bat[:str] := bat.pack("clob":str);
+ X_795:bat[:int] := bat.pack(0:int);
X_45:bat[:timestamp] := bat.new(nil:timestamp);
- X_53:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "1999-10-31
09:00:00.000000":timestamp, "2000-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_58:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -28800000:lng);
- X_69:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2000-04-02
10:00:00.000000":timestamp, "2000-10-29 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_74:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -25200000:lng);
- X_83:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2000-10-29
09:00:00.000000":timestamp, "2001-04-01 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_95:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2001-04-01
10:00:00.000000":timestamp, "2001-10-28 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_113:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2001-10-28
09:00:00.000000":timestamp, "2002-04-07 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_126:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2002-04-07
10:00:00.000000":timestamp, "2002-10-27 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_140:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2002-10-27
09:00:00.000000":timestamp, "2003-04-06 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_158:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2003-04-06
10:00:00.000000":timestamp, "2003-10-26 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_169:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2003-10-26
09:00:00.000000":timestamp, "2004-04-04 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_184:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2004-04-04
10:00:00.000000":timestamp, "2004-10-31 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_202:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2004-10-31
09:00:00.000000":timestamp, "2005-04-03 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_217:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2005-04-03
10:00:00.000000":timestamp, "2005-10-30 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_228:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2005-10-30
09:00:00.000000":timestamp, "2006-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_246:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2006-04-02
10:00:00.000000":timestamp, "2006-10-29 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_260:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2006-10-29
09:00:00.000000":timestamp, "2007-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_272:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2007-03-11
10:00:00.000000":timestamp, "2007-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_291:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2007-11-04
09:00:00.000000":timestamp, "2008-03-09 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_303:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2008-03-09
10:00:00.000000":timestamp, "2008-11-02 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_316:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2008-11-02
09:00:00.000000":timestamp, "2009-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_335:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2009-03-08
10:00:00.000000":timestamp, "2009-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_349:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2009-11-01
09:00:00.000000":timestamp, "2010-03-14 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_361:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2010-03-14
10:00:00.000000":timestamp, "2010-11-07 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_378:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2010-11-07
09:00:00.000000":timestamp, "2011-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_392:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2011-03-13
10:00:00.000000":timestamp, "2011-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_405:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2011-11-06
09:00:00.000000":timestamp, "2012-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_423:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2012-03-11
10:00:00.000000":timestamp, "2012-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_436:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2012-11-04
09:00:00.000000":timestamp, "2013-03-10 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_448:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2013-03-10
10:00:00.000000":timestamp, "2013-11-03 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_467:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2013-11-03
09:00:00.000000":timestamp, "2014-03-09 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_481:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2014-03-09
10:00:00.000000":timestamp, "2014-11-02 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_493:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2014-11-02
09:00:00.000000":timestamp, "2015-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_511:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2015-03-08
10:00:00.000000":timestamp, "2015-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_525:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2015-11-01
09:00:00.000000":timestamp, "2016-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_537:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2016-03-13
10:00:00.000000":timestamp, "2016-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_555:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2016-11-06
09:00:00.000000":timestamp, "2017-03-12 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_568:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2017-03-12
10:00:00.000000":timestamp, "2017-11-05 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_581:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2017-11-05
09:00:00.000000":timestamp, "2018-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_600:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2018-03-11
10:00:00.000000":timestamp, "2018-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_614:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2018-11-04
09:00:00.000000":timestamp, "2019-03-10 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_625:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2019-03-10
10:00:00.000000":timestamp, "2019-11-03 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_643:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2019-11-03
09:00:00.000000":timestamp, "2020-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_657:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2020-03-08
10:00:00.000000":timestamp, "2020-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_670:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2020-11-01
09:00:00.000000":timestamp, "2021-03-14 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_688:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2021-03-14
10:00:00.000000":timestamp, "2021-11-07 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_700:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2021-11-07
09:00:00.000000":timestamp, "2022-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_713:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2022-03-13
10:00:00.000000":timestamp, "2022-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_730:bat[:timestamp] := batcalc.ifthenelse(X_713:bat[:bit],
X_74:bat[:timestamp], X_58:bat[:timestamp]);
- X_734:bat[:timestamp] := batcalc.ifthenelse(X_700:bat[:bit],
X_58:bat[:timestamp], X_730:bat[:timestamp]);
- X_738:bat[:timestamp] := batcalc.ifthenelse(X_688:bat[:bit],
X_74:bat[:timestamp], X_734:bat[:timestamp]);
- X_741:bat[:timestamp] := batcalc.ifthenelse(X_670:bat[:bit],
X_58:bat[:timestamp], X_738:bat[:timestamp]);
- X_744:bat[:timestamp] := batcalc.ifthenelse(X_657:bat[:bit],
X_74:bat[:timestamp], X_741:bat[:timestamp]);
- X_747:bat[:timestamp] := batcalc.ifthenelse(X_643:bat[:bit],
X_58:bat[:timestamp], X_744:bat[:timestamp]);
- X_751:bat[:timestamp] := batcalc.ifthenelse(X_625:bat[:bit],
X_74:bat[:timestamp], X_747:bat[:timestamp]);
- X_754:bat[:timestamp] := batcalc.ifthenelse(X_614:bat[:bit],
X_58:bat[:timestamp], X_751:bat[:timestamp]);
- X_757:bat[:timestamp] := batcalc.ifthenelse(X_600:bat[:bit],
X_74:bat[:timestamp], X_754:bat[:timestamp]);
- X_761:bat[:timestamp] := batcalc.ifthenelse(X_581:bat[:bit],
X_58:bat[:timestamp], X_757:bat[:timestamp]);
- X_764:bat[:timestamp] := batcalc.ifthenelse(X_568:bat[:bit],
X_74:bat[:timestamp], X_761:bat[:timestamp]);
- X_769:bat[:timestamp] := batcalc.ifthenelse(X_555:bat[:bit],
X_58:bat[:timestamp], X_764:bat[:timestamp]);
- X_772:bat[:timestamp] := batcalc.ifthenelse(X_537:bat[:bit],
X_74:bat[:timestamp], X_769:bat[:timestamp]);
- X_775:bat[:timestamp] := batcalc.ifthenelse(X_525:bat[:bit],
X_58:bat[:timestamp], X_772:bat[:timestamp]);
- X_778:bat[:timestamp] := batcalc.ifthenelse(X_511:bat[:bit],
X_74:bat[:timestamp], X_775:bat[:timestamp]);
- X_781:bat[:timestamp] := batcalc.ifthenelse(X_493:bat[:bit],
X_58:bat[:timestamp], X_778:bat[:timestamp]);
- X_785:bat[:timestamp] := batcalc.ifthenelse(X_481:bat[:bit],
X_74:bat[:timestamp], X_781:bat[:timestamp]);
- X_788:bat[:timestamp] := batcalc.ifthenelse(X_467:bat[:bit],
X_58:bat[:timestamp], X_785:bat[:timestamp]);
- X_791:bat[:timestamp] := batcalc.ifthenelse(X_448:bat[:bit],
X_74:bat[:timestamp], X_788:bat[:timestamp]);
- X_795:bat[:timestamp] := batcalc.ifthenelse(X_436:bat[:bit],
X_58:bat[:timestamp], X_791:bat[:timestamp]);
- X_798:bat[:timestamp] := batcalc.ifthenelse(X_423:bat[:bit],
X_74:bat[:timestamp], X_795:bat[:timestamp]);
- X_803:bat[:timestamp] := batcalc.ifthenelse(X_405:bat[:bit],
X_58:bat[:timestamp], X_798:bat[:timestamp]);
- X_806:bat[:timestamp] := batcalc.ifthenelse(X_392:bat[:bit],
X_74:bat[:timestamp], X_803:bat[:timestamp]);
- X_809:bat[:timestamp] := batcalc.ifthenelse(X_378:bat[:bit],
X_58:bat[:timestamp], X_806:bat[:timestamp]);
- X_812:bat[:timestamp] := batcalc.ifthenelse(X_361:bat[:bit],
X_74:bat[:timestamp], X_809:bat[:timestamp]);
- X_815:bat[:timestamp] := batcalc.ifthenelse(X_349:bat[:bit],
X_58:bat[:timestamp], X_812:bat[:timestamp]);
- X_819:bat[:timestamp] := batcalc.ifthenelse(X_335:bat[:bit],
X_74:bat[:timestamp], X_815:bat[:timestamp]);
- X_822:bat[:timestamp] := batcalc.ifthenelse(X_316:bat[:bit],
X_58:bat[:timestamp], X_819:bat[:timestamp]);
- X_825:bat[:timestamp] := batcalc.ifthenelse(X_303:bat[:bit],
X_74:bat[:timestamp], X_822:bat[:timestamp]);
- X_829:bat[:timestamp] := batcalc.ifthenelse(X_291:bat[:bit],
X_58:bat[:timestamp], X_825:bat[:timestamp]);
- X_832:bat[:timestamp] := batcalc.ifthenelse(X_272:bat[:bit],
X_74:bat[:timestamp], X_829:bat[:timestamp]);
- X_837:bat[:timestamp] := batcalc.ifthenelse(X_260:bat[:bit],
X_58:bat[:timestamp], X_832:bat[:timestamp]);
- X_840:bat[:timestamp] := batcalc.ifthenelse(X_246:bat[:bit],
X_74:bat[:timestamp], X_837:bat[:timestamp]);
- X_843:bat[:timestamp] := batcalc.ifthenelse(X_228:bat[:bit],
X_58:bat[:timestamp], X_840:bat[:timestamp]);
- X_846:bat[:timestamp] := batcalc.ifthenelse(X_217:bat[:bit],
X_74:bat[:timestamp], X_843:bat[:timestamp]);
- X_849:bat[:timestamp] := batcalc.ifthenelse(X_202:bat[:bit],
X_58:bat[:timestamp], X_846:bat[:timestamp]);
- X_853:bat[:timestamp] := batcalc.ifthenelse(X_184:bat[:bit],
X_74:bat[:timestamp], X_849:bat[:timestamp]);
- X_856:bat[:timestamp] := batcalc.ifthenelse(X_169:bat[:bit],
X_58:bat[:timestamp], X_853:bat[:timestamp]);
- X_859:bat[:timestamp] := batcalc.ifthenelse(X_158:bat[:bit],
X_74:bat[:timestamp], X_856:bat[:timestamp]);
- X_863:bat[:timestamp] := batcalc.ifthenelse(X_140:bat[:bit],
X_58:bat[:timestamp], X_859:bat[:timestamp]);
- X_866:bat[:timestamp] := batcalc.ifthenelse(X_126:bat[:bit],
X_74:bat[:timestamp], X_863:bat[:timestamp]);
- X_871:bat[:timestamp] := batcalc.ifthenelse(X_113:bat[:bit],
X_58:bat[:timestamp], X_866:bat[:timestamp]);
- X_874:bat[:timestamp] := batcalc.ifthenelse(X_95:bat[:bit],
X_74:bat[:timestamp], X_871:bat[:timestamp]);
- X_877:bat[:timestamp] := batcalc.ifthenelse(X_83:bat[:bit],
X_58:bat[:timestamp], X_874:bat[:timestamp]);
- X_880:bat[:timestamp] := batcalc.ifthenelse(X_69:bat[:bit],
X_74:bat[:timestamp], X_877:bat[:timestamp]);
- X_882:bat[:timestamp] := batcalc.ifthenelse(X_53:bat[:bit],
X_58:bat[:timestamp], X_880:bat[:timestamp]);
- X_883:bat[:timestamp] := batcalc.timestamp(X_882:bat[:timestamp], 7:int);
- X_888:bat[:str] := batmtime.timestamp_to_str(X_883:bat[:timestamp],
"%Y":str);
+ X_51:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "1999-10-31
09:00:00.000000":timestamp, "2000-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_56:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -28800000:lng);
+ X_65:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2000-04-02
10:00:00.000000":timestamp, "2000-10-29 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_70:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -25200000:lng);
+ X_76:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2000-10-29
09:00:00.000000":timestamp, "2001-04-01 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_87:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2001-04-01
10:00:00.000000":timestamp, "2001-10-28 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_102:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2001-10-28
09:00:00.000000":timestamp, "2002-04-07 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_113:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2002-04-07
10:00:00.000000":timestamp, "2002-10-27 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_125:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2002-10-27
09:00:00.000000":timestamp, "2003-04-06 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_141:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2003-04-06
10:00:00.000000":timestamp, "2003-10-26 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_150:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2003-10-26
09:00:00.000000":timestamp, "2004-04-04 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_162:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2004-04-04
10:00:00.000000":timestamp, "2004-10-31 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_179:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2004-10-31
09:00:00.000000":timestamp, "2005-04-03 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_188:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2005-04-03
10:00:00.000000":timestamp, "2005-10-30 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_199:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2005-10-30
09:00:00.000000":timestamp, "2006-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_216:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2006-04-02
10:00:00.000000":timestamp, "2006-10-29 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_226:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2006-10-29
09:00:00.000000":timestamp, "2007-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_237:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2007-03-11
10:00:00.000000":timestamp, "2007-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_253:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2007-11-04
09:00:00.000000":timestamp, "2008-03-09 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_263:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2008-03-09
10:00:00.000000":timestamp, "2008-11-02 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_275:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2008-11-02
09:00:00.000000":timestamp, "2009-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_291:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2009-03-08
10:00:00.000000":timestamp, "2009-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_300:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2009-11-01
09:00:00.000000":timestamp, "2010-03-14 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_312:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2010-03-14
10:00:00.000000":timestamp, "2010-11-07 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_329:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2010-11-07
09:00:00.000000":timestamp, "2011-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_338:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2011-03-13
10:00:00.000000":timestamp, "2011-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_349:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2011-11-06
09:00:00.000000":timestamp, "2012-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_366:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2012-03-11
10:00:00.000000":timestamp, "2012-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_376:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2012-11-04
09:00:00.000000":timestamp, "2013-03-10 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_387:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2013-03-10
10:00:00.000000":timestamp, "2013-11-03 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_403:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2013-11-03
09:00:00.000000":timestamp, "2014-03-09 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_413:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2014-03-09
10:00:00.000000":timestamp, "2014-11-02 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_425:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2014-11-02
09:00:00.000000":timestamp, "2015-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_441:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2015-03-08
10:00:00.000000":timestamp, "2015-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_450:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2015-11-01
09:00:00.000000":timestamp, "2016-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_462:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2016-03-13
10:00:00.000000":timestamp, "2016-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_479:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2016-11-06
09:00:00.000000":timestamp, "2017-03-12 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_488:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2017-03-12
10:00:00.000000":timestamp, "2017-11-05 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_499:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2017-11-05
09:00:00.000000":timestamp, "2018-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_516:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2018-03-11
10:00:00.000000":timestamp, "2018-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_526:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2018-11-04
09:00:00.000000":timestamp, "2019-03-10 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_537:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2019-03-10
10:00:00.000000":timestamp, "2019-11-03 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_553:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2019-11-03
09:00:00.000000":timestamp, "2020-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_563:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2020-03-08
10:00:00.000000":timestamp, "2020-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_575:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2020-11-01
09:00:00.000000":timestamp, "2021-03-14 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_591:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2021-03-14
10:00:00.000000":timestamp, "2021-11-07 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_600:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2021-11-07
09:00:00.000000":timestamp, "2022-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_612:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2022-03-13
10:00:00.000000":timestamp, "2022-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
+ X_630:bat[:timestamp] := batcalc.ifthenelse(X_612:bat[:bit],
X_70:bat[:timestamp], X_56:bat[:timestamp]);
+ X_634:bat[:timestamp] := batcalc.ifthenelse(X_600:bat[:bit],
X_56:bat[:timestamp], X_630:bat[:timestamp]);
+ X_637:bat[:timestamp] := batcalc.ifthenelse(X_591:bat[:bit],
X_70:bat[:timestamp], X_634:bat[:timestamp]);
+ X_640:bat[:timestamp] := batcalc.ifthenelse(X_575:bat[:bit],
X_56:bat[:timestamp], X_637:bat[:timestamp]);
+ X_643:bat[:timestamp] := batcalc.ifthenelse(X_563:bat[:bit],
X_70:bat[:timestamp], X_640:bat[:timestamp]);
+ X_646:bat[:timestamp] := batcalc.ifthenelse(X_553:bat[:bit],
X_56:bat[:timestamp], X_643:bat[:timestamp]);
+ X_650:bat[:timestamp] := batcalc.ifthenelse(X_537:bat[:bit],
X_70:bat[:timestamp], X_646:bat[:timestamp]);
+ X_653:bat[:timestamp] := batcalc.ifthenelse(X_526:bat[:bit],
X_56:bat[:timestamp], X_650:bat[:timestamp]);
+ X_656:bat[:timestamp] := batcalc.ifthenelse(X_516:bat[:bit],
X_70:bat[:timestamp], X_653:bat[:timestamp]);
+ X_661:bat[:timestamp] := batcalc.ifthenelse(X_499:bat[:bit],
X_56:bat[:timestamp], X_656:bat[:timestamp]);
+ X_664:bat[:timestamp] := batcalc.ifthenelse(X_488:bat[:bit],
X_70:bat[:timestamp], X_661:bat[:timestamp]);
+ X_668:bat[:timestamp] := batcalc.ifthenelse(X_479:bat[:bit],
X_56:bat[:timestamp], X_664:bat[:timestamp]);
+ X_671:bat[:timestamp] := batcalc.ifthenelse(X_462:bat[:bit],
X_70:bat[:timestamp], X_668:bat[:timestamp]);
+ X_674:bat[:timestamp] := batcalc.ifthenelse(X_450:bat[:bit],
X_56:bat[:timestamp], X_671:bat[:timestamp]);
+ X_677:bat[:timestamp] := batcalc.ifthenelse(X_441:bat[:bit],
X_70:bat[:timestamp], X_674:bat[:timestamp]);
+ X_680:bat[:timestamp] := batcalc.ifthenelse(X_425:bat[:bit],
X_56:bat[:timestamp], X_677:bat[:timestamp]);
+ X_684:bat[:timestamp] := batcalc.ifthenelse(X_413:bat[:bit],
X_70:bat[:timestamp], X_680:bat[:timestamp]);
+ X_687:bat[:timestamp] := batcalc.ifthenelse(X_403:bat[:bit],
X_56:bat[:timestamp], X_684:bat[:timestamp]);
+ X_690:bat[:timestamp] := batcalc.ifthenelse(X_387:bat[:bit],
X_70:bat[:timestamp], X_687:bat[:timestamp]);
+ X_695:bat[:timestamp] := batcalc.ifthenelse(X_376:bat[:bit],
X_56:bat[:timestamp], X_690:bat[:timestamp]);
+ X_698:bat[:timestamp] := batcalc.ifthenelse(X_366:bat[:bit],
X_70:bat[:timestamp], X_695:bat[:timestamp]);
+ X_702:bat[:timestamp] := batcalc.ifthenelse(X_349:bat[:bit],
X_56:bat[:timestamp], X_698:bat[:timestamp]);
+ X_705:bat[:timestamp] := batcalc.ifthenelse(X_338:bat[:bit],
X_70:bat[:timestamp], X_702:bat[:timestamp]);
+ X_708:bat[:timestamp] := batcalc.ifthenelse(X_329:bat[:bit],
X_56:bat[:timestamp], X_705:bat[:timestamp]);
+ X_711:bat[:timestamp] := batcalc.ifthenelse(X_312:bat[:bit],
X_70:bat[:timestamp], X_708:bat[:timestamp]);
+ X_714:bat[:timestamp] := batcalc.ifthenelse(X_300:bat[:bit],
X_56:bat[:timestamp], X_711:bat[:timestamp]);
+ X_718:bat[:timestamp] := batcalc.ifthenelse(X_291:bat[:bit],
X_70:bat[:timestamp], X_714:bat[:timestamp]);
+ X_721:bat[:timestamp] := batcalc.ifthenelse(X_275:bat[:bit],
X_56:bat[:timestamp], X_718:bat[:timestamp]);
+ X_724:bat[:timestamp] := batcalc.ifthenelse(X_263:bat[:bit],
X_70:bat[:timestamp], X_721:bat[:timestamp]);
+ X_729:bat[:timestamp] := batcalc.ifthenelse(X_253:bat[:bit],
X_56:bat[:timestamp], X_724:bat[:timestamp]);
+ X_732:bat[:timestamp] := batcalc.ifthenelse(X_237:bat[:bit],
X_70:bat[:timestamp], X_729:bat[:timestamp]);
+ X_736:bat[:timestamp] := batcalc.ifthenelse(X_226:bat[:bit],
X_56:bat[:timestamp], X_732:bat[:timestamp]);
+ X_739:bat[:timestamp] := batcalc.ifthenelse(X_216:bat[:bit],
X_70:bat[:timestamp], X_736:bat[:timestamp]);
+ X_742:bat[:timestamp] := batcalc.ifthenelse(X_199:bat[:bit],
X_56:bat[:timestamp], X_739:bat[:timestamp]);
+ X_745:bat[:timestamp] := batcalc.ifthenelse(X_188:bat[:bit],
X_70:bat[:timestamp], X_742:bat[:timestamp]);
+ X_749:bat[:timestamp] := batcalc.ifthenelse(X_179:bat[:bit],
X_56:bat[:timestamp], X_745:bat[:timestamp]);
+ X_752:bat[:timestamp] := batcalc.ifthenelse(X_162:bat[:bit],
X_70:bat[:timestamp], X_749:bat[:timestamp]);
+ X_755:bat[:timestamp] := batcalc.ifthenelse(X_150:bat[:bit],
X_56:bat[:timestamp], X_752:bat[:timestamp]);
+ X_758:bat[:timestamp] := batcalc.ifthenelse(X_141:bat[:bit],
X_70:bat[:timestamp], X_755:bat[:timestamp]);
+ X_763:bat[:timestamp] := batcalc.ifthenelse(X_125:bat[:bit],
X_56:bat[:timestamp], X_758:bat[:timestamp]);
+ X_766:bat[:timestamp] := batcalc.ifthenelse(X_113:bat[:bit],
X_70:bat[:timestamp], X_763:bat[:timestamp]);
+ X_770:bat[:timestamp] := batcalc.ifthenelse(X_102:bat[:bit],
X_56:bat[:timestamp], X_766:bat[:timestamp]);
+ X_773:bat[:timestamp] := batcalc.ifthenelse(X_87:bat[:bit],
X_70:bat[:timestamp], X_770:bat[:timestamp]);
+ X_776:bat[:timestamp] := batcalc.ifthenelse(X_76:bat[:bit],
X_56:bat[:timestamp], X_773:bat[:timestamp]);
+ X_779:bat[:timestamp] := batcalc.ifthenelse(X_65:bat[:bit],
X_70:bat[:timestamp], X_776:bat[:timestamp]);
+ X_782:bat[:timestamp] := batcalc.ifthenelse(X_51:bat[:bit],
X_56:bat[:timestamp], X_779:bat[:timestamp]);
+ X_783:bat[:timestamp] := batcalc.timestamp(X_782:bat[:timestamp], 7:int);
+ X_788:bat[:str] := batmtime.timestamp_to_str(X_783:bat[:timestamp],
"%Y":str);
language.pass(X_45:bat[:timestamp]);
- language.pass(X_74:bat[:timestamp]);
- language.pass(X_58:bat[:timestamp]);
-exit X_1047:bit;
- sql.resultSet(X_892:bat[:str], X_893:bat[:str], X_894:bat[:str],
X_895:bat[:int], X_895:bat[:int], X_888:bat[:str]);
+ language.pass(X_70:bat[:timestamp]);
+ language.pass(X_56:bat[:timestamp]);
+exit X_947:bit;
+ sql.resultSet(X_792:bat[:str], X_793:bat[:str], X_794:bat[:str],
X_795:bat[:int], X_795:bat[:int], X_788:bat[:str]);
end user.main;
# optimizer.mitosis()
# optimizer.dataflow()
diff --git
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
---
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
+++
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
@@ -34,108 +34,108 @@ stdout of test 'duplicates-not-eliminate
% 1023 # length
function user.main():void;
X_1:void := querylog.define("explain select sys.timestamp_to_str(case when
task0.\"sys_created_on\" >= \\'1999-10-31 09:00:00\\' and
task0.\"sys_created_on\" < \\'2000-04-02 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'2000-04-02 10:00:00\\' and
task0.\"sys_created_on\" < \\'2000-10-29 09:00:00\\' then
task0.\"sys_created_on\" + interval \\'-25200\\' second when
task0.\"sys_created_on\" >= \\'2000-10-29 09:00:00\\' and
task0.\"sys_created_on\" < \\'2001-04-01 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'2001-04-01 10:00:00\\' and
task0.\"sys_created_on\" < \\'2001-10-28 09:00:00\\' then
task0.\"sys_created_on\" + interval \\'-25200\\' second when
task0.\"sys_created_on\" >= \\'2001-10-28 09:00:00\\' and
task0.\"sys_created_on\" < \\'2002-04-07 10:00:00\\' then
task0.\"sys_created_on\" + interval \\'-28800\\' second when
task0.\"sys_created_on\" >= \\'20
02-04-07 10:00:00\\' and t
- X_892:bat[:str] := bat.pack("sys.":str);
- X_893:bat[:str] := bat.pack("yearref":str);
- X_894:bat[:str] := bat.pack("clob":str);
- X_895:bat[:int] := bat.pack(0:int);
+ X_792:bat[:str] := bat.pack("sys.":str);
+ X_793:bat[:str] := bat.pack("yearref":str);
+ X_794:bat[:str] := bat.pack("clob":str);
+ X_795:bat[:int] := bat.pack(0:int);
X_45:bat[:timestamp] := bat.new(nil:timestamp);
- X_53:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "1999-10-31
09:00:00.000000":timestamp, "2000-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_58:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -28800000:lng);
- X_69:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2000-04-02
10:00:00.000000":timestamp, "2000-10-29 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_74:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -25200000:lng);
- X_83:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2000-10-29
09:00:00.000000":timestamp, "2001-04-01 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_95:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2001-04-01
10:00:00.000000":timestamp, "2001-10-28 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_113:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2001-10-28
09:00:00.000000":timestamp, "2002-04-07 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_126:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2002-04-07
10:00:00.000000":timestamp, "2002-10-27 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_140:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2002-10-27
09:00:00.000000":timestamp, "2003-04-06 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_158:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2003-04-06
10:00:00.000000":timestamp, "2003-10-26 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_169:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2003-10-26
09:00:00.000000":timestamp, "2004-04-04 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_184:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2004-04-04
10:00:00.000000":timestamp, "2004-10-31 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_202:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2004-10-31
09:00:00.000000":timestamp, "2005-04-03 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_217:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2005-04-03
10:00:00.000000":timestamp, "2005-10-30 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_228:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2005-10-30
09:00:00.000000":timestamp, "2006-04-02 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_246:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2006-04-02
10:00:00.000000":timestamp, "2006-10-29 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_260:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2006-10-29
09:00:00.000000":timestamp, "2007-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_272:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2007-03-11
10:00:00.000000":timestamp, "2007-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_291:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2007-11-04
09:00:00.000000":timestamp, "2008-03-09 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_303:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2008-03-09
10:00:00.000000":timestamp, "2008-11-02 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_316:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2008-11-02
09:00:00.000000":timestamp, "2009-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_335:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2009-03-08
10:00:00.000000":timestamp, "2009-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_349:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2009-11-01
09:00:00.000000":timestamp, "2010-03-14 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_361:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2010-03-14
10:00:00.000000":timestamp, "2010-11-07 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_378:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2010-11-07
09:00:00.000000":timestamp, "2011-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_392:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2011-03-13
10:00:00.000000":timestamp, "2011-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_405:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2011-11-06
09:00:00.000000":timestamp, "2012-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_423:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2012-03-11
10:00:00.000000":timestamp, "2012-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_436:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2012-11-04
09:00:00.000000":timestamp, "2013-03-10 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_448:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2013-03-10
10:00:00.000000":timestamp, "2013-11-03 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_467:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2013-11-03
09:00:00.000000":timestamp, "2014-03-09 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_481:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2014-03-09
10:00:00.000000":timestamp, "2014-11-02 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_493:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2014-11-02
09:00:00.000000":timestamp, "2015-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_511:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2015-03-08
10:00:00.000000":timestamp, "2015-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_525:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2015-11-01
09:00:00.000000":timestamp, "2016-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_537:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2016-03-13
10:00:00.000000":timestamp, "2016-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_555:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2016-11-06
09:00:00.000000":timestamp, "2017-03-12 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_568:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2017-03-12
10:00:00.000000":timestamp, "2017-11-05 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_581:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2017-11-05
09:00:00.000000":timestamp, "2018-03-11 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_600:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2018-03-11
10:00:00.000000":timestamp, "2018-11-04 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_614:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2018-11-04
09:00:00.000000":timestamp, "2019-03-10 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_625:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2019-03-10
10:00:00.000000":timestamp, "2019-11-03 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_643:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2019-11-03
09:00:00.000000":timestamp, "2020-03-08 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_657:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2020-03-08
10:00:00.000000":timestamp, "2020-11-01 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_670:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2020-11-01
09:00:00.000000":timestamp, "2021-03-14 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_688:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2021-03-14
10:00:00.000000":timestamp, "2021-11-07 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_700:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2021-11-07
09:00:00.000000":timestamp, "2022-03-13 10:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_713:bat[:bit] := batcalc.between(X_45:bat[:timestamp], "2022-03-13
10:00:00.000000":timestamp, "2022-11-06 09:00:00.000000":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
- X_730:bat[:timestamp] := batcalc.ifthenelse(X_713:bat[:bit],
X_74:bat[:timestamp], X_58:bat[:timestamp]);
- X_734:bat[:timestamp] := batcalc.ifthenelse(X_700:bat[:bit],
X_58:bat[:timestamp], X_730:bat[:timestamp]);
- X_738:bat[:timestamp] := batcalc.ifthenelse(X_688:bat[:bit],
X_74:bat[:timestamp], X_734:bat[:timestamp]);
- X_741:bat[:timestamp] := batcalc.ifthenelse(X_670:bat[:bit],
X_58:bat[:timestamp], X_738:bat[:timestamp]);
- X_744:bat[:timestamp] := batcalc.ifthenelse(X_657:bat[:bit],
X_74:bat[:timestamp], X_741:bat[:timestamp]);
- X_747:bat[:timestamp] := batcalc.ifthenelse(X_643:bat[:bit],
X_58:bat[:timestamp], X_744:bat[:timestamp]);
- X_751:bat[:timestamp] := batcalc.ifthenelse(X_625:bat[:bit],
X_74:bat[:timestamp], X_747:bat[:timestamp]);
- X_754:bat[:timestamp] := batcalc.ifthenelse(X_614:bat[:bit],
X_58:bat[:timestamp], X_751:bat[:timestamp]);
- X_757:bat[:timestamp] := batcalc.ifthenelse(X_600:bat[:bit],
X_74:bat[:timestamp], X_754:bat[:timestamp]);
- X_761:bat[:timestamp] := batcalc.ifthenelse(X_581:bat[:bit],
X_58:bat[:timestamp], X_757:bat[:timestamp]);
- X_764:bat[:timestamp] := batcalc.ifthenelse(X_568:bat[:bit],
X_74:bat[:timestamp], X_761:bat[:timestamp]);
- X_769:bat[:timestamp] := batcalc.ifthenelse(X_555:bat[:bit],
X_58:bat[:timestamp], X_764:bat[:timestamp]);
- X_772:bat[:timestamp] := batcalc.ifthenelse(X_537:bat[:bit],
X_74:bat[:timestamp], X_769:bat[:timestamp]);
- X_775:bat[:timestamp] := batcalc.ifthenelse(X_525:bat[:bit],
X_58:bat[:timestamp], X_772:bat[:timestamp]);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
