Server terminates upon UPDATE

[monetdb-team]

Date: 2011-07-07 11:07:57 +0200
From: cdxxxx
To: SQL devs <>
Version: 11.3.3 (Apr2011-SP1) [obsolete]

Last updated: 2011-07-29 10:52:43 +0200

Comment 15903

Date: 2011-07-07 11:07:57 +0200
From: cdxxxx

MonetDB5-SQL-Installer-x86_64-OID64-20110516.msi on Windows 7 x64

Script:

create table blobtest(b blob);
insert into blobtest values(cast('00' as blob));
update blobtest set b=cast(cast(b as text)||cast(b as text) as blob);

Result:

Client console:

Welcome to mclient, the MonetDB/SQL interactive terminal (Apr2011-SP1)
Database: MonetDB v11.3.3, 'oetest'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create table blobtest(b blob);
operation successful
sql>insert into blobtest values(cast('00' as blob));
1 affected row (12.894ms)
sql>update blobtest set b=cast(cast(b as text)||cast(b as text) as blob);
MAPI = monetdb@localhost:50000
ACTION= read_line
QUERY = update blobtest set b=cast(cast(b as text)||cast(b as text) as blob);
ERROR = !Connection terminated
Press any key to continue . . .

Server console:

c:\Program Files\MonetDB\MonetDB5>rmdir /S /Q d:\db\MonetDB5
c:\Program Files\MonetDB\MonetDB5>mkdir d:\db\MonetDB5
c:\Program Files\MonetDB\MonetDB5>setlocal&&SET APPDATA=d:\db\MonetDB5&&MSQLServer.bat --dbname=oetest&&endlocal
MonetDB 5 server v11.3.3 "Apr2011-SP1"
Serving database 'oetest', using 4 threads
Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
Found 3.749 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved
Visit http://monetdb.cwi.nl/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
MonetDB/SQL module loaded

SQL catalog created, loading sql scripts once
c:\Program Files\MonetDB\MonetDB5>

Comment 15908

Date: 2011-07-07 17:50:13 +0200
From: @sjoerdmullender

Changeset fc0f336bbc42 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for bug #2832.

Comment 15909

Date: 2011-07-07 17:50:14 +0200
From: @sjoerdmullender

Changeset bcdf2606e893 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Fix for bug #2832.
The cast code needs to differentiate between varsized and non-varsized
data types.

Comment 15910

Date: 2011-07-07 17:53:18 +0200
From: @sjoerdmullender

The bug is fixed in the Apr2011 branch.
The problem was specifically with BLOBs.

Comment 16005

Date: 2011-07-29 10:52:43 +0200
From: @sjoerdmullender

The Apr2011-SP2 bugfix release is out.