Changeset: 2948146bdbf2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2948146bdbf2
Modified Files:
sql/test/astro/Tests/astro.test
Branch: default
Log Message:
Update test with changes from Oct2020 branch.
diffs (53 lines):
diff --git a/sql/test/astro/Tests/astro.test b/sql/test/astro/Tests/astro.test
--- a/sql/test/astro/Tests/astro.test
+++ b/sql/test/astro/Tests/astro.test
@@ -69,7 +69,7 @@ update(
| single project (
| | single left outer join (
| | | semijoin (
-| | | | table("sys"."fluxz") [ "fluxz"."runcat" NOT NULL, "fluxz"."filter" NOT
NULL, "fluxz"."f_datapoints" NOT NULL, "fluxz"."active" NOT NULL,
"fluxz"."avg_flux" NOT NULL, "fluxz"."avg_fluxsq" NOT NULL, "fluxz"."avg_w" NOT
NULL, "fluxz"."avg_wflux" NOT NULL, "fluxz"."avg_wfluxsq" NOT NULL,
"fluxz"."avg_dec_zone_deg" NOT NULL, "fluxz"."%TID%" NOT NULL ] COUNT ,
+| | | | table("sys"."fluxz") [ "fluxz"."runcat" NOT NULL, "fluxz"."filter" NOT
NULL, "fluxz"."%TID%" NOT NULL ] COUNT ,
| | | | select (
| | | | | table("sys"."cm_flux") [ "cm_flux"."runcat" NOT NULL,
"cm_flux"."filter" NOT NULL, "cm_flux"."active" NOT NULL ] COUNT
| | | | ) [ "cm_flux"."active" NOT NULL = boolean "true", "cm_flux"."filter"
NOT NULL = char(1) "g" ]
@@ -84,6 +84,40 @@ update(
) [ "fluxz"."%TID%" NOT NULL, "fluxz"."filter" NOT NULL,
"fluxz"."f_datapoints" NOT NULL, "fluxz"."avg_flux" NOT NULL,
"fluxz"."avg_fluxsq" NOT NULL, "fluxz"."avg_w" NOT NULL, "fluxz"."avg_wflux"
NOT NULL, "fluxz"."avg_wfluxsq" NOT NULL, "fluxz"."avg_dec_zone_deg" NOT NULL ]
statement ok
+UPDATE fluxz
+ SET (filter
+ ,f_datapoints
+ ,avg_flux
+ ,avg_fluxsq
+ ,avg_w
+ ,avg_wflux
+ ,avg_wfluxsq
+ ,avg_dec_zone_deg
+ )
+ =
+ (SELECT filter
+ ,f_datapoints
+ ,avg_flux
+ ,avg_fluxsq
+ ,avg_w
+ ,avg_wflux
+ ,avg_wfluxsq
+ ,avg_dec_zone_deg
+ FROM cm_flux
+ WHERE cm_flux.runcat = fluxz.runcat
+ AND cm_flux.active = TRUE
+ AND cm_flux.filter = 'g'
+ AND cm_flux.filter = fluxz.filter
+ )
+ WHERE EXISTS (SELECT runcat
+ FROM cm_flux
+ WHERE cm_flux.runcat = fluxz.runcat
+ AND cm_flux.active = TRUE
+ AND cm_flux.filter = 'g'
+ AND cm_flux.filter = fluxz.filter
+ )
+
+statement ok
drop table "fluxz"
statement ok
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
