Changeset: 3cbbd75e0d78 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3cbbd75e0d78
Modified Files:
sql/backends/monet5/sql.c
sql/test/BugTracker/Tests/caching.SF-1651599.stable.out
Branch: default
Log Message:
make sure small inserts/deletes/updates are also flaged as point queries
diffs (27 lines):
diff --git a/sql/backends/monet5/sql.c b/sql/backends/monet5/sql.c
--- a/sql/backends/monet5/sql.c
+++ b/sql/backends/monet5/sql.c
@@ -66,6 +66,8 @@ rel_is_point_query(sql_rel *rel)
return 1;
if (is_project(rel->op))
return rel_is_point_query(rel->l);
+ if (is_modify(rel->op) && rel->card <= CARD_AGGR)
+ return rel_is_point_query(rel->r);
if (is_select(rel->op) && rel_is_table(rel->l) && rel->exps) {
is_point = 0;
/* just one point expression makes this a point query */
diff --git a/sql/test/BugTracker/Tests/caching.SF-1651599.stable.out
b/sql/test/BugTracker/Tests/caching.SF-1651599.stable.out
--- a/sql/test/BugTracker/Tests/caching.SF-1651599.stable.out
+++ b/sql/test/BugTracker/Tests/caching.SF-1651599.stable.out
@@ -2353,9 +2353,9 @@ Ready.
% .cache, .cache # table_name
% query, count # name
% clob, int # type
-% 118, 4 # length
+% 130, 1 # length
[ "select * from querycache() cache;", 1 ]
-[ "insert into foo (foo1,foo2,foo3,foo4,foo5,foo6,foo7) select
3869.3905,null,9208.3881,null,9725.9208,435.9519,9519.435;", 2000 ]
+[ "insert into foo (foo1,foo2,foo3,foo4,foo5,foo6,foo7) select
2543.5363,9249.8762,9081.9249,5363.9249,8762.9081,8516.5131,5131.8516;",
1 ]
#drop table foo;
#commit;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
