Bugs item #1959456, was opened at 2008-05-07 12:19
Message generated for change (Comment added) made by nielsnes
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: Closed
>Resolution: Fixed
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
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-05-22 13:15
Message:
Logged In: YES
user_id=43556
Originator: NO
there where 2 bugs. 1) we didn't handle arbitrary expressions before the
IS NOT NULL and this a special case predicate (return all or nothing).
Both problems are fixed.
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-05-08 08:45
Message:
Logged In: YES
user_id=1498628
Originator: YES
test added at:
sql/src/test/BugTracker/Tests/is_not_null_syntax_error.SF-1959456.sql
----------------------------------------------------------------------
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: 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
