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