Changeset: 1bf8d87d9f79 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1bf8d87d9f79
Modified Files:
sql/test/Dependencies/Tests/dependency_functions.test
sql/test/sql_dump/Tests/dump.test
Branch: Sep2022
Log Message:
Approve some more tests.
diffs (100 lines):
diff --git a/sql/test/Dependencies/Tests/dependency_functions.test
b/sql/test/Dependencies/Tests/dependency_functions.test
--- a/sql/test/Dependencies/Tests/dependency_functions.test
+++ b/sql/test/Dependencies/Tests/dependency_functions.test
@@ -52,6 +52,9 @@ DEP_FUNC
dq
prepare_esc
DEP_FUNC
+dq
+schema_guard
+DEP_FUNC
dump_table_data
dump_database
DEP_FUNC
@@ -64,9 +67,6 @@ DEP_FUNC
f1
f3
DEP_FUNC
-fqn
-schema_guard
-DEP_FUNC
getproj4
st_transform
DEP_FUNC
@@ -79,9 +79,6 @@ DEP_FUNC
remote_table_credentials
get_remote_table_expressions
DEP_FUNC
-replace_first
-schema_guard
-DEP_FUNC
sq
get_remote_table_expressions
DEP_FUNC
@@ -116,12 +113,12 @@ DEP_FUNC
dq
prepare_esc
DEP_FUNC
+dq
+schema_guard
+DEP_FUNC
dump_table_data
dump_database
DEP_FUNC
-fqn
-schema_guard
-DEP_FUNC
getproj4
st_transform
DEP_FUNC
@@ -134,9 +131,6 @@ DEP_FUNC
remote_table_credentials
get_remote_table_expressions
DEP_FUNC
-replace_first
-schema_guard
-DEP_FUNC
sq
get_remote_table_expressions
DEP_FUNC
diff --git a/sql/test/sql_dump/Tests/dump.test
b/sql/test/sql_dump/Tests/dump.test
--- a/sql/test/sql_dump/Tests/dump.test
+++ b/sql/test/sql_dump/Tests/dump.test
@@ -315,9 +315,9 @@ CREATE TABLE "sfoo"."tfoo2" ("i" INTEGER
CREATE TABLE "sfoo"."test" ("s" CHARACTER LARGE OBJECT);
CREATE TABLE "sys"."pfoo1" ("i" INTEGER);
CREATE TABLE "sys"."pfoo2" ("i" INTEGER);
-create function "sfoo"."func1" (x int, y int) returns int begin return x + y;
end@;
-create view "sfoo"."baz" (i) as select func1(t.x, t.y) from (values (10, 1),
(20, 2)) as t(x,y)@;
-create function "sfoo"."func2" () returns table(i integer) begin return select
* from "sfoo"."baz"; end@;
+SET SCHEMA "sfoo"; create function "sfoo"."func1" (x int, y int) returns int
begin return x + y; end@;
+SET SCHEMA "sfoo"; create view "sfoo"."baz" (i) as select func1(t.x, t.y) from
(values (10, 1), (20, 2)) as t(x,y)@;
+SET SCHEMA "sfoo"; create function "sfoo"."func2" () returns table(i integer)
begin return select * from "sfoo"."baz"; end@;
CREATE TABLE "sys"."lower_scorers" ("name" CHARACTER LARGE OBJECT,
"first_score" INTEGER, "second_score" INTEGER);
CREATE TABLE "sys"."higher_scorers" ("name" CHARACTER LARGE OBJECT,
"first_score" INTEGER, "second_score" INTEGER);
CREATE TABLE "sys"."unknown_scorers" ("name" CHARACTER LARGE OBJECT,
"first_score" INTEGER, "second_score" INTEGER);
@@ -332,11 +332,11 @@ CREATE TABLE "sys"."first_decade" ("stam
CREATE TABLE "sys"."second_decade" ("stamp" TIMESTAMP, "val" INTEGER);
CREATE TABLE "sys"."third_decade" ("stamp" TIMESTAMP, "val" INTEGER);
CREATE TABLE "sys"."p1" ("i" INTEGER);
-create or replace window "sys"."stddev" (val bigint) returns double external
name "sql"."stdevp"@;
+SET SCHEMA "sys"; create or replace window "sys"."stddev" (val bigint) returns
double external name "sql"."stdevp"@;
CREATE TABLE "sys"."foo" ("i" INTEGER, "j" INTEGER);
-create function "sys"."f1" () returns int begin return 10; end@;
-create procedure "sys"."f1" (i int) begin declare x int; end@;
-create procedure "sys"."f1" () begin declare x int; end@;
+SET SCHEMA "sys"; create function "sys"."f1" () returns int begin return 10;
end@;
+SET SCHEMA "sys"; create procedure "sys"."f1" (i int) begin declare x int;
end@;
+SET SCHEMA "sys"; create procedure "sys"."f1" () begin declare x int; end@;
CREATE TABLE "sys"."tbl_with_data" ("c1" INTEGER, "c2" BIGINT, "c3" BINARY
LARGE OBJECT, "c4" BOOLEAN, "c5" CHARACTER LARGE OBJECT, "c6" DATE, "c7"
INTERVAL DAY, "c8" DECIMAL(18,3), "c9" DECIMAL(5), "c10" DECIMAL(5,2), "c11"
DOUBLE, "c12" FLOAT(5), "c13" FLOAT(5,4), "c14" GEOMETRY(POINT), "c18" INTERVAL
YEAR, "c19" INTERVAL YEAR TO MONTH, "c20" INTERVAL MONTH, "c21" REAL, "c22"
INTERVAL DAY, "c23" INTERVAL DAY TO HOUR, "c24" INTERVAL HOUR, "c25" INTERVAL
HOUR TO MINUTE, "c26" TIME, "c27" TIMESTAMP, "c28" TIMESTAMP(2), "c29"
TIMESTAMP WITH TIME ZONE, "c30" JSON, "c31" INET, "c32" URL, "c33" UUID);
COPY 3 RECORDS INTO "sys"."tbl_with_data"("c1", "c2", "c3", "c4", "c5", "c6",
"c7", "c8", "c9", "c10", "c11", "c12", "c13", "c14", "c18", "c19", "c20",
"c21", "c22", "c23", "c24", "c25", "c26", "c27", "c28", "c29", "c30", "c31",
"c32", "c33") FROM STDIN USING DELIMITERS '|',E'\n','"';
1234|5678|90|true|"Hello\n \\|\"
World"|2020-12-20|10.000|1023.345|12345|123.45|1123.455|1122133.5|121233.45|"POINT
(5.1
34.5)"|2000|4000|8000|65333.414|8000.000|4000.000|2000.000|1000.000|14:18:18|2015-05-22
14:18:17.780331|2015-05-22 00:00:00.00|2015-05-22
14:18:17.780331+02:00|"{\"price\":9}"|10.1.0.0/16|"https://[email protected]:458/Doc/Abc.html?lang=nl&sort=asc#example";|65950c76-a2f6-4543-660a-b849cf5f2453
@@ -368,7 +368,7 @@ ALTER TABLE "sys"."scorers" ADD TABLE "s
ALTER TABLE "sys"."splitted" ADD TABLE "sys"."first_decade" AS PARTITION FROM
RANGE MINVALUE TO '2010-01-01 00:00:00.000000' WITH NULL VALUES;
ALTER TABLE "sys"."splitted" ADD TABLE "sys"."second_decade" AS PARTITION FROM
'2010-01-01 00:00:00.000000' TO '2020-01-01 00:00:00.000000';
ALTER TABLE "sys"."m1" ADD TABLE "sys"."p1";
-create trigger extra_insert after insert on "sfoo"."tfoo1" referencing new row
as new_row for each statement insert into tfoo2(i) values (new_row.i)@;
+SET SCHEMA "sfoo"; create trigger extra_insert after insert on "sfoo"."tfoo1"
referencing new row as new_row for each statement insert into tfoo2(i) values
(new_row.i)@;
COMMENT ON SCHEMA "sbar" IS 'This is a comment on a schema';
COMMENT ON COLUMN "sfoo"."tfoo1"."i" IS 'This is a comment on a column.';
COMMENT ON INDEX "sys"."ind3" IS 'This is a comment on an index.';
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
