Date: 2013-02-19 13:41:32 +0100
From: Christian Braun <>
To: SQL devs <>
Version: 11.15.1 (Feb2013)
CC: hcb, @njnes

Last updated: 2013-03-07 12:41:22 +0100

Comment 18520

Date: 2013-02-19 13:41:32 +0100
From: Christian Braun <>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0
Build Identifier:

Hello,

i updated from v11.13.9 "Oct2012-SP3" to v11.15.1 "Feb2013" (Debian packages). When connection to a local database with the mclient tool the "\d" command produces no output.

Kind regards,
Christian.

Reproducible: Always

Steps to Reproduce:

1.mclient db
2.\L trace.txt
3.\d

Comment 18521

Date: 2013-02-19 13:42:38 +0100
From: Christian Braun <>

Created attachment 184
client/server log

Attached file: trace.txt (text/plain, 20401 bytes)
Description: client/server log

Comment 18523

Date: 2013-02-19 14:00:42 +0100
From: Christian Braun <>

Any statement containing a like seems to fail:

sql>select name from sys.tables where name like 'qwe%';
TypeException:user.s7_1[23]:'pcre.like_filter' undefined in: _40:any := pcre.like_filter(_19:bat[:oid,:str], _38:bat[:oid,:oid], _23:str, _24:str, _41:bit)
TypeException:user.s7_1[24]:'algebra.leftfetchjoin' undefined in: _42:any := algebra.leftfetchjoin(_40:any, _19:bat[:oid,:str])
TypeException:user.s7_1[27]:'bat.append' undefined in: _47:any := bat.append(_4:bat[:oid,:str], _42:any, _48:bit)
TypeException:user.s7_1[42]:'pcre.like_filter' undefined in: _69:any := pcre.like_filter(_54:bat[:oid,:str], _68:bat[:oid,:oid], _58:str, _59:str, _41:bit)
TypeException:user.s7_1[43]:'algebra.leftfetchjoin' undefined in: _70:any := algebra.leftfetchjoin(_69:any, _54:bat[:oid,:str])
TypeException:user.s7_1[46]:'bat.append' undefined in: _73:any := bat.append(_47:any, _70:any, _48:bit)
program contains errors

Comment 18524

Date: 2013-02-19 14:12:46 +0100
From: @sjoerdmullender

How exactly did you do the update?
Can you check whether all monetdb-related packages are actually up-to-date?
It looks like there is a mix of old and new.

Comment 18525

Date: 2013-02-19 14:35:53 +0100
From: Christian Braun <>

Hello,

to update i ran:

apt-get upgrade
apt-get install monetdb5-server monetdb5-sql
dpkg --purge libmonetdb8

I got 6 MonetDB packages installed. All are 11.15.1:

dpkg -l | grep monet
ii libmonetdb-client6 11.15.1-20130212 MonetDB client/server interface library
ii libmonetdb-stream3 11.15.1-20130212 MonetDB stream library
ii libmonetdb8 11.15.1-20130212 MonetDB core library
ii monetdb-client 11.15.1-20130212 MonetDB database client
ii monetdb5-server 11.15.1-20130212 MonetDB database server version 5
ii monetdb5-sql 11.15.1-20130212 MonetDB SQL support for monetdb5

I have 2 databases on this machine. In both a "select name from sys.tables where name like 'qwe%';" fails. I created a new empty database and there the select/like works.

Kind regards,
Christian.

Comment 18526

Date: 2013-02-19 15:22:00 +0100
From: Christian Braun <>

To make sure this is not caused by my databases, i tested in a virtual machine.

Started with a clean installation of Debian Squeeze.
Installed MonetDB 11.13.9-20130115.
Created a new database.
Updated to 11.15.1-20130212
Then the statement fails: "select name from sys.tables where name like '%t%';"

When creating a new database after the update, the select and "\d" works in the new database.

Comment 18527

Date: 2013-02-19 15:54:34 +0100
From: @sjoerdmullender

The problem is that the implementation for like and ilike changed. This means that during a database update, we should do something.
The problem is, we forgot this, and the necessary queries don't work. :-(

What is needed is pretty simple. In each updated database the following five queries need to be executed:

drop filter function sys."like"(string, string, string);
drop filter function sys."ilike"(string, string, string);
create filter function sys."like"(val string, pat string, esc string) external name algebra.likesubselect;
create filter function sys."ilike"(val string, pat string, esc string) external name algebra.ilikesubselect;
insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('like', 'ilike') and f.type = 4 and f.schema_id = s.id and s.name = 'sys';

However, the first two don't work, and hence the create queries also don't work.

We will fix this in Feb2013-SP1. That should also fix an already updated database.

The upshot of all this is, you can't use like queries in an updated database (as you found out).

Comment 18539

Date: 2013-02-21 15:56:33 +0100
From: @njnes

fix in feb2013 branch.

Comment 18590

Date: 2013-03-07 12:41:22 +0100
From: @sjoerdmullender

Feb2013-SP1 has been released.