Changeset: 45013d019d44 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/45013d019d44
Modified Files:
sql/backends/monet5/rel_bin.c
sql/test/merge-partitions/Tests/mergepart20.test
Branch: Dec2023
Log Message:
fixed issue 7456, handle group by of which nothing is used.
diffs (27 lines):
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -4356,8 +4356,10 @@ rel2bin_select(backend *be, sql_rel *rel
return NULL;
}
if (s->nrcols == 0){
- if (!predicate && sub)
+ if (!predicate && sub && !list_empty(sub->op4.lval))
predicate = stmt_const(be,
bin_find_smallest_column(be, sub), stmt_bool(be, 1));
+ else
+ predicate = const_column(be, stmt_bool(be, 1));
if (e->type != e_cmp) {
sql_subtype *bt = sql_bind_localtype("bit");
diff --git a/sql/test/merge-partitions/Tests/mergepart20.test
b/sql/test/merge-partitions/Tests/mergepart20.test
--- a/sql/test/merge-partitions/Tests/mergepart20.test
+++ b/sql/test/merge-partitions/Tests/mergepart20.test
@@ -94,7 +94,7 @@ statement ok
ALTER TABLE testme ADD TABLE subtable2 AS PARTITION FROM 1 TO 10
statement error 22018!conversion of string 'abc' to type int failed.
-ALTER TABLE testme ADD TABLE subtable3 AS PARTITION FROM 'abc' TO 'cde'
+ALTER TABLE testme ADD TABLE subtable3 AS PARTITION FROM 'abc' TO '1'
statement ok rowcount 4
INSERT INTO testme VALUES (1, 'first'), (10, 'second'), (2, 'third'), (15,
'fourth')
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
