Date: 2015-01-20 11:21:12 +0100
From: @hannesmuehleisen
To: SQL devs <>
Version: 11.19.3 (Oct2014)
CC: @njnes

Last updated: 2015-05-07 12:38:13 +0200

Comment 20562

Date: 2015-01-20 11:21:12 +0100
From: @hannesmuehleisen

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.99 Safari/537.36
Build Identifier:

PREPARE SELECT id FROM tables WHERE name = ?;
works fine, output:
+---------+--------+-------+--------+--------+--------+
| type | digits | scale | schema | table | column |
+=========+========+=======+========+========+========+
| int | 32 | 0 | | tables | id |
| varchar | 1024 | 0 | null | null | null |
+---------+--------+-------+--------+--------+--------+

PREPARE SELECT id FROM tables WHERE name = LOWER(?);
crashes mserver (!),

Reproducible: Always

Steps to Reproduce:

1. run PREPARE SELECT id FROM tables WHERE name = LOWER(?);

Actual Results:

crash

Expected Results:

No crash

Comment 20564

Date: 2015-01-20 17:59:07 +0100
From: @hannesmuehleisen

Log says:
Assertion failed: (t1), function bind_func, file rel_select.c, line 1437.

Comment 20573

Date: 2015-01-26 18:51:57 +0100
From: MonetDB Mercurial Repository <>

Changeset 82edf3c91080 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=82edf3c91080

Changeset description:

added test for bug #3653

Comment 20574

Date: 2015-01-26 18:52:32 +0100
From: @njnes

fixed, ie added function lookup only on the function name