Changeset: 0a264879d99a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0a264879d99a
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.sql
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Darwin
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.FreeBSD
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Windows
Branch: Dec2016
Log Message:
Remove "sorted" column from output: it's not constant enough.
diffs (truncated from 301 to 300 lines):
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.sql
b/sql/test/BugTracker-2016/Tests/storagemodel.sql
--- a/sql/test/BugTracker-2016/Tests/storagemodel.sql
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.sql
@@ -1,8 +1,8 @@
-- platform dependent script test.
create table bug3923(i integer);
--- skip columns location, count, columnsize.
-select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
+-- skip columns location, count, columnsize, sorted.
+select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
call storagemodelinit();
update storagemodelinput set "count" =10000 where "table" ='bug3923';
@@ -17,8 +17,8 @@ create schema bug3923schema;
set schema bug3923schema;
create table bug3923(i integer);
--- skip columns location, count, columnsize.
-select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from sys.storage('sys','_tables');
+-- skip columns location, count, columnsize, sorted.
+select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from sys.storage('sys','_tables');
call sys.storagemodelinit();
update sys.storagemodelinput set "count" =10000 where "table" ='bug3923';
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
@@ -66,19 +66,19 @@ Ready.
# 23:38:44 >
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 8,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
45, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 8,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
45, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
@@ -91,19 +91,19 @@ Ready.
[ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0,
1200, true, true, NULL, 0 ]
#drop table bug3923;
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 8,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
45, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 8,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
45, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Darwin
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Darwin
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Darwin
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Darwin
@@ -66,19 +66,19 @@ Ready.
# 23:38:44 >
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
50, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
50, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
@@ -91,19 +91,19 @@ Ready.
[ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0,
1200, true, true, NULL, 0 ]
#drop table bug3923;
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
49, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
49, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.FreeBSD
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.FreeBSD
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.FreeBSD
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.FreeBSD
@@ -66,19 +66,19 @@ Ready.
# 23:38:44 >
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
55, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
55, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
@@ -91,19 +91,19 @@ Ready.
[ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0,
1200, true, true, NULL, 0 ]
#drop table bug3923;
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
54, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, false ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
54, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Windows
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Windows
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Windows
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Windows
@@ -66,19 +66,19 @@ Ready.
# 23:38:44 >
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
55, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
55, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
#update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i';
@@ -91,19 +91,19 @@ Ready.
[ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0,
1200, true, true, NULL, 0 ]
#drop table bug3923;
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints, sorted from storage('sys','_tables');
-% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 #
table_name
-% schema, table, column, type, mode, typewidth, hashes, phash,
imprints, sorted # name
-% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint, boolean # type
-% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 #
length
-[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0, true ]
-[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0, false ]
-[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0, NULL ]
-[ "sys", "_tables", "query", "varchar", "writable",
54, 0, false, 0, NULL ]
-[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0, NULL ]
-[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0, NULL ]
-[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0, NULL ]
-[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0, true ]
+#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
+% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
+% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
+% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
+[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 9,
0, false, 0 ]
+[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
+[ "sys", "_tables", "query", "varchar", "writable",
54, 0, false, 0 ]
+[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
+[ "sys", "_tables", "system", "boolean", "writable",
1, 0, false, 0 ]
+[ "sys", "_tables", "commit_action", "smallint",
"writable", 2, 0, false, 0 ]
+[ "sys", "_tables", "access", "smallint", "writable",
2, 0, false, 0 ]
#update storagemodelinput set "count" =10000 where "table" ='bug3923';
[ 1 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
