Changeset: b08fa89e6cfd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b08fa89e6cfd Modified Files: monetdb5/modules/mosaic/Tests/mosaic_date_1.capped.stable.out monetdb5/modules/mosaic/Tests/mosaic_date_1.delta.stable.out monetdb5/modules/mosaic/Tests/mosaic_date_1.frame.stable.out monetdb5/modules/mosaic/Tests/mosaic_date_1.prefix.stable.out monetdb5/modules/mosaic/Tests/mosaic_date_1.raw.stable.out monetdb5/modules/mosaic/Tests/mosaic_date_1.var.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_1.capped.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_1.delta.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_1.frame.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_1.prefix.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_1.raw.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_1.var.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_2.linear.stable.out monetdb5/modules/mosaic/Tests/mosaic_lng_2.runlength.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_1.capped.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_1.delta.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_1.frame.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_1.prefix.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_1.raw.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_1.var.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_2.linear.stable.out monetdb5/modules/mosaic/Tests/mosaic_oid_2.runlength.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_1.capped.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_1.frame.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_1.prefix.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_1.raw.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_1.var.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_2.linear.stable.out monetdb5/modules/mosaic/Tests/mosaic_timestamp_2.runlength.stable.out monetdb5/modules/mosaic/mosaic.c monetdb5/optimizer/opt_mosaic.c Branch: mosaic Log Message:
Improve mosaic optimizer and mosaic projection: - mosaic.projection returns the left side if the right side is a fully covering candidate list. - mosaic optimizer always replaces join, (theta)select and projection. diffs (truncated from 548 to 300 lines): diff --git a/monetdb5/modules/mosaic/Tests/mosaic_date_1.capped.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_date_1.capped.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_date_1.capped.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_date_1.capped.stable.out @@ -221,8 +221,6 @@ MOSjoin_capped MOSjoin_capped MOSjoin_capped MOSselect_capped -MOSprojection_capped -MOSprojection_capped # 16:33:17 > # 16:33:17 > "/usr/bin/python3" "mosaic_date_1.capped.MAL.py" "mosaic_date_1.capped" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_date_1.delta.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_date_1.delta.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_date_1.delta.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_date_1.delta.stable.out @@ -221,8 +221,6 @@ MOSjoin_delta MOSjoin_delta MOSjoin_delta MOSselect_delta -MOSprojection_delta -MOSprojection_delta # 16:33:20 > # 16:33:20 > "/usr/bin/python3" "mosaic_date_1.delta.MAL.py" "mosaic_date_1.delta" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_date_1.frame.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_date_1.frame.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_date_1.frame.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_date_1.frame.stable.out @@ -221,8 +221,6 @@ MOSjoin_frame MOSjoin_frame MOSjoin_frame MOSselect_frame -MOSprojection_frame -MOSprojection_frame # 16:33:28 > # 16:33:28 > "/usr/bin/python3" "mosaic_date_1.frame.MAL.py" "mosaic_date_1.frame" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_date_1.prefix.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_date_1.prefix.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_date_1.prefix.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_date_1.prefix.stable.out @@ -221,8 +221,6 @@ MOSjoin_prefix MOSjoin_prefix MOSjoin_prefix MOSselect_prefix -MOSprojection_prefix -MOSprojection_prefix # 16:33:31 > # 16:33:31 > "/usr/bin/python3" "mosaic_date_1.prefix.MAL.py" "mosaic_date_1.prefix" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_date_1.raw.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_date_1.raw.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_date_1.raw.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_date_1.raw.stable.out @@ -221,8 +221,6 @@ MOSjoin_raw MOSjoin_raw MOSjoin_raw MOSselect_raw -MOSprojection_raw -MOSprojection_raw # 16:33:04 > # 16:33:04 > "/usr/bin/python3" "mosaic_date_1.raw.MAL.py" "mosaic_date_1.raw" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_date_1.var.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_date_1.var.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_date_1.var.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_date_1.var.stable.out @@ -221,8 +221,6 @@ MOSjoin_var MOSjoin_var MOSjoin_var MOSselect_var -MOSprojection_var -MOSprojection_var # 16:33:13 > # 16:33:13 > "/usr/bin/python3" "mosaic_date_1.var.MAL.py" "mosaic_date_1.var" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.capped.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.capped.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.capped.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.capped.stable.out @@ -219,8 +219,6 @@ MOSjoin_capped MOSjoin_capped MOSjoin_capped MOSselect_capped -MOSprojection_capped -MOSprojection_capped # 16:33:15 > # 16:33:15 > "/usr/bin/python3" "mosaic_lng_1.capped.MAL.py" "mosaic_lng_1.capped" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.delta.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.delta.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.delta.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.delta.stable.out @@ -219,8 +219,6 @@ MOSjoin_delta MOSjoin_delta MOSjoin_delta MOSselect_delta -MOSprojection_delta -MOSprojection_delta # 16:33:18 > # 16:33:18 > "/usr/bin/python3" "mosaic_lng_1.delta.MAL.py" "mosaic_lng_1.delta" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.frame.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.frame.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.frame.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.frame.stable.out @@ -219,8 +219,6 @@ MOSjoin_frame MOSjoin_frame MOSjoin_frame MOSselect_frame -MOSprojection_frame -MOSprojection_frame # 16:33:26 > # 16:33:26 > "/usr/bin/python3" "mosaic_lng_1.frame.MAL.py" "mosaic_lng_1.frame" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.prefix.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.prefix.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.prefix.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.prefix.stable.out @@ -219,8 +219,6 @@ MOSjoin_prefix MOSjoin_prefix MOSjoin_prefix MOSselect_prefix -MOSprojection_prefix -MOSprojection_prefix # 16:33:30 > # 16:33:30 > "/usr/bin/python3" "mosaic_lng_1.prefix.MAL.py" "mosaic_lng_1.prefix" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.raw.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.raw.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.raw.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.raw.stable.out @@ -219,8 +219,6 @@ MOSjoin_raw MOSjoin_raw MOSjoin_raw MOSselect_raw -MOSprojection_raw -MOSprojection_raw # 16:33:02 > # 16:33:02 > "/usr/bin/python3" "mosaic_lng_1.raw.MAL.py" "mosaic_lng_1.raw" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.var.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.var.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_1.var.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_1.var.stable.out @@ -219,8 +219,6 @@ MOSjoin_var MOSjoin_var MOSjoin_var MOSselect_var -MOSprojection_var -MOSprojection_var # 16:33:11 > # 16:33:11 > "/usr/bin/python3" "mosaic_lng_1.var.MAL.py" "mosaic_lng_1.var" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_2.linear.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_2.linear.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_2.linear.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_2.linear.stable.out @@ -1992,26 +1992,6 @@ MOSselect_linear MOSselect_linear MOSselect_linear MOSselect_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear # 16:33:22 > # 16:33:22 > "/usr/bin/python3" "mosaic_lng_2.linear.MAL.py" "mosaic_lng_2.linear" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_lng_2.runlength.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_lng_2.runlength.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_lng_2.runlength.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_lng_2.runlength.stable.out @@ -1992,26 +1992,6 @@ MOSselect_runlength MOSselect_runlength MOSselect_runlength MOSselect_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength -MOSprojection_runlength # 16:33:06 > # 16:33:06 > "/usr/bin/python3" "mosaic_lng_2.runlength.MAL.py" "mosaic_lng_2.runlength" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.capped.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.capped.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.capped.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.capped.stable.out @@ -219,8 +219,6 @@ MOSjoin_capped MOSjoin_capped MOSjoin_capped MOSselect_capped -MOSprojection_capped -MOSprojection_capped # 16:33:16 > # 16:33:16 > "/usr/bin/python3" "mosaic_oid_1.capped.MAL.py" "mosaic_oid_1.capped" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.delta.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.delta.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.delta.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.delta.stable.out @@ -219,8 +219,6 @@ MOSjoin_delta MOSjoin_delta MOSjoin_delta MOSselect_delta -MOSprojection_delta -MOSprojection_delta # 16:33:19 > # 16:33:19 > "/usr/bin/python3" "mosaic_oid_1.delta.MAL.py" "mosaic_oid_1.delta" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.frame.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.frame.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.frame.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.frame.stable.out @@ -219,8 +219,6 @@ MOSjoin_frame MOSjoin_frame MOSjoin_frame MOSselect_frame -MOSprojection_frame -MOSprojection_frame # 16:33:27 > # 16:33:27 > "/usr/bin/python3" "mosaic_oid_1.frame.MAL.py" "mosaic_oid_1.frame" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.prefix.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.prefix.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.prefix.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.prefix.stable.out @@ -219,8 +219,6 @@ MOSjoin_prefix MOSjoin_prefix MOSjoin_prefix MOSselect_prefix -MOSprojection_prefix -MOSprojection_prefix # 16:33:31 > # 16:33:31 > "/usr/bin/python3" "mosaic_oid_1.prefix.MAL.py" "mosaic_oid_1.prefix" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.raw.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.raw.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.raw.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.raw.stable.out @@ -219,8 +219,6 @@ MOSjoin_raw MOSjoin_raw MOSjoin_raw MOSselect_raw -MOSprojection_raw -MOSprojection_raw # 16:33:03 > # 16:33:03 > "/usr/bin/python3" "mosaic_oid_1.raw.MAL.py" "mosaic_oid_1.raw" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.var.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.var.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_1.var.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_1.var.stable.out @@ -219,8 +219,6 @@ MOSjoin_var MOSjoin_var MOSjoin_var MOSselect_var -MOSprojection_var -MOSprojection_var # 16:33:12 > # 16:33:12 > "/usr/bin/python3" "mosaic_oid_1.var.MAL.py" "mosaic_oid_1.var" diff --git a/monetdb5/modules/mosaic/Tests/mosaic_oid_2.linear.stable.out b/monetdb5/modules/mosaic/Tests/mosaic_oid_2.linear.stable.out --- a/monetdb5/modules/mosaic/Tests/mosaic_oid_2.linear.stable.out +++ b/monetdb5/modules/mosaic/Tests/mosaic_oid_2.linear.stable.out @@ -1992,26 +1992,6 @@ MOSselect_linear MOSselect_linear MOSselect_linear MOSselect_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear -MOSprojection_linear _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
