db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fox <Thomas....@seitenbau.net>
Subject Re: [jira] [Created] (TORQUE-185) Allow subselects which do not reference a column
Date Tue, 13 Mar 2012 10:23:23 GMT
Thomas Vandahl wrote:
> 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.

No I believe this is a different case.
The original ticket covers subselects in the WHERE clause.
Your use case would cover subselects in the FROM clause.

Please open a new ticket.

    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