spadefoot/kohana-orm-leap — Issue #18: Oracle - using the ->where on a select breaks statement
Author: ekarlso
Created: 2012-02-01 10:11:46+00:00
State: open

$select->where("BELONGS_TO", "=", "X");

$select->page($this->page_offset, $this->page_limit);
$select->where("BELONGS_TO", "=", "u333v");
$select->order_by($this->sort_column, $this->sort_direction);

This produced a SQL statement like:

SELECT * FROM (SELECT * FROM "SERVERS" WHERE "BELONGS_TO" = 0x7533333376 ORDER BY "SERVER" DESC) WHERE ROWNUM <= 20;

I think the 0x?.. there breaks the SELECT no?

Maybe some kind of error with the builder?