Bugs item #1848511, was opened at 2007-12-11 11:46
Message generated for change (Comment added) made by romulog
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1848511&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 2.20
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: select insert....

Initial Comment:
The following query crashes the mserver5-sql....

select insert('abcd',2,2,'ef') ;

Regards,
Romulo

----------------------------------------------------------------------

>Comment By: Romulo Goncalves (romulog)
Date: 2007-12-14 09:35

Message:
Logged In: YES 
user_id=1498628
Originator: YES

All the functions reported in this bug do not crash the Mserver5-SQL.

The fix was due the check ins:
For the insert
[Monetdb-sql-checkins] sql/src/common sql_types.mx, SQL_2-20,   1.95.2.6,
1.95.2.7

For the other 2 functions:
[Monetdb-checkins] MonetDB5/src/modules/kernel mmath.mx,
MonetDB_5-2,    1.35, 1.35.2.1
[Monetdb-checkins] MonetDB5/src/modules/mal pcre.mx, MonetDB_5-2,       1.49,
1.49.2.1
[Monetdb-sql-checkins] sql/src/common sql_types.mx, SQL_2-20,   1.95.2.7,
1.95.2.8

All the examples were extracted from the test:
sql/src/test/crashme.sql


----------------------------------------------------------------------

Comment By: Romulo Goncalves (romulog)
Date: 2007-12-11 12:40

Message:
Logged In: YES 
user_id=1498628
Originator: YES

More two queries that create the same crash..
select cot(1) ;
select patindex('%a%','crash') ;

This query does not create a crash anymore because soundex() is not a
valid operator in the Stable branch...
select soundex('hello') ;

Regards,
Romulo

----------------------------------------------------------------------

Comment By: Romulo Goncalves (romulog)
Date: 2007-12-11 11:50

Message:
Logged In: YES 
user_id=1498628
Originator: YES

The following queries create the same crash (at least it is in the same
place)...
select replace('abbaab','ab','ba') ;
select soundex('hello') ;

Regards,
Romulo

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1848511&group_id=56967

-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to