create schema leads to sql_stmt symbol(x)->token = CREATE_SCHEMA

[monetdb-team]

Date: 2010-05-23 11:05:07 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.1.1 (Mar2011) [obsolete]
CC: @njnes, @sjoerdmullender, @drstmane

Last updated: 2011-04-28 16:25:36 +0200

Comment 14054

Date: 2010-05-23 11:05:07 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3
Build Identifier:

create schema authorized monetdb;
causes a segfault.

Test file BugTracker-2010/Tests/crashonschema.sql

Reproducible: Always

Comment 14082

Date: 2010-06-05 12:28:12 +0200
From: @mlkersten

It seems this bug has been fixed in the head and Jun2010

Comment 14349

Date: 2010-07-10 08:38:02 +0200
From: @drstmane

Changeset 15deb74e59b4 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

renamed test for bug #2547: "crashonschema" -> "crashonschema.Bug-2547"

Comment 14350

Date: 2010-07-10 08:47:02 +0200
From: @drstmane

Changeset 952e47efdd0b made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

renamed stable output of test for bug #2547 also in Jun2010 branch

Comment 14351

Date: 2010-07-10 08:51:44 +0200
From: @drstmane

Changeset 64774fd570aa made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

back-ported test for bug #2547 to Jun2010

the bug is claimed to be fixed in Jun2010
and the test's stable output was already in Jun2010

Comment 14352

Date: 2010-07-10 09:00:20 +0200
From: @drstmane

Changeset f5cb2db5f58f made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

ignore varying address in error message
of test for bug #2547

Comment 14359

Date: 2010-07-10 10:37:31 +0200
From: @drstmane

While the initially crashing statements now indeed appear to work,
the last statement in the test still triggers an unexpected error:

create schema intro3
grant insert on t2010 to monetdb;

=>

QUERY = create schema intro3
ERROR = !sql_stmt symbol(b31073f8)->token = CREATE_SCHEMA

see also
Bug #2569 "INSERT INTO ... EXCEPT ... fails"

Comment 14608

Date: 2010-08-03 17:05:23 +0200
From: @drstmane

Changeset c3648477858c made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

undo of accidental checkin of incorrect error message;
see also bugs 2547 & 2569

Comment 14915

Date: 2010-09-20 10:05:14 +0200
From: @sjoerdmullender

Although it doesn't cause a server crash, there is still something wrong according to the test that accompanies this bug. Hence I'm reopening it.
When run, the test causes the server to spew the message:
sql_stmt symbol(7fe8b4007ab8)->token = CREATE_SCHEMA

Comment 15705

Date: 2011-03-30 13:06:07 +0200
From: @njnes

fixed (some time ago)

Comment 15749

Date: 2011-04-28 16:25:36 +0200
From: @sjoerdmullender

The Apr2011 release has been uploaded.