Changeset: 16f977983f04 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=16f977983f04
Added Files:
sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.test
sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.test
sql/test/BugTracker-2011/Tests/Crash_in_query_analysis.Bug-2831.test
sql/test/BugTracker-2011/Tests/FK_self_reference.Bug-2862.test
sql/test/BugTracker-2011/Tests/Multiplication_and_cast.Bug-2923.test
sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.test
sql/test/BugTracker-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.test
sql/test/BugTracker-2011/Tests/aggregate-in-subquery.Bug-2739.test
sql/test/BugTracker-2011/Tests/alter-table-set-read-only.bug-2906.test
sql/test/BugTracker-2011/Tests/alter_incorrect_syntax_crash.Bug-2795.test
sql/test/BugTracker-2011/Tests/alter_table_add_column.Bug-2919.test
sql/test/BugTracker-2011/Tests/ambigous_idx_name.Bug-2800.test
sql/test/BugTracker-2011/Tests/and-power.Bug-3013.test
sql/test/BugTracker-2011/Tests/blob-update-crash.Bug-2832.test
sql/test/BugTracker-2011/Tests/bulk_rotate_xor_hash-error.Bug-2734.test
sql/test/BugTracker-2011/Tests/case-overflow.Bug-2239.test
sql/test/BugTracker-2011/Tests/case-when-alias.Bug-2848.test
sql/test/BugTracker-2011/Tests/cast-crash.Bug-2678.test
sql/test/BugTracker-2011/Tests/copy-into-file-error.Bug-2722.test
sql/test/BugTracker-2011/Tests/correlated-update.Bug-2771.test
sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.test
sql/test/BugTracker-2011/Tests/crash_in_modulo_rand.Bug-2766.test
sql/test/BugTracker-2011/Tests/crash_in_push_exp_down.Bug-2811.test
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.test
sql/test/BugTracker-2011/Tests/default-interval.Bug-2877.test
sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.test
sql/test/BugTracker-2011/Tests/device-self-ref-fk.test
sql/test/BugTracker-2011/Tests/div_by_zero.Bug-2887.test
sql/test/BugTracker-2011/Tests/div_zero_problem.Bug-2893.test
sql/test/BugTracker-2011/Tests/double_erange.Bug-2774.test
sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.test
sql/test/BugTracker-2011/Tests/extract_seconds.Bug-2793.test
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.test
sql/test/BugTracker-2011/Tests/groupby_primary_key.Bug-2807.test
sql/test/BugTracker-2011/Tests/jena-optional-1-test.Bug-2915.test
sql/test/BugTracker-2011/Tests/like_or.Bug-2924.test
sql/test/BugTracker-2011/Tests/merge_range_exp.Bug-2806.test
sql/test/BugTracker-2011/Tests/missing_refine_reverse.Bug-2898.test
sql/test/BugTracker-2011/Tests/mkey-bulk_rotate_xor_hash.Bug-2825.test
sql/test/BugTracker-2011/Tests/multicolumn_constraints.Bug-2849.test
sql/test/BugTracker-2011/Tests/multiple-joins.Bug-2879.test
sql/test/BugTracker-2011/Tests/nested_SELECT_UNIAL_ALL.Bug-2816.test
sql/test/BugTracker-2011/Tests/nested_select.Bug-2801.test
sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.test
sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.test
sql/test/BugTracker-2011/Tests/predicate.Bug-2908.test
sql/test/BugTracker-2011/Tests/rand-with-seed.Bug-2900.test
sql/test/BugTracker-2011/Tests/recursive_case.Bug-2838.test
sql/test/BugTracker-2011/Tests/select_value_insert_into.Bug-2845.test
sql/test/BugTracker-2011/Tests/sqltables.Bug-2921.test
sql/test/BugTracker-2011/Tests/str_cast_exception.Bug-2847.test
sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.test
sql/test/BugTracker-2011/Tests/subquery_in_where.Bug-2823.test
sql/test/BugTracker-2011/Tests/supertype.Bug-2830.test
sql/test/BugTracker-2011/Tests/time_precision.Bug-2873.test
sql/test/BugTracker-2011/Tests/update_with_count.Bug-2928.test
sql/test/BugTracker-2011/Tests/view_avg_incorrect_result.Bug-2790.test
sql/test/BugTracker-2011/Tests/with-scope.Bug-2058.test
Modified Files:
sql/test/BugTracker-2011/Tests/All
Branch: mtest
Log Message:
Updated most BugTracker-2011 tests
diffs (truncated from 4049 to 300 lines):
diff --git a/sql/test/BugTracker-2011/Tests/All
b/sql/test/BugTracker-2011/Tests/All
--- a/sql/test/BugTracker-2011/Tests/All
+++ b/sql/test/BugTracker-2011/Tests/All
@@ -49,7 +49,7 @@ device-self-ref-fk
missing_refine_reverse.Bug-2898
rand-with-seed.Bug-2900
HAVE_PYMONETDB?python-connections-Bug.2901
-many-connects-cache.Bug-2904
+HAVE_PYMONETDB?many-connects-cache.Bug-2904
alter-table-set-read-only.bug-2906
predicate.Bug-2908
interrupted-initialization.Bug-2875
@@ -59,7 +59,7 @@ Multiplication_and_cast.Bug-2923
like_or.Bug-2924
alter_table_add_column.Bug-2919
update_with_count.Bug-2928
-user_create_temp_table.Bug-2916
+HAVE_PYMONETDB?user_create_temp_table.Bug-2916
exists-select.Bug-2933
jena-optional-1-test.Bug-2915
and-power.Bug-3013
diff --git
a/sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.test
b/sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.test
@@ -0,0 +1,15 @@
+statement ok
+CREATE TABLE bug_2822 (c INT)
+
+statement ok
+INSERT INTO bug_2822 VALUES (0)
+
+query I rowsort
+SELECT CASE WHEN (c = 0) THEN 0 ELSE (c / (c + 1)) END FROM bug_2822
+----
+0
+
+statement ok
+DROP TABLE bug_2822
+
+
diff --git a/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.test
b/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.test
@@ -0,0 +1,33 @@
+statement ok
+CREATE TABLE t2852 (c INT)
+
+statement ok
+INSERT INTO t2852 VALUES (0)
+
+query I rowsort
+SELECT
+ CAST(COALESCE(
+ COALESCE("c" /
+ CASE
+ WHEN COALESCE("c" , 0) = 0
+ THEN
+ NULL
+ END
+ , 0) - COALESCE("c" /
+ CASE
+ WHEN "c" = 0
+ THEN
+ NULL
+ END
+ ,0)
+ , 0) AS BIGINT)
+ FROM
+ t2852
+
+----
+0
+
+statement ok
+DROP TABLE t2852
+
+
diff --git
a/sql/test/BugTracker-2011/Tests/Crash_in_query_analysis.Bug-2831.test
b/sql/test/BugTracker-2011/Tests/Crash_in_query_analysis.Bug-2831.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/Crash_in_query_analysis.Bug-2831.test
@@ -0,0 +1,45 @@
+statement ok
+create schema lrbm_bug_2831
+
+statement ok
+CREATE TABLE lrbm_bug_2831.accident(carid1 integer, carid2 integer,
firstMinute integer,
+lastMinute integer, dir integer, seg integer, pos integer)
+
+statement ok
+CREATE TABLE lrbm_bug_2831.statistics(dir int,seg int,time_minute
int,numvehicles
+int,lav float,toll int,accident int,accidentSeg int)
+
+statement ok
+UPDATE lrbm_bug_2831.statistics
+ SET toll = 0, accident = 1
+ WHERE EXISTS(
+ SELECT acc.seg
+ FROM lrbm_bug_2831.accident AS acc
+ WHERE acc.dir = statistics.dir AND
+ acc.firstMinute + 1 <= statistics.time_minute AND
+ acc.lastMinute + 1 >= statistics.time_minute AND
+ (
+ (
+ (acc.dir = 0) AND
+ (acc.seg >= statistics.seg) AND
+ (acc.seg <= statistics.seg + 4)
+ )
+ OR
+ (
+ (acc.dir <> 0) AND
+ (acc.seg <= statistics.seg) AND
+ (acc.seg >= statistics.seg - 4)
+ )
+ )
+ )
+
+statement ok
+drop table lrbm_bug_2831.statistics
+
+statement ok
+drop table lrbm_bug_2831.accident
+
+statement ok
+drop schema lrbm_bug_2831
+
+
diff --git a/sql/test/BugTracker-2011/Tests/FK_self_reference.Bug-2862.test
b/sql/test/BugTracker-2011/Tests/FK_self_reference.Bug-2862.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/FK_self_reference.Bug-2862.test
@@ -0,0 +1,34 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "device" (
+ "deviceid" int,
+ "parentdeviceid" int,
+ CONSTRAINT "device_pk" PRIMARY KEY ("deviceid")
+)
+
+statement ok
+COPY 2 RECORDS INTO "device" FROM stdin USING DELIMITERS ',',E'\n','"'
+<COPY_INTO_DATA>
+2,NULL
+23,2
+
+query II rowsort
+SELECT * FROM "device"
+2
+NULL
+23
+2
+
+statement ok
+ALTER TABLE "device" ADD CONSTRAINT "device_device_fk" FOREIGN KEY
("parentdeviceid") REFERENCES "device" ("deviceid")
+
+query II rowsort
+SELECT * FROM "device"
+2
+NULL
+23
+2
+
+
diff --git
a/sql/test/BugTracker-2011/Tests/Multiplication_and_cast.Bug-2923.test
b/sql/test/BugTracker-2011/Tests/Multiplication_and_cast.Bug-2923.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/Multiplication_and_cast.Bug-2923.test
@@ -0,0 +1,15 @@
+statement ok
+create table test234(t decimal(3,2))
+
+statement ok
+insert into test234 (t) values (-1.21)
+
+query I rowsort
+select cast((t * 100) as integer) from test234
+----
+-121
+
+statement ok
+drop table test234
+
+
diff --git a/sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.test
b/sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.test
@@ -0,0 +1,69 @@
+statement ok
+create schema datacell
+
+statement ok
+create table datacell.basket_X(
+ id integer auto_increment,
+ tag timestamp default now(),
+ payload integer
+)
+
+statement ok
+create function datacell.basket_X()
+returns table (id integer, tag timestamp, payload integer)
+begin
+ return select * from datacell.basket_X;
+end
+
+query ITI rowsort
+select * from datacell.basket_X
+----
+
+query ITI rowsort
+select * from datacell.basket_X()
+----
+
+statement ok
+drop function datacell.basket_X
+
+statement ok
+drop table datacell.basket_X
+
+statement ok
+drop schema datacell cascade
+
+statement ok
+create schema schema_2817
+
+statement ok
+create table schema_2817.table_2817(
+ id integer auto_increment,
+ tag timestamp default now(),
+ payload integer
+)
+
+statement ok
+create function schema_2817.function_2817()
+returns table (id integer, tag timestamp, payload integer)
+begin
+ return select * from schema_2817.table_2817;
+end
+
+query ITI rowsort
+select * from schema_2817.table_2817
+----
+
+query ITI rowsort
+select * from schema_2817.function_2817()
+----
+
+statement ok
+drop function schema_2817.function_2817
+
+statement ok
+drop table schema_2817.table_2817
+
+statement ok
+drop schema schema_2817 cascade
+
+
diff --git
a/sql/test/BugTracker-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.test
b/sql/test/BugTracker-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.test
@@ -0,0 +1,79 @@
+statement ok
+CREATE TABLE "Bug_2835_0" ("id" INT PRIMARY KEY )
+
+statement ok
+INSERT INTO "Bug_2835_0" VALUES (0)
+
+statement ok
+INSERT INTO "Bug_2835_0" VALUES (1)
+
+statement ok
+INSERT INTO "Bug_2835_0" VALUES (2)
+
+query I rowsort
+select * from "Bug_2835_0"
+----
+0
+1
+2
+
+statement ok
+CREATE TABLE "Bug_2835_1" ("ref" INT REFERENCES "Bug_2835_0" , CONSTRAINT
"unique" UNIQUE ("ref") )
+
+statement ok
+INSERT INTO "Bug_2835_1" VALUES (0)
+
+statement error
+INSERT INTO "Bug_2835_1" VALUES (0)
+
+query I rowsort
+select * from "Bug_2835_1"
+----
+0
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
