Date: 2020-11-13 10:00:34 +0100
From: Karl <>
To: SQL devs <>
Version: 11.39.5 (Oct2020)
CC: @PedroTadim

Last updated: 2020-11-24 11:37:23 +0100

Comment 28264

Date: 2020-11-13 10:00:34 +0100
From: Karl <>

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:82.0) Gecko/20100101 Firefox/82.0
Build Identifier:

Deallocating a specific prepared statement (via deallocate [prepare] ) causes all session statements to be deallocated.

This is new in 11.39.5, doesn't happen in 11.37.11.

Reproducible: Always

Steps to Reproduce:

sql> prepare select 1;
execute prepared statement using: EXEC 0(...)

sql> prepare select 2;
execute prepared statement using: EXEC 1(...)

sql> select count(*) from sys.prepared_statements;
2

sql> deallocate prepare 0;
operation successful

Actual Results:

sql> select count(*) from sys.prepared_statements;
0

Expected Results:

sql> select count(*) from sys.prepared_statements;
1

Comment 28265

Date: 2020-11-13 10:54:28 +0100
From: MonetDB Mercurial Repository <>

Changeset 9bb34d385f57 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=9bb34d385f57

Changeset description:

Added test and fix for bug #7010, ie don't clean query cache on deallocate mode. It is already handled by the mode itself