Debian Codegraph @

corpus/dists/SQL-Statement.changes

raw
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