X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=03eebf798288fe3bd538c78662b2c40b5c15fed3;hb=5f3fa0ac25497f9ab48ae4950d070208894f5af8;hp=ea6689a8e95864bd52940a71bb0ac49c79a5c5e8;hpb=b25246f02c8f12fc5c060f53f2386db8bcca05ab;p=dbsrgits%2FSQL-Abstract.git diff --git a/Changes b/Changes index ea6689a..03eebf7 100644 --- a/Changes +++ b/Changes @@ -1,10 +1,76 @@ Revision history for SQL::Abstract - - Hide bulk inserts from DBIx::Class - - Highlight transaction keywords + - 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 "no_repeats" option to fix it such that repeated SQL gets ellided + - 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 ----------------------------