Changeset: 1f7c76eca68d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1f7c76eca68d Modified Files: sql/test/Tests/coalesce.sql Branch: default Log Message:
New bug, supertype function is not working well for strings. On this example coalesce should output a char(20) column diffs (11 lines): diff --git a/sql/test/Tests/coalesce.sql b/sql/test/Tests/coalesce.sql --- a/sql/test/Tests/coalesce.sql +++ b/sql/test/Tests/coalesce.sql @@ -28,4 +28,7 @@ select id, name, age from coalescetest w --select the name where the id > age select id, name, age from coalescetest where coalesce(id, 0) < coalesce(age, 1) and coalesce(name,'unknown') LIKE 'unknown'; +insert into coalescetest(id,name) values (3,'hello this is a test'); +select id, coalesce(name, age, 'unknown') from coalescetest; --the output type should be char(20) + drop table coalescetest; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list