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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to