db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vandahl ...@apache.org>
Subject Re: [jira] [Created] (TORQUE-185) Allow subselects which do not reference a column
Date Mon, 12 Mar 2012 18:11:41 GMT
On 09.03.12 13:42, Thomas Fox (Created) (JIRA) wrote:
> Allow subselects which do not reference a column
> ------------------------------------------------
> 
>                  Key: TORQUE-185
>                  URL: https://issues.apache.org/jira/browse/TORQUE-185
>              Project: Torque
>           Issue Type: New Feature
>             Reporter: Thomas Fox
> 
> 
> Currently it is not possible to create the following prepared statement query:
> select * from TABLE_1 where (select count(*) from TABLE2 where TABLE2.COLUMN1 = TABLE1.COLUMN1
AND TABLE2.COLUMN2=?) = 0; 
> It should be possible to create such queries.

Would that allow queries of the form
select stuff from (select otherstuff from table) ?

If not, and while we are at it, I'd open a JIRA issue for that.

Bye, Thomas.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message