| 1 |
Changes log for Perl extension SQL::Statement |
| 2 |
|
| 3 |
1.414 2020-10-21 |
| 4 |
* re-release 1.413_001 without further changes |
| 5 |
|
| 6 |
1.413_001 2020-09-28 |
| 7 |
* Spell check |
| 8 |
* Be specific in which files to skip from the distribution |
| 9 |
* Author fixes |
| 10 |
* Makefile.PL: port WriteMakefile1 from Hash::Merge |
| 11 |
* .travis.yml: update for Xenial VMs |
| 12 |
* cleanup MANIFEST.SKIP |
| 13 |
* bump copyright year |
| 14 |
* SQL::Parser correctly parse VALUES and SET clauses containing function invocations with several arguments |
| 15 |
patch provided by Edgar J. Holleis |
| 16 |
|
| 17 |
1.412 2017-04-06 |
| 18 |
* Release 1.411_001 without further changes as 1.412 |
| 19 |
|
| 20 |
1.411_001 2017-03-30 |
| 21 |
[Bug fixes] |
| 22 |
* Fix http://www.perlmonks.org/?node_id=1167381 (NumericEval: fix |
| 23 |
typo on error handling) (thanks to Yanick Champoux, James R. Leu) |
| 24 |
* fix repo url and t/02execute.t (Reini Urban, Mohammad S Anwar) |
| 25 |
* fix test failing with blead-perl (Jens Rehsack) |
| 26 |
|
| 27 |
[Improvements] |
| 28 |
* Refactor constraints processing (Ovidiu Gheorghies) |
| 29 |
* Support parsing of complex JOIN clause (containing OR and ()'s) (James R. Leu) |
| 30 |
* handle backtick quoting (Ben Hengst) |
| 31 |
|
| 32 |
1.410 2016-04-11 |
| 33 |
[Bug fixes] |
| 34 |
* Fix RT#113625 - Unnecessary x-bits (Kent Fredric, Mohammad S Anwar) |
| 35 |
|
| 36 |
[Documentation] |
| 37 |
* pod2markdown README.md from lib/SQL/Statement.pm |
| 38 |
|
| 39 |
|
| 40 |
1.409 2016-04-06 |
| 41 |
* Release 1.408_001 without further changes as 1.409 |
| 42 |
|
| 43 |
1.408_001 2016-03-07 |
| 44 |
[Bug fixes] |
| 45 |
* Fix RT#112530 - t/06virtual.t fails with -Duselongdouble (thanks |
| 46 |
Slaven Rezic) |
| 47 |
* Fix RT#105852 - dependency installation isn't triggered properly in |
| 48 |
cpan (thanks Mithaldu) |
| 49 |
* Fix RT#99349 - bind variables are not bound to placeholders in the |
| 50 |
correct order (thanks [email protected]) |
| 51 |
|
| 52 |
[Documentation] |
| 53 |
* Update Copyright statements, add where missing (according to records) |
| 54 |
* Add license conditions where missing |
| 55 |
* bundle copy of license conditions to distribution |
| 56 |
|
| 57 |
1.407 2015-05-26 |
| 58 |
* Release 1.406_002 without further changes as 1.407 |
| 59 |
|
| 60 |
1.406_002 2015-05-22 |
| 61 |
[Bug fixes] |
| 62 |
* Fix RT#104579: Redundant argument in sprintf |
| 63 |
submitted by Slaven Rezić |
| 64 |
* Fix RT#104589: t/14parse.t fails if Test::Deep is not installed |
| 65 |
submitted by Slaven Rezić |
| 66 |
|
| 67 |
1.406_001 2015-05-20 |
| 68 |
[Misc] |
| 69 |
* clean up Makefile.PL, meta-data and requirements |
| 70 |
|
| 71 |
[Bug fixes] |
| 72 |
* Fix SQL function CONV to use limited number of sane character sets |
| 73 |
for conversion and rely on Math::Base::Convert instead of own code |
| 74 |
(suggested by Tom Wyant in RT#100551, thanks Tom) |
| 75 |
* fix handling of literal identifiers and for every IMPORT rely on |
| 76 |
literal identifiers to avoid parser errors for column names starting |
| 77 |
with numbers or similar |
| 78 |
* fix capability cache: "$class->can(...)" might return undef and |
| 79 |
therefore inexistent capabilities are queried to often |
| 80 |
* Fix COUNT(DISTINCT col) without GROUP BY clause (patch submitted |
| 81 |
by Grant Mathews, thanks Grant) |
| 82 |
* Fix "parse insert with functions" submitted via GitHub PR#6 by |
| 83 |
fecundf and RT#96628 |
| 84 |
* Fix RT#93320: SQL-style comment can not begin inside quotes by |
| 85 |
Tom Wyant - thanks Tom |
| 86 |
|
| 87 |
[Improvements] |
| 88 |
* reduce blocks and rewrite some inner statements to increase speed |
| 89 |
of sql command processing |
| 90 |
|
| 91 |
1.405 2013-06-17 |
| 92 |
[Bug fixes] |
| 93 |
* INSERT now expands incomplete rows (Thanks to H.Merijn Brand) |
| 94 |
|
| 95 |
1.404 2013-05-23 |
| 96 |
[Bug fixes] |
| 97 |
* re-enable cleanup test_output* after test done |
| 98 |
* recommend Text::Soundex and do soundex-test only when have it, |
| 99 |
because it's going to be removed from core for Perl 5.19 (thank Merijn) |
| 100 |
|
| 101 |
1.403 2013-05-22 |
| 102 |
[Bug fixes] |
| 103 |
* fix documentation (rt#84889 - thanks Xavier Guimard and Florian, |
| 104 |
rt#85257 - thanks Andreas Koenig) |
| 105 |
|
| 106 |
1.402 2012-12-19 |
| 107 |
[Misc] |
| 108 |
* add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik) |
| 109 |
* add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik) |
| 110 |
* clarify Test::Simple 1.90 is required for building |
| 111 |
(RT#81925, Sam Ferencik) |
| 112 |
|
| 113 |
[Bug fixes] |
| 114 |
* fix leaking reference to open tables outside SQL::Statement::execute |
| 115 |
(fixes RT#81523) |
| 116 |
* looks_like_number identifies 'nan' as number sometimes (add regex to |
| 117 |
t/06virtual.t) |
| 118 |
|
| 119 |
1.401 2012-10-29 |
| 120 |
[Misc] |
| 121 |
* Switch to 3-digited minor version |
| 122 |
|
| 123 |
[Bug fixes] |
| 124 |
* undo literal replaces in subqueries before passing them to the |
| 125 |
child parser |
| 126 |
* Fix doc typo RT#76764 (STEFFENW) - thanks Steffen |
| 127 |
* Fix typo documented in RT#71914 (reported by Ze'ev Atlas, |
| 128 |
fixed by H.Merijn Brand) - thanks Ze'ev and Merijn |
| 129 |
* Fix DROP TABLE behaviour and error detection |
| 130 |
|
| 131 |
[Improvements] |
| 132 |
* Improve documentation/tests for multiple JOIN's from RT#69573 |
| 133 |
(from BBYRD) with modifications |
| 134 |
* Filling in the SQL92 gaps for functions (BBYRD) from RT#72638 |
| 135 |
with minor modifications - thanks Brendan |
| 136 |
|
| 137 |
1.33 2011-02-05 |
| 138 |
[Bug fixes] |
| 139 |
* Move test dependencies to (unreleased) Bundle::Test::SQL::Statement |
| 140 |
to avoid circular dependencies |
| 141 |
|
| 142 |
1.32 2011-01-19 |
| 143 |
[Bug fixes] |
| 144 |
* Fixed invalid check for escaped single quotes |
| 145 |
* Fixed unpermitted modification of array source for table creation |
| 146 |
(CREATE TABLE AS IMPORT(?),[[..],[..]]) |
| 147 |
* Fixing alias used in ORDER BY (RT#61384, thanks jvm) |
| 148 |
* Fixing ORDER BY behavior for multiple sort columns |
| 149 |
(slower, but guaranteed correct) |
| 150 |
|
| 151 |
[Improvements] |
| 152 |
* renamed fetch-method into fetch_row (keep fetch() as alias) and |
| 153 |
add a fetch_rows() to fetch all rows at once |
| 154 |
* Different accessors for direction of ORDER BY clause query part |
| 155 |
and it's boolean equivalent "desc" (0 or 1, respectively) |
| 156 |
* Add a lot of Pure-Perl DBD's as build dependency for testing |
| 157 |
(skip DBD::AnyData for now, because it seems to be broken - check |
| 158 |
for next release) |
| 159 |
|
| 160 |
[Misc] |
| 161 |
* Bump requirement of DBI to 1.616 |
| 162 |
* switch for fully external DBD tests from DBD::XBase to DBD::SQLite |
| 163 |
* Document another limitation (lacking implicit creating temp table |
| 164 |
during processing a query using the same table with different aliases |
| 165 |
twice) |
| 166 |
|
| 167 |
1.31 2010-08-16 |
| 168 |
[Bug fixes] |
| 169 |
* Fix misbehaviour of DELETE/UPDATE for tables with only basic capabilities |
| 170 |
and no matching where clause (reported by H.Merijn Brand and Drew ...) |
| 171 |
* Fix some column identifier splits to respect quoted tables |
| 172 |
|
| 173 |
[Improvements] |
| 174 |
* Optimized some core routines between 25% and 50%. |
| 175 |
|
| 176 |
1.30 2010-08-01 |
| 177 |
[Bug fixes] |
| 178 |
* remove blib directory from distfile |
| 179 |
|
| 180 |
1.29 2010-08-01 released August 1st, 2010 |
| 181 |
[Bug fixes] |
| 182 |
* add some getters as documented in SQL::Statement::Structure |
| 183 |
(fixes RT#59834, thanks John Wiersba) |
| 184 |
* add missing import of function croak to SQL::Statement::Term::ColumnValue |
| 185 |
* fix assignment of parser result (doesn't run with perl-5.13.3) |
| 186 |
|
| 187 |
1.28 2010-07-15 |
| 188 |
[Improvements] |
| 189 |
* Introduce new "capability" method for SQL::Statement and SQL::Eval::Table |
| 190 |
+ Add capability for "insert_new_row" to allow DBD::DBM to fix PK |
| 191 |
constrain on INSERT statements. |
| 192 |
* Performance of IMPORT feature improved (thanks to Sven Probst, RT#57322) |
| 193 |
|
| 194 |
[Bug fixes] |
| 195 |
* expect every table object being derived from SQL::Eval::Table |
| 196 |
* rewrite DELETE and UPDATE command based on table capabilities |
| 197 |
* add abstract methods for all methods derived classes must override |
| 198 |
(this means, open_table for SQL::Statement deriveds must be overridden |
| 199 |
and all data access methods of tables - see SQL::Eval::Table for details) |
| 200 |
* Tests are fixed to use TEMP TABLES explicitely when required |
| 201 |
* check for invalid column names fixed |
| 202 |
* Don't let depreciated parser structures stay alive in SQL::Statement when |
| 203 |
reusing the Parser |
| 204 |
|
| 205 |
[Documentation] |
| 206 |
* Method documentation of SQL::Statement and SQL::Eval::Table are improved |
| 207 |
* Add a Roadmap describing future plans for SQL::Statement (in addition to |
| 208 |
DBD::File::Roadmap). |
| 209 |
* POD spelling fixes provided by H.Merijn Brand |
| 210 |
and Pod::Spell::CommonMistakes (thanks Tux) |
| 211 |
* POD grammar fixes and reasonable sentences created by Martin Evans |
| 212 |
|
| 213 |
[Things that may break your code] |
| 214 |
* SQL::Statement 1.28 is expected not to work proper in combination with |
| 215 |
DBI 1.611 and below |
| 216 |
* SQL::Statement::ColumnValue expects now every table being derived from |
| 217 |
SQL::Eval::Table |
| 218 |
|
| 219 |
1.27 2010-05-06 |
| 220 |
[Bug fixes] |
| 221 |
* use originally given table name for open_table() on SELECT, too |
| 222 |
(all other command still use the originally given name) |
| 223 |
* warn/die -> carp/croak |
| 224 |
* fix delete_one_row & update_one_row ability using |
| 225 |
|
| 226 |
[Documentation] |
| 227 |
* Apply spelling fix patch from Ansgar Burchardt (RT#56475) |
| 228 |
|
| 229 |
1.26 2010-04-09 |
| 230 |
[Bug fixes] |
| 231 |
* Handle NULL columns in concatenation as empty strings |
| 232 |
|
| 233 |
[Improvements] |
| 234 |
* Change regex's in parser to use \p{Word} instead of \w to allow unicode |
| 235 |
support |
| 236 |
|
| 237 |
[Documentation] |
| 238 |
* Make clear, that identifiers are handled case insensetive and there is |
| 239 |
a real good solution provided by DBI which allows to live great with |
| 240 |
that behaviour. |
| 241 |
|
| 242 |
1.25 2010-03-15 |
| 243 |
[Bug fixes] |
| 244 |
* Keep org_table_names with schema information to allow derived |
| 245 |
table classes to handle as it seems reasonable there |
| 246 |
* Separate columns with "\0" in multi-column aggregation to be able to |
| 247 |
difference between ('1','1foo') and ('11','foo') |
| 248 |
|
| 249 |
[Misc] |
| 250 |
* More resources added to META.yml |
| 251 |
|
| 252 |
1.24 2010-03-15 |
| 253 |
[Misc] |
| 254 |
* Ignore *.rej in MANIFEST.SKIP (fixes RT #52081 reported by |
| 255 |
Lars Thegler) |
| 256 |
|
| 257 |
[Bug fixes] |
| 258 |
* Add missing import of _INSTANCE in SQL::Statement::Function::NumericEval |
| 259 |
fixes RT #52356 - reported by Detlef Pilzecker) |
| 260 |
* Fix wrongly discarded DISTINCT clause (RT#53186) |
| 261 |
|
| 262 |
[Improvements] |
| 263 |
* Fix parsing errors of plain numbers (RT#16931) |
| 264 |
* Fix parsing errors of nested calculation / functions (RT#16931, RT#52356) |
| 265 |
* Rewrite result calculation of aggregation functions |
| 266 |
(simplify code, speed up) |
| 267 |
* Upgrade Makefile.PL (patch from Alexandr Ciornii) to handle different |
| 268 |
EU::MM versions and abilities properly |
| 269 |
* Update documentation to show how 'column_defs' and SQL::Statement::Term |
| 270 |
instances shall be used |
| 271 |
* Introduce SQL::Dialect::Role providing ini-style data access |
| 272 |
to SQL::Dialects (patch from Michael Schwern) |
| 273 |
|
| 274 |
[Things that may break your code] |
| 275 |
* SQL::Parser now didn't deliver a struct containing 'column_names', |
| 276 |
'computed_columns' and 'set_functions' - it's combined into one member |
| 277 |
'column_defs'. |
| 278 |
* Minimum required perl version is now 5.8 - upcoming next version of DBI |
| 279 |
requires perl 5.8, too - and I could simplify some code that's why |
| 280 |
|
| 281 |
1.23 2009-11-20 |
| 282 |
[Misc] |
| 283 |
* Applied patch from Marc Espie which fixes several orthographic |
| 284 |
errors in SQL::Statement::Syntax documentation. |
| 285 |
* Added a fixed version of test reported via RT #34121 |
| 286 |
|
| 287 |
[Bug fixes] |
| 288 |
* Fix an issue in UPDATE command which 'shift's the values from |
| 289 |
the list of parameters which causes there're no more parameters |
| 290 |
left after first row get's updated (Fixes RT #50788) |
| 291 |
* Fix aggregate function handling of new code since 1.21_01 |
| 292 |
* Correct handling of DISTINCT in aggregate functions |
| 293 |
|
| 294 |
[Improvements] |
| 295 |
* Add support for tables/columns starting with '_' for CSV and AnyData, |
| 296 |
which is usually forbidden by ANSI SQL |
| 297 |
* Add support for inserting multiple lines with one statement |
| 298 |
(fixes RT #31730) |
| 299 |
* Handle ANSI 'IS NULL' and CVS/AnyData 'IS NULL' different |
| 300 |
|
| 301 |
[Things that may break your code] |
| 302 |
* row_value now expects up to two arguments |
| 303 |
|
| 304 |
1.22 2009-10-10 |
| 305 |
[Misc] |
| 306 |
* Add missing changelog - no code changes |
| 307 |
|
| 308 |
1.21 2009-10-10 |
| 309 |
[Misc] |
| 310 |
* remove version dependency to check previously installed version |
| 311 |
* add DBD::File as "Test" requirement |
| 312 |
|
| 313 |
1.21_8 2009-10-05 |
| 314 |
[Bug fixes] |
| 315 |
* Add additional test for bug-fix in 1.21_7 to t/18bigjoin.t |
| 316 |
|
| 317 |
[Misc] |
| 318 |
* Correct some typo's in POD |
| 319 |
|
| 320 |
1.21_7 2009-09-31 |
| 321 |
[Bug fixes] |
| 322 |
* Don't fail for non-existent columns introduced by functions |
| 323 |
in joins |
| 324 |
|
| 325 |
1.21_6 2009-09-24 |
| 326 |
[Bug fixes] |
| 327 |
* Don't abort Makefile.PL when in automated smoke tests |
| 328 |
|
| 329 |
1.21_5 2009-09-23 |
| 330 |
[Bug fixes] |
| 331 |
* table order isn't wrongly used in order of appearance when SQL::Parser |
| 332 |
couldn't determine an order |
| 333 |
* Some internal fixes |
| 334 |
|
| 335 |
[Misc] |
| 336 |
* Updated dependency to Params::Util to non-leaking 1.00 |
| 337 |
* Note dependency to Carp and Data::Dumper |
| 338 |
* rely on version to compare versions |
| 339 |
* Update POD for terms |
| 340 |
* Update |
| 341 |
|
| 342 |
1.21_4 2009-09-21 |
| 343 |
[Bug fixes] |
| 344 |
* modify regex to match types to fix problems with Perl 5.6.2 |
| 345 |
* add DESTROY methods to ensure clean up |
| 346 |
* fix lower casing internal table names when joining tables |
| 347 |
* replace parameter shifting by assigning @_ to the list of parameters |
| 348 |
|
| 349 |
1.21_3 2009-09-17 |
| 350 |
[Things that may break your code] |
| 351 |
* When someone accesses the where_clause attribute of the SQL::Statement |
| 352 |
instance - be aware that now IN and BETWEEN can be native entries |
| 353 |
|
| 354 |
[Bug fixes] |
| 355 |
* convert operation to upper case when surely initialized |
| 356 |
|
| 357 |
[Improvements] |
| 358 |
* IN and BETWEEN are now native operations - they are not expanded |
| 359 |
to OR'ed equalize operations anymore |
| 360 |
|
| 361 |
1.21_2 2009-09-15 |
| 362 |
[Things that may break your code] |
| 363 |
* modify behavior for unquoted identifiers - they're converted and |
| 364 |
returned lower cased now (instead upper cased as in 1.21_1) |
| 365 |
Fixes bug RT #48502 |
| 366 |
|
| 367 |
1.21_1 2009-07-30 |
| 368 |
[Things that may break your code] |
| 369 |
* removed SQL::Statement::Column |
| 370 |
* don't instantiate SQL::Statement::Functions objects |
| 371 |
* Reworked internal column and function handling to reduce code complexity |
| 372 |
* rows and columns aren't setable from outside a table or eval object |
| 373 |
anymore |
| 374 |
|
| 375 |
[Bug fixes and other changes] |
| 376 |
* Fixed bugs: |
| 377 |
+ RT #47292: Test failures with recent DBI |
| 378 |
+ RT #44512: Patch for CREATE TABLE parsing |
| 379 |
+ RT #42676: tests 16 failed |
| 380 |
|
| 381 |
1.20 2009-03-05 |
| 382 |
* Fixed Makefile in MANIFEST (reported by Havard Eidnes in RT #43586) |
| 383 |
* Fixed invalid label FETCHROW used (reported by Michael in RT #42982) |
| 384 |
* separated update_one_row and update_specific_row method names for tables |
| 385 |
to avoid confusion |
| 386 |
|
| 387 |
1.19 2009-02-06 |
| 388 |
* Fixed OUTER JOIN behavior |
| 389 |
* Added version info to all *.pm files to allow CPAN::Reporter find updates |
| 390 |
* Correct META-Files |
| 391 |
* Fixed reported bugs: |
| 392 |
|
| 393 |
1.18_02 2009-01-20 |
| 394 |
* Additional (profiled) optimizations for complicated where clauses |
| 395 |
|
| 396 |
1.18_01 2009-01-12 |
| 397 |
* No code changes within SQL::Statement - |
| 398 |
but deliver and execute additional tests. |
| 399 |
|
| 400 |
1.17 2009-01-12 |
| 401 |
* Fixed bug: RT#42263: GROUP BY doesn't group on multiple columns |
| 402 |
|
| 403 |
1.16_04 2009-01-04 |
| 404 |
* added tests to prove valid quoting (most of them fail) |
| 405 |
* Reformat the source |
| 406 |
* add some (profiled) tweaks as removing useless regex to speed up SELECT |
| 407 |
|
| 408 |
[Bug fixes] |
| 409 |
* 14217 Does not correctly handle SQL statements with comments |
| 410 |
* 15686 Join syntax is case-sensitive, and common columns in natural |
| 411 |
joins are "ambiguous" [patch] |
| 412 |
* 13080 Cannot update a field based on its previous value |
| 413 |
* 26058 functions on computed columns aliased to the underlying column |
| 414 |
name are not called |
| 415 |
|
| 416 |
1.16_03 2009-01-01 |
| 417 |
* removed *.orig and *.rej relics |
| 418 |
|
| 419 |
1.16_02 2009-01-01 |
| 420 |
* Changing join_2_tables to reduce memory usage when joining a lot of tables |
| 421 |
|
| 422 |
[Bug fixes] |
| 423 |
* 15688 Columns aliased with double quotes are a fatal error |
| 424 |
* 16579 Speed optimizations |
| 425 |
* 30590 Bug in SQL::Statement::is_number() |
| 426 |
* 41875 Bug in synopsis example |
| 427 |
|
| 428 |
1.16_01 2009-01-01 |
| 429 |
* With this release, I'd like to welcome Jens Rehsack as co-maintainer of |
| 430 |
the SQL::Statement and SQL::Parser modules. Jens has added in some |
| 431 |
great improvements. |
| 432 |
Thanks Jens! -- Jeff |
| 433 |
* Adding a lot of join tests (once from Jeff, 48 from |
| 434 |
PostgreSQL official handbook) - no error of them will be corrected in the |
| 435 |
first run |
| 436 |
Thanks to Alexander Breibach <[email protected]> -- Jens |
| 437 |
|
| 438 |
1.15 2006-02-02 |
| 439 |
* fixed placeholder bug in SQL::Statement::UPDATE |
| 440 |
thanks for bug report Tanktalus |
| 441 |
|
| 442 |
1.14 2005-04-21 |
| 443 |
* fixed circular dependency in tests (one mistakenly required AnyData) |
| 444 |
|
| 445 |
1.13 2005-04-18 |
| 446 |
* pod fixes |
| 447 |
|
| 448 |
1.12 2005-04-18 |
| 449 |
* added support for GROUP BY |
| 450 |
(several people sent suggestions for this in the past, please email me |
| 451 |
so I can credit you, sorry I lost the names) |
| 452 |
* added support for true LIMIT - if a LIMIT clause is specified and |
| 453 |
no ORDER BY clause is specified, the SELECT will stop searching |
| 454 |
when the limit is reached; with an ORDER BY clause it will still |
| 455 |
search the entire table because we can only ORDER a set; using |
| 456 |
LIMIT without an ORDER BY will greatly increase speed |
| 457 |
* added support for CREATE/DROP keyword|operator|type|function |
| 458 |
* optimized process_predicate to only look up scalars once |
| 459 |
* completely re-wrote the POD |
| 460 |
* fixed bug in primary key search optimization |
| 461 |
thanks for bug report and test scripts: Jim Lambert, <jimlambrtATmac.com> |
| 462 |
* fixed problem with all_cols slowing inserts |
| 463 |
thanks for patch and test Cosimo Streppone <cosimoATcpan.org> |
| 464 |
* cleaned up case of temp table column names |
| 465 |
thanks for bug report: Dan Wright |
| 466 |
* added a META.YML and extra tests |
| 467 |
|
| 468 |
1.11 2005-03-28 |
| 469 |
* fixed bug in "CREATE TABLE AS ..." |
| 470 |
|
| 471 |
1.10 2005-03-27 |
| 472 |
* added support for CREATE TABLE AS SELECT ... and CREATE TABLE AS IMPORT() |
| 473 |
* added support for in-memory tables and heterogeneous operations, |
| 474 |
see the SQL::Parser docs |
| 475 |
* added many new built-in functions see SQL::Statement::Functions.pm |
| 476 |
* added support for user-defined functions, see SQL::Statement::Functions.pm |
| 477 |
* added support for column name aliases |
| 478 |
thanks for patch, Robert Rothenberg |
| 479 |
* added support for comparison to empty string (e.g. WHERE col1='') |
| 480 |
currently returns the same as WHERE col1 IS NULL |
| 481 |
thanks for patch, cpanATgoess.org |
| 482 |
* fixed bug in S::P::clean_sql() newline-handling, |
| 483 |
thanks for patch Steffen G., steffenATkonzeptloses.de |
| 484 |
* fixed bug in SQL::Parser::feature() |
| 485 |
thanks for patch, chromatic |
| 486 |
* the word "INTO" is now optional in "INSERT INTO tblname ..." |
| 487 |
* the word "FROM" is now optional in "DELETE FROM tblname ..." |
| 488 |
thanks for suggestion, [email protected] |
| 489 |
* optimized portions of eval_where, process_predicate, and is_matched |
| 490 |
HUGE thanks Dan Wright and Dean Arnold for patches |
| 491 |
* HUGE thanks to Dean Arnold for all the following which should clean up |
| 492 |
a number of bugs in parentheses parsing and in the predicates IN and |
| 493 |
BETWEEN as well as speed things up considerably |
| 494 |
|
| 495 |
[SQL::Parser changes] |
| 496 |
* removed recursion from get_in(), get_btwn() |
| 497 |
* fixed paren scan and argument separator scan in get_in() |
| 498 |
* optimized get_in/get_btwn code |
| 499 |
* made get_in/get_btwn OO methods to support |
| 500 |
being overridden by subclasses |
| 501 |
* added transform_syntax() abstract method to permit subclasses |
| 502 |
to add their own syntax extensions |
| 503 |
* rewrite of parens_search() to fixed predicate paren processing, |
| 504 |
remove recursion, and optimize code |
| 505 |
* rewrite of non_parens_search() to fixed predicate |
| 506 |
paren processing and optimize code |
| 507 |
* rewrite of PREDICATE to optimize code; |
| 508 |
moved operator regex construction to dialect initialization |
| 509 |
* change undo_string_funcs(), undo_math_funcs(), nongroup_numeric(), |
| 510 |
nongroup_string() to remove scoped recursion |
| 511 |
* fixed nongroup_numeric() for case insensitive operator match |
| 512 |
* fixed nongroup_string, undo_string_funcs() to include user defined funcs |
| 513 |
* fixed ROW_VALUE's scan for user defined function |
| 514 |
argument separator scan |
| 515 |
* fixed function detection regex in SQL::Parser::ROW_VALUE |
| 516 |
to accomodate arbitrary spacing |
| 517 |
* fixed SQL::Parser::SELECT_LIST()/extract_column_list() |
| 518 |
to support concat operator '||' expressions |
| 519 |
* added following functions to SQL::Statement::Functions: |
| 520 |
COALESCE; NVL (same as COALESCE); DECODE (same as Oracle DECODE); |
| 521 |
CONCAT; REPLACE/SUBSTITUTE |
| 522 |
* fixed/adapted SQL::Statement::get_row_value(), |
| 523 |
SQL::Statement::SELECT(), for join'ed resultsets |
| 524 |
|
| 525 |
|
| 526 |
1.09 2004-04-22 |
| 527 |
* fixed parens parsing bug reported by Dan Wright, thanks! |
| 528 |
|
| 529 |
|
| 530 |
1.08 2004-04-20 |
| 531 |
* fixed bug in JOIN handling introduced in 1.06 |
| 532 |
|
| 533 |
|
| 534 |
1.07 2004-04-20 |
| 535 |
* fixed infinite recursion bug with empty IN() predicate |
| 536 |
thanks chromatic, for the patch |
| 537 |
* fixed case issues with table aliases in joins |
| 538 |
thanks chromatic, for bug report |
| 539 |
|
| 540 |
|
| 541 |
1.06 2004-04-18 |
| 542 |
* column and table name hashes now default to case sensitive |
| 543 |
* where() method now supported as per the docs |
| 544 |
|
| 545 |
|
| 546 |
1.005 2002-10-26 |
| 547 |
* added support for MySQL-like "DROP TABLE IF EXISTS" |
| 548 |
* fixed bug in dotted column names e.g. tableA.colB |
| 549 |
* fixed bug in MAX and MIN (thanks Michael Kovacs, |
| 550 |
[email protected]) |
| 551 |
* fixed bug in ORDER BY (when col names not in SELECT list) |
| 552 |
Thanks Janet Goldstein <[email protected]> |
| 553 |
|
| 554 |
|
| 555 |
1.004 2002-03-13 |
| 556 |
* added support for delimited identifiers (inside double quotes); |
| 557 |
these are case sensitive and can contain spaces and other |
| 558 |
special chars |
| 559 |
* added support for two forms of escaping single quotes inside |
| 560 |
quoted values: 'O\'Brien' or 'O''Brien' |
| 561 |
* added support for both C-Style and SQL-Style double-hypen |
| 562 |
comments, e.g. /* comment */ or -- comment |
| 563 |
* added GetInfo.pm for use with $dbh->get_info() |
| 564 |
* updated the readme file |
| 565 |
* fixed bug in update that refers to its own columns |
| 566 |
(e.g. SET num = num + 2) |
| 567 |
* fixed bug in MIN and MAX when used with strings |
| 568 |
Thanks Dean Kopesky <[email protected]> |
| 569 |
|
| 570 |
1.003 2002-03-01 |
| 571 |
* identifiers (names of columns, tables, and table name |
| 572 |
aliases) are now all case insensitive as required by the SQL |
| 573 |
standard. all older versions including the XS versions used |
| 574 |
case sensitive column names |
| 575 |
* added numerous examples to test.pl |
| 576 |
* improved and/or fixed bugs in: |
| 577 |
* placeholder support |
| 578 |
Thanks Achim Grolms <[email protected]> |
| 579 |
* ORDER BY clause |
| 580 |
Thanks Jan Stocker <[email protected]> |
| 581 |
* LIKE/CLIKE/RLIKE/IN predicates |
| 582 |
Thanks Udo Beckmann <[email protected]> |
| 583 |
* table name aliases in explicit joins |
| 584 |
|
| 585 |
1.002 2002-02-05 |
| 586 |
* added backwards compatiblity: both SQL::Statement and |
| 587 |
SQL::Parser now work in perl version 5.004 and above. |
| 588 |
* changed defaults for DBD::CSV so it now accepts new SQL |
| 589 |
without adding extra flags to scripts |
| 590 |
* added support for SQL comments |
| 591 |
* added support for temporary tables and on commit clauses in |
| 592 |
CREATE statements and drop behaviour flags in DROP statements |
| 593 |
(SQL::Parser only, not supported by SQL::Statement) |
| 594 |
* fixed bugs in qualified column names (e.g. tableA.*), and in |
| 595 |
joins using ON or WHERE |
| 596 |
|
| 597 |
1.001 2002-01-17 |
| 598 |
* Fixed bug in UPDATE that caused the new value to be a hash |
| 599 |
rather than a scalar. |
| 600 |
|
| 601 |
1.0 2002-01-15 |
| 602 |
This is the first CPAN release of the pure perl version of the |
| 603 |
module. It was previously released in an XS version by Jochen |
| 604 |
Wiedman who has turned over maintenance of it to me. |
| 605 |
|
| 606 |
The new Pure Perl version of SQL::Statement supports everything |
| 607 |
supported by the XS version and, additionally, at least partial |
| 608 |
support for the following features that are not supported at all |
| 609 |
by the XS version: |
| 610 |
|
| 611 |
* Explicit and implicit joins |
| 612 |
* Table name aliases |
| 613 |
* Set functions |
| 614 |
* String functions |
| 615 |
* String concatenation |
| 616 |
* Numeric expressions |
| 617 |
* IN predicate |
| 618 |
* BETWEEN predicate |
| 619 |
* Alphabetic comparison in WHERE clauses |
| 620 |
* Ordering of text that looks like a number |
| 621 |
* Verbose error messages for both Parsing and Execution errors |
| 622 |
|