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