Changeset: 36650a9744d5 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36650a9744d5
Added Files:
        sql/test/mergetables/Tests/crash0.stable.err
        sql/test/mergetables/Tests/crash0.stable.out
        sql/test/mergetables/Tests/mergedrop.stable.err
        sql/test/mergetables/Tests/mergedrop.stable.out
Removed Files:
        monetdb5/tests/BugsViaSourgeforce/Tests/All
Modified Files:
        clients/Tests/MAL-signatures_all.stable.out
        clients/Tests/MAL-signatures_all.stable.out.int128
        clients/Tests/SQL-dump_all.stable.out
        clients/Tests/SQL-dump_all.stable.out.int128
        clients/Tests/SQL-dump_all.stable.out.oid32
        clients/Tests/SQL-dump_all.stable.out.oid32.int128
        clients/Tests/exports.stable.out
        clients/mapiclient/Makefile.ag
        clients/mapiclient/Tests/stethoscope--help.stable.err
        clients/mapiclient/Tests/tomograph--help.stable.err
        clients/mapiclient/eventparser.c
        clients/mapiclient/eventparser.h
        clients/mapiclient/stethoscope.c
        clients/mapiclient/tachograph.c
        clients/mapiclient/tomograph.c
        monetdb5/mal/mal_profiler.c
        monetdb5/modules/mal/querylog.c
        monetdb5/modules/mal/querylog.h
        monetdb5/modules/mal/querylog.mal
        monetdb5/optimizer/Tests/All
        monetdb5/optimizer/opt_garbageCollector.c
        sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
        sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
        sql/server/rel_updates.c
        sql/server/sql_datetime.c
        sql/server/sql_parser.y
        sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out
        sql/test/Tests/systemfunctions_bam.stable.out
        sql/test/Tests/systemfunctions_bam.stable.out.int128
        sql/test/leaks/Tests/check1_bam.stable.out.int128
        sql/test/leaks/Tests/check2_bam.stable.out.int128
        sql/test/leaks/Tests/check3_bam.stable.out.int128
        sql/test/leaks/Tests/check4_bam.stable.out.int128
        sql/test/leaks/Tests/check5_bam.stable.out.int128
        sql/test/mergetables/Tests/crash0.sql
        sql/test/snodgrass/Tests/cast_select.stable.err
        sql/test/snodgrass/Tests/cast_select.stable.out
Branch: default
Log Message:

merge


diffs (truncated from 4839 to 300 lines):

diff --git a/clients/Tests/MAL-signatures_all.stable.out 
b/clients/Tests/MAL-signatures_all.stable.out
--- a/clients/Tests/MAL-signatures_all.stable.out
+++ b/clients/Tests/MAL-signatures_all.stable.out
@@ -40136,7 +40136,7 @@ pattern querylog.call(tick1:timestamp,ti
 address QLOGcall;
 comment Add a new query call to the query log
 
-command querylog.define(q:str,pipe:str):void 
+command querylog.define(q:str,pipe:str,size:int):void 
 address QLOGdefineNaive;
 comment Noop operation, just marking the query
 
diff --git a/clients/Tests/MAL-signatures_all.stable.out.int128 
b/clients/Tests/MAL-signatures_all.stable.out.int128
--- a/clients/Tests/MAL-signatures_all.stable.out.int128
+++ b/clients/Tests/MAL-signatures_all.stable.out.int128
@@ -51071,7 +51071,7 @@ pattern querylog.call(tick1:timestamp,ti
 address QLOGcall;
 comment Add a new query call to the query log
 
-command querylog.define(q:str,pipe:str):void 
+command querylog.define(q:str,pipe:str,size:int):void 
 address QLOGdefineNaive;
 comment Noop operation, just marking the query
 
diff --git a/clients/Tests/SQL-dump_all.stable.out 
b/clients/Tests/SQL-dump_all.stable.out
--- a/clients/Tests/SQL-dump_all.stable.out
+++ b/clients/Tests/SQL-dump_all.stable.out
@@ -201,6 +201,8 @@ SYSTEM FUNCTION  sys.point
 SYSTEM FUNCTION  sys.pointfromtext
 SYSTEM FUNCTION  sys.polyfromtext
 SYSTEM FUNCTION  sys.polygonfromtext
+SYSTEM FUNCTION  sys.profiler_openstream
+SYSTEM FUNCTION  sys.profiler_stethoscope
 SYSTEM FUNCTION  sys.quantile
 SYSTEM FUNCTION  sys.querycache
 SYSTEM FUNCTION  sys.querylog
diff --git a/clients/Tests/SQL-dump_all.stable.out.int128 
b/clients/Tests/SQL-dump_all.stable.out.int128
--- a/clients/Tests/SQL-dump_all.stable.out.int128
+++ b/clients/Tests/SQL-dump_all.stable.out.int128
@@ -197,6 +197,8 @@ SYSTEM FUNCTION  sys.point
 SYSTEM FUNCTION  sys.pointfromtext
 SYSTEM FUNCTION  sys.polyfromtext
 SYSTEM FUNCTION  sys.polygonfromtext
+SYSTEM FUNCTION  sys.profiler_openstream
+SYSTEM FUNCTION  sys.profiler_stethoscope
 SYSTEM FUNCTION  sys.quantile
 SYSTEM FUNCTION  sys.querycache
 SYSTEM FUNCTION  sys.querylog
@@ -1826,121 +1828,121 @@ 5957  "minflt"        "bigint"        64      0       
5961    NULL    tr
 5958   "majflt"        "bigint"        64      0       5961    NULL    true    
10      NULL
 5959   "nvcsw" "bigint"        64      0       5961    NULL    true    11      
NULL
 5960   "stmt"  "clob"  0       0       5961    NULL    true    12      NULL
-6084   "user"  "clob"  0       0       6090    NULL    true    0       NULL
-6085   "login" "timestamp"     7       0       6090    NULL    true    1       
NULL
-6086   "sessiontimeout"        "bigint"        64      0       6090    NULL    
true    2       NULL
-6087   "lastcommand"   "timestamp"     7       0       6090    NULL    true    
3       NULL
-6088   "querytimeout"  "bigint"        64      0       6090    NULL    true    
4       NULL
-6089   "active"        "boolean"       1       0       6090    NULL    true    
5       NULL
-6167   "name"  "clob"  0       0       6170    NULL    true    0       NULL
-6168   "def"   "clob"  0       0       6170    NULL    true    1       NULL
-6169   "status"        "clob"  0       0       6170    NULL    true    2       
NULL
-6176   "name"  "clob"  0       0       6178    NULL    true    0       NULL
-6177   "value" "clob"  0       0       6178    NULL    true    1       NULL
-6208   "qtag"  "bigint"        64      0       6216    NULL    true    0       
NULL
-6209   "user"  "clob"  0       0       6216    NULL    true    1       NULL
-6210   "started"       "timestamp"     7       0       6216    NULL    true    
2       NULL
-6211   "estimate"      "timestamp"     7       0       6216    NULL    true    
3       NULL
-6212   "progress"      "int"   32      0       6216    NULL    true    4       
NULL
-6213   "status"        "clob"  0       0       6216    NULL    true    5       
NULL
-6214   "tag"   "oid"   63      0       6216    NULL    true    6       NULL
-6215   "query" "clob"  0       0       6216    NULL    true    7       NULL
-6909   "schema"        "clob"  0       0       6922    NULL    true    0       
NULL
-6910   "table" "clob"  0       0       6922    NULL    true    1       NULL
-6911   "column"        "clob"  0       0       6922    NULL    true    2       
NULL
-6912   "type"  "clob"  0       0       6922    NULL    true    3       NULL
-6913   "mode"  "clob"  0       0       6922    NULL    true    4       NULL
-6914   "location"      "clob"  0       0       6922    NULL    true    5       
NULL
-6915   "count" "bigint"        64      0       6922    NULL    true    6       
NULL
-6916   "typewidth"     "int"   32      0       6922    NULL    true    7       
NULL
-6917   "columnsize"    "bigint"        64      0       6922    NULL    true    
8       NULL
-6918   "heapsize"      "bigint"        64      0       6922    NULL    true    
9       NULL
-6919   "hashes"        "bigint"        64      0       6922    NULL    true    
10      NULL
-6920   "imprints"      "bigint"        64      0       6922    NULL    true    
11      NULL
-6921   "sorted"        "boolean"       1       0       6922    NULL    true    
12      NULL
-6924   "schema"        "clob"  0       0       6934    NULL    true    0       
NULL
-6925   "table" "clob"  0       0       6934    NULL    true    1       NULL
-6926   "column"        "clob"  0       0       6934    NULL    true    2       
NULL
-6927   "type"  "clob"  0       0       6934    NULL    true    3       NULL
-6928   "typewidth"     "int"   32      0       6934    NULL    true    4       
NULL
-6929   "count" "bigint"        64      0       6934    NULL    true    5       
NULL
-6930   "distinct"      "bigint"        64      0       6934    NULL    true    
6       NULL
-6931   "atomwidth"     "int"   32      0       6934    NULL    true    7       
NULL
-6932   "reference"     "boolean"       1       0       6934    NULL    true    
8       NULL
-6933   "sorted"        "boolean"       1       0       6934    NULL    true    
9       NULL
-6972   "schema"        "clob"  0       0       6982    NULL    true    0       
NULL
-6973   "table" "clob"  0       0       6982    NULL    true    1       NULL
-6974   "column"        "clob"  0       0       6982    NULL    true    2       
NULL
-6975   "type"  "clob"  0       0       6982    NULL    true    3       NULL
-6976   "count" "bigint"        64      0       6982    NULL    true    4       
NULL
-6977   "columnsize"    "bigint"        64      0       6982    NULL    true    
5       NULL
-6978   "heapsize"      "bigint"        64      0       6982    NULL    true    
6       NULL
-6979   "hashes"        "bigint"        64      0       6982    NULL    true    
7       NULL
-6980   "imprints"      "bigint"        64      0       6982    NULL    true    
8       NULL
-6981   "sorted"        "boolean"       1       0       6982    NULL    true    
9       NULL
-6984   "schema"        "clob"  0       0       6992    NULL    true    0       
NULL
-6985   "table" "clob"  0       0       6992    NULL    true    1       NULL
-6986   "count" "bigint"        64      0       6992    NULL    true    2       
NULL
-6987   "columnsize"    "hugeint"       64      0       6992    NULL    true    
3       NULL
-6988   "heapsize"      "hugeint"       64      0       6992    NULL    true    
4       NULL
-6989   "hashes"        "hugeint"       64      0       6992    NULL    true    
5       NULL
-6990   "imprints"      "hugeint"       64      0       6992    NULL    true    
6       NULL
-6991   "auxiliary"     "hugeint"       128     0       6992    NULL    true    
7       NULL
-6994   "column_id"     "int"   32      0       7005    NULL    true    0       
NULL
-6995   "type"  "clob"  0       0       7005    NULL    true    1       NULL
-6996   "width" "int"   32      0       7005    NULL    true    2       NULL
-6997   "stamp" "timestamp"     7       0       7005    NULL    true    3       
NULL
-6998   "sample"        "bigint"        64      0       7005    NULL    true    
4       NULL
-6999   "count" "bigint"        64      0       7005    NULL    true    5       
NULL
-7000   "unique"        "bigint"        64      0       7005    NULL    true    
6       NULL
-7001   "nils"  "bigint"        64      0       7005    NULL    true    7       
NULL
-7002   "minval"        "clob"  0       0       7005    NULL    true    8       
NULL
-7003   "maxval"        "clob"  0       0       7005    NULL    true    9       
NULL
-7004   "sorted"        "boolean"       1       0       7005    NULL    true    
10      NULL
-7105   "file_id"       "bigint"        64      0       7113    NULL    false   
0       NULL
-7106   "file_location" "clob"  0       0       7113    NULL    false   1       
NULL
-7107   "dbschema"      "smallint"      16      0       7113    NULL    false   
2       NULL
-7108   "format_version"        "varchar"       7       0       7113    NULL    
true    3       NULL
-7109   "sorting_order" "varchar"       10      0       7113    NULL    true    
4       NULL
-7110   "comments"      "clob"  0       0       7113    NULL    true    5       
NULL
-7115   "sn"    "clob"  0       0       7126    NULL    false   0       NULL
-7116   "file_id"       "bigint"        64      0       7126    NULL    false   
1       NULL
-7117   "ln"    "int"   32      0       7126    NULL    true    2       NULL
-7118   "as"    "int"   32      0       7126    NULL    true    3       NULL
-7119   "m5"    "clob"  0       0       7126    NULL    true    4       NULL
-7120   "sp"    "clob"  0       0       7126    NULL    true    5       NULL
-7121   "ur"    "clob"  0       0       7126    NULL    true    6       NULL
-7128   "id"    "clob"  0       0       7145    NULL    false   0       NULL
-7129   "file_id"       "bigint"        64      0       7145    NULL    false   
1       NULL
-7130   "cn"    "clob"  0       0       7145    NULL    true    2       NULL
-7131   "ds"    "clob"  0       0       7145    NULL    true    3       NULL
-7132   "dt"    "timestamp"     7       0       7145    NULL    true    4       
NULL
-7133   "fo"    "clob"  0       0       7145    NULL    true    5       NULL
-7134   "ks"    "clob"  0       0       7145    NULL    true    6       NULL
-7135   "lb"    "clob"  0       0       7145    NULL    true    7       NULL
-7136   "pg"    "clob"  0       0       7145    NULL    true    8       NULL
-7137   "pi"    "int"   32      0       7145    NULL    true    9       NULL
-7138   "pl"    "clob"  0       0       7145    NULL    true    10      NULL
-7139   "pu"    "clob"  0       0       7145    NULL    true    11      NULL
-7140   "sm"    "clob"  0       0       7145    NULL    true    12      NULL
-7147   "id"    "clob"  0       0       7157    NULL    false   0       NULL
-7148   "file_id"       "bigint"        64      0       7157    NULL    false   
1       NULL
-7149   "pn"    "clob"  0       0       7157    NULL    true    2       NULL
-7150   "cl"    "clob"  0       0       7157    NULL    true    3       NULL
-7151   "pp"    "clob"  0       0       7157    NULL    true    4       NULL
-7152   "vn"    "clob"  0       0       7157    NULL    true    5       NULL
-7159   "qname" "clob"  0       0       7170    NULL    false   0       NULL
-7160   "flag"  "smallint"      16      0       7170    NULL    false   1       
NULL
-7161   "rname" "clob"  0       0       7170    NULL    false   2       NULL
-7162   "pos"   "int"   32      0       7170    NULL    false   3       NULL
-7163   "mapq"  "smallint"      16      0       7170    NULL    false   4       
NULL
-7164   "cigar" "clob"  0       0       7170    NULL    false   5       NULL
-7165   "rnext" "clob"  0       0       7170    NULL    false   6       NULL
-7166   "pnext" "int"   32      0       7170    NULL    false   7       NULL
-7167   "tlen"  "int"   32      0       7170    NULL    false   8       NULL
-7168   "seq"   "clob"  0       0       7170    NULL    false   9       NULL
-7169   "qual"  "clob"  0       0       7170    NULL    false   10      NULL
-7251   "function_id"   "int"   32      0       7252    NULL    true    0       
NULL
+6091   "user"  "clob"  0       0       6097    NULL    true    0       NULL
+6092   "login" "timestamp"     7       0       6097    NULL    true    1       
NULL
+6093   "sessiontimeout"        "bigint"        64      0       6097    NULL    
true    2       NULL
+6094   "lastcommand"   "timestamp"     7       0       6097    NULL    true    
3       NULL
+6095   "querytimeout"  "bigint"        64      0       6097    NULL    true    
4       NULL
+6096   "active"        "boolean"       1       0       6097    NULL    true    
5       NULL
+6174   "name"  "clob"  0       0       6177    NULL    true    0       NULL
+6175   "def"   "clob"  0       0       6177    NULL    true    1       NULL
+6176   "status"        "clob"  0       0       6177    NULL    true    2       
NULL
+6183   "name"  "clob"  0       0       6185    NULL    true    0       NULL
+6184   "value" "clob"  0       0       6185    NULL    true    1       NULL
+6215   "qtag"  "bigint"        64      0       6223    NULL    true    0       
NULL
+6216   "user"  "clob"  0       0       6223    NULL    true    1       NULL
+6217   "started"       "timestamp"     7       0       6223    NULL    true    
2       NULL
+6218   "estimate"      "timestamp"     7       0       6223    NULL    true    
3       NULL
+6219   "progress"      "int"   32      0       6223    NULL    true    4       
NULL
+6220   "status"        "clob"  0       0       6223    NULL    true    5       
NULL
+6221   "tag"   "oid"   63      0       6223    NULL    true    6       NULL
+6222   "query" "clob"  0       0       6223    NULL    true    7       NULL
+6916   "schema"        "clob"  0       0       6929    NULL    true    0       
NULL
+6917   "table" "clob"  0       0       6929    NULL    true    1       NULL
+6918   "column"        "clob"  0       0       6929    NULL    true    2       
NULL
+6919   "type"  "clob"  0       0       6929    NULL    true    3       NULL
+6920   "mode"  "clob"  0       0       6929    NULL    true    4       NULL
+6921   "location"      "clob"  0       0       6929    NULL    true    5       
NULL
+6922   "count" "bigint"        64      0       6929    NULL    true    6       
NULL
+6923   "typewidth"     "int"   32      0       6929    NULL    true    7       
NULL
+6924   "columnsize"    "bigint"        64      0       6929    NULL    true    
8       NULL
+6925   "heapsize"      "bigint"        64      0       6929    NULL    true    
9       NULL
+6926   "hashes"        "bigint"        64      0       6929    NULL    true    
10      NULL
+6927   "imprints"      "bigint"        64      0       6929    NULL    true    
11      NULL
+6928   "sorted"        "boolean"       1       0       6929    NULL    true    
12      NULL
+6931   "schema"        "clob"  0       0       6941    NULL    true    0       
NULL
+6932   "table" "clob"  0       0       6941    NULL    true    1       NULL
+6933   "column"        "clob"  0       0       6941    NULL    true    2       
NULL
+6934   "type"  "clob"  0       0       6941    NULL    true    3       NULL
+6935   "typewidth"     "int"   32      0       6941    NULL    true    4       
NULL
+6936   "count" "bigint"        64      0       6941    NULL    true    5       
NULL
+6937   "distinct"      "bigint"        64      0       6941    NULL    true    
6       NULL
+6938   "atomwidth"     "int"   32      0       6941    NULL    true    7       
NULL
+6939   "reference"     "boolean"       1       0       6941    NULL    true    
8       NULL
+6940   "sorted"        "boolean"       1       0       6941    NULL    true    
9       NULL
+6979   "schema"        "clob"  0       0       6989    NULL    true    0       
NULL
+6980   "table" "clob"  0       0       6989    NULL    true    1       NULL
+6981   "column"        "clob"  0       0       6989    NULL    true    2       
NULL
+6982   "type"  "clob"  0       0       6989    NULL    true    3       NULL
+6983   "count" "bigint"        64      0       6989    NULL    true    4       
NULL
+6984   "columnsize"    "bigint"        64      0       6989    NULL    true    
5       NULL
+6985   "heapsize"      "bigint"        64      0       6989    NULL    true    
6       NULL
+6986   "hashes"        "bigint"        64      0       6989    NULL    true    
7       NULL
+6987   "imprints"      "bigint"        64      0       6989    NULL    true    
8       NULL
+6988   "sorted"        "boolean"       1       0       6989    NULL    true    
9       NULL
+6991   "schema"        "clob"  0       0       6999    NULL    true    0       
NULL
+6992   "table" "clob"  0       0       6999    NULL    true    1       NULL
+6993   "count" "bigint"        64      0       6999    NULL    true    2       
NULL
+6994   "columnsize"    "hugeint"       64      0       6999    NULL    true    
3       NULL
+6995   "heapsize"      "hugeint"       64      0       6999    NULL    true    
4       NULL
+6996   "hashes"        "hugeint"       64      0       6999    NULL    true    
5       NULL
+6997   "imprints"      "hugeint"       64      0       6999    NULL    true    
6       NULL
+6998   "auxiliary"     "hugeint"       128     0       6999    NULL    true    
7       NULL
+7001   "column_id"     "int"   32      0       7012    NULL    true    0       
NULL
+7002   "type"  "clob"  0       0       7012    NULL    true    1       NULL
+7003   "width" "int"   32      0       7012    NULL    true    2       NULL
+7004   "stamp" "timestamp"     7       0       7012    NULL    true    3       
NULL
+7005   "sample"        "bigint"        64      0       7012    NULL    true    
4       NULL
+7006   "count" "bigint"        64      0       7012    NULL    true    5       
NULL
+7007   "unique"        "bigint"        64      0       7012    NULL    true    
6       NULL
+7008   "nils"  "bigint"        64      0       7012    NULL    true    7       
NULL
+7009   "minval"        "clob"  0       0       7012    NULL    true    8       
NULL
+7010   "maxval"        "clob"  0       0       7012    NULL    true    9       
NULL
+7011   "sorted"        "boolean"       1       0       7012    NULL    true    
10      NULL
+7112   "file_id"       "bigint"        64      0       7120    NULL    false   
0       NULL
+7113   "file_location" "clob"  0       0       7120    NULL    false   1       
NULL
+7114   "dbschema"      "smallint"      16      0       7120    NULL    false   
2       NULL
+7115   "format_version"        "varchar"       7       0       7120    NULL    
true    3       NULL
+7116   "sorting_order" "varchar"       10      0       7120    NULL    true    
4       NULL
+7117   "comments"      "clob"  0       0       7120    NULL    true    5       
NULL
+7122   "sn"    "clob"  0       0       7133    NULL    false   0       NULL
+7123   "file_id"       "bigint"        64      0       7133    NULL    false   
1       NULL
+7124   "ln"    "int"   32      0       7133    NULL    true    2       NULL
+7125   "as"    "int"   32      0       7133    NULL    true    3       NULL
+7126   "m5"    "clob"  0       0       7133    NULL    true    4       NULL
+7127   "sp"    "clob"  0       0       7133    NULL    true    5       NULL
+7128   "ur"    "clob"  0       0       7133    NULL    true    6       NULL
+7135   "id"    "clob"  0       0       7152    NULL    false   0       NULL
+7136   "file_id"       "bigint"        64      0       7152    NULL    false   
1       NULL
+7137   "cn"    "clob"  0       0       7152    NULL    true    2       NULL
+7138   "ds"    "clob"  0       0       7152    NULL    true    3       NULL
+7139   "dt"    "timestamp"     7       0       7152    NULL    true    4       
NULL
+7140   "fo"    "clob"  0       0       7152    NULL    true    5       NULL
+7141   "ks"    "clob"  0       0       7152    NULL    true    6       NULL
+7142   "lb"    "clob"  0       0       7152    NULL    true    7       NULL
+7143   "pg"    "clob"  0       0       7152    NULL    true    8       NULL
+7144   "pi"    "int"   32      0       7152    NULL    true    9       NULL
+7145   "pl"    "clob"  0       0       7152    NULL    true    10      NULL
+7146   "pu"    "clob"  0       0       7152    NULL    true    11      NULL
+7147   "sm"    "clob"  0       0       7152    NULL    true    12      NULL
+7154   "id"    "clob"  0       0       7164    NULL    false   0       NULL
+7155   "file_id"       "bigint"        64      0       7164    NULL    false   
1       NULL
+7156   "pn"    "clob"  0       0       7164    NULL    true    2       NULL
+7157   "cl"    "clob"  0       0       7164    NULL    true    3       NULL
+7158   "pp"    "clob"  0       0       7164    NULL    true    4       NULL
+7159   "vn"    "clob"  0       0       7164    NULL    true    5       NULL
+7166   "qname" "clob"  0       0       7177    NULL    false   0       NULL
+7167   "flag"  "smallint"      16      0       7177    NULL    false   1       
NULL
+7168   "rname" "clob"  0       0       7177    NULL    false   2       NULL
+7169   "pos"   "int"   32      0       7177    NULL    false   3       NULL
+7170   "mapq"  "smallint"      16      0       7177    NULL    false   4       
NULL
+7171   "cigar" "clob"  0       0       7177    NULL    false   5       NULL
+7172   "rnext" "clob"  0       0       7177    NULL    false   6       NULL
+7173   "pnext" "int"   32      0       7177    NULL    false   7       NULL
+7174   "tlen"  "int"   32      0       7177    NULL    false   8       NULL
+7175   "seq"   "clob"  0       0       7177    NULL    false   9       NULL
+7176   "qual"  "clob"  0       0       7177    NULL    false   10      NULL
+7258   "function_id"   "int"   32      0       7259    NULL    true    0       
NULL
 COMMIT;
 START TRANSACTION;
 CREATE TABLE "sys"."_tables" (
@@ -1984,21 +1986,21 @@ 5893    "querylog_catalog"      2000    "-- create 
 5904   "querylog_calls"        2000    "create view sys.querylog_calls as 
select * from sys.querylog_calls();" 1       true    0       0
 5922   "querylog_history"      2000    "create view sys.querylog_history 
as\nselect qd.*, ql.""start"",ql.""stop"", ql.arguments, ql.tuples, ql.run, 
ql.ship, ql.cpu, ql.io \nfrom sys.querylog_catalog() qd, sys.querylog_calls() 
ql\nwhere qd.id = ql.id and qd.owner = user;"       1       true    0       0
 5961   "tracelog"      2000    "create view sys.tracelog as select * from 
sys.tracelog();"     1       true    0       0
-6090   "sessions"      2000    "create view sys.sessions as select * from 
sys.sessions();"     1       true    0       0
-6170   "optimizers"    2000    "create view sys.optimizers as select * from 
sys.optimizers();" 1       true    0       0
-6178   "environment"   2000    "create view sys.environment as select * from 
sys.environment();"       1       true    0       0
-6216   "queue" 2000    "create view sys.queue as select * from sys.queue();"   
1       true    0       0
-6922   "storage"       2000    "create view sys.""storage"" as select * from 
sys.""storage""();"       1       true    0       0
-6934   "storagemodelinput"     2000    NULL    0       true    0       0
-6982   "storagemodel"  2000    "create view sys.storagemodel as select * from 
sys.storagemodel();"     1       true    0       0
-6992   "tablestoragemodel"     2000    "-- A summary of the table storage 
requirement is is available as a table view.\n-- The auxiliary 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 auxiliary\nfrom sys.storagemodel() group by 
""schema"",""table"";"   1       true    0       0
-7005   "statistics"    2000    NULL    0       true    0       0
-7113   "files" 7062    NULL    0       true    0       0
-7126   "sq"    7062    NULL    0       true    0       0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to