Changeset: 9f193546ae4c for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f193546ae4c
Modified Files:
        sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out
        sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
        sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
        sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.err
        sql/test/Dependencies/Tests/Dependencies.stable.out
        sql/test/mapi/Tests/php_monetdb.stable.out
Branch: default
Log Message:

Approve tests after script change
The storage model changes some output, plus related stuff


diffs (truncated from 314 to 300 lines):

diff --git 
a/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out 
b/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out
--- a/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out
+++ b/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out
@@ -56,7 +56,7 @@ Ready.
 % .tables,     .tables,        .tables,        .tables,        .tables,        
.tables,        .tables,        .tables # table_name
 % name,        schema_id,      query,  type,   system, commit_action,  
readonly,       temporary # name
 % varchar,     int,    varchar,        smallint,       boolean,        
smallint,       boolean,        tinyint # type
-% 17,  4,      496,    1,      5,      1,      5,      1 # length
+% 17,  4,      522,    1,      5,      1,      5,      1 # length
 [ "schemas",   2000,   NULL,   0,      true,   0,      false,  0       ]
 [ "types",     2000,   NULL,   0,      true,   0,      false,  0       ]
 [ "functions", 2000,   NULL,   0,      true,   0,      false,  0       ]
@@ -94,7 +94,7 @@ Ready.
 [ "storage",   2000,   "create view sys.storage as select * from 
sys.storage();",      1,      true,   0,      false,  0       ]
 [ "storagemodelinput", 2000,   NULL,   0,      true,   0,      false,  0       
]
 [ "storagemodel",      2000,   "create view sys.storagemodel as select * from 
sys.storagemodel();",    1,      true,   0,      false,  0       ]
-[ "tablestoragemodel", 2000,   "-- A summary of the table storage requirement 
is is available as a table view.\n-- The auxillary column denotes the maximum 
space if all non-sorted columns\n-- would be augmented with a hash (rare 
situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  0       ]
+[ "tablestoragemodel", 2000,   "-- A summary of the table storage requirement 
is is available as a table view.\n-- The auxillary column denotes the maximum 
space if all non-sorted columns\n-- would be augmented with a hash (rare 
situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as 
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 * 
count else 0 end) as auxillary\nfrom sys.storagemodel() group by 
\"schema\",\"table\";",  1,      true,   0,      false,  0       ]
 [ "statistics",        2000,   NULL,   0,      true,   0,      false,  0       
]
 [ "systemfunctions",   2000,   NULL,   0,      true,   0,      false,  0       
]
 
diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
@@ -30,9 +30,9 @@ stderr of test 'predicate_select.Bug-309
 # 18:53:13 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" 
"--port=32323"
 # 18:53:13 >  
 
-MAPI  = (monetdb) /var/tmp/mtest-4932/.s.monetdb.34449
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = select name, schema_id, query, type, system, commit_action, readonly, 
temporary from tables where name;
-ERROR = !conversion of string 'querylog_history' to type bit failed.
+
 
 # 18:53:13 >  
 # 18:53:13 >  "Done."
diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
@@ -27,7 +27,7 @@ Ready.
 % .tables,     .tables,        .tables,        .tables,        .tables,        
.tables,        .tables,        .tables # table_name
 % name,        schema_id,      query,  type,   system, commit_action,  
readonly,       temporary # name
 % varchar,     int,    varchar,        smallint,       boolean,        
smallint,       boolean,        tinyint # type
-% 17,  4,      496,    1,      5,      1,      5,      1 # length
+% 17,  4,      522,    1,      5,      1,      5,      1 # length
 [ "schemas",   2000,   NULL,   0,      true,   0,      false,  0       ]
 [ "types",     2000,   NULL,   0,      true,   0,      false,  0       ]
 [ "functions", 2000,   NULL,   0,      true,   0,      false,  0       ]
@@ -65,7 +65,7 @@ Ready.
 [ "storage",   2000,   "create view sys.storage as select * from 
sys.storage();",      1,      true,   0,      false,  0       ]
 [ "storagemodelinput", 2000,   NULL,   0,      true,   0,      false,  0       
]
 [ "storagemodel",      2000,   "create view sys.storagemodel as select * from 
sys.storagemodel();",    1,      true,   0,      false,  0       ]
-[ "tablestoragemodel", 2000,   "-- A summary of the table storage requirement 
is is available as a table view.\n-- The auxillary column denotes the maximum 
space if all non-sorted columns\n-- would be augmented with a hash (rare 
situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  0       ]
+[ "tablestoragemodel", 2000,   "-- A summary of the table storage requirement 
is is available as a table view.\n-- The auxillary column denotes the maximum 
space if all non-sorted columns\n-- would be augmented with a hash (rare 
situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as 
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 * 
count else 0 end) as auxillary\nfrom sys.storagemodel() group by 
\"schema\",\"table\";",  1,      true,   0,      false,  0       ]
 [ "statistics",        2000,   NULL,   0,      true,   0,      false,  0       
]
 [ "systemfunctions",   2000,   NULL,   0,      true,   0,      false,  0       
]
 
diff --git 
a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out 
b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
--- a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
+++ b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
@@ -32,11 +32,11 @@ Ready.
 % sys._tables, sys._tables,    sys._tables,    sys._tables,    sys._tables,    
sys._tables,    sys._tables,    sys.x # table_name
 % name,        schema_id,      query,  type,   system, commit_action,  
readonly,       s # name
 % varchar,     int,    varchar,        smallint,       boolean,        
smallint,       boolean,        clob # type
-% 17,  4,      496,    1,      5,      1,      5,      6 # length
+% 17,  4,      522,    1,      5,      1,      5,      6 # length
 [ "_tables",   2000,   NULL,   0,      true,   0,      false,  "%able%"        
]
 [ "_tables",   2106,   NULL,   0,      true,   2,      false,  "%able%"        
]
 [ "tables",    2000,   "SELECT * FROM (SELECT p.*, 0 AS \"temporary\" FROM 
\"sys\".\"_tables\" AS p UNION ALL SELECT t.*, 1 AS \"temporary\" FROM 
\"tmp\".\"_tables\" AS t) AS tables where tables.type <> 2;",        1,      
true,   0,      false,  "%able%"        ]
-[ "tablestoragemodel", 2000,   "-- A summary of the table storage requirement 
is is available as a table view.\n-- The auxillary column denotes the maximum 
space if all non-sorted columns\n-- would be augmented with a hash (rare 
situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  "%able%"        ]
+[ "tablestoragemodel", 2000,   "-- A summary of the table storage requirement 
is is available as a table view.\n-- The auxillary column denotes the maximum 
space if all non-sorted columns\n-- would be augmented with a hash (rare 
situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as 
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 * 
count else 0 end) as auxillary\nfrom sys.storagemodel() group by 
\"schema\",\"table\";",  1,      true,   0,      false,  "%able%"        ]
 #drop table x;
 
 # 10:06:32 >  
diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.err 
b/sql/test/Dependencies/Tests/Dependencies.stable.err
--- a/sql/test/Dependencies/Tests/Dependencies.stable.err
+++ b/sql/test/Dependencies/Tests/Dependencies.stable.err
@@ -5,55 +5,78 @@ stderr of test 'Dependencies` in directo
 # 23:01:45 >  Mtimeout -timeout 180 mserver5 
"--config=/ufs/goncalve/scratch/MonetDB/monetdb5/etc/MonetDB5.conf" --debug=10 
--set 
"monet_mod_path=/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/monetdb5/lib/MonetDB5/bin"
 --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/dbfarm" 
--set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/sql_logs" 
--set 
"sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb5/var/MonetDB5/xquery_logs" 
--set mapi_port=39017 --set monet_prompt= --trace 
"--dbname=mTests_src_test_Dependencies" --dbinit='include sql;' ; echo ; echo 
Over..
 # 23:01:45 >  
 
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+# builtin opt  gdk_dbpath = 
/export/scratch1/mk/current//Linux/var/monetdb5/dbfarm/demo
+# builtin opt  gdk_debug = 0
+# builtin opt  gdk_vmtrim = no
+# builtin opt  monet_prompt = >
+# builtin opt  monet_daemon = no
+# builtin opt  mapi_port = 50000
+# builtin opt  mapi_open = false
+# builtin opt  mapi_autosense = false
+# builtin opt  sql_optimizer = default_pipe
+# builtin opt  sql_debug = 0
+# cmdline opt  gdk_nr_threads = 0
+# cmdline opt  mapi_open = true
+# cmdline opt  mapi_port = 30271
+# cmdline opt  mapi_usock = /var/tmp/mtest-30712/.s.monetdb.30271
+# cmdline opt  monet_prompt = 
+# cmdline opt  mal_listing = 2
+# cmdline opt  gdk_dbpath = 
/export/scratch1/mk/current//Linux/var/MonetDB/mTests_sql_test_Dependencies
+# cmdline opt  mal_listing = 0
+
+# 21:09:10 >  
+# 21:09:10 >  "/usr/bin/python2" "Dependencies.SQL.py" "Dependencies"
+# 21:09:10 >  
+
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP USER monetdb;
 ERROR = !DROP USER: 'monetdb' owns a schema
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP SCHEMA test;
 ERROR = !DROP SCHEMA: unable to drop schema 'test' (there are database objects 
which depend on it
-MAPI  = (monet_test) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monet_test) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = CREATE SCHEMA "test_2" AUTHORIZATION "public";
 ERROR = !CREATE SCHEMA: insufficient privileges for user 'monet_test'
-MAPI  = (monet_test) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monet_test) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP USER monetdb;
 ERROR = !DROP USER: 'monetdb' owns a schema
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = CREATE INDEX id_age_index ON v1(id,age);
 ERROR = !CREATE INDEX: cannot create index on view 'v1'
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = ALTER TABLE t1 DROP COLUMN id;
 ERROR = !ALTER TABLE: cannot drop column 'id': there are database objects 
which depend on it
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = ALTER TABLE v1 DROP COLUMN age;
 ERROR = !ALTER TABLE: cannot drop column from VIEW 'v1'
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = ALTER TABLE t2 ADD FOREIGN KEY(age_v1) REFERENCES v1(age);
 ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in 
table 'v1'
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP TABLE t1;
 ERROR = !DROP TABLE: FOREIGN KEY t2.t2_id_t1_fkey depends on t1
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP VIEW v1;
 ERROR = !DROP VIEW: cannot drop view 'v1', there are database objects which 
depend on it
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP TABLE t2; 
 ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which 
depend on it)
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP FUNCTION f1;
 ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP INDEX id_age_index;
 ERROR = !DROP INDEX: no such index 'id_age_index'
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP VIEW v1;
 ERROR = !DROP VIEW: cannot drop view 'v1', there are database objects which 
depend on it
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP TABLE t1;
 ERROR = !DROP TABLE: unable to drop table t1 (there are database objects which 
depend on it)
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP function f1;
 ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
-MAPI  = (monetdb) /var/tmp/mtest-20269/.s.monetdb.36091
+MAPI  = (monetdb) /var/tmp/mtest-30712/.s.monetdb.30271
 QUERY = DROP SCHEMA test_2;
 ERROR = !DROP SCHEMA: name test_2 does not exist
 
diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out 
b/sql/test/Dependencies/Tests/Dependencies.stable.out
--- a/sql/test/Dependencies/Tests/Dependencies.stable.out
+++ b/sql/test/Dependencies/Tests/Dependencies.stable.out
@@ -380,12 +380,15 @@ Dependencies between database objects
 [ "<", "f2",   "DEP_FUNC"      ]
 [ ">", "f2",   "DEP_FUNC"      ]
 [ "f1",        "f2",   "DEP_FUNC"      ]
+[ "=", "hashsize",     "DEP_FUNC"      ]
+[ "sql_mul",   "hashsize",     "DEP_FUNC"      ]
 [ "<>",        "heapsize",     "DEP_FUNC"      ]
 [ "and",       "heapsize",     "DEP_FUNC"      ]
 [ "sql_add",   "heapsize",     "DEP_FUNC"      ]
 [ "sql_mul",   "heapsize",     "DEP_FUNC"      ]
-[ "=", "indexsize",    "DEP_FUNC"      ]
-[ "sql_mul",   "indexsize",    "DEP_FUNC"      ]
+[ "=", "imprintsize",  "DEP_FUNC"      ]
+[ "or",        "imprintsize",  "DEP_FUNC"      ]
+[ "sql_mul",   "imprintsize",  "DEP_FUNC"      ]
 [ "=", "ms_round",     "DEP_FUNC"      ]
 [ "ms_trunc",  "ms_round",     "DEP_FUNC"      ]
 [ "not",       "ms_round",     "DEP_FUNC"      ]
@@ -402,8 +405,9 @@ Dependencies between database objects
 [ "sql_div",   "radians",      "DEP_FUNC"      ]
 [ "sql_mul",   "radians",      "DEP_FUNC"      ]
 [ "columnsize",        "storagemodel", "DEP_FUNC"      ]
+[ "hashsize",  "storagemodel", "DEP_FUNC"      ]
 [ "heapsize",  "storagemodel", "DEP_FUNC"      ]
-[ "indexsize", "storagemodel", "DEP_FUNC"      ]
+[ "imprintsize",       "storagemodel", "DEP_FUNC"      ]
 #SELECT f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri, 
dependencies as dep where dep.id = f.id AND dep.depend_id =tri.id AND 
dep.depend_type = 8;
 % sys.f,       sys.tri,        .L # table_name
 % name,        name,   single_value # name
@@ -480,12 +484,15 @@ Dependencies between functions with same
 [ "f1",        "f2",   "DEP_FUNC"      ]
 [ "<", "f3",   "DEP_FUNC"      ]
 [ "f1",        "f3",   "DEP_FUNC"      ]
+[ "=", "hashsize",     "DEP_FUNC"      ]
+[ "sql_mul",   "hashsize",     "DEP_FUNC"      ]
 [ "<>",        "heapsize",     "DEP_FUNC"      ]
 [ "and",       "heapsize",     "DEP_FUNC"      ]
 [ "sql_add",   "heapsize",     "DEP_FUNC"      ]
 [ "sql_mul",   "heapsize",     "DEP_FUNC"      ]
-[ "=", "indexsize",    "DEP_FUNC"      ]
-[ "sql_mul",   "indexsize",    "DEP_FUNC"      ]
+[ "=", "imprintsize",  "DEP_FUNC"      ]
+[ "or",        "imprintsize",  "DEP_FUNC"      ]
+[ "sql_mul",   "imprintsize",  "DEP_FUNC"      ]
 [ "=", "ms_round",     "DEP_FUNC"      ]
 [ "ms_trunc",  "ms_round",     "DEP_FUNC"      ]
 [ "not",       "ms_round",     "DEP_FUNC"      ]
@@ -502,8 +509,9 @@ Dependencies between functions with same
 [ "sql_div",   "radians",      "DEP_FUNC"      ]
 [ "sql_mul",   "radians",      "DEP_FUNC"      ]
 [ "columnsize",        "storagemodel", "DEP_FUNC"      ]
+[ "hashsize",  "storagemodel", "DEP_FUNC"      ]
 [ "heapsize",  "storagemodel", "DEP_FUNC"      ]
-[ "indexsize", "storagemodel", "DEP_FUNC"      ]
+[ "imprintsize",       "storagemodel", "DEP_FUNC"      ]
 #DROP FUNCTION f2;
 #DROP FUNCTION f3;
 #DROP ALL FUNCTION f1;
@@ -527,12 +535,15 @@ Dependencies between functions with same
 [ "rotate_xor_hash",   "dependencies_columns_on_keys", "DEP_FUNC"      ]
 [ "sql_neg",   "dependencies_columns_on_keys", "DEP_FUNC"      ]
 [ "isnull",    "dependencies_tables_on_indexes",       "DEP_FUNC"      ]
+[ "=", "hashsize",     "DEP_FUNC"      ]
+[ "sql_mul",   "hashsize",     "DEP_FUNC"      ]
 [ "<>",        "heapsize",     "DEP_FUNC"      ]
 [ "and",       "heapsize",     "DEP_FUNC"      ]
 [ "sql_add",   "heapsize",     "DEP_FUNC"      ]
 [ "sql_mul",   "heapsize",     "DEP_FUNC"      ]
-[ "=", "indexsize",    "DEP_FUNC"      ]
-[ "sql_mul",   "indexsize",    "DEP_FUNC"      ]
+[ "=", "imprintsize",  "DEP_FUNC"      ]
+[ "or",        "imprintsize",  "DEP_FUNC"      ]
+[ "sql_mul",   "imprintsize",  "DEP_FUNC"      ]
 [ "=", "ms_round",     "DEP_FUNC"      ]
 [ "ms_trunc",  "ms_round",     "DEP_FUNC"      ]
 [ "not",       "ms_round",     "DEP_FUNC"      ]
@@ -549,8 +560,9 @@ Dependencies between functions with same
 [ "sql_div",   "radians",      "DEP_FUNC"      ]
 [ "sql_mul",   "radians",      "DEP_FUNC"      ]
 [ "columnsize",        "storagemodel", "DEP_FUNC"      ]
+[ "hashsize",  "storagemodel", "DEP_FUNC"      ]
 [ "heapsize",  "storagemodel", "DEP_FUNC"      ]
-[ "indexsize", "storagemodel", "DEP_FUNC"      ]
+[ "imprintsize",       "storagemodel", "DEP_FUNC"      ]
 #create table t1(id int, name varchar(1024), age int);
 #create function f1()
 #returns int
@@ -786,7 +798,8 @@ Cleanup
 [ "=", "columnsize",   "DEP_FUNC"      ]
 [ "=", "dependencies_columns_on_indexes",      "DEP_FUNC"      ]
 [ "=", "dependencies_columns_on_keys", "DEP_FUNC"      ]
-[ "=", "indexsize",    "DEP_FUNC"      ]
+[ "=", "hashsize",     "DEP_FUNC"      ]
+[ "=", "imprintsize",  "DEP_FUNC"      ]
 [ "=", "ms_round",     "DEP_FUNC"      ]
 [ ">", "ms_stuff",     "DEP_FUNC"      ]
 [ "and",       "heapsize",     "DEP_FUNC"      ]
@@ -794,14 +807,16 @@ Cleanup
 [ "concat",    "ms_stuff",     "DEP_FUNC"      ]
 [ "hash",      "dependencies_columns_on_indexes",      "DEP_FUNC"      ]
 [ "hash",      "dependencies_columns_on_keys", "DEP_FUNC"      ]
+[ "hashsize",  "storagemodel", "DEP_FUNC"      ]
 [ "heapsize",  "storagemodel", "DEP_FUNC"      ]
-[ "indexsize", "storagemodel", "DEP_FUNC"      ]
+[ "imprintsize",       "storagemodel", "DEP_FUNC"      ]
 [ "isnull",    "dependencies_columns_on_indexes",      "DEP_FUNC"      ]
 [ "isnull",    "dependencies_tables_on_indexes",       "DEP_FUNC"      ]
 [ "left_shift",        "columnsize",   "DEP_FUNC"      ]
 [ "length",    "ms_stuff",     "DEP_FUNC"      ]
 [ "ms_trunc",  "ms_round",     "DEP_FUNC"      ]
 [ "not",       "ms_round",     "DEP_FUNC"      ]
+[ "or",        "imprintsize",  "DEP_FUNC"      ]
 [ "or",        "ms_stuff",     "DEP_FUNC"      ]
 [ "pi",        "degrees",      "DEP_FUNC"      ]
 [ "pi",        "radians",      "DEP_FUNC"      ]
@@ -814,8 +829,9 @@ Cleanup
 [ "sql_div",   "radians",      "DEP_FUNC"      ]
 [ "sql_mul",   "columnsize",   "DEP_FUNC"      ]
 [ "sql_mul",   "degrees",      "DEP_FUNC"      ]
+[ "sql_mul",   "hashsize",     "DEP_FUNC"      ]
 [ "sql_mul",   "heapsize",     "DEP_FUNC"      ]
-[ "sql_mul",   "indexsize",    "DEP_FUNC"      ]
+[ "sql_mul",   "imprintsize",  "DEP_FUNC"      ]
 [ "sql_mul",   "radians",      "DEP_FUNC"      ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to