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
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list