Hello,
i stumbled upon some strange behavior when using the LIKE construct
within selects. When we want to select all items that start with a 'n', like
>>> list(item_table.select("name LIKE 'n%'").execute())
we will get an exception.
This seems to happen due to a string formatting on the SQL statement, as
>>> list(item_table.select("name LIKE 'n%%'").execute())
works just fine. Now, if this behavior will be consistent all over SA
and across SA versions this may just be ok, if not i would consider it
a bug. Shall i fill a ticket?
--
Cheers, Sol.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
