Changeset: 95bb0faa88b7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=95bb0faa88b7
Branch: mtest
Log Message:
merged
diffs (truncated from 21856 to 300 lines):
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.test
@@ -0,0 +1,31 @@
+query I rowsort
+select CASE WHEN 1=1 THEN 1 ELSE NULL END
+----
+1
+
+query I rowsort
+select CASE WHEN 1=0 THEN 1 ELSE NULL END
+----
+NULL
+
+query T rowsort
+select CASE WHEN 2=2 THEN 2 else cast(null as char) end
+----
+2
+
+query T rowsort
+select CASE WHEN 2=0 THEN 2 else cast(null as char) end
+----
+NULL
+
+query I rowsort
+select CASE WHEN 3=3 THEN 3 else cast(null as int) end
+----
+3
+
+query I rowsort
+select CASE WHEN 3=0 THEN 3 else cast(null as int) end
+----
+NULL
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.test
@@ -0,0 +1,168 @@
+statement ok
+create table test_aggre_limit (id int, name varchar(25), type varchar(10))
+
+statement ok
+insert into test_aggre_limit values ( 1,'id','int')
+
+statement ok
+insert into test_aggre_limit values ( 2,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values ( 3,'internal','varchar')
+
+statement ok
+insert into test_aggre_limit values ( 4,'id','int')
+
+statement ok
+insert into test_aggre_limit values ( 5,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values ( 6,'authorization','int')
+
+statement ok
+insert into test_aggre_limit values ( 7,'id','int')
+
+statement ok
+insert into test_aggre_limit values ( 8,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values ( 9,'schema_id','int')
+
+statement ok
+insert into test_aggre_limit values (10,'query','varchar')
+
+statement ok
+insert into test_aggre_limit values (11,'istable','boolean')
+
+statement ok
+insert into test_aggre_limit values (12,'system','boolean')
+
+statement ok
+insert into test_aggre_limit values (13,'clear','boolean')
+
+statement ok
+insert into test_aggre_limit values (14,'id','int')
+
+statement ok
+insert into test_aggre_limit values (15,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values (16,'type','varchar')
+
+statement ok
+insert into test_aggre_limit values (17,'type_digits','int')
+
+statement ok
+insert into test_aggre_limit values (18,'type_scale','int')
+
+statement ok
+insert into test_aggre_limit values (19,'table_id','int')
+
+statement ok
+insert into test_aggre_limit values (20,'default','varchar')
+
+statement ok
+insert into test_aggre_limit values (21,'null','boolean')
+
+statement ok
+insert into test_aggre_limit values (22,'number','int')
+
+statement ok
+insert into test_aggre_limit values (23,'id','int')
+
+statement ok
+insert into test_aggre_limit values (24,'table_id','int')
+
+statement ok
+insert into test_aggre_limit values (25,'type','int')
+
+statement ok
+insert into test_aggre_limit values (26,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values (27,'rkey','int')
+
+statement ok
+insert into test_aggre_limit values (28,'id','int')
+
+statement ok
+insert into test_aggre_limit values (29,'table_id','int')
+
+statement ok
+insert into test_aggre_limit values (30,'type','int')
+
+statement ok
+insert into test_aggre_limit values (31,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values (32,'id','int')
+
+statement ok
+insert into test_aggre_limit values (33,'column','varchar')
+
+statement ok
+insert into test_aggre_limit values (34,'trunc','int')
+
+statement ok
+insert into test_aggre_limit values (35,'nr','int')
+
+statement ok
+insert into test_aggre_limit values (36,'id','int')
+
+statement ok
+insert into test_aggre_limit values (37,'systemname','varchar')
+
+statement ok
+insert into test_aggre_limit values (38,'sqlname','varchar')
+
+statement ok
+insert into test_aggre_limit values (39,'digits','int')
+
+statement ok
+insert into test_aggre_limit values (40,'scale','int')
+
+statement ok
+insert into test_aggre_limit values (41,'radix','int')
+
+statement ok
+insert into test_aggre_limit values (42,'eclass','int')
+
+statement ok
+insert into test_aggre_limit values (43,'module_id','int')
+
+statement ok
+insert into test_aggre_limit values (44,'id','int')
+
+statement ok
+insert into test_aggre_limit values (45,'name','varchar')
+
+statement ok
+insert into test_aggre_limit values (46,'func','varchar')
+
+statement ok
+insert into test_aggre_limit values (47,'sql','boolean')
+
+statement ok
+insert into test_aggre_limit values (48,'aggr','boolean')
+
+statement ok
+insert into test_aggre_limit values (49,'module_id','int')
+
+statement ok
+insert into test_aggre_limit values (50,'id','int')
+
+query I rowsort
+select count(*) from test_aggre_limit limit 1
+----
+50
+
+query TI rowsort
+select type, count(*) from test_aggre_limit group by type limit 1
+----
+int
+29
+
+statement ok
+drop table test_aggre_limit
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/bogus_prepare.SF-1377079.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/bogus_prepare.SF-1377079.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/bogus_prepare.SF-1377079.test
@@ -0,0 +1,4 @@
+statement error
+prepare select ?
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.test
@@ -0,0 +1,16 @@
+query I rowsort
+select cast(1117422000 as integer)
+----
+1117422000
+
+query I rowsort
+select cast('1117422000' as integer)
+----
+1117422000
+
+query I rowsort
+select cast(cast(1117422000 as bigint) as integer)
+----
+1117422000
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_interval.SF.1280682.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_interval.SF.1280682.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_interval.SF.1280682.test
@@ -0,0 +1,7 @@
+statement error
+select cast( 1 as interval year )
+
+statement error
+select cast( 1 as interval day )
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/crash_on_incorrect_SQL.SF-1314904.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/crash_on_incorrect_SQL.SF-1314904.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/crash_on_incorrect_SQL.SF-1314904.test
@@ -0,0 +1,7 @@
+statement ok
+create table t1314904b (testid int, testchar varchar(255))
+
+statement error
+create table t1314904b (testid unknowntype, testchar varchar(255))
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/default_next_value_for_non_ex_seq.SF.1246631.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/default_next_value_for_non_ex_seq.SF.1246631.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/default_next_value_for_non_ex_seq.SF.1246631.test
@@ -0,0 +1,13 @@
+statement error
+create table test1246631( i int default next value for non_ex_seq)
+
+statement error
+insert into test1246631
+
+statement error
+select * from test1246631
+
+statement error
+insert into test1246631
+
+
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.test
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.test
@@ -0,0 +1,21 @@
+statement ok
+create table a1296395 (id int primary key)
+
+statement ok
+create table b1296395 (id int, foreign key (id) references a1296395(id) on
delete cascade)
+
+statement ok
+insert into a1296395 values (1)
+
+statement ok
+insert into b1296395 values(1)
+
+statement ok
+delete from a1296395
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
