[TORQUE-185] Allow subselects which do not reference a column

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0-beta1
• Assignee: Thomas Fox
• Reporter: Thomas Fox
• Created: 09/Mar/12 12:41
• Updated: 24/Sep/12 07:06
• Resolved: 24/Apr/12 11:56

Description

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.

Sub-Tasks

• create method to set FROM clause from Criteria: Closed
• Allow other types than Columns as left hand side of a comparison in Criteria.: Closed
• create methods to create custom sql queries with prepared statement replacements: Closed