Changeset: 44fb338dac3c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=44fb338dac3c
Added Files:
sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/accents_in_strings.SF-926709.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/affected_rows_count.SF-1149757.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/alter_table_describe.SF-1146092.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/basic_arithmetics.SF-922252.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/bool_boolean.SF-935601.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/case.SF-929151.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/cast_to_interval.SF-1019079.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/comment_only.SF-931619.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/create_drop_schema.SF-933546.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/create_table_default.SF-931573.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/create_view_with_check_options.SF-1314951.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/cross_product.SF-1122802.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/custom_function_in_where.SF-937859.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/drop_index.SF-929243.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/error_in_sql_parser.SF-1019122.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/fk_without_notnull_constraint.SF-1016842.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/foreign_key_in_frontend_crashes_backend.SF-935578.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/foreign_key_null.SF-1164646.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/index_management.SF-927326.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/inlined_copy_into.SF-922392.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/jdbc_crashes_on_getTables.SF_944316.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/last_line_without_newline.SF-922390.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/last_line_without_newline.SF-922390.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/limit_in_create_view.SF-924448.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/multiple_select_cast.SF-938419.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/multiple_select_on_view.SF-935639.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/not_null.SF-933194.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/parser_crashes_server.SF-921996.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/parsing_doubles.SF-922332.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/quoted_keywords.SF-922288.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/reserved_words.SF-939112.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/rollback_and_autocommit.SF-926453.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/select_not_true.SF-1314945.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/sesamstr_parser_error.SF-993366.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/set_types.SF-932360.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/singleton_view.SF-933573.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting.SF-923709.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting.SF-923709.stable.err
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting.SF-923709.stable.out
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting.SF-923709.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/string2float_coercions.SF-928850.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/timestamp_parsing.SF-927300.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/type_dump_test.SF-989257.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/type_error_in_self-insert.SF-921985.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/update_column_to_null.SF-922406.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/var_char_cast_truncate.SF-1150907.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/variable_arg_substring.SF_942981.test
sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.test
Removed Files:
sql/test/BugDay_2005-10-06_2.9.3/Tests/last_line_without_newline.SF-922390_s00.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/last_line_without_newline.SF-922390_s01.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/last_line_without_newline.SF-922390_s02.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.stable.err
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.stable.out
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_2.SF-923709.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_2.SF-923709.stable.err
sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_2.SF-923709.stable.out
Modified Files:
sql/test/BugDay_2005-10-06_2.9.3/Tests/All
Branch: mtest
Log Message:
Converted BugDay_2005-10-06_2.9.3 directory
diffs (truncated from 3954 to 300 lines):
diff --git a/sql/test/BugDay_2005-10-06_2.9.3/Tests/All
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/All
--- a/sql/test/BugDay_2005-10-06_2.9.3/Tests/All
+++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/All
@@ -52,5 +52,4 @@ var_char_cast_truncate.SF-1150907
foreign_key_null.SF-1164646
select_not_true.SF-1314945
create_view_with_check_options.SF-1314951
-slow_counting_1.SF-923709
-slow_counting_2.SF-923709
+slow_counting.SF-923709
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.test
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.test
@@ -0,0 +1,25 @@
+query TTTTIT rowsort
+SELECT
+ null AS "TABLE_CAT",
+ "schemas"."name" AS "TABLE_SCHEM",
+ "tables"."name" AS "TABLE_NAME",
+ "objects"."name" AS "COLUMN_NAME",
+ "keys"."type" AS "KEY_SEQ",
+ "keys"."name" AS "PK_NAME"
+FROM "keys", "objects", "tables", "schemas"
+WHERE
+ "keys"."id" = "objects"."id"
+AND
+ "keys"."table_id" = "tables"."id"
+AND
+ "tables"."schema_id" = "schemas"."id"
+AND
+ "keys"."type" = 0
+AND
+ "schemas"."name" LIKE 'sys'
+AND
+ "tables"."name" LIKE 'voyages'
+ORDER BY "COLUMN_NAME"
+----
+
+
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.test
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.test
@@ -0,0 +1,6 @@
+query T rowsort
+select 2 in (3,2,5,9,5,1)
+----
+True
+
+
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.test
@@ -0,0 +1,31 @@
+query TTTTTIIIITTTIIIITTT rowsort
+SELECT null AS TABLE_CAT,
+ schemas.name AS TABLE_SCHEM,
+ tables.name AS TABLE_NAME,
+ columns.name AS COLUMN_NAME,
+ columns.type AS TYPE_NAME,
+ columns.type_digits AS COLUMN_SIZE,
+ columns.type_scale AS DECIMAL_DIGITS,
+ 0 AS BUFFER_LENGTH,
+ 10 AS NUM_PREC_RADIX,
+ null AS nullable,
+ null AS REMARKS,
+ columns."default" AS COLUMN_DEF,
+ 0 AS SQL_DATA_TYPE,
+ 0 AS SQL_DATETIME_SUB,
+ 0 AS CHAR_OCTET_LENGTH,
+ columns.number + 1 AS ORDINAL_POSITION,
+ null AS SCOPE_CATALOG,
+ null AS SCOPE_SCHEMA,
+ null AS SCOPE_TABLE
+FROM schemas, tables, columns
+WHERE columns.table_id = tables.id
+ AND tables.schema_id = schemas.id
+ AND tables.system = true
+ AND tables.name IN ('args', 'columns', 'functions', 'idx',
+ 'objects', 'keys', 'modules', 'sequences')
+ORDER BY TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION
+----
+1083 values hashing to 819cace9654bce8e750b5e69795d0f62
+
+
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.test
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.test
@@ -0,0 +1,196 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE SCHEMA "t920585"
+
+statement ok
+SET SCHEMA "t920585"
+
+statement ok
+CREATE TABLE "t920585"."_tables" (
+ "id" int ,
+ "name" varchar (1024),
+ "schema_id" int ,
+ "query" varchar (2048),
+ "istable" boolean ,
+ "system" boolean ,
+ "commit_action" smallint
+)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4458, 'modules', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4462, 'schemas', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4466, 'types', 4457, NULL, true, true,
0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4475, 'functions', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4482, 'args', 4457, NULL, true, true,
0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4490, '_tables', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4498, '_columns', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4508, 'keys', 4457, NULL, true, true,
0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4514, 'idxs', 4457, NULL, true, true,
0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4519, 'triggers', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4530, 'keycolumns', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4536, '_tables', 4535, NULL, true,
true, 2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4544, '_columns', 4535, NULL, true,
true, 2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4554, 'keys', 4535, NULL, true, true,
2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4560, 'idxs', 4535, NULL, true, true,
2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4565, 'triggers', 4535, NULL, true,
true, 2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4576, 'keycolumns', 4535, NULL, true,
true, 2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4581, 'tables', 4457, 'SELECT * FROM
(SELECT p.*, 0 AS "temporary" FROM "sys"."_tables" AS p UNION ALL SELECT t.*, 1
AS "temporary" FROM "tmp"."_tables" AS t) AS tables;', false, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4590, 'columns', 4457, 'SELECT * FROM
(SELECT p.* FROM "sys"."_columns" AS p UNION ALL SELECT t.* FROM
"tmp"."_columns" AS t) AS columns;', false, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4600, 'sequences', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4611, 'env', 4457, NULL, true, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4614, 'db_user_info', 4457, NULL,
true, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4618, 'db_users', 4457, ';CREATE VIEW
"db_users" ([system BAT]) AS BATS', false, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4621, 'db_scens', 4457, ';CREATE VIEW
"db_scens" ([system BAT]) AS BATS', false, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4624, 'users', 4457, 'SELECT u."t" AS
"name", ui."fullname", ui."default_schema" FROM "sys"."db_users" AS u,
"sys"."db_user_info" AS ui WHERE u."h" = ui."id" AND u."h" NOT IN (SELECT s."h"
FROM "sys"."db_scens" AS s WHERE s."t" NOT LIKE ''sql'');', false, true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4628, 'user_role', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4631, 'auths', 4457, NULL, true, true,
0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4635, 'privileges', 4457, NULL, true,
true, 0)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4641, 'profile', 4535, NULL, true,
true, 2)
+
+statement ok
+INSERT INTO "t920585"."_tables" VALUES (4649, 'sessions', 4535, NULL, true,
true, 2)
+
+statement ok
+CREATE TABLE "ttables" AS SELECT * FROM "t920585"."_tables" WITH NO DATA
+
+statement ok
+CREATE TABLE "t920585"."schemas" (
+ "id" int ,
+ "name" varchar(1024),
+ "authorization" int
+)
+
+statement ok
+INSERT INTO "t920585"."schemas" VALUES (4457, 'sys', 2)
+
+statement ok
+INSERT INTO "t920585"."schemas" VALUES (4535, 'tmp', 2)
+
+statement ok
+CREATE VIEW "t920585"."tables" AS SELECT * FROM (SELECT p.*, 0 AS "temporary"
FROM "t920585"."_tables" AS p UNION ALL SELECT t.*, 1 AS "temporary" FROM
"t920585"."ttables" AS t) AS tables
+
+query TTTTII rowsort
+select name, query, istable, system, commit_action, "temporary"
+ from (
+ select *
+ from tables
+ where tables.system = 1
+ union
+ select *
+ from tables
+ where tables.system = 1
+ ) as a
+ order by name, commit_action
+----
+180 values hashing to 03744d024ad9081bdf87a6143097fe02
+
+query TTTTTTTTTT rowsort
+select * from (
+SELECT 'null' AS TABLE_CAT,
+ schemas.name AS TABLE_SCHEM,
+ tables.name AS TABLE_NAME,
+ 'SYSTEM TABLE' AS TABLE_TYPE,
+ '' AS REMARKS,
+ 'null' AS TYPE_CAT,
+ 'null' AS TYPE_SCHEM,
+ 'null' AS TYPE_NAME,
+ 'id' AS SELF_REFERENCING_COL_NAME,
+ 'SYSTEM' AS REF_GENERATION
+FROM tables, schemas
+WHERE tables.schema_id = schemas.id
+ AND tables.system = 1
+ AND tables.istable = 0
+UNION ALL
+SELECT 'null' AS TABLE_CAT,
+ schemas.name AS TABLE_SCHEM,
+ tables.name AS TABLE_NAME,
+ 'TABLE' AS TABLE_TYPE,
+ '' AS REMARKS,
+ 'null' AS TYPE_CAT,
+ 'null' AS TYPE_SCHEM,
+ 'null' AS TYPE_NAME,
+ 'id' AS SELF_REFERENCING_COL_NAME,
+ 'SYSTEM' AS REF_GENERATION
+FROM tables, schemas
+WHERE tables.schema_id = schemas.id
+ AND tables.system = 0
+ AND tables.istable = 0
+ AND tables.name = 'test'
+UNION ALL
+SELECT 'null' AS TABLE_CAT,
+ schemas.name AS TABLE_SCHEM,
+ tables.name AS TABLE_NAME,
+ 'VIEW' AS TABLE_TYPE,
+ tables.query AS REMARKS,
+ 'null' AS TYPE_CAT,
+ 'null' AS TYPE_SCHEM,
+ 'null' AS TYPE_NAME,
+ 'id' AS SELF_REFERENCING_COL_NAME,
+ 'SYSTEM' AS REF_GENERATION
+FROM tables, schemas
+WHERE tables.schema_id = schemas.id
+ AND tables.istable = 0
+ AND (tables.name = '_tables' or tables.name = '_columns' or tables.name
= 'users')
+) as tables order by TABLE_NAME, TABLE_TYPE
+----
+60 values hashing to 9253025445c88dd08740238d62f8580c
+
+
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/accents_in_strings.SF-926709.test
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/accents_in_strings.SF-926709.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/accents_in_strings.SF-926709.test
@@ -0,0 +1,21 @@
+statement ok
+CREATE TABLE bugtest (
+id INTEGER NOT NULL,
+name VARCHAR(255)
+)
+
+statement ok
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
