Bugs item #2233677, was opened at 2008-11-07 11:23
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2233677&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Lucas Serpa Silva (profetas)
Assigned to: Niels Nes (nielsnes)
Summary: SQL Command kills DB
Initial Comment:
With the following table:
===================================================
CREATE TABLE "adt"."adt_scene_witness" (
"scene_id" int NOT NULL,
"witness_name" varchar(260) NOT NULL,
"relation" CHARACTER LARGE OBJECT,
"reliability" CHARACTER LARGE OBJECT,
"state" CHARACTER LARGE OBJECT,
CONSTRAINT "adt_scene_witness_scene_id_witness_name_pkey" PRIMARY KEY
("scene_id", "witness_name"),
CONSTRAINT "adt_scene_witness_scene_id_fkey" FOREIGN KEY ("scene_id")
REFERENCES "adt_scene" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "adt_scene_witness_witness_name_fkey" FOREIGN KEY
("witness_name") REFERENCES "adt_witness" ("name") ON DELETE CASCADE
ON UPDATE CASCADE
);
==========================================
The following query will crash the DBMS Server
insert into adt_scene_witness values( (select v.scene_id , i.name from
adt_victim v,adt_witness i where v.name like '%Mary Ann Walker%' and i.name
like '%Patrick Mulshaw%'),'a','b','c','d');
Result
================================================
MAPI = [EMAIL PROTECTED]:50000
ACTION= read_line
QUERY = insert into adt_scene_witness values( (select v.scene_id ,
i.name from adt_victim v,adt_witness i where v.name like '%Mary Ann
Walker%' and i.name like '%Patrick Mulshaw%'),'a','b','c','d');
ERROR = Connection terminated
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-11-17 18:08
Message:
The bug can be represented by the following test:
create table t1 (id int NOT NULL);
insert into t1 values ((select id, name from tables));
drop table t1;
The problem is the sub select. It selects 2 columns and in the insertion I
am only inserting one attribute value... ;)
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-11-07 11:53
Message:
It is sql and not MonetDB5 problem....
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2233677&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
