Changeset: cfa0d9bc116b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cfa0d9bc116b
Modified Files:
clients/examples/php/sqlsample.php
sql/jdbc/tests/Tests/Test_Dobjects_bam.stable.out
sql/server/sql_parser.y
sql/storage/bat/bat_storage.c
sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.stable.out
sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out
sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.out
sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.sql
sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
sql/test/BugTracker/Tests/like_exp.SF-1613949.stable.out
sql/test/Tests/setoptimizer.stable.out
sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out
sql/test/mapi/Tests/php_monetdb.stable.out.int128
sql/test/mosaic/Tests/compression.sql
sql/test/mserver5-sql-readonly/Tests/mserver5-sql-readonly-table.stable.err
Branch: mosaic
Log Message:
use alter table .. alter column to compress
diffs (truncated from 385 to 300 lines):
diff --git a/clients/examples/php/sqlsample.php
b/clients/examples/php/sqlsample.php
--- a/clients/examples/php/sqlsample.php
+++ b/clients/examples/php/sqlsample.php
@@ -28,7 +28,7 @@ require 'monetdb/php_monetdb.php';
for ($i = 0; $line = @monetdb_fetch_assoc($tables); $i++) {
print($line['name']."\n");
}
-$result = monetdb_query('SELECT name, schema_id, query, type, system,
commit_action, readonly, temporary FROM tables LIMIT 10');
+$result = monetdb_query('SELECT name, schema_id, query, type, system,
commit_action, access, temporary FROM tables LIMIT 10');
$cols = monetdb_num_fields($result);
for ($i = 0; $i < $cols; $i++) {
print(monetdb_field_name($result, $i)."\t");
diff --git a/sql/jdbc/tests/Tests/Test_Dobjects_bam.stable.out
b/sql/jdbc/tests/Tests/Test_Dobjects_bam.stable.out
--- a/sql/jdbc/tests/Tests/Test_Dobjects_bam.stable.out
+++ b/sql/jdbc/tests/Tests/Test_Dobjects_bam.stable.out
@@ -111,7 +111,7 @@ from sys.querylog_catalog() qd, sys.quer
where qd.id = ql.id and qd.owner = user; null null null rowid
SYSTEM
mTests_sql_jdbc_tests sys queue SYSTEM VIEW create view sys.queue
as select * from sys.queue(); null null null rowid SYSTEM
mTests_sql_jdbc_tests sys sessions SYSTEM VIEW create view
sys.sessions as select * from sys.sessions(); null null null
rowid SYSTEM
-mTests_sql_jdbc_tests sys storage SYSTEM VIEW create view sys.storage
as select * from sys.storage(); null null null rowid SYSTEM
+mTests_sql_jdbc_tests sys storage SYSTEM VIEW create view
sys."storage" as select * from sys."storage"(); null null null
rowid SYSTEM
mTests_sql_jdbc_tests sys storagemodel SYSTEM VIEW create view
sys.storagemodel as select * from sys.storagemodel(); null null
null rowid SYSTEM
mTests_sql_jdbc_tests sys tables SYSTEM VIEW 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;
null null null rowid SYSTEM
mTests_sql_jdbc_tests sys tablestoragemodel SYSTEM VIEW -- A
summary of the table storage requirement is is available as a table view.
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -4883,6 +4883,7 @@ non_reserved_word:
| FILTER { $$ = sa_strdup(SA, "filter"); }
| TEMPORARY { $$ = sa_strdup(SA, "temporary"); }
| ANALYZE { $$ = sa_strdup(SA, "analyze"); }
+| STORAGE { $$ = sa_strdup(SA, "storage"); }
;
name_commalist:
diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c
--- a/sql/storage/bat/bat_storage.c
+++ b/sql/storage/bat/bat_storage.c
@@ -1830,7 +1830,7 @@ update_table(sql_trans *tr, sql_table *f
}
} else {
assert(oc->base.allocated);
- if (cc->storage_type && (!cc->storage_type ||
strcmp(cc->storage_type, oc->storage_type) != 0))
+ if ((cc->storage_type && (!oc->storage_type ||
(strcmp(cc->storage_type, oc->storage_type) != 0))) || (!cc->storage_type &&
oc->storage_type))
tr_update_storage(tr, oc->data, cc->data);
else
tr_update_delta(tr, oc->data, cc->data,
cc->unique == 1);
@@ -1838,8 +1838,8 @@ update_table(sql_trans *tr, sql_table *f
oc->null = cc->null;
oc->unique = cc->unique;
- if (cc->storage_type && (!cc->storage_type ||
strcmp(cc->storage_type, oc->storage_type) != 0))
- oc->storage_type = sa_strdup(tr->sa, cc->storage_type);
+ if ((cc->storage_type && (!oc->storage_type ||
(strcmp(cc->storage_type, oc->storage_type) != 0))) || (!cc->storage_type &&
oc->storage_type))
+ oc->storage_type = (cc->storage_type)?sa_strdup(tr->sa,
cc->storage_type):NULL;
if (cc->def && (!cc->def || strcmp(cc->def, oc->def) != 0))
oc->def = sa_strdup(tr->sa, cc->def);
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.stable.out
b/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.stable.out
---
a/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.stable.out
@@ -32,9 +32,9 @@ Ready.
# AND "tables"."system" = FALSE
# AND "keys"."type" = 0;
% .keys, .keys, .keys, .keys, .keys, .keys, .objects,
.objects, .objects, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables,
.tables, .schemas, .schemas, .schemas, .schemas,
.schemas # table_name
-% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action,
readonly, temporary, id, name, authorization, owner, system
# name
-% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, boolean, tinyint, int,
varchar, int, int, boolean # type
-% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 5, 1, 1, 0,
1, 1, 5 # length
+% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action, access,
temporary, id, name, authorization, owner, system # name
+% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, smallint, tinyint, int,
varchar, int, int, boolean # type
+% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 1, 1, 1, 0,
1, 1, 5 # length
#SELECT *
#FROM "keys", "objects", "tables", "schemas"
#WHERE "keys"."id" = "objects"."id"
@@ -44,11 +44,11 @@ Ready.
# AND "keys"."type" = 0
#ORDER BY "objects"."name";
% .keys, .keys, .keys, .keys, .keys, .keys, .objects,
.objects, .objects, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables,
.tables, .schemas, .schemas, .schemas, .schemas,
.schemas # table_name
-% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action,
readonly, temporary, id, name, authorization, owner, system
# name
-% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, boolean, tinyint, int,
varchar, int, int, boolean # type
-% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 5, 1, 1, 0,
1, 1, 5 # length
+% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action, access,
temporary, id, name, authorization, owner, system # name
+% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, smallint, tinyint, int,
varchar, int, int, boolean # type
+% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 1, 1, 1, 0,
1, 1, 5 # length
-# 17:12:14 >
-# 17:12:14 > "Done."
-# 17:12:14 >
+# 10:23:23 >
+# 10:23:23 > "Done."
+# 10:23:23 >
diff --git a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out
b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out
--- a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out
+++ b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out
@@ -29,19 +29,19 @@ Ready.
[ 1 ]
#select * from tables, x limit 10;
% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .x, .x #
table_name
-% id, name, schema_id, query, type, system, commit_action,
readonly, temporary, n, s # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, boolean, tinyint, int, varchar # type
-% 4, 9, 4, 0, 1, 5, 1, 5, 1, 1,
5 # length
-[ 2001, "schemas", 2000, NULL, 0, true, 0, false,
0, 1, "one" ]
-[ 2001, "schemas", 2000, NULL, 0, true, 0, false,
0, 2, "two" ]
-[ 2001, "schemas", 2000, NULL, 0, true, 0, false,
0, 3, "three" ]
-[ 2007, "types", 2000, NULL, 0, true, 0, false,
0, 1, "one" ]
-[ 2007, "types", 2000, NULL, 0, true, 0, false,
0, 2, "two" ]
-[ 2007, "types", 2000, NULL, 0, true, 0, false,
0, 3, "three" ]
-[ 2016, "functions", 2000, NULL, 0, true, 0, false,
0, 1, "one" ]
-[ 2016, "functions", 2000, NULL, 0, true, 0, false,
0, 2, "two" ]
-[ 2016, "functions", 2000, NULL, 0, true, 0, false,
0, 3, "three" ]
-[ 2027, "args", 2000, NULL, 0, true, 0, false, 0,
1, "one" ]
+% id, name, schema_id, query, type, system, commit_action, access,
temporary, n, s # name
+% int, varchar, int, varchar, smallint, boolean,
smallint, smallint, tinyint, int, varchar # type
+% 4, 9, 4, 0, 1, 5, 1, 1, 1, 1,
5 # length
+[ 2001, "schemas", 2000, NULL, 0, true, 0, 0,
0, 1, "one" ]
+[ 2001, "schemas", 2000, NULL, 0, true, 0, 0,
0, 2, "two" ]
+[ 2001, "schemas", 2000, NULL, 0, true, 0, 0,
0, 3, "three" ]
+[ 2007, "types", 2000, NULL, 0, true, 0, 0,
0, 1, "one" ]
+[ 2007, "types", 2000, NULL, 0, true, 0, 0,
0, 2, "two" ]
+[ 2007, "types", 2000, NULL, 0, true, 0, 0,
0, 3, "three" ]
+[ 2016, "functions", 2000, NULL, 0, true, 0, 0,
0, 1, "one" ]
+[ 2016, "functions", 2000, NULL, 0, true, 0, 0,
0, 2, "two" ]
+[ 2016, "functions", 2000, NULL, 0, true, 0, 0,
0, 3, "three" ]
+[ 2027, "args", 2000, NULL, 0, true, 0, 0, 0,
1, "one" ]
#drop table x cascade;
# 19:39:26 >
diff --git
a/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.out
b/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.out
--- a/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.out
+++ b/sql/test/BugTracker-2010/Tests/offset_limited_32bit.SF-2950579.stable.out
@@ -27,16 +27,16 @@ Ready.
#SELECT * from tables OFFSET 2147483647; -- never finishes
% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
readonly, temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, boolean, tinyint # type
-% 1, 0, 1, 0, 1, 5, 1, 5, 1 # length
+% id, name, schema_id, query, type, system, commit_action, access,
temporary # name
+% int, varchar, int, varchar, smallint, boolean,
smallint, smallint, tinyint # type
+% 1, 0, 1, 0, 1, 5, 1, 1, 1 # length
#SELECT * from tables OFFSET 2147483646; -- returns instantly
% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
readonly, temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, boolean, tinyint # type
-% 1, 0, 1, 0, 1, 5, 1, 5, 1 # length
+% id, name, schema_id, query, type, system, commit_action, access,
temporary # name
+% int, varchar, int, varchar, smallint, boolean,
smallint, smallint, tinyint # type
+% 1, 0, 1, 0, 1, 5, 1, 1, 1 # length
-# 08:08:12 >
-# 08:08:12 > Done.
-# 08:08:12 >
+# 10:30:54 >
+# 10:30:54 > "Done."
+# 10:30:54 >
diff --git a/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.sql
b/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.sql
--- a/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.sql
+++ b/sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.sql
@@ -1,8 +1,8 @@
create table x(a int);
insert into x values (1),(2),(3);
alter table x set read only;
-select readonly from sys.tables where name='x';
+select access from sys.tables where name='x';
alter table x add primary key (a);
-select readonly from sys.tables where name='x';
+select access from sys.tables where name='x';
drop table x;
diff --git a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
--- a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
+++ b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
@@ -1,5 +1,5 @@
create table x (s string);
insert into x values('%able%');
-select name, schema_id, query, type, system, commit_action, readonly, s from
sys._tables, x where name like s;
+select name, schema_id, query, type, system, commit_action, access, s from
sys._tables, x where name like s;
drop table x;
diff --git a/sql/test/BugTracker/Tests/like_exp.SF-1613949.stable.out
b/sql/test/BugTracker/Tests/like_exp.SF-1613949.stable.out
--- a/sql/test/BugTracker/Tests/like_exp.SF-1613949.stable.out
+++ b/sql/test/BugTracker/Tests/like_exp.SF-1613949.stable.out
@@ -26,11 +26,11 @@ Ready.
#select * from tables where name LIKE ('hel%');
% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
readonly, temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, boolean, tinyint # type
-% 1, 0, 1, 0, 1, 5, 1, 5, 1 # length
+% id, name, schema_id, query, type, system, commit_action, access,
temporary # name
+% int, varchar, int, varchar, smallint, boolean,
smallint, smallint, tinyint # type
+% 1, 0, 1, 0, 1, 5, 1, 1, 1 # length
-# 19:37:54 >
-# 19:37:54 > Done.
-# 19:37:54 >
+# 10:24:27 >
+# 10:24:27 > "Done."
+# 10:24:27 >
diff --git a/sql/test/Tests/setoptimizer.stable.out
b/sql/test/Tests/setoptimizer.stable.out
--- a/sql/test/Tests/setoptimizer.stable.out
+++ b/sql/test/Tests/setoptimizer.stable.out
@@ -64,13 +64,13 @@ Ready.
% ., ., . # table_name
% name, def, status # name
% clob, clob, clob # type
-% 15, 491, 12 # length
-[ "minimal_pipe",
"optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();",
"stable" ]
-[ "default_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();",
"stable" ]
-[ "no_mitosis_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();",
"stable" ]
-[ "sequential_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();",
"stable" ]
-[ "recycler_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.recycler();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();",
"stable" ]
-[ "centipede_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.centipede();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();",
"experimental" ]
+% 15, 510, 12 # length
+[ "minimal_pipe",
"optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.generator();optimizer.mosaic();optimizer.garbageCollector();",
"stable" ]
+[ "default_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.mosaic();optimizer.garbageCollector();",
"stable" ]
+[ "no_mitosis_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.mosaic();optimizer.garbageCollector();",
"stable" ]
+[ "sequential_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.mosaic();optimizer.garbageCollector();",
"stable" ]
+[ "recycler_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.recycler();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.mosaic();optimizer.garbageCollector();",
"stable" ]
+[ "centipede_pipe",
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptySet();optimizer.aliases();optimizer.centipede();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.mosaic();optimizer.garbageCollector();",
"experimental" ]
[ "user_1", " optimizer.inline(); optimizer.remap(); optimizer.evaluate();
optimizer.costModel(); optimizer.coercions(); optimizer.emptySet();
optimizer.aliases(); optimizer.mergetable(); optimizer.deadcode();
optimizer.commonTerms(); optimizer.joinPath(); optimizer.reorder();
optimizer.deadcode(); optimizer.reduce(); optimizer.querylog();
optimizer.multiplex(); optimizer.accumulators();
optimizer.garbageCollector();", "experimental" ]
# 02:57:35 >
diff --git a/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out
b/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out
--- a/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out
+++ b/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out
@@ -32,9 +32,9 @@ Ready.
#"keys"."type" = 0 AND "schemas"."name" LIKE 'sys' AND
#"tables"."name" LIKE 'x';
% .keys, .keys, .keys, .keys, .keys, .keys, .objects,
.objects, .objects, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables,
.tables, .schemas, .schemas, .schemas, .schemas,
.schemas # table_name
-% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action,
readonly, temporary, id, name, authorization, owner, system
# name
-% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, boolean, tinyint, int,
varchar, int, int, boolean # type
-% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 5, 1, 1, 0,
1, 1, 5 # length
+% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action, access,
temporary, id, name, authorization, owner, system # name
+% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, smallint, tinyint, int,
varchar, int, int, boolean # type
+% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 1, 1, 1, 0,
1, 1, 5 # length
#SELECT * FROM "sys"."keys" AS "keys", "sys"."objects" AS
#"objects", "sys"."tables" AS "tables",
#"sys"."schemas" AS "schemas" WHERE "keys"."id" =
@@ -43,9 +43,9 @@ Ready.
#"keys"."type" = 0 AND "schemas"."name" LIKE 'sys' AND
#"tables"."name" LIKE 'x' ORDER BY "objects"."name";
% .keys, .keys, .keys, .keys, .keys, .keys, .objects,
.objects, .objects, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, .tables,
.tables, .schemas, .schemas, .schemas, .schemas,
.schemas # table_name
-% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action,
readonly, temporary, id, name, authorization, owner, system
# name
-% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, boolean, tinyint, int,
varchar, int, int, boolean # type
-% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 5, 1, 1, 0,
1, 1, 5 # length
+% id, table_id, type, name, rkey, action, id, name, nr,
id, name, schema_id, query, type, system, commit_action, access,
temporary, id, name, authorization, owner, system # name
+% int, int, int, varchar, int, int, int, varchar,
int, int, varchar, int, varchar, smallint,
boolean, smallint, smallint, tinyint, int,
varchar, int, int, boolean # type
+% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
0, 1, 0, 1, 5, 1, 1, 1, 1, 0,
1, 1, 5 # length
#SELECT cast(null AS varchar(1)) AS "TABLE_CAT",
#"schemas"."name" AS "TABLE_SCHEM", "tables"."name" AS
#"TABLE_NAME", "objects"."name" AS "COLUMN_NAME",
diff --git a/sql/test/mapi/Tests/php_monetdb.stable.out.int128
b/sql/test/mapi/Tests/php_monetdb.stable.out.int128
--- a/sql/test/mapi/Tests/php_monetdb.stable.out.int128
+++ b/sql/test/mapi/Tests/php_monetdb.stable.out.int128
@@ -39,19 +39,19 @@ connections
_tables
_columns
keys
-name schema_id query type system commit_action readonly
temporary
-schemas 2000 0 true 0 false 0
-types 2000 0 true 0 false 0
-functions 2000 0 true 0 false 0
-args 2000 0 true 0 false 0
-sequences 2000 0 true 0 false 0
-dependencies 2000 0 true 0 false 0
-connections 2000 0 true 0 false 0
-_tables 2000 0 true 0 false 0
-_columns 2000 0 true 0 false 0
-keys 2000 0 true 0 false 0
+name schema_id query type system commit_action access
temporary
+schemas 2000 0 true 0 0 0
+types 2000 0 true 0 0 0
+functions 2000 0 true 0 0 0
+args 2000 0 true 0 0 0
+sequences 2000 0 true 0 0 0
+dependencies 2000 0 true 0 0 0
+connections 2000 0 true 0 0 0
+_tables 2000 0 true 0 0 0
+_columns 2000 0 true 0 0 0
+keys 2000 0 true 0 0 0
-# 22:57:55 >
-# 22:57:55 > "Done."
-# 22:57:55 >
+# 11:36:36 >
+# 11:36:36 > "Done."
+# 11:36:36 >
diff --git a/sql/test/mosaic/Tests/compression.sql
b/sql/test/mosaic/Tests/compression.sql
--- a/sql/test/mosaic/Tests/compression.sql
+++ b/sql/test/mosaic/Tests/compression.sql
@@ -90,13 +90,23 @@ insert into tmp3 values
alter table tmp3 set read only;
+explain select * from tmp3;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
