LIKE: batstr.like+algebra.uselect called instead of pcre.like_filter #3179
Last updated: 2013-02-19 13:17:57 +0100
Date: 2012-11-07 15:09:36 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.60 Safari/537.11
Take the following query:
sql>select name,func from functions where name like '%optimizers%';
And its explain (I used the sequential_pipe to get a more readable explain):
sql>explain select name,func from functions where name like '%optimizers%';
Notice that pcre.like_filter() is used.
Now, I define the following function:
create function contains(str string, substr string)
And get the explain for the following query (equivalent to the previous one):
sql>explain select name,func from functions where contains(name, 'optimizers');
Notice that, this time, pcre.like_filter() is replaced now with batstr.like() + algebra.uselect().
In principle I wouldn't consider this as a bug, as long as this difference comes for a reason.
Steps to Reproduce:
MonetDB 5 server v11.11.12 (64-bit, 64-bit oids)
Date: 2012-11-25 15:20:19 +0100
The mal plan with function will first inline the contains function, then
So we need to align names of single value, bulk and select operators,
Date: 2012-11-27 10:05:39 +0100
keep alias in the loop
Date: 2012-11-27 14:35:11 +0100
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=89a9ebc92eda
Date: 2013-02-19 13:17:57 +0100
Feb2013 has been released.
The text was updated successfully, but these errors were encountered: