Changeset: 9e5aee26325d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9e5aee26325d Modified Files: clients/mapiclient/mclient.c Branch: Mar2018 Log Message:
No need to quote single quotes within double quotes.
diffs (51 lines):
diff --git a/clients/mapiclient/mclient.c b/clients/mapiclient/mclient.c
--- a/clients/mapiclient/mclient.c
+++ b/clients/mapiclient/mclient.c
@@ -2543,12 +2543,12 @@ doFile(Mapi mid, stream *fp, bool useins
"WITH
describe_all_objects AS (\n"
" SELECT s.name AS
sname,\n"
" t.name,\n"
- " s.name || \'.\'
|| t.name AS fullname,\n"
+ " s.name || '.' ||
t.name AS fullname,\n"
" CAST(CASE
t.type\n"
" WHEN 1 THEN 2 --
ntype for views\n"
" ELSE 1\t --
ntype for tables\n"
" END AS SMALLINT)
AS ntype,\n"
- " (CASE WHEN
t.system THEN \'SYSTEM \' ELSE \'\' END) || tt.table_type_name AS type,\n"
+ " (CASE WHEN
t.system THEN 'SYSTEM ' ELSE '' END) || tt.table_type_name AS type,\n"
" t.system,\n"
" c.remark AS
remark\n"
" FROM sys._tables
t\n"
@@ -2558,9 +2558,9 @@ doFile(Mapi mid, stream *fp, bool useins
" UNION ALL\n"
" SELECT s.name AS
sname,\n"
" sq.name,\n"
- " s.name || \'.\'
|| sq.name AS fullname,\n"
+ " s.name || '.' ||
sq.name AS fullname,\n"
" CAST(4 AS
SMALLINT) AS ntype,\n"
- " \'SEQUENCE\' AS
type,\n"
+ " 'SEQUENCE' AS
type,\n"
" false AS
system,\n"
" c.remark AS
remark\n"
" FROM sys.sequences
sq\n"
@@ -2569,9 +2569,9 @@ doFile(Mapi mid, stream *fp, bool useins
" UNION ALL\n"
" SELECT DISTINCT
s.name AS sname, -- DISTINCT is needed to filter out duplicate overloaded
function/procedure names\n"
" f.name,\n"
- " s.name || \'.\'
|| f.name AS fullname,\n"
+ " s.name || '.' ||
f.name AS fullname,\n"
" CAST(8 AS
SMALLINT) AS ntype,\n"
- " (CASE WHEN
sf.function_id IS NOT NULL THEN \'SYSTEM \' ELSE \'\' END) ||
function_type_keyword AS type,\n"
+ " (CASE WHEN
sf.function_id IS NOT NULL THEN 'SYSTEM ' ELSE '' END) || function_type_keyword
AS type,\n"
" sf.function_id
IS NOT NULL AS system,\n"
" c.remark AS
remark\n"
" FROM sys.functions
f\n"
@@ -2584,7 +2584,7 @@ doFile(Mapi mid, stream *fp, bool useins
" s.name,\n"
" s.name AS
fullname,\n"
" CAST(16 AS
SMALLINT) AS ntype,\n"
- " (CASE WHEN
s.system THEN \'SYSTEM SCHEMA\' ELSE \'SCHEMA\' END) AS type,\n"
+ " (CASE WHEN
s.system THEN 'SYSTEM SCHEMA' ELSE 'SCHEMA' END) AS type,\n"
" s.system,\n"
" c.remark AS
remark\n"
" FROM sys.schemas
s\n"
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
