[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: pyapi - merged with default
From:       Hannes Muehleisen <commits () monetdb ! org>
Date:       2015-04-29 9:05:06
Message-ID: hg.6a45d6060d71.1430298306.6315528441665844383 () monetdb2 ! cwi-incubator ! nl
[Download RAW message or body]

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[:oi \
d,: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,:i \
nt],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,:i \
nt],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[:oi \
d,: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,:i \
nt],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,:i \
nt],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


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic