Changeset: e72f56ea821d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e72f56ea821d
Modified Files:
        sql/test/emptydb/Tests/check.SQL.py
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.32bit
        sql/test/emptydb/Tests/check.stable.out.int128
Branch: Mar2018
Log Message:

Fix ordering.


diffs (truncated from 1796 to 300 lines):

diff --git a/sql/test/emptydb/Tests/check.SQL.py 
b/sql/test/emptydb/Tests/check.SQL.py
--- a/sql/test/emptydb/Tests/check.SQL.py
+++ b/sql/test/emptydb/Tests/check.SQL.py
@@ -120,7 +120,7 @@ select s1.name, t.name, s2.name, f.name,
 select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, sys._columns c, sys._tables t, sys.schemas s1, 
sys.functions f, sys.schemas s2 where d.id = c.id and d.depend_id = f.id and 
c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by 
s2.name, f.name, s1.name, t.name, c.name;
 select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, schemas s1, functions f1, schemas s2, _tables t2 where 
d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id 
= s2.id order by s2.name, t2.name, s1.name, f1.name;
 select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where 
d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id 
= s2.id order by s2.name, t2.name, s1.name, t1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name 
from sys.dependencies d left outer join sys.dependency_types dt on 
d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, 
schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and 
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by 
s2.name, t2.name, s1.name, t1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name 
from sys.dependencies d left outer join sys.dependency_types dt on 
d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, 
schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and 
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by 
s2.name, t2.name, s1.name, t1.name, c1.name;
 select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, 
dt.dependency_type_name from sys.dependencies d left outer join 
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, 
_tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and 
d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and 
k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, 
k2.name, s1.name, t1.name, c1.name;
 select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name, 
dt.dependency_type_name from sys.dependencies d left outer join 
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, 
_tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.id = c1.id and 
d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and 
i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, 
i2.name, s1.name, t1.name, c1.name;
 select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, types t, functions f, schemas s where d.id = t.id and 
d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name, 
t.systemname, t.sqlname;
diff --git a/sql/test/emptydb/Tests/check.stable.out 
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -1336,7 +1336,7 @@ select s1.name, t.name, s2.name, f.name,
 select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, sys._columns c, sys._tables t, sys.schemas s1, 
sys.functions f, sys.schemas s2 where d.id = c.id and d.depend_id = f.id and 
c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by 
s2.name, f.name, s1.name, t.name, c.name;
 select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, schemas s1, functions f1, schemas s2, _tables t2 where 
d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id 
= s2.id order by s2.name, t2.name, s1.name, f1.name;
 select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where 
d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id 
= s2.id order by s2.name, t2.name, s1.name, t1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name 
from sys.dependencies d left outer join sys.dependency_types dt on 
d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, 
schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and 
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by 
s2.name, t2.name, s1.name, t1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name 
from sys.dependencies d left outer join sys.dependency_types dt on 
d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, 
schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and 
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by 
s2.name, t2.name, s1.name, t1.name, c1.name;
 select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, 
dt.dependency_type_name from sys.dependencies d left outer join 
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, 
_tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and 
d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and 
k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, 
k2.name, s1.name, t1.name, c1.name;
 select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name, 
dt.dependency_type_name from sys.dependencies d left outer join 
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, 
_tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.id = c1.id and 
d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and 
i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, 
i2.name, s1.name, t1.name, c1.name;
 select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from 
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = 
dt.dependency_type_id, types t, functions f, schemas s where d.id = t.id and 
d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name, 
t.systemname, t.sqlname;
@@ -4144,214 +4144,214 @@ drop function pcre_replace(string, strin
 % name,        name,   name,   name,   name,   dependency_type_name # name
 % varchar,     varchar,        varchar,        varchar,        varchar,        
varchar # type
 % 3,   16,     20,     3,      33,     4 # length
-[ "sys",       "args", "type", "sys",  "commented_function_signatures",        
"VIEW"  ]
+[ "sys",       "args", "func_id",      "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "args", "inout",        "sys",  
"commented_function_signatures",        "VIEW"  ]
-[ "sys",       "args", "type_scale",   "sys",  
"commented_function_signatures",        "VIEW"  ]
-[ "sys",       "args", "type_digits",  "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "args", "number",       "sys",  
"commented_function_signatures",        "VIEW"  ]
-[ "sys",       "args", "func_id",      "sys",  
"commented_function_signatures",        "VIEW"  ]
-[ "sys",       "comments",     "remark",       "sys",  
"commented_function_signatures",        "VIEW"  ]
+[ "sys",       "args", "type", "sys",  "commented_function_signatures",        
"VIEW"  ]
+[ "sys",       "args", "type_digits",  "sys",  
"commented_function_signatures",        "VIEW"  ]
+[ "sys",       "args", "type_scale",   "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "comments",     "id",   "sys",  
"commented_function_signatures",        "VIEW"  ]
+[ "sys",       "comments",     "remark",       "sys",  
"commented_function_signatures",        "VIEW"  ]
+[ "sys",       "functions",    "id",   "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"commented_function_signatures",        "VIEW"  ]
-[ "sys",       "functions",    "id",   "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "functions",    "schema_id",    "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"commented_function_signatures",        "VIEW"  ]
+[ "sys",       "schemas",      "id",   "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "schemas",      "name", "sys",  
"commented_function_signatures",        "VIEW"  ]
-[ "sys",       "schemas",      "id",   "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "systemfunctions",      "function_id",  "sys",  
"commented_function_signatures",        "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  "dependencies_vw",      
"VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  "dependencies_vw",      
"VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  "dependencies_vw",      "VIEW"  
]
 [ "sys",       "dependency_types",     "dependency_type_id",   "sys",  
"dependencies_vw",      "VIEW"  ]
 [ "sys",       "dependency_types",     "dependency_type_name", "sys",  
"dependencies_vw",      "VIEW"  ]
-[ "sys",       "args", "number",       "sys",  "dependency_args_on_types",     
"VIEW"  ]
 [ "sys",       "args", "func_id",      "sys",  "dependency_args_on_types",     
"VIEW"  ]
 [ "sys",       "args", "id",   "sys",  "dependency_args_on_types",     "VIEW"  
]
 [ "sys",       "args", "name", "sys",  "dependency_args_on_types",     "VIEW"  
]
-[ "sys",       "dependencies", "id",   "sys",  "dependency_args_on_types",     
"VIEW"  ]
+[ "sys",       "args", "number",       "sys",  "dependency_args_on_types",     
"VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_args_on_types",     "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_args_on_types",     "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_args_on_types",     "VIEW"  ]
+[ "sys",       "dependencies", "id",   "sys",  "dependency_args_on_types",     
"VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  "dependency_args_on_types",     
"VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  "dependency_args_on_types",     
"VIEW"  ]
+[ "sys",       "types",        "id",   "sys",  "dependency_args_on_types",     
"VIEW"  ]
 [ "sys",       "types",        "sqlname",      "sys",  
"dependency_args_on_types",     "VIEW"  ]
-[ "sys",       "types",        "id",   "sys",  "dependency_args_on_types",     
"VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
+[ "sys",       "functions",    "id",   "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
+[ "sys",       "functions",    "name", "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
-[ "sys",       "functions",    "name", "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
-[ "sys",       "functions",    "id",   "sys",  
"dependency_columns_on_functions",      "VIEW"  ]
+[ "sys",       "idxs", "id",   "sys",  "dependency_columns_on_indexes",        
"VIEW"  ]
 [ "sys",       "idxs", "name", "sys",  "dependency_columns_on_indexes",        
"VIEW"  ]
 [ "sys",       "idxs", "table_id",     "sys",  
"dependency_columns_on_indexes",        "VIEW"  ]
-[ "sys",       "idxs", "id",   "sys",  "dependency_columns_on_indexes",        
"VIEW"  ]
 [ "sys",       "idxs", "type", "sys",  "dependency_columns_on_indexes",        
"VIEW"  ]
+[ "sys",       "keys", "name", "sys",  "dependency_columns_on_indexes",        
"VIEW"  ]
 [ "sys",       "keys", "table_id",     "sys",  
"dependency_columns_on_indexes",        "VIEW"  ]
-[ "sys",       "keys", "name", "sys",  "dependency_columns_on_indexes",        
"VIEW"  ]
 [ "sys",       "objects",      "id",   "sys",  
"dependency_columns_on_indexes",        "VIEW"  ]
 [ "sys",       "objects",      "name", "sys",  
"dependency_columns_on_indexes",        "VIEW"  ]
 [ "sys",       "objects",      "nr",   "sys",  
"dependency_columns_on_indexes",        "VIEW"  ]
-[ "sys",       "keys", "type", "sys",  "dependency_columns_on_keys",   "VIEW"  
]
+[ "sys",       "keys", "id",   "sys",  "dependency_columns_on_keys",   "VIEW"  
]
 [ "sys",       "keys", "name", "sys",  "dependency_columns_on_keys",   "VIEW"  
]
-[ "sys",       "keys", "id",   "sys",  "dependency_columns_on_keys",   "VIEW"  
]
 [ "sys",       "keys", "table_id",     "sys",  "dependency_columns_on_keys",   
"VIEW"  ]
-[ "sys",       "objects",      "nr",   "sys",  "dependency_columns_on_keys",   
"VIEW"  ]
+[ "sys",       "keys", "type", "sys",  "dependency_columns_on_keys",   "VIEW"  
]
+[ "sys",       "objects",      "id",   "sys",  "dependency_columns_on_keys",   
"VIEW"  ]
 [ "sys",       "objects",      "name", "sys",  "dependency_columns_on_keys",   
"VIEW"  ]
-[ "sys",       "objects",      "id",   "sys",  "dependency_columns_on_keys",   
"VIEW"  ]
+[ "sys",       "objects",      "nr",   "sys",  "dependency_columns_on_keys",   
"VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
-[ "sys",       "functions",    "type", "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
+[ "sys",       "functions",    "type", "sys",  
"dependency_columns_on_procdures",      "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_triggers",       "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_triggers",       "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_columns_on_triggers",       "VIEW"  ]
+[ "sys",       "triggers",     "id",   "sys",  
"dependency_columns_on_triggers",       "VIEW"  ]
 [ "sys",       "triggers",     "name", "sys",  
"dependency_columns_on_triggers",       "VIEW"  ]
-[ "sys",       "triggers",     "id",   "sys",  
"dependency_columns_on_triggers",       "VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_types",  "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_types",  "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  "dependency_columns_on_types",  
"VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_types",  "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_types",  "VIEW"  ]
 [ "sys",       "types",        "id",   "sys",  "dependency_columns_on_types",  
"VIEW"  ]
 [ "sys",       "types",        "sqlname",      "sys",  
"dependency_columns_on_types",  "VIEW"  ]
-[ "sys",       "dependencies", "id",   "sys",  "dependency_columns_on_views",  
"VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_views",  "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_columns_on_views",  "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_columns_on_views",  "VIEW"  ]
+[ "sys",       "dependencies", "id",   "sys",  "dependency_columns_on_views",  
"VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
-[ "sys",       "functions",    "schema_id",    "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
+[ "sys",       "functions",    "schema_id",    "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_functions_on_functions",    "VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_functions_on_procdures",    "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
+[ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
 [ "sys",       "functions",    "schema_id",    "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
-[ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
-[ "sys",       "triggers",     "table_id",     "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
+[ "sys",       "triggers",     "id",   "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
 [ "sys",       "triggers",     "name", "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
-[ "sys",       "triggers",     "id",   "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
+[ "sys",       "triggers",     "table_id",     "sys",  
"dependency_functions_on_triggers",     "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_types",        "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_types",        "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_functions_on_types",        "VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_types",        "VIEW"  ]
-[ "sys",       "functions",    "type", "sys",  
"dependency_functions_on_types",        "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_functions_on_types",        "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_types",        "VIEW"  ]
+[ "sys",       "functions",    "type", "sys",  
"dependency_functions_on_types",        "VIEW"  ]
 [ "sys",       "types",        "id",   "sys",  
"dependency_functions_on_types",        "VIEW"  ]
 [ "sys",       "types",        "sqlname",      "sys",  
"dependency_functions_on_types",        "VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_views",        "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_functions_on_views",        "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_functions_on_views",        "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_functions_on_views",        "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_functions_on_views",        "VIEW"  ]
+[ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_views",        "VIEW"  ]
 [ "sys",       "functions",    "schema_id",    "sys",  
"dependency_functions_on_views",        "VIEW"  ]
-[ "sys",       "functions",    "name", "sys",  
"dependency_functions_on_views",        "VIEW"  ]
+[ "sys",       "keys", "id",   "sys",  "dependency_keys_on_foreignkeys",       
"VIEW"  ]
 [ "sys",       "keys", "name", "sys",  "dependency_keys_on_foreignkeys",       
"VIEW"  ]
-[ "sys",       "keys", "id",   "sys",  "dependency_keys_on_foreignkeys",       
"VIEW"  ]
+[ "sys",       "keys", "rkey", "sys",  "dependency_keys_on_foreignkeys",       
"VIEW"  ]
 [ "sys",       "keys", "table_id",     "sys",  
"dependency_keys_on_foreignkeys",       "VIEW"  ]
 [ "sys",       "keys", "type", "sys",  "dependency_keys_on_foreignkeys",       
"VIEW"  ]
-[ "sys",       "keys", "rkey", "sys",  "dependency_keys_on_foreignkeys",       
"VIEW"  ]
+[ "sys",       "auths",        "id",   "sys",  "dependency_owners_on_schemas", 
"VIEW"  ]
 [ "sys",       "auths",        "name", "sys",  "dependency_owners_on_schemas", 
"VIEW"  ]
-[ "sys",       "auths",        "id",   "sys",  "dependency_owners_on_schemas", 
"VIEW"  ]
 [ "sys",       "schemas",      "id",   "sys",  "dependency_owners_on_schemas", 
"VIEW"  ]
 [ "sys",       "schemas",      "name", "sys",  "dependency_owners_on_schemas", 
"VIEW"  ]
 [ "sys",       "schemas",      "owner",        "sys",  
"dependency_owners_on_schemas", "VIEW"  ]
+[ "sys",       "schemas",      "id",   "sys",  "dependency_schemas_on_users",  
"VIEW"  ]
 [ "sys",       "schemas",      "name", "sys",  "dependency_schemas_on_users",  
"VIEW"  ]
-[ "sys",       "schemas",      "id",   "sys",  "dependency_schemas_on_users",  
"VIEW"  ]
-[ "sys",       "keys", "table_id",     "sys",  
"dependency_tables_on_foreignkeys",     "VIEW"  ]
-[ "sys",       "keys", "rkey", "sys",  "dependency_tables_on_foreignkeys",     
"VIEW"  ]
-[ "sys",       "keys", "type", "sys",  "dependency_tables_on_foreignkeys",     
"VIEW"  ]
 [ "sys",       "keys", "id",   "sys",  "dependency_tables_on_foreignkeys",     
"VIEW"  ]
 [ "sys",       "keys", "name", "sys",  "dependency_tables_on_foreignkeys",     
"VIEW"  ]
+[ "sys",       "keys", "rkey", "sys",  "dependency_tables_on_foreignkeys",     
"VIEW"  ]
+[ "sys",       "keys", "table_id",     "sys",  
"dependency_tables_on_foreignkeys",     "VIEW"  ]
+[ "sys",       "keys", "type", "sys",  "dependency_tables_on_foreignkeys",     
"VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
+[ "sys",       "functions",    "id",   "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
-[ "sys",       "functions",    "id",   "sys",  
"dependency_tables_on_functions",       "VIEW"  ]
-[ "sys",       "idxs", "type", "sys",  "dependency_tables_on_indexes", "VIEW"  
]
-[ "sys",       "idxs", "table_id",     "sys",  "dependency_tables_on_indexes", 
"VIEW"  ]
 [ "sys",       "idxs", "id",   "sys",  "dependency_tables_on_indexes", "VIEW"  
]
 [ "sys",       "idxs", "name", "sys",  "dependency_tables_on_indexes", "VIEW"  
]
+[ "sys",       "idxs", "table_id",     "sys",  "dependency_tables_on_indexes", 
"VIEW"  ]
+[ "sys",       "idxs", "type", "sys",  "dependency_tables_on_indexes", "VIEW"  
]
 [ "sys",       "keys", "name", "sys",  "dependency_tables_on_indexes", "VIEW"  
]
 [ "sys",       "keys", "table_id",     "sys",  "dependency_tables_on_indexes", 
"VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_tables_on_procdures",       "VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
-[ "sys",       "triggers",     "table_id",     "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
+[ "sys",       "triggers",     "id",   "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
 [ "sys",       "triggers",     "name", "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
-[ "sys",       "triggers",     "id",   "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
+[ "sys",       "triggers",     "table_id",     "sys",  
"dependency_tables_on_triggers",        "VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_tables_on_views",   "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_views",   "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  "dependency_tables_on_views",   
"VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_tables_on_views",   "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_tables_on_views",   "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_views_on_functions",        "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_views_on_functions",        "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_views_on_functions",        "VIEW"  ]
+[ "sys",       "functions",    "id",   "sys",  
"dependency_views_on_functions",        "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_views_on_functions",        "VIEW"  ]
-[ "sys",       "functions",    "id",   "sys",  
"dependency_views_on_functions",        "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_views_on_functions",        "VIEW"  ]
+[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
 [ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
-[ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
+[ "sys",       "functions",    "id",   "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
 [ "sys",       "functions",    "name", "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
-[ "sys",       "functions",    "id",   "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
 [ "sys",       "functions",    "type", "sys",  
"dependency_views_on_procdures",        "VIEW"  ]
 [ "sys",       "dependencies", "depend_id",    "sys",  
"dependency_views_on_views",    "VIEW"  ]
+[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_views_on_views",    "VIEW"  ]
 [ "sys",       "dependencies", "id",   "sys",  "dependency_views_on_views",    
"VIEW"  ]
-[ "sys",       "dependencies", "depend_type",  "sys",  
"dependency_views_on_views",    "VIEW"  ]
-[ "sys",       "_tables",      "schema_id",    "sys",  "describe_all_objects", 
"VIEW"  ]
 [ "sys",       "_tables",      "id",   "sys",  "describe_all_objects", "VIEW"  
]
 [ "sys",       "_tables",      "name", "sys",  "describe_all_objects", "VIEW"  
]
+[ "sys",       "_tables",      "schema_id",    "sys",  "describe_all_objects", 
"VIEW"  ]
+[ "sys",       "_tables",      "system",       "sys",  "describe_all_objects", 
"VIEW"  ]
 [ "sys",       "_tables",      "type", "sys",  "describe_all_objects", "VIEW"  
]
-[ "sys",       "_tables",      "system",       "sys",  "describe_all_objects", 
"VIEW"  ]
 [ "sys",       "comments",     "id",   "sys",  "describe_all_objects", "VIEW"  
]
 [ "sys",       "comments",     "remark",       "sys",  "describe_all_objects", 
"VIEW"  ]
-[ "sys",       "functions",    "type", "sys",  "describe_all_objects", "VIEW"  
]
-[ "sys",       "functions",    "schema_id",    "sys",  "describe_all_objects", 
"VIEW"  ]
 [ "sys",       "functions",    "id",   "sys",  "describe_all_objects", "VIEW"  
]
 [ "sys",       "functions",    "name", "sys",  "describe_all_objects", "VIEW"  
]
-[ "sys",       "schemas",      "system",       "sys",  "describe_all_objects", 
"VIEW"  ]
+[ "sys",       "functions",    "schema_id",    "sys",  "describe_all_objects", 
"VIEW"  ]
+[ "sys",       "functions",    "type", "sys",  "describe_all_objects", "VIEW"  
]
+[ "sys",       "schemas",      "id",   "sys",  "describe_all_objects", "VIEW"  
]
 [ "sys",       "schemas",      "name", "sys",  "describe_all_objects", "VIEW"  
]
-[ "sys",       "schemas",      "id",   "sys",  "describe_all_objects", "VIEW"  
]
-[ "sys",       "sequences",    "schema_id",    "sys",  "describe_all_objects", 
"VIEW"  ]
+[ "sys",       "schemas",      "system",       "sys",  "describe_all_objects", 
"VIEW"  ]
 [ "sys",       "sequences",    "id",   "sys",  "describe_all_objects", "VIEW"  
]
 [ "sys",       "sequences",    "name", "sys",  "describe_all_objects", "VIEW"  
]
+[ "sys",       "sequences",    "schema_id",    "sys",  "describe_all_objects", 
"VIEW"  ]
 [ "sys",       "systemfunctions",      "function_id",  "sys",  
"describe_all_objects", "VIEW"  ]
 [ "sys",       "table_types",  "table_type_id",        "sys",  
"describe_all_objects", "VIEW"  ]
 [ "sys",       "table_types",  "table_type_name",      "sys",  
"describe_all_objects", "VIEW"  ]
+[ "sys",       "schemas",      "id",   "sys",  "geometry_columns",     "VIEW"  
]
 [ "sys",       "schemas",      "name", "sys",  "geometry_columns",     "VIEW"  
]
-[ "sys",       "schemas",      "id",   "sys",  "geometry_columns",     "VIEW"  
]
 [ "sys",       "types",        "sqlname",      "sys",  "geometry_columns",     
"VIEW"  ]
 [ "sys",       "types",        "systemname",   "sys",  "geometry_columns",     
"VIEW"  ]
 [ "sys",       "_columns",     "id",   "sys",  "ids",  "VIEW"  ]
 [ "sys",       "_columns",     "name", "sys",  "ids",  "VIEW"  ]
 [ "sys",       "_columns",     "table_id",     "sys",  "ids",  "VIEW"  ]
-[ "sys",       "_tables",      "type", "sys",  "ids",  "VIEW"  ]
+[ "sys",       "_tables",      "id",   "sys",  "ids",  "VIEW"  ]
 [ "sys",       "_tables",      "name", "sys",  "ids",  "VIEW"  ]
-[ "sys",       "_tables",      "id",   "sys",  "ids",  "VIEW"  ]
 [ "sys",       "_tables",      "schema_id",    "sys",  "ids",  "VIEW"  ]
+[ "sys",       "_tables",      "type", "sys",  "ids",  "VIEW"  ]
+[ "sys",       "args", "func_id",      "sys",  "ids",  "VIEW"  ]
+[ "sys",       "args", "id",   "sys",  "ids",  "VIEW"  ]
 [ "sys",       "args", "name", "sys",  "ids",  "VIEW"  ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to