Changeset: 70df7525033b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/70df7525033b
Modified Files:
sql/test/Tests/comment-dump.test
Branch: Sep2022
Log Message:
merge
diffs (87 lines):
diff --git a/sql/test/Tests/comment-dump.test b/sql/test/Tests/comment-dump.test
--- a/sql/test/Tests/comment-dump.test
+++ b/sql/test/Tests/comment-dump.test
@@ -20,10 +20,13 @@ statement ok
COMMENT ON COLUMN foo.tab.i IS 'ii'
statement ok
-CREATE VIEW vivi AS SELECT * FROM tab
+CREATE VIEW sel AS SELECT * FROM foo."tab";
statement ok
-COMMENT ON VIEW vivi IS 'phew'
+COMMENT ON VIEW sel IS 'phew'
+
+statement ok
+CREATE VIEW "SEL" AS SELECT * FROM sel;
statement ok
CREATE INDEX idx ON tab(j,i)
@@ -38,31 +41,31 @@ statement ok
COMMENT ON SEQUENCE counter IS 'counting'
statement ok
-CREATE FUNCTION f() RETURNS INT BEGIN RETURN 42; END
+CREATE FUNCTION f() RETURNS INT BEGIN RETURN 42; END;
statement ok
COMMENT ON FUNCTION f() IS '0 parms'
statement ok
-CREATE FUNCTION f(i INT) RETURNS INT BEGIN RETURN 43; END
+CREATE FUNCTION f(i INT) RETURNS INT BEGIN RETURN 43; END;
statement ok
COMMENT ON FUNCTION f(INT) IS '1 parm'
statement ok
-CREATE FUNCTION f(i INT, j INT) RETURNS INT BEGIN RETURN 44; END
+CREATE FUNCTION f(i INT, j INT) RETURNS INT BEGIN RETURN 44; END;
statement ok
COMMENT ON FUNCTION f(INTEGER, INTEGER) IS '2 parms'
statement ok
-CREATE FUNCTION f(i INT, j INT, k INT) RETURNS INT BEGIN RETURN 45; END
+CREATE FUNCTION f(i INT, j INT, k INT) RETURNS INT BEGIN RETURN 45; END;
statement ok
-CREATE FUNCTION f(i INT, j INT, k INT, l INT) RETURNS INT BEGIN RETURN 45; END
+CREATE FUNCTION f(i INT, j INT, k INT, l INT) RETURNS INT BEGIN RETURN 45; END;
statement ok
-CREATE PROCEDURE g() BEGIN DELETE FROM tab WHERE FALSE; END
+CREATE PROCEDURE g() BEGIN DELETE FROM tab WHERE FALSE; END;
statement ok
COMMENT ON PROCEDURE g() IS 'proc'
@@ -75,13 +78,14 @@ SET SCHEMA "sys";
CREATE SCHEMA "foo" AUTHORIZATION "monetdb";
CREATE SEQUENCE "foo"."counter" AS BIGINT;
CREATE TABLE "foo"."tab" ("i" INTEGER, "j" DECIMAL(4,2));
-create view "foo"."vivi" as select * from tab@;
-create "foo"."f" unction "foo"."f" () returns int begin return 42; end@;
-create "foo"."f" unction "foo"."f" (i int) returns int begin return 43; end@;
-create "foo"."f" unction "foo"."f" (i int, j int) returns int begin return 44;
end@;
-create "foo"."f" unction "foo"."f" (i int, j int, k int) returns int begin
return 45; end@;
-create "foo"."f" unction "foo"."f" (i int, j int, k int, l int) returns int
begin return 45; end@;
-create procedure "foo"."g" () be "foo"."g" in delete from tab where false;
end@;
+create view "foo"."sel" as select * from foo."tab";
+create view "foo"."SEL" as select * from sel;
+create function "foo"."f" () returns int begin return 42; end;
+create function "foo"."f" (i int) returns int begin return 43; end;
+create function "foo"."f" (i int, j int) returns int begin return 44; end;
+create function "foo"."f" (i int, j int, k int) returns int begin return 45;
end;
+create function "foo"."f" (i int, j int, k int, l int) returns int begin
return 45; end;
+create procedure "foo"."g" () begin delete from tab where false; end;
ALTER SEQUENCE "foo"."counter" RESTART WITH 1 NO CYCLE;
CREATE INDEX "idx" ON "foo"."tab"(j,i);
COMMENT ON COLUMN "foo"."tab"."i" IS 'ii';
@@ -94,6 +98,6 @@ COMMENT ON PROCEDURE "foo"."g"() IS 'pro
COMMENT ON SCHEMA "foo" IS 'foo foo';
COMMENT ON SEQUENCE "foo"."counter" IS 'counting';
COMMENT ON TABLE "foo"."tab" IS 'table';
-COMMENT ON VIEW "foo"."vivi" IS 'phew';
+COMMENT ON VIEW "foo"."sel" IS 'phew';
COMMIT;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
