Changeset: a44540a957cc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a44540a957cc
Branch: mtest
Log Message:
merged
diffs (truncated from 896 to 300 lines):
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.test
@@ -0,0 +1,22 @@
+query IIITIIITIITITITIIIITIIT rowsort
+SELECT *
+FROM "keys", "objects", "tables", "schemas"
+WHERE "keys"."id" = "objects"."id"
+ AND "keys"."table_id" = "tables"."id"
+ AND "tables"."schema_id" = "schemas"."id"
+ AND "tables"."system" = FALSE
+ AND "keys"."type" = 0
+----
+
+query IIITIIITIITITITIIIITIIT rowsort
+SELECT *
+FROM "keys", "objects", "tables", "schemas"
+WHERE "keys"."id" = "objects"."id"
+ AND "keys"."table_id" = "tables"."id"
+ AND "tables"."schema_id" = "schemas"."id"
+ AND "tables"."system" = FALSE
+ AND "keys"."type" = 0
+ORDER BY "objects"."name"
+----
+
+
diff --git a/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.test
@@ -0,0 +1,6 @@
+query T rowsort
+select case when 1 > 2 then 'false' when 2 > 1 then 'true' end
+----
+true
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/crash_with_wrong_nesting.SF-1097883.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/crash_with_wrong_nesting.SF-1097883.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-11-09_2.8/Tests/crash_with_wrong_nesting.SF-1097883.test
@@ -0,0 +1,11 @@
+statement ok
+create table crash_q (a integer,b char(10))
+
+statement ok
+insert into crash_q values(1,'c')
+
+statement error
+update crash_q set b= (
+select b from crash_me where crash_q.a = crash_me.a)
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/delete_with_auto_commit.SF-1096337.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/delete_with_auto_commit.SF-1096337.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-11-09_2.8/Tests/delete_with_auto_commit.SF-1096337.test
@@ -0,0 +1,43 @@
+statement ok
+create table t1096337(i int)
+
+statement ok
+insert into t1096337 values(123456789)
+
+query I rowsort
+select * from t1096337
+----
+123456789
+
+statement ok
+delete from t1096337
+
+query I rowsort
+select * from t1096337
+----
+
+statement ok
+start transaction
+
+statement ok
+create table u1096337 (id int)
+
+statement ok
+commit
+
+statement ok
+insert into u1096337 values (123456789)
+
+query I rowsort
+select * from u1096337
+----
+123456789
+
+statement ok
+delete from u1096337
+
+query I rowsort
+select * from u1096337
+----
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/insert_from_no-existing_tables.SF-1037020.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/insert_from_no-existing_tables.SF-1037020.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-11-09_2.8/Tests/insert_from_no-existing_tables.SF-1037020.test
@@ -0,0 +1,7 @@
+statement ok
+create table t1037020 (i integer)
+
+statement error
+insert into t1037020 select * from does_not_exist
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.test
@@ -0,0 +1,31 @@
+statement ok
+CREATE TABLE "rawtriples" (
+"id" decimal(10) NOT NULL,
+"subjns" decimal(10) NOT NULL,
+"subjlname" varchar(255) NOT NULL,
+"predns" decimal(10) NOT NULL,
+"predlname" varchar(255) NOT NULL,
+"objns" decimal(10) NOT NULL,
+"objlname" varchar(255) NOT NULL,
+"objlabelhash" decimal(10),
+"objlang" varchar(16),
+"objlabel" varchar(100),
+"objisliteral" boolean
+)
+
+statement ok
+INSERT INTO rawtriples VALUES(1001, 1,
+'100168990', 2, 'glossaryEntry', 0, '',
+-53495548, NULL, 'adorning with mosaic', true)
+
+statement error
+INSERT INTO rawtriples VALUES(1001, 1,
+'100168990', 2, 'glossaryEntry', 0, '',
+-5342185907394955428, NULL, 'adorning with mosaic', true)
+
+query RRTRTRTRTTT rowsort
+select * from rawtriples
+----
+11 values hashing to c537223e6971d4e31202cacabed01842
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.test
b/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.test
@@ -0,0 +1,10 @@
+statement ok
+create table t1023645 (c1 int, c2 int)
+
+statement ok
+create view v1023645 as select c1 from t1023645
+
+statement error
+insert into v1023645 values (1)
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/alias_union_join.SF-1063089.test
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/alias_union_join.SF-1063089.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/alias_union_join.SF-1063089.test
@@ -0,0 +1,36 @@
+statement ok
+CREATE TABLE tempEntries (
+ url varchar(255),
+ psize int
+)
+
+statement ok
+CREATE TABLE entries (
+ id int,
+ url varchar(255) not null unique,
+ doc date,
+ dom date,
+ psize int,
+ ranking int,
+ primary key (id)
+)
+
+statement ok
+CREATE TABLE links (
+ entryid int,
+ url varchar(255) not null,
+ primary key (entryid, url)
+)
+
+query TI rowsort
+select locallinks.url, allentries.psize
+from links locallinks inner join (
+ select url, psize
+ from entries union
+ select url, psize
+ from tempEntries
+ ) as allentries
+ on locallinks.url=allentries.url
+----
+
+
diff --git a/sql/test/BugDay_2005-11-09_2.9.3/Tests/alter_table.SF-1040057.test
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/alter_table.SF-1040057.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/alter_table.SF-1040057.test
@@ -0,0 +1,35 @@
+statement ok
+CREATE TABLE "ggle_urls"
+(
+"id" integer,
+"url" varchar(255)
+)
+
+statement ok
+ALTER TABLE "ggle_urls" ADD PRIMARY KEY("id")
+
+statement ok
+CREATE TABLE "ggle_url_links"
+(
+"urls_id" integer,
+"link" varchar(255)
+)
+
+statement ok
+ALTER TABLE "ggle_url_links" ADD FOREIGN KEY("urls_id")
+ REFERENCES "ggle_urls"("id")
+
+statement ok
+CREATE TABLE "ggle_url_data"
+(
+"urls_id" integer,
+"doc" varchar(100),
+"dom" varchar(100),
+"size" varchar(25)
+)
+
+statement ok
+ALTER TABLE "ggle_url_data" ADD FOREIGN KEY("urls_id")
+ REFERENCES "ggle_urls"("id")
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.test
@@ -0,0 +1,7 @@
+statement error
+select current_date - current_date
+
+statement error
+select current_date() - current_date()
+
+
diff --git a/sql/test/BugDay_2005-11-09_2.9.3/Tests/delete_x_2.SF-1082915.test
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/delete_x_2.SF-1082915.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/delete_x_2.SF-1082915.test
@@ -0,0 +1,16 @@
+statement ok
+create table test(a integer, b int)
+
+statement ok
+insert into test(a) values(NULL)
+
+statement ok
+insert into test(b) values(NULL)
+
+statement ok
+delete from test
+
+statement ok
+delete from test
+
+
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/drop_column_alter_table.SF-1114557.test
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/drop_column_alter_table.SF-1114557.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/drop_column_alter_table.SF-1114557.test
@@ -0,0 +1,19 @@
+statement ok
+CREATE TABLE t1114557 (id INT, name VARCHAR(10))
+
+statement error
+ALTER TABLE t1114557 DROP garbage
+
+statement ok
+ALTER TABLE t1114557 DROP name
+
+statement error
+ALTER TABLE t1114557 DROP id
+
+statement error
+ALTER TABLE t1114557 DROP name
+
+statement ok
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
