Bugs item #1959456, was opened at 2008-05-07 14:19
Message generated for change (Settings changed) made by romulog
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959456&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: is not null syntax error

Initial Comment:
The following sql statements gave an expected syntax error:

create function f1()
RETURNS int
BEGIN
        return 0;
END;

create table t1 (id int);
select id from t1 where f1() IS NOT NULL;

drop function f1;
drop table t1;



MAPI  = [EMAIL PROTECTED]:50000
QUERY = select id from t1 where f1() IS NOT NULL;
ERROR = !syntax error, unexpected IS, expecting SCOLON in: "select id from t1 
where f1() is"

Romulo

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

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

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to