Date: 2020-07-29 09:23:47 +0200
From: Daniel Glöckner <<gloeckner.daniel>>
To: SQL devs <>
Version: 11.37.7 (Jun2020)
CC: @PedroTadim

Last updated: 2020-10-19 11:06:22 +0200

Comment 27954

Date: 2020-07-29 09:23:47 +0200
From: Daniel Glöckner <<gloeckner.daniel>>

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36
Build Identifier:

When using LIKE in WHERE conditions in SELECT statements on remote tables MonetDB reports the error: "Filter: missing function 'like'"

Reproducible: Always

Steps to Reproduce:

Steps to reproduce:

Open mclient connected to monetdb instance 1
create table remote_data (id int, name varchar(2048));
insert into remote_data values (1, 'Name 1');

Open mclient connected to monetdb instance 2
create remote table remote_data (id int, name varchar(2048)) on 'mapi:monetdb://$host:$port/$databasename';

select * from remote_data where name like 'N%';

Actual Results:

(mapi:monetdb://monetdb@$host/$database) Filter: missing function 'like'

Expected Results:

1 record is returned for the given test data

Comment 27958

Date: 2020-07-29 11:12:44 +0200
From: @PedroTadim

I just fixed this issue. Thanks for the bug report. It will be available at the next release.

Comment 28043

Date: 2020-09-01 10:51:06 +0200
From: Daniel Glöckner <<gloeckner.daniel>>

This is working fine on our end. Tested with a recent build of Oct202 branch, git HEAD is at dccd4bd.

Thanks a lot for fixing this, guys!