Brian Candler
3/20/2007 9:09:00 PM
> OCIError: ORA-00920: invalid relational operator: SELECT entities.id AS
> t0_r0, entities.key_attribute_id AS t0_r1, entities.key_value AS t0_r2,
> entities.state AS t0_r3, avpairs.id AS t1_r0, avpairs.entity_id AS t1_r1,
> avpairs.attribute_id AS t1_r2, avpairs.value AS t1_r3 FROM entities LEFT
> OUTER JOIN avpairs ON avpairs.entity_id = entities.id WHERE (0 OR
> (entities.key_attribute_id=2 AND entities.key_value='vpn1s4') OR
> (entities.key_attribute_id=3 AND entities.key_value='000001'))
Doh! Running the query under yasql shows the error to be at
WHERE (0 OR ...
and removing it makes the problem goes away. And this was really just
laziness on my part in formulating the SQL statement builder.
Sorry for the noise.
Regards,
Brian.