Changeset: 55183d3b4786 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=55183d3b4786
Modified Files:
sql/test/sql_dump/Tests/dump.test
Branch: default
Log Message:
Approved output
diffs (22 lines):
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
@@ -381,12 +381,12 @@ COMMENT ON INDEX "sys"."ind3" IS 'This
COMMENT ON SEQUENCE "sys"."seq1" IS 'This is a comment on a sequence.' ;
COMMENT ON WINDOW "sys"."stddev" IS 'This is a comment on a window function.'
;
TRUNCATE sys.privileges;
-INSERT INTO sys.privileges VALUES ((SELECT t.id FROM sys.schemas s, tables t
WHERE s.id = t.schema_id AND s.name || '.' || t.name = 'sys.foo' ),(SELECT id
FROM auths a WHERE a.name = 'voc' ),(SELECT pc.privilege_code_id FROM
privilege_codes pc WHERE pc.privilege_code_name = 'SELECT' ),(SELECT id FROM
auths g WHERE g.name = 'monetdb' ),0);
-INSERT INTO sys.privileges VALUES ((SELECT c.id FROM sys.schemas s, tables t,
columns c WHERE s.id = t.schema_id AND t.id = c.table_id AND s.name || '.' ||
t.name || '.' || c.name = 'sys.foo.i' ),(SELECT id FROM auths a WHERE a.name =
'voc' ),(SELECT pc.privilege_code_id FROM privilege_codes pc WHERE
pc.privilege_code_name = 'UPDATE' ),(SELECT id FROM auths g WHERE g.name =
'monetdb' ),0);
-INSERT INTO sys.privileges VALUES ((SELECT fqn.id FROM
fully_qualified_functions fqn WHERE fqn.nme = 'sys.f1(INTEGER)' AND fqn.tpe =
'FUNCTION' ),(SELECT id FROM auths a WHERE a.name = 'voc' ),(SELECT
pc.privilege_code_id FROM privilege_codes pc WHERE pc.privilege_code_name =
'EXECUTE' ),(SELECT id FROM auths g WHERE g.name = 'monetdb' ),0);
-INSERT INTO sys.privileges VALUES ((SELECT fqn.id FROM
fully_qualified_functions fqn WHERE fqn.nme = 'sys.f1(INTEGER)' AND fqn.tpe =
'PROCEDURE' ),(SELECT id FROM auths a WHERE a.name = 'voc' ),(SELECT
pc.privilege_code_id FROM privilege_codes pc WHERE pc.privilege_code_name =
'EXECUTE' ),(SELECT id FROM auths g WHERE g.name = 'monetdb' ),0);
-INSERT INTO sys.privileges VALUES ((SELECT fqn.id FROM
fully_qualified_functions fqn WHERE fqn.nme = 'sys.f1()' AND fqn.tpe =
'PROCEDURE' ),(SELECT id FROM auths a WHERE a.name = 'voc' ),(SELECT
pc.privilege_code_id FROM privilege_codes pc WHERE pc.privilege_code_name =
'EXECUTE' ),(SELECT id FROM auths g WHERE g.name = 'monetdb' ),1);
-INSERT INTO sys.privileges VALUES (0,(SELECT id FROM auths a WHERE a.name =
'voc' ),(SELECT pc.privilege_code_id FROM privilege_codes pc WHERE
pc.privilege_code_name = 'UPDATE' ),(SELECT id FROM auths g WHERE g.name =
'monetdb' ),0);
+INSERT INTO sys.privileges VALUES ((SELECT t.id FROM sys.schemas s, sys.tables
t WHERE s.id = t.schema_id AND s.name || '.' || t.name = 'sys.foo' ),(SELECT id
FROM sys.auths a WHERE a.name = 'voc' ),(SELECT pc.privilege_code_id FROM
sys.privilege_codes pc WHERE pc.privilege_code_name = 'SELECT' ),(SELECT id
FROM sys.auths g WHERE g.name = 'monetdb' ),0);
+INSERT INTO sys.privileges VALUES ((SELECT c.id FROM sys.schemas s, sys.tables
t, sys.columns c WHERE s.id = t.schema_id AND t.id = c.table_id AND s.name ||
'.' || t.name || '.' || c.name = 'sys.foo.i' ),(SELECT id FROM sys.auths a
WHERE a.name = 'voc' ),(SELECT pc.privilege_code_id FROM sys.privilege_codes
pc WHERE pc.privilege_code_name = 'UPDATE' ),(SELECT id FROM sys.auths g WHERE
g.name = 'monetdb' ),0);
+INSERT INTO sys.privileges VALUES ((SELECT fqn.id FROM
sys.fully_qualified_functions fqn WHERE fqn.nme = 'sys.f1(INTEGER)' AND
fqn.tpe = 'FUNCTION' ),(SELECT id FROM sys.auths a WHERE a.name = 'voc'
),(SELECT pc.privilege_code_id FROM sys.privilege_codes pc WHERE
pc.privilege_code_name = 'EXECUTE' ),(SELECT id FROM sys.auths g WHERE g.name
= 'monetdb' ),0);
+INSERT INTO sys.privileges VALUES ((SELECT fqn.id FROM
sys.fully_qualified_functions fqn WHERE fqn.nme = 'sys.f1(INTEGER)' AND
fqn.tpe = 'PROCEDURE' ),(SELECT id FROM sys.auths a WHERE a.name = 'voc'
),(SELECT pc.privilege_code_id FROM sys.privilege_codes pc WHERE
pc.privilege_code_name = 'EXECUTE' ),(SELECT id FROM sys.auths g WHERE g.name
= 'monetdb' ),0);
+INSERT INTO sys.privileges VALUES ((SELECT fqn.id FROM
sys.fully_qualified_functions fqn WHERE fqn.nme = 'sys.f1()' AND fqn.tpe =
'PROCEDURE' ),(SELECT id FROM sys.auths a WHERE a.name = 'voc' ),(SELECT
pc.privilege_code_id FROM sys.privilege_codes pc WHERE pc.privilege_code_name =
'EXECUTE' ),(SELECT id FROM sys.auths g WHERE g.name = 'monetdb' ),1);
+INSERT INTO sys.privileges VALUES (0,(SELECT id FROM sys.auths a WHERE a.name
= 'voc' ),(SELECT pc.privilege_code_id FROM sys.privilege_codes pc WHERE
pc.privilege_code_name = 'UPDATE' ),(SELECT id FROM sys.auths g WHERE g.name =
'monetdb' ),0);
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
12:18:17.780331+00:00|"{\"price\":9}"|10.1.0.0/16|"https://m...@www.monetdb.org:458/Doc/Abc.html?lang=nl&sort=asc#example";|65950c76-a2f6-4543-660a-b849cf5f2453
null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
