X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FSQL-Abstract.git;a=blobdiff_plain;f=Changes;h=ff78a51fb04c273287fa66f64db8beb44e49ff3c;hp=4762be30389cc92a22ede708ad2321aa0a96788a;hb=d4b1c5548fa1a3da5888b3decfcbc6f0825e07c6;hpb=b66dea8d0c69111d33d4ebc51239fc6bd6faa1d2 diff --git a/Changes b/Changes index 4762be3..ff78a51 100644 --- a/Changes +++ b/Changes @@ -1,5 +1,154 @@ Revision history for SQL::Abstract +1.83 - 2017-04-03 + - Support for DELETE ... RETURNING (GH#9) + - Port to Distar + +revision 1.82 2017-03-20 +------------------------- + - Add explicit dependency on Sub::Quote (GH#8) + - Fix syntax errors in ORDER BY docs (GH#7) + +revision 1.81_01 2017-02-28 +---------------------------- + - Fix order clauses with bind parameters in ->where + - Fix ->insert($table, \@values) with >26 values (RT#112684) + - Teach ::Tree that ILIKE (PostgreSQL) and REGEXP (MySQL) are binary ops + - Support for UPDATE ... RETURNING + - Documentation improvements for ORDER BY + +revision 1.81 2014-10-25 +---------------------------- + - Fix overly-enthusiastic parenthesis unroller (RT#99503) + +revision 1.80 2014-10-05 +---------------------------- + - Fix erroneous behavior of is_literal_value($) wrt { -ident => ... } + - Explicitly croak on top-level special ops (they didn't work anyway) + +revision 1.79 2014-09-25 +---------------------------- + - New exportable functions: is_literal_value($) and is_plain_value($) + - New attribute 'escape_char' allowing for proper escape of quote_chars + present in an identifier + - Deprecate { "" => \... } constructs + - Treat { -value => undef } as plain undef in all cases + - Explicitly throw on { -ident => undef } + +revision 1.78 2014-05-28 +---------------------------- + - Fix parsing of binary ops to correctly take up only a single LHS + element, instead of gobbling up the entire parse-to-date + - Explicitly handle ROW_NUMBER() OVER as the snowflake-operator it is + - Improve signatures/documentation of is_same_sql_bind / eq_sql_bind + - Retire script/format-sql - the utility needs more work to be truly + end-user convenient + +revision 1.77 2014-01-17 +---------------------------- + - Reintroduce { -not => undef } column operator (regression from 1.75) + +revision 1.75 2013-12-27 +---------------------------- + - *UPCOMING INCOMPATIBLE BUGFIX*: SQLA used to generate incorrect SQL + on undef-containing lists fed to -in and -not_in. An exception will + be raised for a while before properly fixing this, to avoid quiet + but subtle changes to query results in production + - Deprecate and warn when supplying an empty arrayref to like/not_like + operators (likely to be removed before 2.0) + + - Warn when using an inequality operator with a multi-value array to + arrive at what amounts to a 1=1 condition (no pre-2.0 plans to fix + this behavior due to backwards comp concerns) + - Fix false negative comparison of ORDER BY ASC + - More improvements of incorrect parsing (placeholder at end of list + element) + - Fix typos in POD and comments (RT#87776) + - Augment -not_bool example with nesting (RT#89601) + +revision 1.74 2013-06-04 +---------------------------- + - Fix insufficient parenthesis unroll during operator comparison + - 'ORDER BY foo' and 'ORDER BY foo ASC' are now considered equal + by default (with a switch to reenable old behavior when necessary) + - Change parser to not eagerly slurp RHS expressions it doesn't recognize + +revision 1.73 2012-07-10 +---------------------------- + - Fix parsing of ORDER BY foo + ? + - Stop filling in placeholders in `format-sql` since it does not support + passing values for them anyway + - Fix parsing of NOT EXISTS + - Fix over-eager parenthesis unrolling + - Fix deep recursion warnings while parsing obnoxiously long sql statements + - Fix incorrect comparison of malformed lists + - Fix incorrect reporting of mismatch-members in SQLA::Test + - Migrate the -ident operator from DBIC into SQLA + - Migrate the -value operator from DBIC into SQLA + +revision 1.72 2010-12-21 +---------------------------- + - Extra checks of search arguments for possible SQL injection attacks + - Remove excess parentheses in debug SQL + - Fix parsing of foo.* in SQLA::Tree + - Fix bindtype fail when using -between with arrayrefref literals + - Add handling for NULL for -in + - The -nest operator has entered semi-deprecated status and has been + undocumented. Please do not use it in new code + +revision 1.71 2010-11-09 +---------------------------- + - Add EXECUTING for clarity of long running SQL + - Add "squash_repeats" option to fix it such that repeated SQL gets ellided + except for placeholders + - Highlight transaction keywords + - Highlight HAVING + - Leave quotes from DBIC in bindargs + - Add error checking on "profile" for SQLA::Tree + - Hide bulk inserts from DBIx::Class + - Fix missing doc (RT#62587) + - Format functions in MySQL-friendly manner foo( ... ) vs foo ( ... ) + +revision 1.69 2010-10-22 +---------------------------- + - Add quotes for populated placeholders and make the background + magenta instead of cyan + - Color and indent pagination keywords + - Fix a silly bug which broke placeholder fill-in in DBIC + - Installs format-sql to format SQL passed in over STDIN + - Switch the tokenizer to precompiled regexes (massive speedup) + - Rudimentary handling of quotes ( 'WHERE' vs WHERE ) + - Fix extended argument parsing by IN/BETWEEN + - Add proper handling of lists (foo,bar,?) + - Better handling of generic -function's during AST construction + - Special handle IS NOT? NULL + - Make sure unparse() does not destroy a passed in \@bindargs + - Support ops with _'s in them (valid in Oracle) + - Properly parse both types of default value inserts + - Allow { -func => $val } as arguments to UPDATE + +revision 1.68 2010-09-16 +---------------------------- + - Document methods on Tree + - Add affordances for color coding placeholders + - Change ::Tree::whitespace to whitespace_keyword + +revision 1.67_03 2010-09-11 +---------------------------- + - Add docs for SQL::Abstract::Tree->new + - correcty merge profile and parameters + - added fill_in_placeholders option for excellent copy/pasta + +revision 1.67_02 2010-09-08 +---------------------------- + - rename DBIx::Class::Storage::PrettyPrinter to DBIx::Class::Storage::Debug::PrettyPrint + - decreased a lot of indentation from ::Tree + - cleaned up handling of newlines inside of parens + +revision 1.67_01 2010-09-06 +---------------------------- + - Add SQL::Abstract::Tree + - Add unindexed DBIx::Class::Storage::PrettyPrinter - Better documentation of undef/NULL in where clause - Depend on bugfixed Module::Install (now again installs on old < 5.8.3 perls)