Changeset: 01c7e75d0ae6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=01c7e75d0ae6
Modified Files:
sql/test/miscellaneous/Tests/simple_selects.sql
Branch: timezone
Log Message:
merged
diffs (23 lines):
diff --git a/sql/test/miscellaneous/Tests/simple_selects.sql
b/sql/test/miscellaneous/Tests/simple_selects.sql
--- a/sql/test/miscellaneous/Tests/simple_selects.sql
+++ b/sql/test/miscellaneous/Tests/simple_selects.sql
@@ -97,3 +97,19 @@ CREATE AGGREGATE sin(input REAL) RETURNS
select length(myblob), octet_length(myblob), length(mystr),
octet_length(mystr)
from (values (cast(null as blob), cast(null as char(32)))) as my(myblob,
mystr);
select md5(null);
+
+select 'a' like null, null like 'a', null like null, 'a' ilike null, null
ilike 'a', null ilike null,
+ 'a' not like null, null not like 'a', null not like null, 'a' not ilike
null, null not ilike 'a', null not ilike null; --all NULL
+
+create table x (x varchar(32));
+insert into x values (null), ('a');
+
+select x like null, null like x, null like null, x ilike null, null ilike x,
null ilike null,
+ x not like null, null not like x, null not like null, x not ilike null,
null not ilike x, null not ilike null from x;
+ -- all NULL
+
+select x like x, x ilike x, x not like x, x not ilike x from x;
+ -- NULL NULL NULL NULL
+ -- True True False False
+
+drop table x;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
