Changeset: 763aa8bfb815 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=763aa8bfb815
Modified Files:
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 796 to 300 lines):
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
@@ -42,380 +42,425 @@ function user.main():void;
X_61:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -28800000:lng);
X_64:bat[:timestamp] := algebra.projection(C_58:bat[:oid],
X_61:bat[:timestamp]);
X_65:bat[:timestamp] := bat.replace(X_56:bat[:timestamp], C_58:bat[:oid],
X_64:bat[:timestamp], true:bit);
- X_80: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_66:bat[:bit] := batcalc.not(X_51:bat[:bit]);
X_69:bat[:bit] := batcalc.isnil(X_66:bat[:bit]);
X_71:bat[:bit] := batcalc.or(X_66:bat[:bit], X_69:bat[:bit]);
- C_75:bat[:oid] := algebra.thetaselect(X_71:bat[:bit], true:bit, "==":str);
- C_82:bat[:oid] := algebra.thetaselect(X_80:bat[:bit], C_75:bat[:oid],
true:bit, "==":str);
+ X_76: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_78:bat[:bit] := batcalc.and(X_71:bat[:bit], X_76:bat[:bit]);
+ C_81:bat[:oid] := algebra.thetaselect(X_78:bat[:bit], true:bit, "==":str);
X_85:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_45:bat[:timestamp], -25200000:lng);
- X_86:bat[:timestamp] := algebra.projection(C_82:bat[:oid],
X_85:bat[:timestamp]);
- X_87:bat[:timestamp] := bat.replace(X_65:bat[:timestamp], C_82:bat[:oid],
X_86:bat[:timestamp], true:bit);
- X_97: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_88:bat[:bit] := batcalc.not(X_80:bat[:bit]);
+ X_86:bat[:timestamp] := algebra.projection(C_81:bat[:oid],
X_85:bat[:timestamp]);
+ X_87:bat[:timestamp] := bat.replace(X_65:bat[:timestamp], C_81:bat[:oid],
X_86:bat[:timestamp], true:bit);
+ X_88:bat[:bit] := batcalc.not(X_76:bat[:bit]);
X_89:bat[:bit] := batcalc.isnil(X_88:bat[:bit]);
X_90:bat[:bit] := batcalc.or(X_88:bat[:bit], X_89:bat[:bit]);
- C_92:bat[:oid] := algebra.thetaselect(X_90:bat[:bit], C_75:bat[:oid],
true:bit, "==":str);
- C_101:bat[:oid] := algebra.thetaselect(X_97:bat[:bit], C_92:bat[:oid],
true:bit, "==":str);
- X_107:bat[:timestamp] := algebra.projection(C_101:bat[:oid],
X_61:bat[:timestamp]);
- X_108:bat[:timestamp] := bat.replace(X_87:bat[:timestamp],
C_101:bat[:oid], X_107:bat[:timestamp], true:bit);
- X_123: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_110:bat[:bit] := batcalc.not(X_97:bat[:bit]);
- X_113:bat[:bit] := batcalc.isnil(X_110:bat[:bit]);
- X_115:bat[:bit] := batcalc.or(X_110:bat[:bit], X_113:bat[:bit]);
- C_118:bat[:oid] := algebra.thetaselect(X_115:bat[:bit], C_92:bat[:oid],
true:bit, "==":str);
- C_125:bat[:oid] := algebra.thetaselect(X_123:bat[:bit], C_118:bat[:oid],
true:bit, "==":str);
- X_129:bat[:timestamp] := algebra.projection(C_125:bat[:oid],
X_85:bat[:timestamp]);
- X_130:bat[:timestamp] := bat.replace(X_108:bat[:timestamp],
C_125:bat[:oid], X_129:bat[:timestamp], true:bit);
- X_140: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_131:bat[:bit] := batcalc.not(X_123:bat[:bit]);
- X_132:bat[:bit] := batcalc.isnil(X_131:bat[:bit]);
- X_133:bat[:bit] := batcalc.or(X_131:bat[:bit], X_132:bat[:bit]);
- C_135:bat[:oid] := algebra.thetaselect(X_133:bat[:bit], C_118:bat[:oid],
true:bit, "==":str);
- C_144:bat[:oid] := algebra.thetaselect(X_140:bat[:bit], C_135:bat[:oid],
true:bit, "==":str);
- X_150:bat[:timestamp] := algebra.projection(C_144:bat[:oid],
X_61:bat[:timestamp]);
- X_151:bat[:timestamp] := bat.replace(X_130:bat[:timestamp],
C_144:bat[:oid], X_150:bat[:timestamp], true:bit);
+ X_91:bat[:bit] := batcalc.and(X_71:bat[:bit], X_90:bat[:bit]);
+ X_96: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_99:bat[:bit] := batcalc.and(X_91:bat[:bit], X_96:bat[:bit]);
+ C_102:bat[:oid] := algebra.thetaselect(X_99:bat[:bit], true:bit, "==":str);
+ X_108:bat[:timestamp] := algebra.projection(C_102:bat[:oid],
X_61:bat[:timestamp]);
+ X_109:bat[:timestamp] := bat.replace(X_87:bat[:timestamp],
C_102:bat[:oid], X_108:bat[:timestamp], true:bit);
+ X_111:bat[:bit] := batcalc.not(X_96:bat[:bit]);
+ X_113:bat[:bit] := batcalc.isnil(X_111:bat[:bit]);
+ X_115:bat[:bit] := batcalc.or(X_111:bat[:bit], X_113:bat[:bit]);
+ X_117:bat[:bit] := batcalc.and(X_91:bat[:bit], X_115:bat[:bit]);
+ X_122: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_123:bat[:bit] := batcalc.and(X_117:bat[:bit], X_122:bat[:bit]);
+ C_125:bat[:oid] := algebra.thetaselect(X_123:bat[:bit], true:bit,
"==":str);
+ X_130:bat[:timestamp] := algebra.projection(C_125:bat[:oid],
X_85:bat[:timestamp]);
+ X_131:bat[:timestamp] := bat.replace(X_109:bat[:timestamp],
C_125:bat[:oid], X_130:bat[:timestamp], true:bit);
+ X_132:bat[:bit] := batcalc.not(X_122:bat[:bit]);
+ X_134:bat[:bit] := batcalc.isnil(X_132:bat[:bit]);
+ X_135:bat[:bit] := batcalc.or(X_132:bat[:bit], X_134:bat[:bit]);
+ X_136:bat[:bit] := batcalc.and(X_117:bat[:bit], X_135:bat[:bit]);
+ X_141: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_144:bat[:bit] := batcalc.and(X_136:bat[:bit], X_141:bat[:bit]);
+ C_146:bat[:oid] := algebra.thetaselect(X_144:bat[:bit], true:bit,
"==":str);
+ X_152:bat[:timestamp] := algebra.projection(C_146:bat[:oid],
X_61:bat[:timestamp]);
+ X_153:bat[:timestamp] := bat.replace(X_131:bat[:timestamp],
C_146:bat[:oid], X_152:bat[:timestamp], true:bit);
+ X_154:bat[:bit] := batcalc.not(X_141:bat[:bit]);
+ X_156:bat[:bit] := batcalc.isnil(X_154:bat[:bit]);
+ X_158:bat[:bit] := batcalc.or(X_154:bat[:bit], X_156:bat[:bit]);
+ X_160:bat[:bit] := batcalc.and(X_136:bat[:bit], X_158:bat[:bit]);
X_165: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_152:bat[:bit] := batcalc.not(X_140:bat[:bit]);
- X_155:bat[:bit] := batcalc.isnil(X_152:bat[:bit]);
- X_157:bat[:bit] := batcalc.or(X_152:bat[:bit], X_155:bat[:bit]);
- C_160:bat[:oid] := algebra.thetaselect(X_157:bat[:bit], C_135:bat[:oid],
true:bit, "==":str);
- C_167:bat[:oid] := algebra.thetaselect(X_165:bat[:bit], C_160:bat[:oid],
true:bit, "==":str);
- X_171:bat[:timestamp] := algebra.projection(C_167:bat[:oid],
X_85:bat[:timestamp]);
- X_172:bat[:timestamp] := bat.replace(X_151:bat[:timestamp],
C_167:bat[:oid], X_171:bat[:timestamp], true:bit);
- X_183: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_173:bat[:bit] := batcalc.not(X_165:bat[:bit]);
- X_174:bat[:bit] := batcalc.isnil(X_173:bat[:bit]);
- X_175:bat[:bit] := batcalc.or(X_173:bat[:bit], X_174:bat[:bit]);
- C_178:bat[:oid] := algebra.thetaselect(X_175:bat[:bit], C_160:bat[:oid],
true:bit, "==":str);
- C_187:bat[:oid] := algebra.thetaselect(X_183:bat[:bit], C_178:bat[:oid],
true:bit, "==":str);
- X_193:bat[:timestamp] := algebra.projection(C_187:bat[:oid],
X_61:bat[:timestamp]);
- X_194:bat[:timestamp] := bat.replace(X_172:bat[:timestamp],
C_187:bat[:oid], X_193:bat[:timestamp], true:bit);
- X_208: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_195:bat[:bit] := batcalc.not(X_183:bat[:bit]);
- X_198:bat[:bit] := batcalc.isnil(X_195:bat[:bit]);
- X_200:bat[:bit] := batcalc.or(X_195:bat[:bit], X_198:bat[:bit]);
- C_203:bat[:oid] := algebra.thetaselect(X_200:bat[:bit], C_178:bat[:oid],
true:bit, "==":str);
- C_211:bat[:oid] := algebra.thetaselect(X_208:bat[:bit], C_203:bat[:oid],
true:bit, "==":str);
- X_215:bat[:timestamp] := algebra.projection(C_211:bat[:oid],
X_85:bat[:timestamp]);
- X_216:bat[:timestamp] := bat.replace(X_194:bat[:timestamp],
C_211:bat[:oid], X_215:bat[:timestamp], true:bit);
- X_226: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_217:bat[:bit] := batcalc.not(X_208:bat[:bit]);
- X_218:bat[:bit] := batcalc.isnil(X_217:bat[:bit]);
- X_219:bat[:bit] := batcalc.or(X_217:bat[:bit], X_218:bat[:bit]);
- C_221:bat[:oid] := algebra.thetaselect(X_219:bat[:bit], C_203:bat[:oid],
true:bit, "==":str);
- C_230:bat[:oid] := algebra.thetaselect(X_226:bat[:bit], C_221:bat[:oid],
true:bit, "==":str);
- X_236:bat[:timestamp] := algebra.projection(C_230:bat[:oid],
X_61:bat[:timestamp]);
- X_237:bat[:timestamp] := bat.replace(X_216:bat[:timestamp],
C_230:bat[:oid], X_236:bat[:timestamp], true:bit);
- X_252: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_238:bat[:bit] := batcalc.not(X_226:bat[:bit]);
- X_241:bat[:bit] := batcalc.isnil(X_238:bat[:bit]);
- X_243:bat[:bit] := batcalc.or(X_238:bat[:bit], X_241:bat[:bit]);
- C_247:bat[:oid] := algebra.thetaselect(X_243:bat[:bit], C_221:bat[:oid],
true:bit, "==":str);
- C_254:bat[:oid] := algebra.thetaselect(X_252:bat[:bit], C_247:bat[:oid],
true:bit, "==":str);
- X_258:bat[:timestamp] := algebra.projection(C_254:bat[:oid],
X_85:bat[:timestamp]);
- X_259:bat[:timestamp] := bat.replace(X_237:bat[:timestamp],
C_254:bat[:oid], X_258:bat[:timestamp], true:bit);
- X_269: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_260:bat[:bit] := batcalc.not(X_252:bat[:bit]);
- X_261:bat[:bit] := batcalc.isnil(X_260:bat[:bit]);
- X_262:bat[:bit] := batcalc.or(X_260:bat[:bit], X_261:bat[:bit]);
- C_264:bat[:oid] := algebra.thetaselect(X_262:bat[:bit], C_247:bat[:oid],
true:bit, "==":str);
- C_273:bat[:oid] := algebra.thetaselect(X_269:bat[:bit], C_264:bat[:oid],
true:bit, "==":str);
- X_279:bat[:timestamp] := algebra.projection(C_273:bat[:oid],
X_61:bat[:timestamp]);
- X_280:bat[:timestamp] := bat.replace(X_259:bat[:timestamp],
C_273:bat[:oid], X_279:bat[:timestamp], true:bit);
- X_295: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_282:bat[:bit] := batcalc.not(X_269:bat[:bit]);
- X_285:bat[:bit] := batcalc.isnil(X_282:bat[:bit]);
- X_287:bat[:bit] := batcalc.or(X_282:bat[:bit], X_285:bat[:bit]);
- C_290:bat[:oid] := algebra.thetaselect(X_287:bat[:bit], C_264:bat[:oid],
true:bit, "==":str);
- C_297:bat[:oid] := algebra.thetaselect(X_295:bat[:bit], C_290:bat[:oid],
true:bit, "==":str);
- X_301:bat[:timestamp] := algebra.projection(C_297:bat[:oid],
X_85:bat[:timestamp]);
- X_302:bat[:timestamp] := bat.replace(X_280:bat[:timestamp],
C_297:bat[:oid], X_301:bat[:timestamp], true:bit);
- X_312: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_303:bat[:bit] := batcalc.not(X_295:bat[:bit]);
- X_304:bat[:bit] := batcalc.isnil(X_303:bat[:bit]);
- X_305:bat[:bit] := batcalc.or(X_303:bat[:bit], X_304:bat[:bit]);
- C_307:bat[:oid] := algebra.thetaselect(X_305:bat[:bit], C_290:bat[:oid],
true:bit, "==":str);
- C_316:bat[:oid] := algebra.thetaselect(X_312:bat[:bit], C_307:bat[:oid],
true:bit, "==":str);
- X_322:bat[:timestamp] := algebra.projection(C_316:bat[:oid],
X_61:bat[:timestamp]);
- X_323:bat[:timestamp] := bat.replace(X_302:bat[:timestamp],
C_316:bat[:oid], X_322:bat[:timestamp], true:bit);
- X_337: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_324:bat[:bit] := batcalc.not(X_312:bat[:bit]);
- X_327:bat[:bit] := batcalc.isnil(X_324:bat[:bit]);
- X_329:bat[:bit] := batcalc.or(X_324:bat[:bit], X_327:bat[:bit]);
- C_332:bat[:oid] := algebra.thetaselect(X_329:bat[:bit], C_307:bat[:oid],
true:bit, "==":str);
- C_339:bat[:oid] := algebra.thetaselect(X_337:bat[:bit], C_332:bat[:oid],
true:bit, "==":str);
- X_343:bat[:timestamp] := algebra.projection(C_339:bat[:oid],
X_85:bat[:timestamp]);
- X_344:bat[:timestamp] := bat.replace(X_323:bat[:timestamp],
C_339:bat[:oid], X_343:bat[:timestamp], true:bit);
- X_355: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_345:bat[:bit] := batcalc.not(X_337:bat[:bit]);
- X_346:bat[:bit] := batcalc.isnil(X_345:bat[:bit]);
- X_347:bat[:bit] := batcalc.or(X_345:bat[:bit], X_346:bat[:bit]);
- C_350:bat[:oid] := algebra.thetaselect(X_347:bat[:bit], C_332:bat[:oid],
true:bit, "==":str);
- C_359:bat[:oid] := algebra.thetaselect(X_355:bat[:bit], C_350:bat[:oid],
true:bit, "==":str);
- X_365:bat[:timestamp] := algebra.projection(C_359:bat[:oid],
X_61:bat[:timestamp]);
- X_366:bat[:timestamp] := bat.replace(X_344:bat[:timestamp],
C_359:bat[:oid], X_365:bat[:timestamp], true:bit);
- X_380: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_367:bat[:bit] := batcalc.not(X_355:bat[:bit]);
- X_370:bat[:bit] := batcalc.isnil(X_367:bat[:bit]);
- X_372:bat[:bit] := batcalc.or(X_367:bat[:bit], X_370:bat[:bit]);
- C_375:bat[:oid] := algebra.thetaselect(X_372:bat[:bit], C_350:bat[:oid],
true:bit, "==":str);
- C_383:bat[:oid] := algebra.thetaselect(X_380:bat[:bit], C_375:bat[:oid],
true:bit, "==":str);
- X_387:bat[:timestamp] := algebra.projection(C_383:bat[:oid],
X_85:bat[:timestamp]);
- X_388:bat[:timestamp] := bat.replace(X_366:bat[:timestamp],
C_383:bat[:oid], X_387:bat[:timestamp], true:bit);
- X_398: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_389:bat[:bit] := batcalc.not(X_380:bat[:bit]);
- X_390:bat[:bit] := batcalc.isnil(X_389:bat[:bit]);
- X_391:bat[:bit] := batcalc.or(X_389:bat[:bit], X_390:bat[:bit]);
- C_393:bat[:oid] := algebra.thetaselect(X_391:bat[:bit], C_375:bat[:oid],
true:bit, "==":str);
- C_402:bat[:oid] := algebra.thetaselect(X_398:bat[:bit], C_393:bat[:oid],
true:bit, "==":str);
- X_408:bat[:timestamp] := algebra.projection(C_402:bat[:oid],
X_61:bat[:timestamp]);
- X_409:bat[:timestamp] := bat.replace(X_388:bat[:timestamp],
C_402:bat[:oid], X_408:bat[:timestamp], true:bit);
- X_424: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_410:bat[:bit] := batcalc.not(X_398:bat[:bit]);
- X_413:bat[:bit] := batcalc.isnil(X_410:bat[:bit]);
- X_415:bat[:bit] := batcalc.or(X_410:bat[:bit], X_413:bat[:bit]);
- C_419:bat[:oid] := algebra.thetaselect(X_415:bat[:bit], C_393:bat[:oid],
true:bit, "==":str);
- C_426:bat[:oid] := algebra.thetaselect(X_424:bat[:bit], C_419:bat[:oid],
true:bit, "==":str);
- X_430:bat[:timestamp] := algebra.projection(C_426:bat[:oid],
X_85:bat[:timestamp]);
- X_431:bat[:timestamp] := bat.replace(X_409:bat[:timestamp],
C_426:bat[:oid], X_430:bat[:timestamp], true:bit);
- X_441: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_432:bat[:bit] := batcalc.not(X_424:bat[:bit]);
- X_433:bat[:bit] := batcalc.isnil(X_432:bat[:bit]);
- X_434:bat[:bit] := batcalc.or(X_432:bat[:bit], X_433:bat[:bit]);
- C_436:bat[:oid] := algebra.thetaselect(X_434:bat[:bit], C_419:bat[:oid],
true:bit, "==":str);
- C_445:bat[:oid] := algebra.thetaselect(X_441:bat[:bit], C_436:bat[:oid],
true:bit, "==":str);
- X_451:bat[:timestamp] := algebra.projection(C_445:bat[:oid],
X_61:bat[:timestamp]);
- X_452:bat[:timestamp] := bat.replace(X_431:bat[:timestamp],
C_445:bat[:oid], X_451:bat[:timestamp], true:bit);
- X_467: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_454:bat[:bit] := batcalc.not(X_441:bat[:bit]);
- X_457:bat[:bit] := batcalc.isnil(X_454:bat[:bit]);
- X_459:bat[:bit] := batcalc.or(X_454:bat[:bit], X_457:bat[:bit]);
- C_462:bat[:oid] := algebra.thetaselect(X_459:bat[:bit], C_436:bat[:oid],
true:bit, "==":str);
- C_469:bat[:oid] := algebra.thetaselect(X_467:bat[:bit], C_462:bat[:oid],
true:bit, "==":str);
- X_473:bat[:timestamp] := algebra.projection(C_469:bat[:oid],
X_85:bat[:timestamp]);
- X_474:bat[:timestamp] := bat.replace(X_452:bat[:timestamp],
C_469:bat[:oid], X_473:bat[:timestamp], true:bit);
- X_484: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_475:bat[:bit] := batcalc.not(X_467:bat[:bit]);
- X_476:bat[:bit] := batcalc.isnil(X_475:bat[:bit]);
- X_477:bat[:bit] := batcalc.or(X_475:bat[:bit], X_476:bat[:bit]);
- C_479:bat[:oid] := algebra.thetaselect(X_477:bat[:bit], C_462:bat[:oid],
true:bit, "==":str);
- C_488:bat[:oid] := algebra.thetaselect(X_484:bat[:bit], C_479:bat[:oid],
true:bit, "==":str);
- X_494:bat[:timestamp] := algebra.projection(C_488:bat[:oid],
X_61:bat[:timestamp]);
- X_495:bat[:timestamp] := bat.replace(X_474:bat[:timestamp],
C_488:bat[:oid], X_494:bat[:timestamp], true:bit);
- X_509: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_496:bat[:bit] := batcalc.not(X_484:bat[:bit]);
- X_499:bat[:bit] := batcalc.isnil(X_496:bat[:bit]);
- X_501:bat[:bit] := batcalc.or(X_496:bat[:bit], X_499:bat[:bit]);
- C_504:bat[:oid] := algebra.thetaselect(X_501:bat[:bit], C_479:bat[:oid],
true:bit, "==":str);
- C_511:bat[:oid] := algebra.thetaselect(X_509:bat[:bit], C_504:bat[:oid],
true:bit, "==":str);
- X_515:bat[:timestamp] := algebra.projection(C_511:bat[:oid],
X_85:bat[:timestamp]);
- X_516:bat[:timestamp] := bat.replace(X_495:bat[:timestamp],
C_511:bat[:oid], X_515:bat[:timestamp], true:bit);
- X_527: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_517:bat[:bit] := batcalc.not(X_509:bat[:bit]);
- X_518:bat[:bit] := batcalc.isnil(X_517:bat[:bit]);
- X_519:bat[:bit] := batcalc.or(X_517:bat[:bit], X_518:bat[:bit]);
- C_522:bat[:oid] := algebra.thetaselect(X_519:bat[:bit], C_504:bat[:oid],
true:bit, "==":str);
- C_531:bat[:oid] := algebra.thetaselect(X_527:bat[:bit], C_522:bat[:oid],
true:bit, "==":str);
- X_537:bat[:timestamp] := algebra.projection(C_531:bat[:oid],
X_61:bat[:timestamp]);
- X_538:bat[:timestamp] := bat.replace(X_516:bat[:timestamp],
C_531:bat[:oid], X_537:bat[:timestamp], true:bit);
- X_552: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_539:bat[:bit] := batcalc.not(X_527:bat[:bit]);
- X_542:bat[:bit] := batcalc.isnil(X_539:bat[:bit]);
- X_544:bat[:bit] := batcalc.or(X_539:bat[:bit], X_542:bat[:bit]);
- C_547:bat[:oid] := algebra.thetaselect(X_544:bat[:bit], C_522:bat[:oid],
true:bit, "==":str);
- C_555:bat[:oid] := algebra.thetaselect(X_552:bat[:bit], C_547:bat[:oid],
true:bit, "==":str);
- X_559:bat[:timestamp] := algebra.projection(C_555:bat[:oid],
X_85:bat[:timestamp]);
- X_560:bat[:timestamp] := bat.replace(X_538:bat[:timestamp],
C_555:bat[:oid], X_559:bat[:timestamp], true:bit);
- X_570: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_561:bat[:bit] := batcalc.not(X_552:bat[:bit]);
- X_562:bat[:bit] := batcalc.isnil(X_561:bat[:bit]);
- X_563:bat[:bit] := batcalc.or(X_561:bat[:bit], X_562:bat[:bit]);
- C_565:bat[:oid] := algebra.thetaselect(X_563:bat[:bit], C_547:bat[:oid],
true:bit, "==":str);
- C_574:bat[:oid] := algebra.thetaselect(X_570:bat[:bit], C_565:bat[:oid],
true:bit, "==":str);
- X_580:bat[:timestamp] := algebra.projection(C_574:bat[:oid],
X_61:bat[:timestamp]);
- X_581:bat[:timestamp] := bat.replace(X_560:bat[:timestamp],
C_574:bat[:oid], X_580:bat[:timestamp], true:bit);
- X_596: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_582:bat[:bit] := batcalc.not(X_570:bat[:bit]);
- X_585:bat[:bit] := batcalc.isnil(X_582:bat[:bit]);
- X_587:bat[:bit] := batcalc.or(X_582:bat[:bit], X_585:bat[:bit]);
- C_591:bat[:oid] := algebra.thetaselect(X_587:bat[:bit], C_565:bat[:oid],
true:bit, "==":str);
- C_598:bat[:oid] := algebra.thetaselect(X_596:bat[:bit], C_591:bat[:oid],
true:bit, "==":str);
- X_602:bat[:timestamp] := algebra.projection(C_598:bat[:oid],
X_85:bat[:timestamp]);
- X_603:bat[:timestamp] := bat.replace(X_581:bat[:timestamp],
C_598:bat[:oid], X_602:bat[:timestamp], true:bit);
- X_613: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_604:bat[:bit] := batcalc.not(X_596:bat[:bit]);
- X_605:bat[:bit] := batcalc.isnil(X_604:bat[:bit]);
- X_606:bat[:bit] := batcalc.or(X_604:bat[:bit], X_605:bat[:bit]);
- C_608:bat[:oid] := algebra.thetaselect(X_606:bat[:bit], C_591:bat[:oid],
true:bit, "==":str);
- C_617:bat[:oid] := algebra.thetaselect(X_613:bat[:bit], C_608:bat[:oid],
true:bit, "==":str);
- X_623:bat[:timestamp] := algebra.projection(C_617:bat[:oid],
X_61:bat[:timestamp]);
- X_624:bat[:timestamp] := bat.replace(X_603:bat[:timestamp],
C_617:bat[:oid], X_623:bat[:timestamp], true:bit);
- X_639: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_626:bat[:bit] := batcalc.not(X_613:bat[:bit]);
- X_629:bat[:bit] := batcalc.isnil(X_626:bat[:bit]);
- X_631:bat[:bit] := batcalc.or(X_626:bat[:bit], X_629:bat[:bit]);
- C_634:bat[:oid] := algebra.thetaselect(X_631:bat[:bit], C_608:bat[:oid],
true:bit, "==":str);
- C_641:bat[:oid] := algebra.thetaselect(X_639:bat[:bit], C_634:bat[:oid],
true:bit, "==":str);
- X_645:bat[:timestamp] := algebra.projection(C_641:bat[:oid],
X_85:bat[:timestamp]);
- X_646:bat[:timestamp] := bat.replace(X_624:bat[:timestamp],
C_641:bat[:oid], X_645:bat[:timestamp], true:bit);
- X_656: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_647:bat[:bit] := batcalc.not(X_639:bat[:bit]);
- X_648:bat[:bit] := batcalc.isnil(X_647:bat[:bit]);
- X_649:bat[:bit] := batcalc.or(X_647:bat[:bit], X_648:bat[:bit]);
- C_651:bat[:oid] := algebra.thetaselect(X_649:bat[:bit], C_634:bat[:oid],
true:bit, "==":str);
- C_660:bat[:oid] := algebra.thetaselect(X_656:bat[:bit], C_651:bat[:oid],
true:bit, "==":str);
- X_666:bat[:timestamp] := algebra.projection(C_660:bat[:oid],
X_61:bat[:timestamp]);
- X_667:bat[:timestamp] := bat.replace(X_646:bat[:timestamp],
C_660:bat[:oid], X_666:bat[:timestamp], true:bit);
- X_681: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_668:bat[:bit] := batcalc.not(X_656:bat[:bit]);
- X_671:bat[:bit] := batcalc.isnil(X_668:bat[:bit]);
- X_673:bat[:bit] := batcalc.or(X_668:bat[:bit], X_671:bat[:bit]);
- C_676:bat[:oid] := algebra.thetaselect(X_673:bat[:bit], C_651:bat[:oid],
true:bit, "==":str);
- C_683:bat[:oid] := algebra.thetaselect(X_681:bat[:bit], C_676:bat[:oid],
true:bit, "==":str);
- X_687:bat[:timestamp] := algebra.projection(C_683:bat[:oid],
X_85:bat[:timestamp]);
- X_688:bat[:timestamp] := bat.replace(X_667:bat[:timestamp],
C_683:bat[:oid], X_687:bat[:timestamp], true:bit);
- X_699: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_689:bat[:bit] := batcalc.not(X_681:bat[:bit]);
- X_690:bat[:bit] := batcalc.isnil(X_689:bat[:bit]);
- X_691:bat[:bit] := batcalc.or(X_689:bat[:bit], X_690:bat[:bit]);
- C_694:bat[:oid] := algebra.thetaselect(X_691:bat[:bit], C_676:bat[:oid],
true:bit, "==":str);
- C_703:bat[:oid] := algebra.thetaselect(X_699:bat[:bit], C_694:bat[:oid],
true:bit, "==":str);
- X_709:bat[:timestamp] := algebra.projection(C_703:bat[:oid],
X_61:bat[:timestamp]);
- X_710:bat[:timestamp] := bat.replace(X_688:bat[:timestamp],
C_703:bat[:oid], X_709:bat[:timestamp], true:bit);
- X_724: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_711:bat[:bit] := batcalc.not(X_699:bat[:bit]);
- X_714:bat[:bit] := batcalc.isnil(X_711:bat[:bit]);
- X_716:bat[:bit] := batcalc.or(X_711:bat[:bit], X_714:bat[:bit]);
- C_719:bat[:oid] := algebra.thetaselect(X_716:bat[:bit], C_694:bat[:oid],
true:bit, "==":str);
- C_727:bat[:oid] := algebra.thetaselect(X_724:bat[:bit], C_719:bat[:oid],
true:bit, "==":str);
- X_731:bat[:timestamp] := algebra.projection(C_727:bat[:oid],
X_85:bat[:timestamp]);
- X_732:bat[:timestamp] := bat.replace(X_710:bat[:timestamp],
C_727:bat[:oid], X_731:bat[:timestamp], true:bit);
- X_742: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_733:bat[:bit] := batcalc.not(X_724:bat[:bit]);
- X_734:bat[:bit] := batcalc.isnil(X_733:bat[:bit]);
- X_735:bat[:bit] := batcalc.or(X_733:bat[:bit], X_734:bat[:bit]);
- C_737:bat[:oid] := algebra.thetaselect(X_735:bat[:bit], C_719:bat[:oid],
true:bit, "==":str);
- C_746:bat[:oid] := algebra.thetaselect(X_742:bat[:bit], C_737:bat[:oid],
true:bit, "==":str);
- X_752:bat[:timestamp] := algebra.projection(C_746:bat[:oid],
X_61:bat[:timestamp]);
- X_753:bat[:timestamp] := bat.replace(X_732:bat[:timestamp],
C_746:bat[:oid], X_752:bat[:timestamp], true:bit);
- X_768: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_754:bat[:bit] := batcalc.not(X_742:bat[:bit]);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
