Skip Menu |

This queue is for tickets about the SQL-Statement CPAN distribution.

Report information
The Basics
Id: 56988
Status: rejected
Priority: 0/
Queue: SQL-Statement

People
Owner: Nobody in particular
Requestors: whatever [...] davidnicol.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: (no value)
Fixed in: (no value)



Subject: sub-selects
sub-selects seem like they should be tractable. There are two cases, a select that returns one value that can be used instead of a literal or placeholder, and a select that returns a list that is only usable with the IN operator. Am I missing something making sub-selects more complex than that?
This is a known to-do for SQL::Statement 2.0. It's well documented that this is a limitation and there's no plan to speed up to next major version. And yes, you're missing something (I recommend reading e.g. "Databases" from Saake). Of course, money could change that plan - but as long as it's done in my free and unpaid time, there're many reasons for missing features: family, friends, hobbies away from computer, ...