You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Thomas Fox (Created) (JIRA)" <ji...@apache.org> on 2012/03/09 13:42:57 UTC
[jira] [Created] (TORQUE-185) Allow subselects which do not
reference a column
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
Re: [jira] [Created] (TORQUE-185) Allow subselects which do not reference a
column
Posted by Thomas Fox <Th...@seitenbau.net>.
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
Re: [jira] [Created] (TORQUE-185) Allow subselects which do not reference
a column
Posted by Thomas Vandahl <tv...@apache.org>.
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
[jira] [Closed] (TORQUE-185) Allow subselects which do not
reference a column
Posted by "Thomas Fox (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Fox closed TORQUE-185.
-----------------------------
> 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
> Assignee: Thomas Fox
> Fix For: 4.0-beta1
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] [Commented] (TORQUE-185) Allow subselects which do not
reference a column
Posted by "Thomas Fox (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13258173#comment-13258173 ]
Thomas Fox commented on TORQUE-185:
-----------------------------------
Currently, all tables are added to the from clause of a criteria. Currently the query would have an additional TABLE1 in the inner select clause.
select * from TABLE_1 where (select count(*) from TABLE2,TABLE1 where TABLE2.COLUMN1 = TABLE1.COLUMN1 AND TABLE2.COLUMN2=?) = 0;
It must be possible to define the from clause manually.
> 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
> Assignee: 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] [Assigned] (TORQUE-185) Allow subselects which do not
reference a column
Posted by "Thomas Fox (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Fox reassigned TORQUE-185:
---------------------------------
Assignee: Thomas Fox
> 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
> Assignee: 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] [Resolved] (TORQUE-185) Allow subselects which do not
reference a column
Posted by "Thomas Fox (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Fox resolved TORQUE-185.
-------------------------------
Resolution: Fixed
Fix Version/s: 4.0
> 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
> Assignee: Thomas Fox
> Fix For: 4.0
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org