Hi,
I have a simple query like,
*SELECT tb1."id" AS "id"*
*FROM "ACCOUNTS" tb1*
*WHERE tb1."id" = 87*
* OR tb1."id" = 89 LIMIT 1*
which when running through JAVA using jdbc driver returns me only one row.
Whereas there are two rows in the table with those ids.
The explain plan of this (fro
Hi Anirudha,
No, there's no difference between using sqlline and a Java client (sqlline
is a Java client).
If you can put together a test with your original OR query and some sample
data that exhibits the behavior, please let us know.
Thanks,
James
On Wed, Jul 1, 2015 at 3:40 AM, Anirudha Khanna
Hi James,
Thanks for your reply, but further debugging pointed out that it was
something I was doing wrong on the client side and was able to resolve it.
Sorry for the inconvenience.
Cheers,
Anirudha
On Wed, Jul 1, 2015 at 9:45 PM, James Taylor wrote:
> Hi Anirudha,
> No, there's no difference