Changeset: 67ee5467d9ec for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=67ee5467d9ec
Modified Files:
        clients/Tests/SQL-dump_all.stable.out.int128
        clients/Tests/exports.stable.out
        monetdb5/modules/mal/mosaic.c
        sql/backends/monet5/sql.mal
        sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/02-explain.stable.out
        sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/04-explain.stable.out
        sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/13-explain.stable.out
        sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/21-explain.stable.out
        sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out
        sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
        sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
        sql/test/Tests/systemfunctions_bam.stable.out.int128
        sql/test/mergetables/Tests/mergequery.stable.out
        sql/test/mosaic/Tests/compressionRLE.stable.out
Branch: mosaic
Log Message:

Approve merge with default


diffs (truncated from 4927 to 300 lines):

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
@@ -265,7 +265,7 @@ CREATE TABLE "sys"."_tables" (
        "type"          SMALLINT,
        "system"        BOOLEAN,
        "commit_action" SMALLINT,
-       "readonly"      BOOLEAN
+       "access"        SMALLINT
 );
 CREATE TABLE "sys"."args" (
        "id"          INTEGER,
@@ -424,7 +424,7 @@ from sys.querylog_catalog() qd, sys.quer
 where qd.id = ql.id and qd.owner = user;
 create view sys.queue as select * from sys.queue();
 create view sys.sessions as select * from sys.sessions();
-create view sys.storage as select * from sys.storage();
+create view sys."storage" as select * from sys."storage"();
 create view sys.storagemodel as select * from sys.storagemodel();
 SELECT * FROM (SELECT p.*, 0 AS "temporary" FROM "sys"."_tables" AS p UNION 
ALL SELECT t.*, 1 AS "temporary" FROM "tmp"."_tables" AS t) AS tables where 
tables.type <> 2;
 -- A summary of the table storage requirement is is available as a table view.
@@ -1417,9 +1417,9 @@ external name sql.sysmon_stop;
 -- of columns and foreign key indices, and possible temporary hash indices.
 -- 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, location string, "count" bigint, typewidth int, columnsize bigint, 
heapsize bigint, hashes bigint, imprints bigint, sorted boolean)
-external name sql.storage;
+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, compress boolean)
+external name sql."storage";
 create function sys.storagemodel()
 returns table (
        "schema" string,
@@ -1449,7 +1449,7 @@ begin
        delete from sys.storagemodelinput;
 
        insert into sys.storagemodelinput
-       select x."schema", x."table", x."column", x."type", x.typewidth, 
x.count, 0, x.typewidth, false, x.sorted from sys.storage() x;
+       select x."schema", x."table", x."column", x."type", x.typewidth, 
x.count, 0, x.typewidth, false, x.sorted from sys."storage"() x;
 
        update sys.storagemodelinput
        set reference = true
@@ -1637,7 +1637,7 @@ CREATE TABLE "sys"."_columns" (
        "number"      INTEGER,
        "storage"     VARCHAR(2048)
 );
-COPY 328 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS 
'\t','\n','"';
+COPY 330 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
@@ -1696,7 +1696,7 @@ 2063      "query" "varchar"       2048    0       2059    
NULL    
 2064   "type"  "smallint"      16      0       2059    NULL    true    4       
NULL
 2065   "system"        "boolean"       1       0       2059    NULL    true    
5       NULL
 2066   "commit_action" "smallint"      16      0       2059    NULL    true    
6       NULL
-2067   "readonly"      "boolean"       1       0       2059    NULL    true    
7       NULL
+2067   "access"        "smallint"      16      0       2059    NULL    true    
7       NULL
 2069   "id"    "int"   32      0       2068    NULL    true    0       NULL
 2070   "name"  "varchar"       1024    0       2068    NULL    true    1       
NULL
 2071   "type"  "varchar"       1024    0       2068    NULL    true    2       
NULL
@@ -1737,7 +1737,7 @@ 2111      "query" "varchar"       2048    0       2107    
NULL    
 2112   "type"  "smallint"      16      0       2107    NULL    true    4       
NULL
 2113   "system"        "boolean"       1       0       2107    NULL    true    
5       NULL
 2114   "commit_action" "smallint"      16      0       2107    NULL    true    
6       NULL
-2115   "readonly"      "boolean"       1       0       2107    NULL    true    
7       NULL
+2115   "access"        "smallint"      16      0       2107    NULL    true    
7       NULL
 2117   "id"    "int"   32      0       2116    NULL    true    0       NULL
 2118   "name"  "varchar"       1024    0       2116    NULL    true    1       
NULL
 2119   "type"  "varchar"       1024    0       2116    NULL    true    2       
NULL
@@ -1778,7 +1778,7 @@ 5652      "query" "varchar"       2048    0       5648    
NULL    
 5653   "type"  "smallint"      16      0       5648    NULL    true    4       
NULL
 5654   "system"        "boolean"       1       0       5648    NULL    true    
5       NULL
 5655   "commit_action" "smallint"      16      0       5648    NULL    true    
6       NULL
-5656   "readonly"      "boolean"       1       0       5648    NULL    true    
7       NULL
+5656   "access"        "smallint"      16      0       5648    NULL    true    
7       NULL
 5657   "temporary"     "smallint"      16      0       5648    NULL    true    
8       NULL
 5659   "id"    "int"   32      0       5658    NULL    true    0       NULL
 5660   "name"  "varchar"       1024    0       5658    NULL    true    1       
NULL
@@ -1871,101 +1871,103 @@ 6200  "progress"      "int"   32      0       6204    
NULL    tru
 6201   "status"        "clob"  0       0       6204    NULL    true    5       
NULL
 6202   "tag"   "oid"   63      0       6204    NULL    true    6       NULL
 6203   "query" "clob"  0       0       6204    NULL    true    7       NULL
-6896   "schema"        "clob"  0       0       6908    NULL    true    0       
NULL
-6897   "table" "clob"  0       0       6908    NULL    true    1       NULL
-6898   "column"        "clob"  0       0       6908    NULL    true    2       
NULL
-6899   "type"  "clob"  0       0       6908    NULL    true    3       NULL
-6900   "location"      "clob"  0       0       6908    NULL    true    4       
NULL
-6901   "count" "bigint"        64      0       6908    NULL    true    5       
NULL
-6902   "typewidth"     "int"   32      0       6908    NULL    true    6       
NULL
-6903   "columnsize"    "bigint"        64      0       6908    NULL    true    
7       NULL
-6904   "heapsize"      "bigint"        64      0       6908    NULL    true    
8       NULL
-6905   "hashes"        "bigint"        64      0       6908    NULL    true    
9       NULL
-6906   "imprints"      "bigint"        64      0       6908    NULL    true    
10      NULL
-6907   "sorted"        "boolean"       1       0       6908    NULL    true    
11      NULL
-6910   "schema"        "clob"  0       0       6920    NULL    true    0       
NULL
-6911   "table" "clob"  0       0       6920    NULL    true    1       NULL
-6912   "column"        "clob"  0       0       6920    NULL    true    2       
NULL
-6913   "type"  "clob"  0       0       6920    NULL    true    3       NULL
-6914   "typewidth"     "int"   32      0       6920    NULL    true    4       
NULL
-6915   "count" "bigint"        64      0       6920    NULL    true    5       
NULL
-6916   "distinct"      "bigint"        64      0       6920    NULL    true    
6       NULL
-6917   "atomwidth"     "int"   32      0       6920    NULL    true    7       
NULL
-6918   "reference"     "boolean"       1       0       6920    NULL    true    
8       NULL
-6919   "sorted"        "boolean"       1       0       6920    NULL    true    
9       NULL
-6958   "schema"        "clob"  0       0       6968    NULL    true    0       
NULL
-6959   "table" "clob"  0       0       6968    NULL    true    1       NULL
-6960   "column"        "clob"  0       0       6968    NULL    true    2       
NULL
-6961   "type"  "clob"  0       0       6968    NULL    true    3       NULL
-6962   "count" "bigint"        64      0       6968    NULL    true    4       
NULL
-6963   "columnsize"    "bigint"        64      0       6968    NULL    true    
5       NULL
-6964   "heapsize"      "bigint"        64      0       6968    NULL    true    
6       NULL
-6965   "hashes"        "bigint"        64      0       6968    NULL    true    
7       NULL
-6966   "imprints"      "bigint"        64      0       6968    NULL    true    
8       NULL
-6967   "sorted"        "boolean"       1       0       6968    NULL    true    
9       NULL
-6970   "schema"        "clob"  0       0       6978    NULL    true    0       
NULL
-6971   "table" "clob"  0       0       6978    NULL    true    1       NULL
-6972   "count" "bigint"        64      0       6978    NULL    true    2       
NULL
-6973   "columnsize"    "hugeint"       64      0       6978    NULL    true    
3       NULL
-6974   "heapsize"      "hugeint"       64      0       6978    NULL    true    
4       NULL
-6975   "hashes"        "hugeint"       64      0       6978    NULL    true    
5       NULL
-6976   "imprints"      "hugeint"       64      0       6978    NULL    true    
6       NULL
-6977   "auxiliary"     "hugeint"       128     0       6978    NULL    true    
7       NULL
-6980   "column_id"     "int"   32      0       6991    NULL    true    0       
NULL
-6981   "type"  "clob"  0       0       6991    NULL    true    1       NULL
-6982   "width" "int"   32      0       6991    NULL    true    2       NULL
-6983   "stamp" "timestamp"     7       0       6991    NULL    true    3       
NULL
-6984   "sample"        "bigint"        64      0       6991    NULL    true    
4       NULL
-6985   "count" "bigint"        64      0       6991    NULL    true    5       
NULL
-6986   "unique"        "bigint"        64      0       6991    NULL    true    
6       NULL
-6987   "nils"  "bigint"        64      0       6991    NULL    true    7       
NULL
-6988   "minval"        "clob"  0       0       6991    NULL    true    8       
NULL
-6989   "maxval"        "clob"  0       0       6991    NULL    true    9       
NULL
-6990   "sorted"        "boolean"       1       0       6991    NULL    true    
10      NULL
-7091   "file_id"       "bigint"        64      0       7099    NULL    false   
0       NULL
-7092   "file_location" "clob"  0       0       7099    NULL    false   1       
NULL
-7093   "dbschema"      "smallint"      16      0       7099    NULL    false   
2       NULL
-7094   "format_version"        "varchar"       7       0       7099    NULL    
true    3       NULL
-7095   "sorting_order" "varchar"       10      0       7099    NULL    true    
4       NULL
-7096   "comments"      "clob"  0       0       7099    NULL    true    5       
NULL
-7101   "sn"    "clob"  0       0       7112    NULL    false   0       NULL
-7102   "file_id"       "bigint"        64      0       7112    NULL    false   
1       NULL
-7103   "ln"    "int"   32      0       7112    NULL    true    2       NULL
-7104   "as"    "int"   32      0       7112    NULL    true    3       NULL
-7105   "m5"    "clob"  0       0       7112    NULL    true    4       NULL
-7106   "sp"    "clob"  0       0       7112    NULL    true    5       NULL
-7107   "ur"    "clob"  0       0       7112    NULL    true    6       NULL
-7114   "id"    "clob"  0       0       7131    NULL    false   0       NULL
-7115   "file_id"       "bigint"        64      0       7131    NULL    false   
1       NULL
-7116   "cn"    "clob"  0       0       7131    NULL    true    2       NULL
-7117   "ds"    "clob"  0       0       7131    NULL    true    3       NULL
-7118   "dt"    "timestamp"     7       0       7131    NULL    true    4       
NULL
-7119   "fo"    "clob"  0       0       7131    NULL    true    5       NULL
-7120   "ks"    "clob"  0       0       7131    NULL    true    6       NULL
-7121   "lb"    "clob"  0       0       7131    NULL    true    7       NULL
-7122   "pg"    "clob"  0       0       7131    NULL    true    8       NULL
-7123   "pi"    "int"   32      0       7131    NULL    true    9       NULL
-7124   "pl"    "clob"  0       0       7131    NULL    true    10      NULL
-7125   "pu"    "clob"  0       0       7131    NULL    true    11      NULL
-7126   "sm"    "clob"  0       0       7131    NULL    true    12      NULL
-7133   "id"    "clob"  0       0       7143    NULL    false   0       NULL
-7134   "file_id"       "bigint"        64      0       7143    NULL    false   
1       NULL
-7135   "pn"    "clob"  0       0       7143    NULL    true    2       NULL
-7136   "cl"    "clob"  0       0       7143    NULL    true    3       NULL
-7137   "pp"    "clob"  0       0       7143    NULL    true    4       NULL
-7138   "vn"    "clob"  0       0       7143    NULL    true    5       NULL
-7145   "qname" "clob"  0       0       7156    NULL    false   0       NULL
-7146   "flag"  "smallint"      16      0       7156    NULL    false   1       
NULL
-7147   "rname" "clob"  0       0       7156    NULL    false   2       NULL
-7148   "pos"   "int"   32      0       7156    NULL    false   3       NULL
-7149   "mapq"  "smallint"      16      0       7156    NULL    false   4       
NULL
-7150   "cigar" "clob"  0       0       7156    NULL    false   5       NULL
-7151   "rnext" "clob"  0       0       7156    NULL    false   6       NULL
-7152   "pnext" "int"   32      0       7156    NULL    false   7       NULL
-7153   "tlen"  "int"   32      0       7156    NULL    false   8       NULL
-7154   "seq"   "clob"  0       0       7156    NULL    false   9       NULL
-7155   "qual"  "clob"  0       0       7156    NULL    false   10      NULL
-7237   "function_id"   "int"   32      0       7238    NULL    true    0       
NULL
+6898   "schema"        "clob"  0       0       6912    NULL    true    0       
NULL
+6899   "table" "clob"  0       0       6912    NULL    true    1       NULL
+6900   "column"        "clob"  0       0       6912    NULL    true    2       
NULL
+6901   "type"  "clob"  0       0       6912    NULL    true    3       NULL
+6902   "mode"  "clob"  0       0       6912    NULL    true    4       NULL
+6903   "location"      "clob"  0       0       6912    NULL    true    5       
NULL
+6904   "count" "bigint"        64      0       6912    NULL    true    6       
NULL
+6905   "typewidth"     "int"   32      0       6912    NULL    true    7       
NULL
+6906   "columnsize"    "bigint"        64      0       6912    NULL    true    
8       NULL
+6907   "heapsize"      "bigint"        64      0       6912    NULL    true    
9       NULL
+6908   "hashes"        "bigint"        64      0       6912    NULL    true    
10      NULL
+6909   "imprints"      "bigint"        64      0       6912    NULL    true    
11      NULL
+6910   "sorted"        "boolean"       1       0       6912    NULL    true    
12      NULL
+6911   "compress"      "boolean"       1       0       6912    NULL    true    
13      NULL
+6914   "schema"        "clob"  0       0       6924    NULL    true    0       
NULL
+6915   "table" "clob"  0       0       6924    NULL    true    1       NULL
+6916   "column"        "clob"  0       0       6924    NULL    true    2       
NULL
+6917   "type"  "clob"  0       0       6924    NULL    true    3       NULL
+6918   "typewidth"     "int"   32      0       6924    NULL    true    4       
NULL
+6919   "count" "bigint"        64      0       6924    NULL    true    5       
NULL
+6920   "distinct"      "bigint"        64      0       6924    NULL    true    
6       NULL
+6921   "atomwidth"     "int"   32      0       6924    NULL    true    7       
NULL
+6922   "reference"     "boolean"       1       0       6924    NULL    true    
8       NULL
+6923   "sorted"        "boolean"       1       0       6924    NULL    true    
9       NULL
+6962   "schema"        "clob"  0       0       6972    NULL    true    0       
NULL
+6963   "table" "clob"  0       0       6972    NULL    true    1       NULL
+6964   "column"        "clob"  0       0       6972    NULL    true    2       
NULL
+6965   "type"  "clob"  0       0       6972    NULL    true    3       NULL
+6966   "count" "bigint"        64      0       6972    NULL    true    4       
NULL
+6967   "columnsize"    "bigint"        64      0       6972    NULL    true    
5       NULL
+6968   "heapsize"      "bigint"        64      0       6972    NULL    true    
6       NULL
+6969   "hashes"        "bigint"        64      0       6972    NULL    true    
7       NULL
+6970   "imprints"      "bigint"        64      0       6972    NULL    true    
8       NULL
+6971   "sorted"        "boolean"       1       0       6972    NULL    true    
9       NULL
+6974   "schema"        "clob"  0       0       6982    NULL    true    0       
NULL
+6975   "table" "clob"  0       0       6982    NULL    true    1       NULL
+6976   "count" "bigint"        64      0       6982    NULL    true    2       
NULL
+6977   "columnsize"    "hugeint"       64      0       6982    NULL    true    
3       NULL
+6978   "heapsize"      "hugeint"       64      0       6982    NULL    true    
4       NULL
+6979   "hashes"        "hugeint"       64      0       6982    NULL    true    
5       NULL
+6980   "imprints"      "hugeint"       64      0       6982    NULL    true    
6       NULL
+6981   "auxiliary"     "hugeint"       128     0       6982    NULL    true    
7       NULL
+6984   "column_id"     "int"   32      0       6995    NULL    true    0       
NULL
+6985   "type"  "clob"  0       0       6995    NULL    true    1       NULL
+6986   "width" "int"   32      0       6995    NULL    true    2       NULL
+6987   "stamp" "timestamp"     7       0       6995    NULL    true    3       
NULL
+6988   "sample"        "bigint"        64      0       6995    NULL    true    
4       NULL
+6989   "count" "bigint"        64      0       6995    NULL    true    5       
NULL
+6990   "unique"        "bigint"        64      0       6995    NULL    true    
6       NULL
+6991   "nils"  "bigint"        64      0       6995    NULL    true    7       
NULL
+6992   "minval"        "clob"  0       0       6995    NULL    true    8       
NULL
+6993   "maxval"        "clob"  0       0       6995    NULL    true    9       
NULL
+6994   "sorted"        "boolean"       1       0       6995    NULL    true    
10      NULL
+7095   "file_id"       "bigint"        64      0       7103    NULL    false   
0       NULL
+7096   "file_location" "clob"  0       0       7103    NULL    false   1       
NULL
+7097   "dbschema"      "smallint"      16      0       7103    NULL    false   
2       NULL
+7098   "format_version"        "varchar"       7       0       7103    NULL    
true    3       NULL
+7099   "sorting_order" "varchar"       10      0       7103    NULL    true    
4       NULL
+7100   "comments"      "clob"  0       0       7103    NULL    true    5       
NULL
+7105   "sn"    "clob"  0       0       7116    NULL    false   0       NULL
+7106   "file_id"       "bigint"        64      0       7116    NULL    false   
1       NULL
+7107   "ln"    "int"   32      0       7116    NULL    true    2       NULL
+7108   "as"    "int"   32      0       7116    NULL    true    3       NULL
+7109   "m5"    "clob"  0       0       7116    NULL    true    4       NULL
+7110   "sp"    "clob"  0       0       7116    NULL    true    5       NULL
+7111   "ur"    "clob"  0       0       7116    NULL    true    6       NULL
+7118   "id"    "clob"  0       0       7135    NULL    false   0       NULL
+7119   "file_id"       "bigint"        64      0       7135    NULL    false   
1       NULL
+7120   "cn"    "clob"  0       0       7135    NULL    true    2       NULL
+7121   "ds"    "clob"  0       0       7135    NULL    true    3       NULL
+7122   "dt"    "timestamp"     7       0       7135    NULL    true    4       
NULL
+7123   "fo"    "clob"  0       0       7135    NULL    true    5       NULL
+7124   "ks"    "clob"  0       0       7135    NULL    true    6       NULL
+7125   "lb"    "clob"  0       0       7135    NULL    true    7       NULL
+7126   "pg"    "clob"  0       0       7135    NULL    true    8       NULL
+7127   "pi"    "int"   32      0       7135    NULL    true    9       NULL
+7128   "pl"    "clob"  0       0       7135    NULL    true    10      NULL
+7129   "pu"    "clob"  0       0       7135    NULL    true    11      NULL
+7130   "sm"    "clob"  0       0       7135    NULL    true    12      NULL
+7137   "id"    "clob"  0       0       7147    NULL    false   0       NULL
+7138   "file_id"       "bigint"        64      0       7147    NULL    false   
1       NULL
+7139   "pn"    "clob"  0       0       7147    NULL    true    2       NULL
+7140   "cl"    "clob"  0       0       7147    NULL    true    3       NULL
+7141   "pp"    "clob"  0       0       7147    NULL    true    4       NULL
+7142   "vn"    "clob"  0       0       7147    NULL    true    5       NULL
+7149   "qname" "clob"  0       0       7160    NULL    false   0       NULL
+7150   "flag"  "smallint"      16      0       7160    NULL    false   1       
NULL
+7151   "rname" "clob"  0       0       7160    NULL    false   2       NULL
+7152   "pos"   "int"   32      0       7160    NULL    false   3       NULL
+7153   "mapq"  "smallint"      16      0       7160    NULL    false   4       
NULL
+7154   "cigar" "clob"  0       0       7160    NULL    false   5       NULL
+7155   "rnext" "clob"  0       0       7160    NULL    false   6       NULL
+7156   "pnext" "int"   32      0       7160    NULL    false   7       NULL
+7157   "tlen"  "int"   32      0       7160    NULL    false   8       NULL
+7158   "seq"   "clob"  0       0       7160    NULL    false   9       NULL
+7159   "qual"  "clob"  0       0       7160    NULL    false   10      NULL
+7241   "function_id"   "int"   32      0       7242    NULL    true    0       
NULL
 COMMIT;
 START TRANSACTION;
 CREATE TABLE "sys"."_tables" (
@@ -1976,54 +1978,54 @@ CREATE TABLE "sys"."_tables" (
        "type"          SMALLINT,
        "system"        BOOLEAN,
        "commit_action" SMALLINT,
-       "readonly"      BOOLEAN
+       "access"        SMALLINT
 );
 COPY 45 RECORDS INTO "sys"."_tables" FROM stdin USING DELIMITERS '\t','\n','"';
-2001   "schemas"       2000    NULL    0       true    0       false
-2007   "types" 2000    NULL    0       true    0       false
-2016   "functions"     2000    NULL    0       true    0       false
-2027   "args"  2000    NULL    0       true    0       false
-2036   "sequences"     2000    NULL    0       true    0       false
-2046   "dependencies"  2000    NULL    0       true    0       false
-2050   "connections"   2000    NULL    0       true    0       false
-2059   "_tables"       2000    NULL    0       true    0       false
-2068   "_columns"      2000    NULL    0       true    0       false
-2079   "keys"  2000    NULL    0       true    0       false
-2086   "idxs"  2000    NULL    0       true    0       false
-2091   "triggers"      2000    NULL    0       true    0       false
-2102   "objects"       2000    NULL    0       true    0       false
-2107   "_tables"       2106    NULL    0       true    2       false
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to