Changeset: fcc49f6b24f6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fcc49f6b24f6
Modified Files:
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-2013/Tests/qualified_aggrname.Bug-3332.sql
sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out
sql/test/bugs/Tests/crash_order_by.sql
sql/test/bugs/Tests/simple_view.sql
sql/test/bugs/insert_delete-bug-sf-904025.sql
Branch: Dec2016
Log Message:
Fix tests: a quote character cannot occur by itself in a CSV file.
diffs (173 lines):
diff --git a/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
b/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
--- a/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
+++ b/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
--- a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
+++ b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
---
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
+++
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
--- a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
+++ b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git
a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
--- a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
+++ b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
@@ -50,8 +50,8 @@ Ready.
#2086 "idxs" 2000 NULL 0 true 0 false 0
[ 40 ]
#select sys.median(cast (id as double)) from tbls;
-% sys.L3 # table_name
-% L2 # name
+% sys.L5 # table_name
+% L4 # name
% double # type
% 24 # length
[ 5183 ]
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
@@ -55,7 +55,7 @@ 6995 netcdf_attrs 2000 0 true 0 0
7034 storage 2000 "create view sys.""storage"" as select * from
sys.""storage""();" 1 true 0 0
7046 storagemodelinput 2000 0 true 0 0
7094 storagemodel 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 0
-7104 tablestoragemodel 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum("imprints") as "imprints",\n\tsum(case when sorted = false then
8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 0
+7104 tablestoragemodel 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(""imprints"") as ""imprints"",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 0
7117 statistics 2000 0 true 0 0
7245 systemfunctions 2000 0 true 0 0
diff --git
a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
--- a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
+++ b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
@@ -59,12 +59,12 @@ Ready.
% sys.tbls, sys.tbls, sys.tbls, sys.tbls, sys.tbls,
sys.tbls, sys.tbls, sys.x # table_name
% name, schema_id, query, type, system, commit_action, access,
s # name
% varchar, int, varchar, smallint, boolean,
smallint, smallint, clob # type
-% 17, 4, 433, 1, 5, 1, 1, 6 # length
+% 17, 4, 526, 1, 5, 1, 1, 6 # length
[ "_tables", 2000, "", 0, true, 0, 0, "%able%"
]
[ "_tables", 2106, "", 0, true, 2, 0, "%able%"
]
[ "tables", 2000, "SELECT * FROM (SELECT p.*, 0 AS \"temporary\",
CAST(CASE WHEN system THEN type + 10 /* system table/view */ ELSE (CASE WHEN
commit_action = 0 THEN type /* table/view */ ELSE type + 20 /* global temp
table */ END) END AS SMALLINT) AS table_type FROM \"sys\".\"_tables\" AS p
UNION ALL SELECT t.*, 1 AS \"temporary\", CAST(type + 30 /* local temp table */
AS SMALLINT) AS table_type FROM \"tmp\".\"_tables\" AS t) AS tables where
tables.type <> 2;", 1, true, 0, 0, "%able%" ]
[ "table_types", 2000, "", 0, true, 0, 0,
"%able%" ]
-[ "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(",
1, true, 0, 0, "%able%" ]
+[ "tablestoragemodel", 2000, "-- A summary of the table storage requirement
is is available as a table view.\n-- The auxiliary column denotes the maximum
space if all non-sorted columns\n-- would be augmented with a hash (rare
situation)\ncreate view sys.tablestoragemodel\nas select
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(\"imprints\") as \"imprints\",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
\"schema\",\"table\";", 1, true, 0, 0, "%able%" ]
#drop table x;
# 10:06:32 >
diff --git a/sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
b/sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
--- a/sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
+++ b/sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql
b/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql
--- a/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql
+++ b/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql
@@ -56,7 +56,7 @@ 7007 netcdf_attrs 2000 10 true 0
0 0
7046 storage 2000 "create view sys.""storage"" as select * from
sys.""storage""();" 11 true 0 0 0
7058 storagemodelinput 2000 10 true 0 0 0
7106 storagemodel 2000 create view sys.storagemodel as select * from
sys.storagemodel(); 11 true 0 0 0
-7116 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"";" 11 true 0 0 0
+7116 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"";" 11 true 0 0 0
7129 statistics 2000 10 true 0 0 0
7227 files 7176 10 true 0 0 0
7240 sq 7176 10 true 0 0 0
diff --git a/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out
b/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out
--- a/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out
+++ b/sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out
@@ -70,7 +70,7 @@ Ready.
#7176 "bam" 3 3 true
[ 4 ]
#SELECT NULL AS table_catalog, (SELECT s.name FROM schms s WHERE t.schema_id =
s.id) AS table_schema FROM tbls t ORDER BY table_schema;
-% .L1, .L4 # table_name
+% .L2, .L11 # table_name
% table_catalog, table_schema # name
% char, varchar # type
% 0, 3 # length
@@ -129,7 +129,7 @@ Ready.
[ NULL, "tmp" ]
[ NULL, "tmp" ]
#SELECT (SELECT s.name FROM schms s WHERE t.schema_id = s.id) AS table_schema,
NULL AS table_catalog FROM tbls t ORDER BY table_schema;
-% .L3, .L4 # table_name
+% .L6, .L10 # table_name
% table_schema, table_catalog # name
% varchar, char # type
% 3, 0 # length
diff --git a/sql/test/bugs/Tests/crash_order_by.sql
b/sql/test/bugs/Tests/crash_order_by.sql
--- a/sql/test/bugs/Tests/crash_order_by.sql
+++ b/sql/test/bugs/Tests/crash_order_by.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/bugs/Tests/simple_view.sql
b/sql/test/bugs/Tests/simple_view.sql
--- a/sql/test/bugs/Tests/simple_view.sql
+++ b/sql/test/bugs/Tests/simple_view.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "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 0
+6438 "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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/bugs/insert_delete-bug-sf-904025.sql
b/sql/test/bugs/insert_delete-bug-sf-904025.sql
--- a/sql/test/bugs/insert_delete-bug-sf-904025.sql
+++ b/sql/test/bugs/insert_delete-bug-sf-904025.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary 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 0
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary 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 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
