Changeset: 4c129eb95903 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4c129eb95903
Added Files:
sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.stable.err
sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.stable.out
sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.stable.err
sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.stable.out
Modified Files:
clients/Tests/SQL-dump_all.stable.out
clients/Tests/SQL-dump_all.stable.out.oid32
clients/Tests/SQL-dump_geom.stable.out
clients/Tests/SQL-dump_geom.stable.out.32bit
clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
clients/Tests/SQL-dump_none.stable.out
clients/mapiclient/mclient.1
monetdb5/optimizer/opt_dataflow.c
sql/ChangeLog.Oct2014
sql/backends/monet5/sql_scenario.c
sql/backends/monet5/sql_upgrades.c
sql/jdbc/tests/Tests/Test_Dobjects.stable.out
sql/jdbc/tests/Tests/Test_Dobjects_bam.stable.out
sql/scripts/75_storagemodel.sql
sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
sql/test/BugTracker-2013/Tests/All
sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.stable.out
sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
sql/test/bugs/Tests/crash_order_by.sql
sql/test/bugs/Tests/simple_view.sql
sql/test/bugs/insert_delete-bug-sf-904025.sql
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
Merge with Oct2014 branch.
diffs (truncated from 1041 to 300 lines):
diff --git a/clients/Tests/SQL-dump_all.stable.out
b/clients/Tests/SQL-dump_all.stable.out
--- a/clients/Tests/SQL-dump_all.stable.out
+++ b/clients/Tests/SQL-dump_all.stable.out
@@ -427,7 +427,7 @@ create view sys.storage as select * from
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.
--- The auxillary column denotes the maximum space if all non-sorted columns
+-- The auxiliary column denotes the maximum space if all non-sorted columns
-- would be augmented with a hash (rare situation)
create view sys.tablestoragemodel
as select "schema","table",max(count) as "count",
@@ -435,7 +435,7 @@ as select "schema","table",max(count) as
sum(heapsize) as heapsize,
sum(hashes) as hashes,
sum(imprints) as imprints,
- sum(case when sorted = false then 8 * count else 0 end) as auxillary
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary
from sys.storagemodel() group by "schema","table";
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
@@ -1830,7 +1830,7 @@ 6458 "columnsize" "bigint" 64 0
6463 NUL
6459 "heapsize" "bigint" 64 0 6463 NULL true
4 NULL
6460 "hashes" "bigint" 64 0 6463 NULL true
5 NULL
6461 "imprints" "bigint" 64 0 6463 NULL true
6 NULL
-6462 "auxillary" "bigint" 53 0 6463 NULL true
7 NULL
+6462 "auxiliary" "bigint" 53 0 6463 NULL true
7 NULL
6465 "column_id" "int" 32 0 6476 NULL true 0
NULL
6466 "type" "clob" 0 0 6476 NULL true 1 NULL
6467 "width" "int" 32 0 6476 NULL true 2 NULL
@@ -1936,7 +1936,7 @@ 5737 "queue" 2000 "create view sys.queue
6393 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
6405 "storagemodelinput" 2000 NULL 0 true 0 false
6453 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6463 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary 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 auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6463 "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 false
6476 "statistics" 2000 NULL 0 true 0 false
6579 "files" 6528 NULL 0 true 0 false
6592 "sq" 6528 NULL 0 true 0 false
diff --git a/clients/Tests/SQL-dump_all.stable.out.oid32
b/clients/Tests/SQL-dump_all.stable.out.oid32
--- a/clients/Tests/SQL-dump_all.stable.out.oid32
+++ b/clients/Tests/SQL-dump_all.stable.out.oid32
@@ -427,7 +427,7 @@ create view sys.storage as select * from
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.
--- The auxillary column denotes the maximum space if all non-sorted columns
+-- The auxiliary column denotes the maximum space if all non-sorted columns
-- would be augmented with a hash (rare situation)
create view sys.tablestoragemodel
as select "schema","table",max(count) as "count",
@@ -435,7 +435,7 @@ as select "schema","table",max(count) as
sum(heapsize) as heapsize,
sum(hashes) as hashes,
sum(imprints) as imprints,
- sum(case when sorted = false then 8 * count else 0 end) as auxillary
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary
from sys.storagemodel() group by "schema","table";
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
@@ -1830,7 +1830,7 @@ 6458 "columnsize" "bigint" 64 0
6463 NUL
6459 "heapsize" "bigint" 64 0 6463 NULL true
4 NULL
6460 "hashes" "bigint" 64 0 6463 NULL true
5 NULL
6461 "imprints" "bigint" 64 0 6463 NULL true
6 NULL
-6462 "auxillary" "bigint" 53 0 6463 NULL true
7 NULL
+6462 "auxiliary" "bigint" 53 0 6463 NULL true
7 NULL
6465 "column_id" "int" 32 0 6476 NULL true 0
NULL
6466 "type" "clob" 0 0 6476 NULL true 1 NULL
6467 "width" "int" 32 0 6476 NULL true 2 NULL
@@ -1936,7 +1936,7 @@ 5737 "queue" 2000 "create view sys.queue
6393 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
6405 "storagemodelinput" 2000 NULL 0 true 0 false
6453 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6463 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary 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 auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6463 "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 false
6476 "statistics" 2000 NULL 0 true 0 false
6579 "files" 6528 NULL 0 true 0 false
6592 "sq" 6528 NULL 0 true 0 false
diff --git a/clients/Tests/SQL-dump_geom.stable.out
b/clients/Tests/SQL-dump_geom.stable.out
--- a/clients/Tests/SQL-dump_geom.stable.out
+++ b/clients/Tests/SQL-dump_geom.stable.out
@@ -424,7 +424,7 @@ create view sys.storage as select * from
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.
--- The auxillary column denotes the maximum space if all non-sorted columns
+-- The auxiliary column denotes the maximum space if all non-sorted columns
-- would be augmented with a hash (rare situation)
create view sys.tablestoragemodel
as select "schema","table",max(count) as "count",
@@ -432,7 +432,7 @@ as select "schema","table",max(count) as
sum(heapsize) as heapsize,
sum(hashes) as hashes,
sum(imprints) as imprints,
- sum(case when sorted = false then 8 * count else 0 end) as auxillary
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary
from sys.storagemodel() group by "schema","table";
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
@@ -1804,7 +1804,7 @@ 6453 "columnsize" "bigint" 64 0
6458 NUL
6454 "heapsize" "bigint" 64 0 6458 NULL true
4 NULL
6455 "hashes" "bigint" 64 0 6458 NULL true
5 NULL
6456 "imprints" "bigint" 64 0 6458 NULL true
6 NULL
-6457 "auxillary" "bigint" 53 0 6458 NULL true
7 NULL
+6457 "auxiliary" "bigint" 53 0 6458 NULL true
7 NULL
6460 "column_id" "int" 32 0 6471 NULL true 0
NULL
6461 "type" "clob" 0 0 6471 NULL true 1 NULL
6462 "width" "int" 32 0 6471 NULL true 2 NULL
@@ -1867,7 +1867,7 @@ 5737 "queue" 2000 "create view sys.queue
6388 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
6400 "storagemodelinput" 2000 NULL 0 true 0 false
6448 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6458 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary 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 auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6458 "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 false
6471 "statistics" 2000 NULL 0 true 0 false
6593 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
diff --git a/clients/Tests/SQL-dump_geom.stable.out.32bit
b/clients/Tests/SQL-dump_geom.stable.out.32bit
--- a/clients/Tests/SQL-dump_geom.stable.out.32bit
+++ b/clients/Tests/SQL-dump_geom.stable.out.32bit
@@ -420,7 +420,7 @@ create view sys.storage as select * from
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.
--- The auxillary column denotes the maximum space if all non-sorted columns
+-- The auxiliary column denotes the maximum space if all non-sorted columns
-- would be augmented with a hash (rare situation)
create view sys.tablestoragemodel
as select "schema","table",max(count) as "count",
@@ -428,7 +428,7 @@ as select "schema","table",max(count) as
sum(heapsize) as heapsize,
sum(hashes) as hashes,
sum(imprints) as imprints,
- sum(case when sorted = false then 8 * count else 0 end) as auxillary
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary
from sys.storagemodel() group by "schema","table";
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
@@ -1798,7 +1798,7 @@ 6453 "columnsize" "bigint" 64 0
6458 NUL
6454 "heapsize" "bigint" 64 0 6458 NULL true
4 NULL
6455 "hashes" "bigint" 64 0 6458 NULL true
5 NULL
6456 "imprints" "bigint" 64 0 6458 NULL true
6 NULL
-6457 "auxillary" "bigint" 53 0 6458 NULL true
7 NULL
+6457 "auxiliary" "bigint" 53 0 6458 NULL true
7 NULL
6460 "column_id" "int" 32 0 6471 NULL true 0
NULL
6461 "type" "clob" 0 0 6471 NULL true 1 NULL
6462 "width" "int" 32 0 6471 NULL true 2 NULL
@@ -1861,7 +1861,7 @@ 5737 "queue" 2000 "create view sys.queue
6388 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
6400 "storagemodelinput" 2000 NULL 0 true 0 false
6448 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6458 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary 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 auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6458 "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 false
6471 "statistics" 2000 NULL 0 true 0 false
6593 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
diff --git a/clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
b/clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
--- a/clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
+++ b/clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
@@ -424,7 +424,7 @@ create view sys.storage as select * from
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.
--- The auxillary column denotes the maximum space if all non-sorted columns
+-- The auxiliary column denotes the maximum space if all non-sorted columns
-- would be augmented with a hash (rare situation)
create view sys.tablestoragemodel
as select "schema","table",max(count) as "count",
@@ -432,7 +432,7 @@ as select "schema","table",max(count) as
sum(heapsize) as heapsize,
sum(hashes) as hashes,
sum(imprints) as imprints,
- sum(case when sorted = false then 8 * count else 0 end) as auxillary
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary
from sys.storagemodel() group by "schema","table";
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
@@ -1804,7 +1804,7 @@ 6453 "columnsize" "bigint" 64 0
6458 NUL
6454 "heapsize" "bigint" 64 0 6458 NULL true
4 NULL
6455 "hashes" "bigint" 64 0 6458 NULL true
5 NULL
6456 "imprints" "bigint" 64 0 6458 NULL true
6 NULL
-6457 "auxillary" "bigint" 53 0 6458 NULL true
7 NULL
+6457 "auxiliary" "bigint" 53 0 6458 NULL true
7 NULL
6460 "column_id" "int" 32 0 6471 NULL true 0
NULL
6461 "type" "clob" 0 0 6471 NULL true 1 NULL
6462 "width" "int" 32 0 6471 NULL true 2 NULL
@@ -1867,7 +1867,7 @@ 5737 "queue" 2000 "create view sys.queue
6388 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
6400 "storagemodelinput" 2000 NULL 0 true 0 false
6448 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6458 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary 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 auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6458 "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 false
6471 "statistics" 2000 NULL 0 true 0 false
6593 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
diff --git a/clients/Tests/SQL-dump_none.stable.out
b/clients/Tests/SQL-dump_none.stable.out
--- a/clients/Tests/SQL-dump_none.stable.out
+++ b/clients/Tests/SQL-dump_none.stable.out
@@ -384,7 +384,7 @@ create view sys.storage as select * from
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.
--- The auxillary column denotes the maximum space if all non-sorted columns
+-- The auxiliary column denotes the maximum space if all non-sorted columns
-- would be augmented with a hash (rare situation)
create view sys.tablestoragemodel
as select "schema","table",max(count) as "count",
@@ -392,7 +392,7 @@ as select "schema","table",max(count) as
sum(heapsize) as heapsize,
sum(hashes) as hashes,
sum(imprints) as imprints,
- sum(case when sorted = false then 8 * count else 0 end) as auxillary
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary
from sys.storagemodel() group by "schema","table";
create view sys.tracelog as select * from sys.tracelog();
SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users()
AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ;
@@ -1710,7 +1710,7 @@ 6253 "columnsize" "bigint" 64 0
6258 NUL
6254 "heapsize" "bigint" 64 0 6258 NULL true
4 NULL
6255 "hashes" "bigint" 64 0 6258 NULL true
5 NULL
6256 "imprints" "bigint" 64 0 6258 NULL true
6 NULL
-6257 "auxillary" "bigint" 53 0 6258 NULL true
7 NULL
+6257 "auxiliary" "bigint" 53 0 6258 NULL true
7 NULL
6260 "column_id" "int" 32 0 6271 NULL true 0
NULL
6261 "type" "clob" 0 0 6271 NULL true 1 NULL
6262 "width" "int" 32 0 6271 NULL true 2 NULL
@@ -1773,7 +1773,7 @@ 5737 "queue" 2000 "create view sys.queue
6188 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
6200 "storagemodelinput" 2000 NULL 0 true 0 false
6248 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6258 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary 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 auxillary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false
+6258 "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 false
6271 "statistics" 2000 NULL 0 true 0 false
6393 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
diff --git a/clients/mapiclient/mclient.1 b/clients/mapiclient/mclient.1
--- a/clients/mapiclient/mclient.1
+++ b/clients/mapiclient/mclient.1
@@ -370,7 +370,7 @@ The specifiers \fIS\fP, \fIt\fP, \fIv\fP
stand for System, table, view, sequence, function and schema
respectively.
Note that \fIS\fP simply switches on viewing system catalog objects,
-which is orthogonal on the other specifiers.
+which is orthogonal to the other specifiers.
.TP
\fB\ed[Stvsfn]+\fP \fIobject\fP
Describe the given
diff --git a/monetdb5/optimizer/opt_dataflow.c
b/monetdb5/optimizer/opt_dataflow.c
--- a/monetdb5/optimizer/opt_dataflow.c
+++ b/monetdb5/optimizer/opt_dataflow.c
@@ -126,7 +126,7 @@ void removeDataflow(MalBlkPtr mb)
}
}
/* remove the superflous variable initializations */
- /* when there are no auxillary barrier blocks */
+ /* when there are no auxiliary barrier blocks */
for (i = 0; i<limit; i++)
if ( delete[i] == 0 )
pushInstruction(mb,old[i]);
diff --git a/sql/ChangeLog.Oct2014 b/sql/ChangeLog.Oct2014
--- a/sql/ChangeLog.Oct2014
+++ b/sql/ChangeLog.Oct2014
@@ -1,3 +1,7 @@
# ChangeLog file for sql
# This file is updated with Maddlog
+* Mon Jan 19 2015 Sjoerd Mullender <[email protected]>
+- Fixed a typo in a column name of the sys.tablestoragemodel view
+ (auxillary changed to auxiliary).
+
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -218,7 +218,7 @@ as select \"schema\",\"table\",max(count
sum(columnsize) as columnsize,\n\
sum(heapsize) as heapsize,\n\
sum(indices) as indices,\n\
- sum(case when sorted = false then 8 * count else 0 end) as auxillary\n\
+ sum(case when sorted = false then 8 * count else 0 end) as auxiliary\n\
from sys.storagemodel() group by \"schema\",\"table\";\n\
update sys._tables\n\
set system = true\n\
@@ -893,7 +893,7 @@ create aggregate json.tojsonarray( x dou
" sum(heapsize) as heapsize,"
" sum(hashes) as hashes,"
" sum(imprints) as imprints,"
-" sum(case when sorted = false then 8 * count else 0 end) as auxillary"
+" sum(case when sorted = false then 8 * count else 0 end) as auxiliary"
" from sys.storagemodel() group by \"schema\",\"table\";\n");
pos += snprintf(buf + pos, bufsize - pos, "create view sys.storagemodel
as select * from sys.storagemodel();\n");
pos += snprintf(buf + pos, bufsize - pos, "update sys._tables set
system = true where name in ('storage','storagemodel','tablestoragemodel') and
schema_id = (select id from sys.schemas where name = 'sys');\n");
@@ -1010,6 +1010,60 @@ sql_update_oct2014_sp1(Client c)
return err; /* usually MAL_SUCCEED */
}
+static str
+sql_update_oct2014_sp2(Client c)
+{
+ size_t bufsize = 8192, pos = 0;
+ char *buf = GDKmalloc(bufsize), *err = NULL;
+ mvc *sql = ((backend*) c->sqlcontext)->mvc;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
