Changeset: 38aa03e5cedc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=38aa03e5cedc
Modified Files:
clients/mapiclient/dump.c
Branch: Aug2018
Log Message:
Use UNION ALL instead of UNION, as done in mclient.c
The query results which are unioned are already distinct, so UNION ALL is
sufficient and faster.
diffs (21 lines):
diff --git a/clients/mapiclient/dump.c b/clients/mapiclient/dump.c
--- a/clients/mapiclient/dump.c
+++ b/clients/mapiclient/dump.c
@@ -1944,7 +1944,7 @@ dump_database(Mapi mid, stream *toConsol
"t.system = FALSE AND "
"s.id = t.schema_id AND "
"s.name <> 'tmp' "
- "UNION "
+ "UNION ALL "
"SELECT s.name AS sname, "
"f.name AS name, "
"f.id AS id, "
@@ -1954,7 +1954,7 @@ dump_database(Mapi mid, stream *toConsol
"sys.functions f "
"WHERE s.id = f.schema_id "
"AND f.id NOT IN (SELECT function_id FROM
sys.systemfunctions) "
- "UNION "
+ "UNION ALL "
"SELECT s.name AS sname, "
"tr.name AS name, "
"tr.id AS id, "
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
