Changeset: e3d5d6145be0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e3d5d6145be0
Modified Files:
Branch: default
Log Message:
Merge with Oct2010 branch.
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 97998a7ac3e3 -r e3d5d6145be0 sql/src/sql/history.sql
--- a/sql/src/sql/history.sql Wed Sep 08 13:54:50 2010 +0200
+++ b/sql/src/sql/history.sql Wed Sep 08 14:26:23 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
