Revision history for SQL-Yapp
2.002 2017-12-03
- implement column subqueries, i.e. 'SELECT * FROM (SELECT ...) AS ...'
Thanks to Yoran Heling for pointing me to this and for beta testing.
- Allow COUNT(ALL a), COUNT(DISTINCT a), etc.; some syntax is now
relaxed and does not catch all syntax errors, i.e., this will delay
some syntax errors till the SQL DB reads the expression
- Fix documentation.
2.001 2016-04-24
- Fix Oracle 'AS' generation bug (CPAN #100454)
2 2013-04-07
- Added sqlDo{} and sqlFetch{} for more easy direct embedding into Perl
- Added prefix AND and OR
- Allow void context if there is no result
- BUG FIX: nested AND and OR sometimes expanded only into the outer operand
- many more tests
1.002 2011-08-05/0:00
- Removed HTML generation from Makefile.PL: not my business (and produced
'unknown' results on cpantesters)
- fixed documentation
- reworked documentation
- made hash interpolation deterministic by sorting keys
- BUG FIX: REGRESSION: fixed parens again (WHEN was broken in some cases)
- FEATURE: sqlCheck{...} + WHEN and hash interpolation
- throw error in void context so that we can fill this with life later
- changed required Perl version to 5.8 so that more tests can be done
(produced 'unknown' results on cpantesters)
Thanks again to cpantesters!
1.001 2011-07-31/0:00
- BUG FIX: 'use DBI' in syntax.t (bug found by CPAN tests, thank you!)
- BUG FIX: CAST(x AS y) cannot not be parsed (like several others)
- BUG FIX: DEFAULT CHARACTER SET is not parsed correctly
- BUG FIX: quote_identifier module option doesn't work
- fixed documentation
- more tests (simple syntax check from earlier manual testing)
- more tests (some dialect switching features)
- more tests (documentation examples)
- added prerequisites to Makefile.PL
1 2011-01-01/0:00
- First version, released on an unsuspecting world.