X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=7f25a87fc986e3d440f5e98a8fb795cccff7af80;hb=8c15b4213396b4ae2b73d44adaaaea5be2915db1;hp=3e8ae4b95443b9e83020350a55dee84221a4286d;hpb=23401b818b099397e04df91b43340ecd59e8f92b;p=dbsrgits%2FSQL-Abstract.git diff --git a/Changes b/Changes index 3e8ae4b..7f25a87 100644 --- a/Changes +++ b/Changes @@ -1,12 +1,62 @@ Revision history for SQL::Abstract + - 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 (literal at end of list elt) + - 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)