Hi Fabio,
On Tue, Jan 26, 2010 at 11:28 AM, Ryan Pusztai <rpusz...@gmail.com> wrote:
> Hi Fabio,
>
> On Mon, Jan 25, 2010 at 5:56 PM, Fabio Mascarenhas <mascaren...@acm.org>wrote:
>
>> Yes, lpeg is a rock that you install with "luarocks install lpeg".
>>
>> Could you apply the attached patch to orbit/model.lua to try the new
>> LPEG-based matcher and write back? Thanks!
>>
>>
> This works great! I tested it on all my different sets of queries and it
> works all the time. I did not have to install anything because LPeg was
> already there. I used the Kepler installer to install Kepler and Xavante. It
> must have come in with that. Is this going to be included in Orbit? Since
> LPeg seems to already be a requirement.
>
> Again your support is very appreciated. Thanks so much.
> --
> Regards,
> Ryan
>
OK I did more testing and I found another case that doesn't work.
Here is the code:
self:find_all("user_id IS NULL and oem = ?", {BMW, order = "id asc"})
here is the generated SQL statement:
select * from visiondb_clip where user_id IS NULL BMWand id=id order by id
asc
Error message:
/usr/local/rocks//orbit/2.0.2-1/lua/orbit/model.lua:160: LuaSQL: error
executing query. MySQL: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'BMWand id=id order by id asc' at line 1
stack traceback:
[C]: in function 'error'
/usr/local/rocks//orbit/2.0.2-1/lua/orbit/model.lua:160: in function
(tail call): ?
(tail call): ?
./search_controller.lua:44: in function <./search_controller.lua:28>
(tail call): ?/usr/local/rocks//orbit/2.0.2-1/lua/orbit/model.lua:160:
LuaSQL: error executing query. MySQL: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'BMWand id=id order by id asc' at
line 1
stack traceback:
/usr/local/rocks//coxpcall/1.13.0-1/lua/coxpcall.lua:24: in function
(tail call): ?
(tail call): ?
/usr/local/rocks//orbit/2.0.2-1/lua/orbit.lua:497: in function
(tail call): ?
(tail call): ?
--
Regards,
Ryan
_______________________________________________
Kepler-Project mailing list
Kepler-Project@lists.luaforge.net
http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
http://www.keplerproject.org/
