Changeset: f4e6658a6c22 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f4e6658a6c22
Modified Files:
        sql/jdbc/tests/Tests/Test_Dobjects.stable.out
        
sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
        sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
        sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
        
sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.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-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err
        
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out
        sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err
        sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
        sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.err
        sql/test/Dependencies/Tests/Dependencies.stable.out
        sql/test/Dependencies/Tests/dependency_loop.stable.out
        sql/test/Tests/systemfunctions.stable.out
        sql/test/Tests/systemfunctions_nogeom.stable.out
        sql/test/Tests/trace_nogeom.stable.out
        sql/test/bugs/Tests/crash_order_by.stable.err
        sql/test/bugs/Tests/crash_order_by.stable.out
        sql/test/bugs/Tests/insert_delete-bug-sf-904025.stable.out
        sql/test/bugs/Tests/simple_view.stable.out
        sql/test/leaks/Tests/check0.stable.out
        sql/test/leaks/Tests/check0_nogeom.stable.out
        sql/test/leaks/Tests/check1.stable.out
        sql/test/leaks/Tests/check1_nogeom.stable.out
        sql/test/leaks/Tests/check2.stable.out
        sql/test/leaks/Tests/check2_nogeom.stable.out
        sql/test/leaks/Tests/check3.stable.out
        sql/test/leaks/Tests/check3_nogeom.stable.out
        sql/test/leaks/Tests/check4.stable.out
        sql/test/leaks/Tests/check4_nogeom.stable.out
        sql/test/leaks/Tests/check5.stable.out
        sql/test/leaks/Tests/check5_nogeom.stable.out
        sql/test/leaks/Tests/drop3.stable.out
        sql/test/leaks/Tests/drop3_nogeom.stable.out
        sql/test/leaks/Tests/select1.stable.out
        sql/test/leaks/Tests/select1_nogeom.stable.out
        sql/test/leaks/Tests/select2.stable.out
        sql/test/leaks/Tests/select2_nogeom.stable.out
        sql/test/leaks/Tests/temp1.stable.out
        sql/test/leaks/Tests/temp1_nogeom.stable.out
        sql/test/leaks/Tests/temp2.stable.out
        sql/test/leaks/Tests/temp2_nogeom.stable.out
        sql/test/leaks/Tests/temp3.stable.out
        sql/test/leaks/Tests/temp3_nogeom.stable.out
        sql/test/mapi/Tests/php_monetdb.stable.out
        sql/test/mapi/Tests/php_monetdb_nogeom.stable.out
Branch: default
Log Message:

Approvals after changesets 523120729e8d and 0735f6e1ddfc.


diffs (truncated from 2545 to 300 lines):

diff --git a/sql/jdbc/tests/Tests/Test_Dobjects.stable.out 
b/sql/jdbc/tests/Tests/Test_Dobjects.stable.out
--- a/sql/jdbc/tests/Tests/Test_Dobjects.stable.out
+++ b/sql/jdbc/tests/Tests/Test_Dobjects.stable.out
@@ -77,6 +77,7 @@ mTests_jdbc_tests     sys     privileges      SYSTEM 
 mTests_jdbc_tests      sys     queryhistory    SYSTEM TABLE    null    null    
null    null    rowid   SYSTEM  
 mTests_jdbc_tests      sys     schemas SYSTEM TABLE    null    null    null    
null    rowid   SYSTEM  
 mTests_jdbc_tests      sys     sequences       SYSTEM TABLE    null    null    
null    null    rowid   SYSTEM  
+mTests_jdbc_tests      sys     storagemodelinput       SYSTEM TABLE    null    
null    null    null    rowid   SYSTEM  
 mTests_jdbc_tests      sys     systemfunctions SYSTEM TABLE    null    null    
null    null    rowid   SYSTEM  
 mTests_jdbc_tests      sys     triggers        SYSTEM TABLE    null    null    
null    null    rowid   SYSTEM  
 mTests_jdbc_tests      sys     types   SYSTEM TABLE    null    null    null    
null    rowid   SYSTEM  
@@ -92,6 +93,16 @@ mTests_jdbc_tests    sys     querylog        SYSTEM VI
 select qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, 
ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql
 where qd.id = ql.id;   null    null    null    rowid   SYSTEM  
 mTests_jdbc_tests      sys     tables  SYSTEM VIEW     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;        
null    null    null    rowid   SYSTEM  
+mTests_jdbc_tests      sys     tablestoragemodel       SYSTEM VIEW     -- A 
summary of the table storage requirement is is available as a table view.
+-- The auxillary column denotes the maximum space if all non-sorted columns
+-- would be augmented with a hash (rare situation)
+create view tablestoragemodel
+as select "schema","table",max(count) as "count",
+       sum(columnsize) as columnsize,
+       sum(heapsize) as heapsize,
+       sum(indices) as indices,
+       sum(case when sorted = false then 8 * count else 0 end) as auxillary
+from storagemodel() group by "schema","table"; null    null    null    rowid   
SYSTEM  
 mTests_jdbc_tests      sys     users   SYSTEM VIEW     SELECT u."name" AS 
"name", ui."fullname", ui."default_schema" FROM db_users() AS u LEFT JOIN 
"sys"."db_user_info" AS ui ON u."name" = ui."name" ;       null    null    null 
   rowid   SYSTEM  
 
 # 20:09:14 >  
diff --git 
a/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err 
b/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
--- a/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
+++ b/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
@@ -82,9 +82,9 @@ stderr of test 'sql_command_kills_db.SF-
 # 16:15:09 >  mclient -lsql -umonetdb -Pmonetdb --host=alf --port=39774  -G
 # 16:15:09 >  
 
-MAPI  = monetdb@niels:30424
+MAPI  = monetdb@madrid:36834
 QUERY = insert into t1 values ((select id from tables));
-ERROR = !cardinality violation (31>1)
+ERROR = !cardinality violation (33>1)
 
 # 16:15:09 >  
 # 16:15:09 >  Done.
diff --git 
a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out 
b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
--- a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
+++ b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
@@ -29,19 +29,19 @@ Ready.
 % L1 # name
 % wrd # type
 % 2 # length
-[ 30   ]
+[ 32   ]
 #select count(distinct name) from tables;
 % .tables # table_name
 % L1 # name
 % wrd # type
 % 2 # length
-[ 24   ]
+[ 26   ]
 #select count(name) , count(distinct name) from tables;
 % .tables,     .tables # table_name
 % L1,  L2 # name
 % wrd, wrd # type
 % 2,   2 # length
-[ 30,  24      ]
+[ 32,  26      ]
 
 # 10:05:42 >  
 # 10:05:42 >  Done.
diff --git a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out 
b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
--- a/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
+++ b/sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out
@@ -123,6 +123,8 @@ Ready.
 [ 123  ]
 [ 123  ]
 [ 123  ]
+[ 123  ]
+[ 123  ]
 
 # 17:14:07 >  
 # 17:14:07 >  "Done."
diff --git 
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
 
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
--- 
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
+++ 
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
@@ -28,13 +28,13 @@ Ready.
 % L2,  L1 # name
 % tinyint,     wrd # type
 % 1,   2 # length
-[ 1,   31      ]
+[ 1,   33      ]
 #SELECT (SELECT count(*) FROM tables), 1;
 % .tables,     . # table_name
 % L1,  single_value # name
 % wrd, tinyint # type
 % 2,   1 # length
-[ 31,  1       ]
+[ 33,  1       ]
 
 # 21:48:51 >  
 # 21:48:51 >  "Done."
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,7 +30,7 @@ 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@sofia:39129
+MAPI  = monetdb@madrid:36834
 QUERY = select * from tables where name;
 ERROR = !conversion from string to type bit failed.
 
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,        .tables # table_name
 % id,  name,   schema_id,      query,  type,   system, commit_action,  
readonly,       temporary # name
 % int, varchar,        int,    varchar,        smallint,       boolean,        
smallint,       boolean,        tinyint # type
-% 4,   15,     4,      192,    1,      5,      1,      5,      1 # length
+% 4,   17,     4,      488,    1,      5,      1,      5,      1 # length
 [ 2001,        "schemas",      2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 2006,        "types",        2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 2015,        "functions",    2000,   NULL,   0,      true,   0,      false,  
0       ]
@@ -57,8 +57,10 @@ Ready.
 [ 5220,        "queryhistory", 2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 5234,        "callhistory",  2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 5251,        "querylog",     2000,   "create view querylog as\nselect qd.*, 
ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, 
ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = 
ql.id;",   1,      true,   0,      false,  0       ]
-[ 5843,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
-[ 5952,        "r",    2000,   NULL,   0,      false,  0,      false,  0       
]
+[ 5848,        "storagemodelinput",    2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 5889,        "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 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 storagemodel() group by \"schema\",\"table\";",      1,      
true,   0,      false,  0       ]
+[ 5911,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 6020,        "r",    2000,   NULL,   0,      false,  0,      false,  0       
]
 
 # 18:53:13 >  
 # 18:53:13 >  "Done."
diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err
@@ -30,7 +30,7 @@ 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@madrid:32839
+MAPI  = monetdb@madrid:37409
 QUERY = select * from tables where name;
 ERROR = !conversion from string to type bit failed.
 
diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.out
@@ -27,7 +27,7 @@ Ready.
 % .tables,     .tables,        .tables,        .tables,        .tables,        
.tables,        .tables,        .tables,        .tables # table_name
 % id,  name,   schema_id,      query,  type,   system, commit_action,  
readonly,       temporary # name
 % int, varchar,        int,    varchar,        smallint,       boolean,        
smallint,       boolean,        tinyint # type
-% 4,   15,     4,      192,    1,      5,      1,      5,      1 # length
+% 4,   17,     4,      488,    1,      5,      1,      5,      1 # length
 [ 2001,        "schemas",      2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 2006,        "types",        2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 2015,        "functions",    2000,   NULL,   0,      true,   0,      false,  
0       ]
@@ -47,18 +47,20 @@ Ready.
 [ 2130,        "idxs", 2102,   NULL,   0,      true,   2,      false,  0       
]
 [ 2135,        "triggers",     2102,   NULL,   0,      true,   2,      false,  
0       ]
 [ 2146,        "objects",      2102,   NULL,   0,      true,   2,      false,  
0       ]
-[ 4993,        "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,  0       ]
-[ 5003,        "columns",      2000,   "SELECT * FROM (SELECT p.* FROM 
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) 
AS columns;",    1,      true,   0,      false,  0       ]
-[ 5023,        "db_user_info", 2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5031,        "users",        2000,   "SELECT u.\"name\" AS \"name\", 
ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN 
\"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\" ;",    1,      true, 
  0,      false,  0       ]
-[ 5035,        "user_role",    2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5038,        "auths",        2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5042,        "privileges",   2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5195,        "queryhistory", 2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5209,        "callhistory",  2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5226,        "querylog",     2000,   "create view querylog as\nselect qd.*, 
ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, 
ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = 
ql.id;",   1,      true,   0,      false,  0       ]
-[ 5632,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
-[ 5741,        "r",    2000,   NULL,   0,      false,  0,      false,  0       
]
+[ 5018,        "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,  0       ]
+[ 5028,        "columns",      2000,   "SELECT * FROM (SELECT p.* FROM 
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t) 
AS columns;",    1,      true,   0,      false,  0       ]
+[ 5048,        "db_user_info", 2000,   NULL,   0,      true,   0,      false,  
0       ]
+[ 5056,        "users",        2000,   "SELECT u.\"name\" AS \"name\", 
ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN 
\"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\" ;",    1,      true, 
  0,      false,  0       ]
+[ 5060,        "user_role",    2000,   NULL,   0,      true,   0,      false,  
0       ]
+[ 5063,        "auths",        2000,   NULL,   0,      true,   0,      false,  
0       ]
+[ 5067,        "privileges",   2000,   NULL,   0,      true,   0,      false,  
0       ]
+[ 5220,        "queryhistory", 2000,   NULL,   0,      true,   0,      false,  
0       ]
+[ 5234,        "callhistory",  2000,   NULL,   0,      true,   0,      false,  
0       ]
+[ 5251,        "querylog",     2000,   "create view querylog as\nselect qd.*, 
ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, ql.tuples, 
ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere qd.id = 
ql.id;",   1,      true,   0,      false,  0       ]
+[ 5648,        "storagemodelinput",    2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 5689,        "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 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 storagemodel() group by \"schema\",\"table\";",      1,      
true,   0,      false,  0       ]
+[ 5711,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 5820,        "r",    2000,   NULL,   0,      false,  0,      false,  0       
]
 
 # 18:53:13 >  
 # 18:53:13 >  "Done."
diff --git 
a/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err 
b/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err
--- a/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err
+++ b/sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err
@@ -80,12 +80,12 @@ stderr of test 'cardinality_violation.SF
 # 21:00:43 >  mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38808 
 # 21:00:43 >  
 
-MAPI  = monetdb@niels:32557
+MAPI  = monetdb@madrid:36834
 QUERY = select * from env() as env where name = ( select 'prefix' from env() 
as env );
 ERROR = !cardinality violation (20>1)
-MAPI  = monetdb@niels:32557
+MAPI  = monetdb@madrid:36834
 QUERY = select * from columns where name = (select columns.name from _tables, 
columns where _tables.id = columns.table_id);
-ERROR = !cardinality violation (289>1)
+ERROR = !cardinality violation (326>1)
 
 
 # 21:00:43 >  
diff --git a/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out 
b/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
--- a/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
+++ b/sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
@@ -58,6 +58,8 @@ Ready.
 [ 28   ]
 [ 29   ]
 [ 30   ]
+[ 31   ]
+[ 32   ]
 
 # 11:15:39 >  
 # 11:15:39 >  Done.
diff --git a/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out 
b/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
--- a/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
+++ b/sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
@@ -28,13 +28,13 @@ Ready.
 % L1 # name
 % wrd # type
 % 2 # length
-[ 30   ]
+[ 32   ]
 #WITH t AS ( SELECT count(*) FROM tables ) SELECT * FROM t;
 % .t # table_name
 % L1 # name
 % wrd # type
 % 2 # length
-[ 30   ]
+[ 32   ]
 
 # 22:41:45 >  
 # 22:41:45 >  Done.
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
@@ -10,55 +10,55 @@ stderr of test 'Dependencies` in directo
 # 23:01:45 >  Mtimeout -timeout 60 ./Dependencies.SQL Dependencies 
 # 23:01:45 >  
 
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = DROP USER monetdb;
 ERROR = !DROP USER: cannot remove yourself
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = DROP SCHEMA test;
 ERROR = !DROP SCHEMA: unable to drop schema 'test' (there are database objects 
which depend on it
-MAPI  = monet_test@alf:38889
+MAPI  = monet_test@madrid:36834
 QUERY = CREATE SCHEMA "test_2" AUTHORIZATION "public";
 ERROR = !CREATE SCHEMA: insufficient privileges for user 'monet_test'
-MAPI  = monet_test@alf:38889
+MAPI  = monet_test@madrid:36834
 QUERY = DROP USER monetdb;
 ERROR = !DROP USER: access denied for user 'monet_test'
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = CREATE INDEX id_age_index ON v1(id,age);
 ERROR = !CREATE INDEX: cannot create index on view 'v1'
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = ALTER TABLE t1 DROP COLUMN id;
 ERROR = !ALTER TABLE: cannot drop column 'id': there are database objects 
which depend on it
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = ALTER TABLE v1 DROP COLUMN age;
 ERROR = !ALTER TABLE: cannot drop column from VIEW 'v1'
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 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@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = DROP TABLE t1;
 ERROR = !DROP TABLE: FOREIGN KEY t2.t2_id_t1_fkey depends on t1
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = DROP VIEW v1;
 ERROR = !DROP VIEW: cannot drop view 'v1', there are database objects which 
depend on it
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = DROP TABLE t2; 
 ERROR = !DROP TABLE: unable to drop table t2 (there are database objects which 
depend on it)
-MAPI  = monetdb@alf:38889
+MAPI  = monetdb@madrid:36834
 QUERY = DROP FUNCTION f1;
 ERROR = !DROP FUNCTION: there are database objects dependent on function f1;
-MAPI  = monetdb@alf:38889
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to