"IN" SQL Operator Issue

Hi All.

I ran from the gs-ui:

SELECT count(*) FROM Transaccion WHERE clienteId=2 and estado = 2

It returns me "count = 5"

Later I run from the gs-ui:

SELECT count(*) FROM Transaccion WHERE clienteId=2 and estado in (2)

It returns me "count = 3"

If I use SELECT count(*) FROM Transaccion WHERE estado in (2) without "clienteId=2", everything works fine.

I need to use the IN operator because I need to include a list of values. What´s wrong?. I´m using GS XAP 6.6.0.

Thanks

{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=2691]{quote}

asked 2008-11-06 16:31:25 -0500

nullcipher2 gravatar image

updated 2013-08-08 09:52:00 -0500

jaissefsfex gravatar image
edit retag flag offensive close merge delete