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 <>
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 <>
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.
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).
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
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.
The text was updated successfully, but these errors were encountered: