Bugs item #1907905, was opened at 2008-03-05 13:00
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: Open
Resolution: None
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
----------------------------------------------------------------------
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
