Changeset: 6a45d6060d71 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6a45d6060d71
Removed Files:
        clients/Tests/SQL-dump.stable.out.oid32
        clients/Tests/SQL-dump.stable.out.oid32.int128
Modified Files:
        .hgtags
        clients/Tests/All
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/SQL-dump.stable.out
        clients/Tests/SQL-dump.stable.out.int128
        clients/Tests/exports.stable.out
        configure.ag
        gdk/gdk_atomic.h
        gdk/gdk_calc.c
        gdk/gdk_system.c
        gdk/gdk_system.h
        gdk/gdk_utils.c
        monetdb5/mal/mal_dataflow.c
        sql/backends/monet5/sql.c
        sql/backends/monet5/sql.mal
        sql/backends/monet5/sql_upgrades.c
        sql/scripts/75_storagemodel.sql
        sql/storage/bat/bat_table.c
        sql/test/Tests/systemfunctions.stable.out
        sql/test/Tests/systemfunctions.stable.out.int128
        sql/test/leaks/Tests/check1.stable.out.int128
        sql/test/leaks/Tests/check2.stable.out.int128
        sql/test/leaks/Tests/check3.stable.out.int128
        sql/test/leaks/Tests/check4.stable.out.int128
        sql/test/leaks/Tests/check5.stable.out.int128
        testing/Mtest.py.in
Branch: pyapi
Log Message:

merged with default


diffs (truncated from 20494 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -589,3 +589,5 @@ 6607367487d91eb02c5eb7dfb9d96606f8f7c6f0
 e3d0eecdc35dc633fdd89157ba704f60f03756c1 Oct2014_9
 d98df578687e677ae3abbc0ba41e3bb0631ef08a Oct2014_SP2_release
 c80c3439c5d7b2bddb710e584eb0936adc21d462 MonetDB.R-0.9.6
+0529873485e7ec8e4c723f8bf7fc14020a7390b2 Oct2014_11
+f59ba5dedd0122403ab175cd1d44a88ab6b3be02 Oct2014_SP3_release
diff --git a/clients/Tests/All b/clients/Tests/All
--- a/clients/Tests/All
+++ b/clients/Tests/All
@@ -1,4 +1,4 @@
 exports
 
HAVE_NETCDF&HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIBR&HAVE_SAMTOOLS&HAVE_SPHINXCLIENT?MAL-signatures
-HAVE_NETCDF&HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_SAMTOOLS&!BITS32?SQL-dump
+HAVE_NETCDF&HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_SAMTOOLS&!BITS32&!BITS64OID32?SQL-dump
 MERCURIAL?malcheck
diff --git a/clients/Tests/MAL-signatures.stable.out 
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -40859,7 +40859,7 @@ pattern sql.sysmon_pause(tag:sht):void
 address SYSMONpause;
 pattern sql.sysmon_queue() 
(qtag:bat[:oid,:lng],user:bat[:oid,:str],started:bat[:oid,:timestamp],estimate:bat[:oid,:timestamp],progress:bat[:oid,:int],status:bat[:oid,:str],tag:bat[:oid,:oid],query:bat[:oid,:str])
 
 address SYSMONqueue;
-pattern sql.storage() 
(schema:bat[:oid,:str],table:bat[:oid,:str],column:bat[:oid,:str],type:bat[:oid,:str],mode:bat[:oid,:str],location:bat[:oid,:str],count:bat[:oid,:lng],atomwidth:bat[:oid,:int],columnsize:bat[:oid,:lng],heap:bat[:oid,:lng],hashes:bat[:oid,:lng],imprints:bat[:oid,:lng],sorted:bat[:oid,:bit])
 
+pattern sql.storage() 
(schema:bat[:oid,:str],table:bat[:oid,:str],column:bat[:oid,:str],type:bat[:oid,:str],mode:bat[:oid,:str],location:bat[:oid,:str],count:bat[:oid,:lng],atomwidth:bat[:oid,:int],columnsize:bat[:oid,:lng],heap:bat[:oid,:lng],hashes:bat[:oid,:lng],phash:bat[:oid,:bit],imprints:bat[:oid,:lng],sorted:bat[:oid,:bit])
 
 address sql_storage;
 comment return a table with storage information 
 
diff --git a/clients/Tests/MAL-signatures.stable.out.int128 
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -51802,7 +51802,7 @@ pattern sql.sysmon_pause(tag:sht):void
 address SYSMONpause;
 pattern sql.sysmon_queue() 
(qtag:bat[:oid,:lng],user:bat[:oid,:str],started:bat[:oid,:timestamp],estimate:bat[:oid,:timestamp],progress:bat[:oid,:int],status:bat[:oid,:str],tag:bat[:oid,:oid],query:bat[:oid,:str])
 
 address SYSMONqueue;
-pattern sql.storage() 
(schema:bat[:oid,:str],table:bat[:oid,:str],column:bat[:oid,:str],type:bat[:oid,:str],mode:bat[:oid,:str],location:bat[:oid,:str],count:bat[:oid,:lng],atomwidth:bat[:oid,:int],columnsize:bat[:oid,:lng],heap:bat[:oid,:lng],hashes:bat[:oid,:lng],imprints:bat[:oid,:lng],sorted:bat[:oid,:bit])
 
+pattern sql.storage() 
(schema:bat[:oid,:str],table:bat[:oid,:str],column:bat[:oid,:str],type:bat[:oid,:str],mode:bat[:oid,:str],location:bat[:oid,:str],count:bat[:oid,:lng],atomwidth:bat[:oid,:int],columnsize:bat[:oid,:lng],heap:bat[:oid,:lng],hashes:bat[:oid,:lng],phash:bat[:oid,:bit],imprints:bat[:oid,:lng],sorted:bat[:oid,:bit])
 
 address sql_storage;
 comment return a table with storage information 
 
diff --git a/clients/Tests/SQL-dump.stable.out 
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -1166,7 +1166,7 @@ external name sql.sysmon_stop;
 -- For strings we take a sample to determine their average length.
 
 create function sys."storage"()
-returns table ("schema" string, "table" string, "column" string, "type" 
string, "mode" string, location string, "count" bigint, typewidth int, 
columnsize bigint, heapsize bigint, hashes bigint, imprints bigint, sorted 
boolean)
+returns table ("schema" string, "table" string, "column" string, "type" 
string, "mode" string, location string, "count" bigint, typewidth int, 
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, imprints 
bigint, sorted boolean)
 external name sql."storage";
 create function sys.storagemodel()
 returns table (
@@ -1337,7 +1337,7 @@ CREATE TABLE "sys"."_columns" (
        "number"      INTEGER,
        "storage"     VARCHAR(2048)
 );
-COPY 351 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS 
'\t','\n','"';
+COPY 352 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS 
'\t','\n','"';
 2002   "id"    "int"   32      0       2001    NULL    true    0       NULL
 2003   "name"  "varchar"       1024    0       2001    NULL    true    1       
NULL
 2004   "authorization" "int"   32      0       2001    NULL    true    2       
NULL
diff --git a/clients/Tests/SQL-dump.stable.out.int128 
b/clients/Tests/SQL-dump.stable.out.int128
--- a/clients/Tests/SQL-dump.stable.out.int128
+++ b/clients/Tests/SQL-dump.stable.out.int128
@@ -1203,7 +1203,7 @@ external name sql.sysmon_stop;
 -- For strings we take a sample to determine their average length.
 
 create function sys."storage"()
-returns table ("schema" string, "table" string, "column" string, "type" 
string, "mode" string, location string, "count" bigint, typewidth int, 
columnsize bigint, heapsize bigint, hashes bigint, imprints bigint, sorted 
boolean)
+returns table ("schema" string, "table" string, "column" string, "type" 
string, "mode" string, location string, "count" bigint, typewidth int, 
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, imprints 
bigint, sorted boolean)
 external name sql."storage";
 create function sys.storagemodel()
 returns table (
@@ -1378,7 +1378,7 @@ CREATE TABLE "sys"."_columns" (
        "number"      INTEGER,
        "storage"     VARCHAR(2048)
 );
-COPY 351 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS 
'\t','\n','"';
+COPY 352 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS 
'\t','\n','"';
 2002   "id"    "int"   32      0       2001    NULL    true    0       NULL
 2003   "name"  "varchar"       1024    0       2001    NULL    true    1       
NULL
 2004   "authorization" "int"   32      0       2001    NULL    true    2       
NULL
@@ -1634,102 +1634,103 @@ 6938  "att_type"      "varchar"       64      0       
6942    NULL
 6939   "value" "clob"  0       0       6942    NULL    true    3       NULL
 6940   "file_id"       "int"   32      0       6942    NULL    true    4       
NULL
 6941   "gr_name"       "varchar"       256     0       6942    NULL    true    
5       NULL
-6966   "schema"        "clob"  0       0       6979    NULL    true    0       
NULL
-6967   "table" "clob"  0       0       6979    NULL    true    1       NULL
-6968   "column"        "clob"  0       0       6979    NULL    true    2       
NULL
-6969   "type"  "clob"  0       0       6979    NULL    true    3       NULL
-6970   "mode"  "clob"  0       0       6979    NULL    true    4       NULL
-6971   "location"      "clob"  0       0       6979    NULL    true    5       
NULL
-6972   "count" "bigint"        64      0       6979    NULL    true    6       
NULL
-6973   "typewidth"     "int"   32      0       6979    NULL    true    7       
NULL
-6974   "columnsize"    "bigint"        64      0       6979    NULL    true    
8       NULL
-6975   "heapsize"      "bigint"        64      0       6979    NULL    true    
9       NULL
-6976   "hashes"        "bigint"        64      0       6979    NULL    true    
10      NULL
-6977   "imprints"      "bigint"        64      0       6979    NULL    true    
11      NULL
-6978   "sorted"        "boolean"       1       0       6979    NULL    true    
12      NULL
-6981   "schema"        "clob"  0       0       6991    NULL    true    0       
NULL
-6982   "table" "clob"  0       0       6991    NULL    true    1       NULL
-6983   "column"        "clob"  0       0       6991    NULL    true    2       
NULL
-6984   "type"  "clob"  0       0       6991    NULL    true    3       NULL
-6985   "typewidth"     "int"   32      0       6991    NULL    true    4       
NULL
-6986   "count" "bigint"        64      0       6991    NULL    true    5       
NULL
-6987   "distinct"      "bigint"        64      0       6991    NULL    true    
6       NULL
-6988   "atomwidth"     "int"   32      0       6991    NULL    true    7       
NULL
-6989   "reference"     "boolean"       1       0       6991    NULL    true    
8       NULL
-6990   "sorted"        "boolean"       1       0       6991    NULL    true    
9       NULL
-7029   "schema"        "clob"  0       0       7039    NULL    true    0       
NULL
-7030   "table" "clob"  0       0       7039    NULL    true    1       NULL
-7031   "column"        "clob"  0       0       7039    NULL    true    2       
NULL
-7032   "type"  "clob"  0       0       7039    NULL    true    3       NULL
-7033   "count" "bigint"        64      0       7039    NULL    true    4       
NULL
-7034   "columnsize"    "bigint"        64      0       7039    NULL    true    
5       NULL
-7035   "heapsize"      "bigint"        64      0       7039    NULL    true    
6       NULL
-7036   "hashes"        "bigint"        64      0       7039    NULL    true    
7       NULL
-7037   "imprints"      "bigint"        64      0       7039    NULL    true    
8       NULL
-7038   "sorted"        "boolean"       1       0       7039    NULL    true    
9       NULL
-7041   "schema"        "clob"  0       0       7049    NULL    true    0       
NULL
-7042   "table" "clob"  0       0       7049    NULL    true    1       NULL
-7043   "count" "bigint"        64      0       7049    NULL    true    2       
NULL
-7044   "columnsize"    "hugeint"       128     0       7049    NULL    true    
3       NULL
-7045   "heapsize"      "hugeint"       128     0       7049    NULL    true    
4       NULL
-7046   "hashes"        "hugeint"       128     0       7049    NULL    true    
5       NULL
-7047   "imprints"      "hugeint"       128     0       7049    NULL    true    
6       NULL
-7048   "auxiliary"     "hugeint"       128     0       7049    NULL    true    
7       NULL
-7051   "column_id"     "int"   32      0       7062    NULL    true    0       
NULL
-7052   "type"  "clob"  0       0       7062    NULL    true    1       NULL
-7053   "width" "int"   32      0       7062    NULL    true    2       NULL
-7054   "stamp" "timestamp"     7       0       7062    NULL    true    3       
NULL
-7055   "sample"        "bigint"        64      0       7062    NULL    true    
4       NULL
-7056   "count" "bigint"        64      0       7062    NULL    true    5       
NULL
-7057   "unique"        "bigint"        64      0       7062    NULL    true    
6       NULL
-7058   "nils"  "bigint"        64      0       7062    NULL    true    7       
NULL
-7059   "minval"        "clob"  0       0       7062    NULL    true    8       
NULL
-7060   "maxval"        "clob"  0       0       7062    NULL    true    9       
NULL
-7061   "sorted"        "boolean"       1       0       7062    NULL    true    
10      NULL
-7162   "file_id"       "bigint"        64      0       7170    NULL    false   
0       NULL
-7163   "file_location" "clob"  0       0       7170    NULL    false   1       
NULL
-7164   "dbschema"      "smallint"      16      0       7170    NULL    false   
2       NULL
-7165   "format_version"        "varchar"       7       0       7170    NULL    
true    3       NULL
-7166   "sorting_order" "varchar"       10      0       7170    NULL    true    
4       NULL
-7167   "comments"      "clob"  0       0       7170    NULL    true    5       
NULL
-7172   "sn"    "clob"  0       0       7183    NULL    false   0       NULL
-7173   "file_id"       "bigint"        64      0       7183    NULL    false   
1       NULL
-7174   "ln"    "int"   32      0       7183    NULL    true    2       NULL
-7175   "as"    "int"   32      0       7183    NULL    true    3       NULL
-7176   "m5"    "clob"  0       0       7183    NULL    true    4       NULL
-7177   "sp"    "clob"  0       0       7183    NULL    true    5       NULL
-7178   "ur"    "clob"  0       0       7183    NULL    true    6       NULL
-7185   "id"    "clob"  0       0       7202    NULL    false   0       NULL
-7186   "file_id"       "bigint"        64      0       7202    NULL    false   
1       NULL
-7187   "cn"    "clob"  0       0       7202    NULL    true    2       NULL
-7188   "ds"    "clob"  0       0       7202    NULL    true    3       NULL
-7189   "dt"    "timestamp"     7       0       7202    NULL    true    4       
NULL
-7190   "fo"    "clob"  0       0       7202    NULL    true    5       NULL
-7191   "ks"    "clob"  0       0       7202    NULL    true    6       NULL
-7192   "lb"    "clob"  0       0       7202    NULL    true    7       NULL
-7193   "pg"    "clob"  0       0       7202    NULL    true    8       NULL
-7194   "pi"    "int"   32      0       7202    NULL    true    9       NULL
-7195   "pl"    "clob"  0       0       7202    NULL    true    10      NULL
-7196   "pu"    "clob"  0       0       7202    NULL    true    11      NULL
-7197   "sm"    "clob"  0       0       7202    NULL    true    12      NULL
-7204   "id"    "clob"  0       0       7214    NULL    false   0       NULL
-7205   "file_id"       "bigint"        64      0       7214    NULL    false   
1       NULL
-7206   "pn"    "clob"  0       0       7214    NULL    true    2       NULL
-7207   "cl"    "clob"  0       0       7214    NULL    true    3       NULL
-7208   "pp"    "clob"  0       0       7214    NULL    true    4       NULL
-7209   "vn"    "clob"  0       0       7214    NULL    true    5       NULL
-7216   "qname" "clob"  0       0       7227    NULL    false   0       NULL
-7217   "flag"  "smallint"      16      0       7227    NULL    false   1       
NULL
-7218   "rname" "clob"  0       0       7227    NULL    false   2       NULL
-7219   "pos"   "int"   32      0       7227    NULL    false   3       NULL
-7220   "mapq"  "smallint"      16      0       7227    NULL    false   4       
NULL
-7221   "cigar" "clob"  0       0       7227    NULL    false   5       NULL
-7222   "rnext" "clob"  0       0       7227    NULL    false   6       NULL
-7223   "pnext" "int"   32      0       7227    NULL    false   7       NULL
-7224   "tlen"  "int"   32      0       7227    NULL    false   8       NULL
-7225   "seq"   "clob"  0       0       7227    NULL    false   9       NULL
-7226   "qual"  "clob"  0       0       7227    NULL    false   10      NULL
-7308   "function_id"   "int"   32      0       7309    NULL    true    0       
NULL
+6967   "schema"        "clob"  0       0       6981    NULL    true    0       
NULL
+6968   "table" "clob"  0       0       6981    NULL    true    1       NULL
+6969   "column"        "clob"  0       0       6981    NULL    true    2       
NULL
+6970   "type"  "clob"  0       0       6981    NULL    true    3       NULL
+6971   "mode"  "clob"  0       0       6981    NULL    true    4       NULL
+6972   "location"      "clob"  0       0       6981    NULL    true    5       
NULL
+6973   "count" "bigint"        64      0       6981    NULL    true    6       
NULL
+6974   "typewidth"     "int"   32      0       6981    NULL    true    7       
NULL
+6975   "columnsize"    "bigint"        64      0       6981    NULL    true    
8       NULL
+6976   "heapsize"      "bigint"        64      0       6981    NULL    true    
9       NULL
+6977   "hashes"        "bigint"        64      0       6981    NULL    true    
10      NULL
+6978   "phash" "boolean"       1       0       6981    NULL    true    11      
NULL
+6979   "imprints"      "bigint"        64      0       6981    NULL    true    
12      NULL
+6980   "sorted"        "boolean"       1       0       6981    NULL    true    
13      NULL
+6983   "schema"        "clob"  0       0       6993    NULL    true    0       
NULL
+6984   "table" "clob"  0       0       6993    NULL    true    1       NULL
+6985   "column"        "clob"  0       0       6993    NULL    true    2       
NULL
+6986   "type"  "clob"  0       0       6993    NULL    true    3       NULL
+6987   "typewidth"     "int"   32      0       6993    NULL    true    4       
NULL
+6988   "count" "bigint"        64      0       6993    NULL    true    5       
NULL
+6989   "distinct"      "bigint"        64      0       6993    NULL    true    
6       NULL
+6990   "atomwidth"     "int"   32      0       6993    NULL    true    7       
NULL
+6991   "reference"     "boolean"       1       0       6993    NULL    true    
8       NULL
+6992   "sorted"        "boolean"       1       0       6993    NULL    true    
9       NULL
+7031   "schema"        "clob"  0       0       7041    NULL    true    0       
NULL
+7032   "table" "clob"  0       0       7041    NULL    true    1       NULL
+7033   "column"        "clob"  0       0       7041    NULL    true    2       
NULL
+7034   "type"  "clob"  0       0       7041    NULL    true    3       NULL
+7035   "count" "bigint"        64      0       7041    NULL    true    4       
NULL
+7036   "columnsize"    "bigint"        64      0       7041    NULL    true    
5       NULL
+7037   "heapsize"      "bigint"        64      0       7041    NULL    true    
6       NULL
+7038   "hashes"        "bigint"        64      0       7041    NULL    true    
7       NULL
+7039   "imprints"      "bigint"        64      0       7041    NULL    true    
8       NULL
+7040   "sorted"        "boolean"       1       0       7041    NULL    true    
9       NULL
+7043   "schema"        "clob"  0       0       7051    NULL    true    0       
NULL
+7044   "table" "clob"  0       0       7051    NULL    true    1       NULL
+7045   "count" "bigint"        64      0       7051    NULL    true    2       
NULL
+7046   "columnsize"    "hugeint"       128     0       7051    NULL    true    
3       NULL
+7047   "heapsize"      "hugeint"       128     0       7051    NULL    true    
4       NULL
+7048   "hashes"        "hugeint"       128     0       7051    NULL    true    
5       NULL
+7049   "imprints"      "hugeint"       128     0       7051    NULL    true    
6       NULL
+7050   "auxiliary"     "hugeint"       128     0       7051    NULL    true    
7       NULL
+7053   "column_id"     "int"   32      0       7064    NULL    true    0       
NULL
+7054   "type"  "clob"  0       0       7064    NULL    true    1       NULL
+7055   "width" "int"   32      0       7064    NULL    true    2       NULL
+7056   "stamp" "timestamp"     7       0       7064    NULL    true    3       
NULL
+7057   "sample"        "bigint"        64      0       7064    NULL    true    
4       NULL
+7058   "count" "bigint"        64      0       7064    NULL    true    5       
NULL
+7059   "unique"        "bigint"        64      0       7064    NULL    true    
6       NULL
+7060   "nils"  "bigint"        64      0       7064    NULL    true    7       
NULL
+7061   "minval"        "clob"  0       0       7064    NULL    true    8       
NULL
+7062   "maxval"        "clob"  0       0       7064    NULL    true    9       
NULL
+7063   "sorted"        "boolean"       1       0       7064    NULL    true    
10      NULL
+7164   "file_id"       "bigint"        64      0       7172    NULL    false   
0       NULL
+7165   "file_location" "clob"  0       0       7172    NULL    false   1       
NULL
+7166   "dbschema"      "smallint"      16      0       7172    NULL    false   
2       NULL
+7167   "format_version"        "varchar"       7       0       7172    NULL    
true    3       NULL
+7168   "sorting_order" "varchar"       10      0       7172    NULL    true    
4       NULL
+7169   "comments"      "clob"  0       0       7172    NULL    true    5       
NULL
+7174   "sn"    "clob"  0       0       7185    NULL    false   0       NULL
+7175   "file_id"       "bigint"        64      0       7185    NULL    false   
1       NULL
+7176   "ln"    "int"   32      0       7185    NULL    true    2       NULL
+7177   "as"    "int"   32      0       7185    NULL    true    3       NULL
+7178   "m5"    "clob"  0       0       7185    NULL    true    4       NULL
+7179   "sp"    "clob"  0       0       7185    NULL    true    5       NULL
+7180   "ur"    "clob"  0       0       7185    NULL    true    6       NULL
+7187   "id"    "clob"  0       0       7204    NULL    false   0       NULL
+7188   "file_id"       "bigint"        64      0       7204    NULL    false   
1       NULL
+7189   "cn"    "clob"  0       0       7204    NULL    true    2       NULL
+7190   "ds"    "clob"  0       0       7204    NULL    true    3       NULL
+7191   "dt"    "timestamp"     7       0       7204    NULL    true    4       
NULL
+7192   "fo"    "clob"  0       0       7204    NULL    true    5       NULL
+7193   "ks"    "clob"  0       0       7204    NULL    true    6       NULL
+7194   "lb"    "clob"  0       0       7204    NULL    true    7       NULL
+7195   "pg"    "clob"  0       0       7204    NULL    true    8       NULL
+7196   "pi"    "int"   32      0       7204    NULL    true    9       NULL
+7197   "pl"    "clob"  0       0       7204    NULL    true    10      NULL
+7198   "pu"    "clob"  0       0       7204    NULL    true    11      NULL
+7199   "sm"    "clob"  0       0       7204    NULL    true    12      NULL
+7206   "id"    "clob"  0       0       7216    NULL    false   0       NULL
+7207   "file_id"       "bigint"        64      0       7216    NULL    false   
1       NULL
+7208   "pn"    "clob"  0       0       7216    NULL    true    2       NULL
+7209   "cl"    "clob"  0       0       7216    NULL    true    3       NULL
+7210   "pp"    "clob"  0       0       7216    NULL    true    4       NULL
+7211   "vn"    "clob"  0       0       7216    NULL    true    5       NULL
+7218   "qname" "clob"  0       0       7229    NULL    false   0       NULL
+7219   "flag"  "smallint"      16      0       7229    NULL    false   1       
NULL
+7220   "rname" "clob"  0       0       7229    NULL    false   2       NULL
+7221   "pos"   "int"   32      0       7229    NULL    false   3       NULL
+7222   "mapq"  "smallint"      16      0       7229    NULL    false   4       
NULL
+7223   "cigar" "clob"  0       0       7229    NULL    false   5       NULL
+7224   "rnext" "clob"  0       0       7229    NULL    false   6       NULL
+7225   "pnext" "int"   32      0       7229    NULL    false   7       NULL
+7226   "tlen"  "int"   32      0       7229    NULL    false   8       NULL
+7227   "seq"   "clob"  0       0       7229    NULL    false   9       NULL
+7228   "qual"  "clob"  0       0       7229    NULL    false   10      NULL
+7310   "function_id"   "int"   32      0       7311    NULL    true    0       
NULL
 COMMIT;
 START TRANSACTION;
 CREATE TABLE "sys"."_tables" (
@@ -1782,17 +1783,17 @@ 6920    "netcdf_dims"   2000    NULL    0       true    
0       0
 6928   "netcdf_vars"   2000    NULL    0       true    0       0
 6934   "netcdf_vardim" 2000    NULL    0       true    0       0
 6942   "netcdf_attrs"  2000    NULL    0       true    0       0
-6979   "storage"       2000    "create view sys.""storage"" as select * from 
sys.""storage""();"       1       true    0       0
-6991   "storagemodelinput"     2000    NULL    0       true    0       0
-7039   "storagemodel"  2000    "create view sys.storagemodel as select * from 
sys.storagemodel();"     1       true    0       0
-7049   "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
-7062   "statistics"    2000    NULL    0       true    0       0
-7170   "files" 7119    NULL    0       true    0       0
-7183   "sq"    7119    NULL    0       true    0       0
-7202   "rg"    7119    NULL    0       true    0       0
-7214   "pg"    7119    NULL    0       true    0       0
-7227   "export"        7119    NULL    0       true    0       0
-7309   "systemfunctions"       2000    NULL    0       true    0       0
+6981   "storage"       2000    "create view sys.""storage"" as select * from 
sys.""storage""();"       1       true    0       0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to