Bug #113499 for SQL-Statement: parsing error with using sub-selects

Fri Apr 01 11:21:39 2016 PIRZYK [...] cpan.org - Ticket created

CC:	jpirzyk [...] akamai.com
Subject:	parsing error with using sub-selects

Given this simplified SQL statement: SELECT * FROM ( SELECT machineip, location FROM machinedetails WHERE network="foo" ) fails with this error: Bad table or column name: '(SELECT' has chars not alphanumeric or underscore! at $INSTALLDIR/SQL/Statement.pm line 90 Now reading the BUGS and LIMITATIONS section I see this: Some SQL commands/features are not supported (most of them cannot by design), as LOCK TABLE, using indices, sub-selects etc. Currently the statement for missing features is: I plan to create a SQL::Statement v2.00 based on a pure Backus-Naur-Form parser ... So my question is how is v2.00 going and is there an estimated release date?

Fri Apr 01 11:47:41 2016 REHSACK [...] cpan.org - Correspondence added

On Fri Apr 01 11:21:39 2016, PIRZYK wrote: Show quoted text

> Given this simplified SQL statement: > > SELECT * > FROM ( > SELECT machineip, > location > FROM machinedetails > WHERE network="foo" > ) > > fails with this error: > > Bad table or column name: '(SELECT' has chars not alphanumeric or > underscore! at $INSTALLDIR/SQL/Statement.pm line 90 > > Now reading the BUGS and LIMITATIONS section I see this: > > Some SQL commands/features are not supported (most of them cannot by > design), as LOCK TABLE, using indices, sub-selects etc. > > Currently the statement for missing features is: I plan to create > a SQL::Statement v2.00 based on a pure Backus-Naur-Form parser ... > > So my question is how is v2.00 going and is there an estimated release > date?

I don't have any near plans for v2.00 - I tried but the joint-venture was killed by participants by ignoring SQL::Statement (no use-case). Same participants killed my engagement to invest into new development for Perl5. Since several years I did not any business with SQL::Statement. When I would come back to such a business which brings me back needing SQL::Statement, I will do it using Perl6. S::S v2 for Perl5 could only be done by being sponsored.

Fri Apr 01 11:47:42 2016 The RT System itself - Status changed from 'new' to 'open'

Wed Apr 06 09:43:45 2016 REHSACK [...] cpan.org - Correspondence added

I think the question is answered. No checks wrt. the answer, can be closed.

Wed Apr 06 09:43:49 2016 REHSACK [...] cpan.org - Status changed from 'open' to 'resolved'