Forum: Building VoltDB Applications

Post: What time can support in about "IN" syntax

What time can support in about "IN" syntax
dl_zhenglp
May 29, 2012
Hi,
I view the ENG-2779 issue(https://issues.voltdb.com/browse/ENG-2779).
We want to use "IN" syntax in SQL STMT, can any one tell me when it can be fix?
IN support
jpiekos
May 29, 2012
It's on our roadmap (and product backlog), but we have no target release at present.
Perhaps you can post an example of your queries that require IN support and we can help you express them differently?
John
I'm trying to do the
francis
Jul 26, 2012
It's on our roadmap (and product backlog), but we have no target release at present.
Perhaps you can post an example of your queries that require IN support and we can help you express them differently?
John


I'm trying to do the following:

SELECT * FROM items WHERE disabled=0 AND itemID IN (SELECT contentID as itemID FROM categories_selected WHERE contentType='items' AND categoryID=?)
In and sub-select
awilson
Jul 26, 2012
I'm trying to do the following:

SELECT * FROM items WHERE disabled=0 AND itemID IN (SELECT contentID as itemID FROM categories_selected WHERE contentType='items' AND categoryID=?)


Hi,
In and sub-selects are on the roadmap but are not currently supported.
That's what we need!
jerrykey1980
May 29, 2012
That's what we need!