Changeset: 8fa82454536c for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8fa82454536c
Modified Files:
sql/src/sql/history.sql
Branch: Oct2010
Log Message:
Set the 'system' property on tables created by the system.
This is an adaptation of Fabian's patch for bug 2620 and should fix the bug.
diffs (33 lines):
diff -r 2cc898521dcb -r 8fa82454536c sql/src/sql/history.sql
--- a/sql/src/sql/history.sql Wed Sep 08 13:50:51 2010 +0200
+++ b/sql/src/sql/history.sql Wed Sep 08 14:25:35 2010 +0200
@@ -31,6 +31,10 @@
parse bigint, -- time in usec
optimize bigint -- time in usec
);
+update _tables
+ set system = true
+ where name = 'queryhistory'
+ and schema_id = (select id from schemas where name = 'sys');
-- Each query call is stored in the table callHistory using 'keepCall'.
-- At regular intervals the query history table should be cleaned.
@@ -57,10 +61,18 @@
inblock bigint, -- number of physical blocks read
oublock bigint -- number of physical blocks written
);
+update _tables
+ set system = true
+ where name = 'callhistory'
+ and schema_id = (select id from schemas where name = 'sys');
create view queryLog as
select qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory,
ql.tuples, ql.inblock, ql.oublock from queryHistory qd, callHistory ql
where qd.id = ql.id;
+update _tables
+ set system = true
+ where name = 'querylog'
+ and schema_id = (select id from schemas where name = 'sys');
-- the signature is used in the kernel, don't change it
create procedure keepQuery(
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
