Bugs item #1613949, was opened at 2006-12-12 13:23
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1613949&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.14
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Ronald Oussoren (ronaldoussoren)
Assigned to: Niels Nes (nielsnes)
Summary: SQL parsing for LIKE expressions
Initial Comment:
A (Python) database abstraction layer that I use generates statements where
expressions make heavy use of parentheses. An example:
SELECT * FROM myTable
WHERE
key LIKE ("foo%")
This confuses the SQL parser in the current stable branch of monet:
sql> select * from myTable where key LIKE ('hel%');
MAPI = [EMAIL PROTECTED]:50000
QUERY = select * from myTable where key LIKE ('hel%');
ERROR = !syntax error, unexpected '(' in: "select * from mytable where key like
("
The same query works correctly with PostgreSQL, and supposedly other database
engines as well.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-01-15 20:46
Message:
Logged In: YES
user_id=43556
Originator: NO
Fixed parser and added a simple test in
src/test/BugTracker/Tests/like_exp.SF-1613949
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1613949&group_id=56967
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
