Changeset: 7f1736750cd6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7f1736750cd6
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/76_dump.sql
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
When dumping CREATE USER, also specify SCHEMA PATH.
diffs (truncated from 1100 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -3859,9 +3859,9 @@ sql_update_default(Client c, mvc *sql, c
" AND grantor <> 0;\n"
"CREATE VIEW sys.dump_create_users AS\n"
" SELECT\n"
- " 'CREATE USER ' || sys.dq(ui.name)
|| ' WITH ENCRYPTED PASSWORD ' ||\n"
+ " 'CREATE USER ' || sys.dq(ui.name)
|| ' WITH ENCRYPTED PASSWORD ' ||\n"
"
sys.sq(sys.password_hash(ui.name)) ||\n"
- " ' NAME ' || sys.sq(ui.fullname)
|| ' SCHEMA sys;' stmt,\n"
+ " ' NAME ' || sys.sq(ui.fullname)
|| ' SCHEMA sys' || ifthenelse(ui.schema_path = '\"sys\"', '', ' SCHEMA PATH '
|| sys.sq(ui.schema_path)) || ';' stmt,\n"
" ui.name user_name\n"
" FROM sys.db_user_info ui,
sys.schemas s\n"
" WHERE ui.default_schema = s.id\n"
@@ -3869,7 +3869,7 @@ sql_update_default(Client c, mvc *sql, c
" AND ui.name <> '.snapshot';\n"
"CREATE VIEW sys.dump_create_schemas
AS\n"
" SELECT\n"
- " 'CREATE SCHEMA ' ||
sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', ' AUTHORIZATION ' ||
sys.dq(a.name), ' ') || ';' stmt,\n"
+ " 'CREATE SCHEMA ' || sys.dq(s.name)
|| ifthenelse(a.name <> 'sysadmin', ' AUTHORIZATION ' || sys.dq(a.name), ' ')
|| ';' stmt,\n"
" s.name schema_name\n"
" FROM sys.schemas s, sys.auths a\n"
" WHERE s.authorization = a.id AND
s.system = FALSE;\n"
@@ -4029,7 +4029,7 @@ sql_update_default(Client c, mvc *sql, c
" FROM sys.describe_sequences;\n"
"CREATE VIEW sys.dump_start_sequences
AS\n"
" SELECT\n"
- " 'UPDATE sys.sequences seq SET
start = ' || s ||\n"
+ " 'UPDATE sys.sequences seq SET
start = ' || s ||\n"
" ' WHERE name = ' || sys.SQ(seq)
||\n"
" ' AND schema_id = (SELECT s.id
FROM sys.schemas s WHERE s.name = ' || sys.SQ(sch) || ');' stmt,\n"
" sch schema_name,\n"
@@ -4089,7 +4089,7 @@ sql_update_default(Client c, mvc *sql, c
" DECLARE _cnt INT;\n"
" SET _cnt = (SELECT count FROM
sys.storage(sch, tbl, cname));\n"
" IF _cnt > 0 THEN\n"
- " SET COPY_INTO_STMT = 'COPY ' ||
_cnt || ' RECORDS INTO ' || sys.FQN(sch, tbl) || '(' || sys.DQ(cname);\n"
+ " SET COPY_INTO_STMT = 'COPY ' ||
_cnt || ' RECORDS INTO ' || sys.FQN(sch, tbl) || '(' || sys.DQ(cname);\n"
" DECLARE SELECT_DATA_STMT
STRING;\n"
" SET SELECT_DATA_STMT = 'SELECT
(SELECT COUNT(*) FROM sys.dump_statements) + RANK() OVER(), ' ||
sys.prepare_esc(cname, ctype);\n"
" DECLARE M INT;\n"
@@ -4102,7 +4102,7 @@ sql_update_default(Client c, mvc *sql, c
" SET SELECT_DATA_STMT =
SELECT_DATA_STMT || '|| ''|'' || ' || sys.prepare_esc(cname, ctype);\n"
" END WHILE;\n"
" SET COPY_INTO_STMT =
(COPY_INTO_STMT || ') FROM STDIN USING DELIMITERS ''|'',E''\\\\n'',''\"'';');\n"
- " SET SELECT_DATA_STMT =
SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch, tbl);\n"
+ " SET SELECT_DATA_STMT =
SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch, tbl);\n"
" insert into sys.dump_statements
VALUES ((SELECT COUNT(*) FROM sys.dump_statements) + 1, COPY_INTO_STMT);\n"
" CALL sys.EVAL('INSERT INTO
sys.dump_statements ' || SELECT_DATA_STMT || ';');\n"
" END IF;\n"
diff --git a/sql/scripts/76_dump.sql b/sql/scripts/76_dump.sql
--- a/sql/scripts/76_dump.sql
+++ b/sql/scripts/76_dump.sql
@@ -14,9 +14,9 @@ CREATE VIEW sys.dump_create_roles AS
CREATE VIEW sys.dump_create_users AS
SELECT
- 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
+ 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
sys.sq(sys.password_hash(ui.name)) ||
- ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys;' stmt,
+ ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys' ||
ifthenelse(ui.schema_path = '"sys"', '', ' SCHEMA PATH ' ||
sys.sq(ui.schema_path)) || ';' stmt,
ui.name user_name
FROM sys.db_user_info ui, sys.schemas s
WHERE ui.default_schema = s.id
@@ -25,7 +25,7 @@ CREATE VIEW sys.dump_create_users AS
CREATE VIEW sys.dump_create_schemas AS
SELECT
- 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
+ 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
s.name schema_name
FROM sys.schemas s, sys.auths a
WHERE s.authorization = a.id AND s.system = FALSE;
@@ -197,7 +197,7 @@ CREATE VIEW sys.dump_sequences AS
CREATE VIEW sys.dump_start_sequences AS
SELECT
- 'UPDATE sys.sequences seq SET start = ' || s ||
+ 'UPDATE sys.sequences seq SET start = ' || s ||
' WHERE name = ' || sys.SQ(seq) ||
' AND schema_id = (SELECT s.id FROM sys.schemas s WHERE s.name = ' ||
sys.SQ(sch) || ');' stmt,
sch schema_name,
@@ -278,7 +278,7 @@ BEGIN
SET _cnt = (SELECT count FROM sys.storage(sch, tbl, cname));
IF _cnt > 0 THEN
- SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' ||
sys.FQN(sch, tbl) || '(' || sys.DQ(cname);
+ SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' || sys.FQN(sch,
tbl) || '(' || sys.DQ(cname);
DECLARE SELECT_DATA_STMT STRING;
SET SELECT_DATA_STMT = 'SELECT (SELECT COUNT(*) FROM
sys.dump_statements) + RANK() OVER(), ' || sys.prepare_esc(cname, ctype);
@@ -295,7 +295,7 @@ BEGIN
END WHILE;
SET COPY_INTO_STMT = (COPY_INTO_STMT || ') FROM STDIN USING DELIMITERS
''|'',E''\\n'',''"'';');
- SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch,
tbl);
+ SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch, tbl);
insert into sys.dump_statements VALUES ((SELECT COUNT(*) FROM
sys.dump_statements) + 1, COPY_INTO_STMT);
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -288,9 +288,9 @@ CREATE VIEW sys.dump_create_roles AS
AND grantor <> 0;
CREATE VIEW sys.dump_create_users AS
SELECT
- 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
+ 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
sys.sq(sys.password_hash(ui.name)) ||
- ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys;' stmt,
+ ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys' ||
ifthenelse(ui.schema_path = '"sys"', '', ' SCHEMA PATH ' ||
sys.sq(ui.schema_path)) || ';' stmt,
ui.name user_name
FROM sys.db_user_info ui, sys.schemas s
WHERE ui.default_schema = s.id
@@ -298,7 +298,7 @@ CREATE VIEW sys.dump_create_users AS
AND ui.name <> '.snapshot';
CREATE VIEW sys.dump_create_schemas AS
SELECT
- 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
+ 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
s.name schema_name
FROM sys.schemas s, sys.auths a
WHERE s.authorization = a.id AND s.system = FALSE;
@@ -458,7 +458,7 @@ CREATE VIEW sys.dump_sequences AS
FROM sys.describe_sequences;
CREATE VIEW sys.dump_start_sequences AS
SELECT
- 'UPDATE sys.sequences seq SET start = ' || s ||
+ 'UPDATE sys.sequences seq SET start = ' || s ||
' WHERE name = ' || sys.SQ(seq) ||
' AND schema_id = (SELECT s.id FROM sys.schemas s WHERE s.name = ' ||
sys.SQ(sch) || ');' stmt,
sch schema_name,
@@ -518,7 +518,7 @@ BEGIN
DECLARE _cnt INT;
SET _cnt = (SELECT count FROM sys.storage(sch, tbl, cname));
IF _cnt > 0 THEN
- SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' ||
sys.FQN(sch, tbl) || '(' || sys.DQ(cname);
+ SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' || sys.FQN(sch,
tbl) || '(' || sys.DQ(cname);
DECLARE SELECT_DATA_STMT STRING;
SET SELECT_DATA_STMT = 'SELECT (SELECT COUNT(*) FROM
sys.dump_statements) + RANK() OVER(), ' || sys.prepare_esc(cname, ctype);
DECLARE M INT;
@@ -531,7 +531,7 @@ BEGIN
SET SELECT_DATA_STMT = SELECT_DATA_STMT || '|| ''|'' || ' ||
sys.prepare_esc(cname, ctype);
END WHILE;
SET COPY_INTO_STMT = (COPY_INTO_STMT || ') FROM STDIN USING DELIMITERS
''|'',E''\\n'',''"'';');
- SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch,
tbl);
+ SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch, tbl);
insert into sys.dump_statements VALUES ((SELECT COUNT(*) FROM
sys.dump_statements) + 1, COPY_INTO_STMT);
CALL sys.EVAL('INSERT INTO sys.dump_statements ' || SELECT_DATA_STMT ||
';');
END IF;
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -288,9 +288,9 @@ CREATE VIEW sys.dump_create_roles AS
AND grantor <> 0;
CREATE VIEW sys.dump_create_users AS
SELECT
- 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
+ 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
sys.sq(sys.password_hash(ui.name)) ||
- ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys;' stmt,
+ ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys' ||
ifthenelse(ui.schema_path = '"sys"', '', ' SCHEMA PATH ' ||
sys.sq(ui.schema_path)) || ';' stmt,
ui.name user_name
FROM sys.db_user_info ui, sys.schemas s
WHERE ui.default_schema = s.id
@@ -298,7 +298,7 @@ CREATE VIEW sys.dump_create_users AS
AND ui.name <> '.snapshot';
CREATE VIEW sys.dump_create_schemas AS
SELECT
- 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
+ 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
s.name schema_name
FROM sys.schemas s, sys.auths a
WHERE s.authorization = a.id AND s.system = FALSE;
@@ -458,7 +458,7 @@ CREATE VIEW sys.dump_sequences AS
FROM sys.describe_sequences;
CREATE VIEW sys.dump_start_sequences AS
SELECT
- 'UPDATE sys.sequences seq SET start = ' || s ||
+ 'UPDATE sys.sequences seq SET start = ' || s ||
' WHERE name = ' || sys.SQ(seq) ||
' AND schema_id = (SELECT s.id FROM sys.schemas s WHERE s.name = ' ||
sys.SQ(sch) || ');' stmt,
sch schema_name,
@@ -518,7 +518,7 @@ BEGIN
DECLARE _cnt INT;
SET _cnt = (SELECT count FROM sys.storage(sch, tbl, cname));
IF _cnt > 0 THEN
- SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' ||
sys.FQN(sch, tbl) || '(' || sys.DQ(cname);
+ SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' || sys.FQN(sch,
tbl) || '(' || sys.DQ(cname);
DECLARE SELECT_DATA_STMT STRING;
SET SELECT_DATA_STMT = 'SELECT (SELECT COUNT(*) FROM
sys.dump_statements) + RANK() OVER(), ' || sys.prepare_esc(cname, ctype);
DECLARE M INT;
@@ -531,7 +531,7 @@ BEGIN
SET SELECT_DATA_STMT = SELECT_DATA_STMT || '|| ''|'' || ' ||
sys.prepare_esc(cname, ctype);
END WHILE;
SET COPY_INTO_STMT = (COPY_INTO_STMT || ') FROM STDIN USING DELIMITERS
''|'',E''\\n'',''"'';');
- SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch,
tbl);
+ SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch, tbl);
insert into sys.dump_statements VALUES ((SELECT COUNT(*) FROM
sys.dump_statements) + 1, COPY_INTO_STMT);
CALL sys.EVAL('INSERT INTO sys.dump_statements ' || SELECT_DATA_STMT ||
';');
END IF;
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -288,9 +288,9 @@ CREATE VIEW sys.dump_create_roles AS
AND grantor <> 0;
CREATE VIEW sys.dump_create_users AS
SELECT
- 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
+ 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
sys.sq(sys.password_hash(ui.name)) ||
- ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys;' stmt,
+ ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys' ||
ifthenelse(ui.schema_path = '"sys"', '', ' SCHEMA PATH ' ||
sys.sq(ui.schema_path)) || ';' stmt,
ui.name user_name
FROM sys.db_user_info ui, sys.schemas s
WHERE ui.default_schema = s.id
@@ -298,7 +298,7 @@ CREATE VIEW sys.dump_create_users AS
AND ui.name <> '.snapshot';
CREATE VIEW sys.dump_create_schemas AS
SELECT
- 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
+ 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
s.name schema_name
FROM sys.schemas s, sys.auths a
WHERE s.authorization = a.id AND s.system = FALSE;
@@ -458,7 +458,7 @@ CREATE VIEW sys.dump_sequences AS
FROM sys.describe_sequences;
CREATE VIEW sys.dump_start_sequences AS
SELECT
- 'UPDATE sys.sequences seq SET start = ' || s ||
+ 'UPDATE sys.sequences seq SET start = ' || s ||
' WHERE name = ' || sys.SQ(seq) ||
' AND schema_id = (SELECT s.id FROM sys.schemas s WHERE s.name = ' ||
sys.SQ(sch) || ');' stmt,
sch schema_name,
@@ -518,7 +518,7 @@ BEGIN
DECLARE _cnt INT;
SET _cnt = (SELECT count FROM sys.storage(sch, tbl, cname));
IF _cnt > 0 THEN
- SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' ||
sys.FQN(sch, tbl) || '(' || sys.DQ(cname);
+ SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' || sys.FQN(sch,
tbl) || '(' || sys.DQ(cname);
DECLARE SELECT_DATA_STMT STRING;
SET SELECT_DATA_STMT = 'SELECT (SELECT COUNT(*) FROM
sys.dump_statements) + RANK() OVER(), ' || sys.prepare_esc(cname, ctype);
DECLARE M INT;
@@ -531,7 +531,7 @@ BEGIN
SET SELECT_DATA_STMT = SELECT_DATA_STMT || '|| ''|'' || ' ||
sys.prepare_esc(cname, ctype);
END WHILE;
SET COPY_INTO_STMT = (COPY_INTO_STMT || ') FROM STDIN USING DELIMITERS
''|'',E''\\n'',''"'';');
- SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch,
tbl);
+ SET SELECT_DATA_STMT = SELECT_DATA_STMT || ' FROM ' || sys.FQN(sch, tbl);
insert into sys.dump_statements VALUES ((SELECT COUNT(*) FROM
sys.dump_statements) + 1, COPY_INTO_STMT);
CALL sys.EVAL('INSERT INTO sys.dump_statements ' || SELECT_DATA_STMT ||
';');
END IF;
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -288,9 +288,9 @@ CREATE VIEW sys.dump_create_roles AS
AND grantor <> 0;
CREATE VIEW sys.dump_create_users AS
SELECT
- 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
+ 'CREATE USER ' || sys.dq(ui.name) || ' WITH ENCRYPTED PASSWORD ' ||
sys.sq(sys.password_hash(ui.name)) ||
- ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys;' stmt,
+ ' NAME ' || sys.sq(ui.fullname) || ' SCHEMA sys' ||
ifthenelse(ui.schema_path = '"sys"', '', ' SCHEMA PATH ' ||
sys.sq(ui.schema_path)) || ';' stmt,
ui.name user_name
FROM sys.db_user_info ui, sys.schemas s
WHERE ui.default_schema = s.id
@@ -298,7 +298,7 @@ CREATE VIEW sys.dump_create_users AS
AND ui.name <> '.snapshot';
CREATE VIEW sys.dump_create_schemas AS
SELECT
- 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
+ 'CREATE SCHEMA ' || sys.dq(s.name) || ifthenelse(a.name <> 'sysadmin', '
AUTHORIZATION ' || sys.dq(a.name), ' ') || ';' stmt,
s.name schema_name
FROM sys.schemas s, sys.auths a
WHERE s.authorization = a.id AND s.system = FALSE;
@@ -458,7 +458,7 @@ CREATE VIEW sys.dump_sequences AS
FROM sys.describe_sequences;
CREATE VIEW sys.dump_start_sequences AS
SELECT
- 'UPDATE sys.sequences seq SET start = ' || s ||
+ 'UPDATE sys.sequences seq SET start = ' || s ||
' WHERE name = ' || sys.SQ(seq) ||
' AND schema_id = (SELECT s.id FROM sys.schemas s WHERE s.name = ' ||
sys.SQ(sch) || ');' stmt,
sch schema_name,
@@ -518,7 +518,7 @@ BEGIN
DECLARE _cnt INT;
SET _cnt = (SELECT count FROM sys.storage(sch, tbl, cname));
IF _cnt > 0 THEN
- SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' ||
sys.FQN(sch, tbl) || '(' || sys.DQ(cname);
+ SET COPY_INTO_STMT = 'COPY ' || _cnt || ' RECORDS INTO ' || sys.FQN(sch,
tbl) || '(' || sys.DQ(cname);
DECLARE SELECT_DATA_STMT STRING;
SET SELECT_DATA_STMT = 'SELECT (SELECT COUNT(*) FROM
sys.dump_statements) + RANK() OVER(), ' || sys.prepare_esc(cname, ctype);
DECLARE M INT;
@@ -531,7 +531,7 @@ BEGIN
SET SELECT_DATA_STMT = SELECT_DATA_STMT || '|| ''|'' || ' ||
sys.prepare_esc(cname, ctype);
END WHILE;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
