Changeset: 4dc49d9d5052 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4dc49d9d5052
Branch: Oct2020
Log Message:
merged
diffs (44 lines):
diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c
--- a/sql/server/rel_exp.c
+++ b/sql/server/rel_exp.c
@@ -316,6 +316,8 @@ exp_convert(sql_allocator *sa, sql_exp *
e->r = append(append(sa_list(sa), dup_subtype(sa, fromtype)),totype);
e->tpe = *totype;
e->alias = exp->alias;
+ if (!has_nil(exp))
+ set_has_no_nil(e);
return e;
}
diff --git a/sql/test/Tests/keys.stable.out b/sql/test/Tests/keys.stable.out
--- a/sql/test/Tests/keys.stable.out
+++ b/sql/test/Tests/keys.stable.out
@@ -142,24 +142,24 @@ project (
% .plan # table_name
% rel # name
% clob # type
-% 111 # length
+% 129 # length
project (
| group by (
| | project (
| | | table(sys.dummyme) [ "dummyme"."a" NOT NULL HASHCOL ] COUNT
-| | ) [ bigint["dummyme"."a" NOT NULL HASHCOL ] as "%3"."%3",
sys.sql_add("%3"."%3", bigint "1") as "%2"."%2" ]
+| | ) [ bigint["dummyme"."a" NOT NULL HASHCOL ] NOT NULL as "%3"."%3",
sys.sql_add("%3"."%3" NOT NULL, bigint "1") as "%2"."%2" ]
| ) [ ] [ sys.count unique no nil ("%2"."%2") as "%1"."%1" ]
) [ "%1"."%1" ]
#plan select count(distinct a + b) from dummyme;
% .plan # table_name
% rel # name
% clob # type
-% 146 # length
+% 164 # length
project (
| group by (
| | project (
| | | table(sys.dummyme) [ "dummyme"."a" NOT NULL HASHCOL , "dummyme"."b" ]
COUNT
-| | ) [ bigint["dummyme"."a" NOT NULL HASHCOL ] as "%3"."%3",
bigint["dummyme"."b"] as "%4"."%4", sys.sql_add("%3"."%3", "%4"."%4") as
"%2"."%2" ]
+| | ) [ bigint["dummyme"."a" NOT NULL HASHCOL ] NOT NULL as "%3"."%3",
bigint["dummyme"."b"] as "%4"."%4", sys.sql_add("%3"."%3" NOT NULL, "%4"."%4")
as "%2"."%2" ]
| ) [ ] [ sys.count unique no nil ("%2"."%2") as "%1"."%1" ]
) [ "%1"."%1" ]
#plan select count(distinct abs(a)) from dummyme;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list