Changeset: 8df42b3ae7c9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8df42b3ae7c9
Modified Files:
sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
Branch: default
Log Message:
Fix alias name of two query result columns.
Apparently Mtest.py can not correctly handle queries where an alias name
contains a # character.
diffs (28 lines):
diff --git
a/sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
b/sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
---
a/sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
+++
b/sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_not_in_select.Bug-6290.test
@@ -1,18 +1,18 @@
query TIII rowsort
SELECT s.name AS schema_nm, s.system AS is_system_schema
-, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type <> 2 AND f.id NOT IN (SELECT sf.id as function_id FROM sys.functions
sf WHERE sf.system)) AS "# user defined functions"
-, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type = 2 AND f.id NOT IN (SELECT sf.id as function_id FROM sys.functions
sf WHERE sf.system)) AS "# user defined procedures"
+, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type <> 2 AND f.id NOT IN (SELECT sf.id as function_id FROM sys.functions
sf WHERE sf.system)) AS "user defined functions count"
+, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type = 2 AND f.id NOT IN (SELECT sf.id as function_id FROM sys.functions
sf WHERE sf.system)) AS "user defined procedures count"
FROM sys.schemas AS s
WHERE s.name IN ('json', 'profiler', 'sys')
----
-12 values hashing to 6727addaaf6d5fc792d7a107a1d2990a
+12 values hashing to 9a34d92e7a28fa3845d10ff8833706a6
query TIII rowsort
SELECT s.name AS schema_nm, s.system AS is_system_schema
-, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type <> 2 AND NOT f.system) AS "# user defined functions"
-, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type = 2 AND NOT f.system) AS "# user defined procedures"
+, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type <> 2 AND NOT f.system) AS "user defined functions count"
+, (SELECT CAST(COUNT(*) as int) FROM sys.functions f WHERE f.schema_id = s.id
AND f.type = 2 AND NOT f.system) AS "user defined procedures count"
FROM sys.schemas AS s
WHERE s.name IN ('json', 'profiler', 'sys')
----
-12 values hashing to 6727addaaf6d5fc792d7a107a1d2990a
+12 values hashing to 9a34d92e7a28fa3845d10ff8833706a6
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
