Bugs item #1841759, was opened at 2007-11-30 15:51
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841759&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 CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: insert text with repeat...
Initial Comment:
The following insertion crashes Mserver5-SQL:
create temp table pp (f1 text);
insert into pp values (repeat('abcdefghijkl', 100000));
Regards,
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2007-12-01 16:03
Message:
Logged In: YES
user_id=1498628
Originator: YES
Because we are using a temp table (the content is destroyed after the
commit)
I inserted a Start transaction to check the temp table status after the
insert.
I Approved the out output for the test and the test can be closed.
Regards,
Romulo
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2007-12-01 15:30
Message:
Logged In: YES
user_id=1498628
Originator: YES
The test to this bug was added in:
sql/src/test/BugTracker/Tests/insert_text_with_repeat.SF-1841759
The Mserver5 does not crash after Niels fix. However, the insertion does
not insert any tuple in the table.
I did a select over the table after the insertion and there is not tuples
inserted.
So I will keep the bug open and the resolution is none.
Regards,
Romulo
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2007-11-30 23:09
Message:
Logged In: YES
user_id=43556
Originator: NO
the function definition in sql_types was incorrect. Will you add the test
script?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841759&group_id=56967
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
