Bugs item #1907905, was opened at 2008-03-05 13:00
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907905&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: coalesce = coalesce...
Initial Comment:
The following sql code crash mserver...
CREATE TABLE syscolumns(
id int,
length int,
uid int,
nme char(100),
xtype char(100)
);
CREATE TABLE spt_datatype_info(
length int,
ss_dtype varchar(100),
"AUTO_INCREMENT" varchar(100)
);
CREATE FUNCTION fDocColumnsWithRank(TableName varchar(400))
RETURNS float
BEGIN
return table ( SELECT
c.nme as nme
FROM
spt_datatype_info d,
syscolumns c
WHERE
coalesce(d."AUTO_INCREMENT",0) =
coalesce(ColumnProperty (c.id, c.nme, 'IsIdentity'),0)
);
END;
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-03-09 00:27
Message:
Logged In: YES
user_id=1498628
Originator: YES
Fixed :
[Monetdb-sql-checkins] sql/src/server sql_psm.mx, SQL_2-22, 1.50, 1.50.2.1
sql_select.mx, SQL_2-22, 1.219.2.5, 1.219.2.6
Modified Files:
Tag: SQL_2-22
sql_psm.mx sql_select.mx
Log Message:
fixes for the bugs
[ 1907905 ] coalesce = coalesce...
(added some more checks for semantic problems)
and
[ 1907006 ] range select....
Properly interpret 0<id>10 as a boolean (0<id) followed by the selection
criteria (bool > 10).
test added in:
sql/src/test/BugTracker/Tests/coalesce_equal_coalesce.SF-1907905.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907905&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
