couple utility scripts
[scpubgit/Q-Branch.git] / Changes
CommitLineData
41751122 1Revision history for SQL::Abstract
e3dd5e89 2
4805666f 31.86 - 2018-07-09
063097a3 4 - Remove obsolete documentation about arrayrefref as the $source
5 argument for ->select (removed in version 1.74)
daa4ccdd 6 - Factor out the field list part of SELECT for subclassability (GH#13)
12d77b9a 7 - Do not replace literal '0' with empty string in WHERE clauses (GH#14)
063097a3 8
c416cbc0 91.85 - 2018-01-27
b3ecfcfa 10 - Restore perl version requirement missed in the Distar port
2052671a 11 - Factor out the SET ... part of UPDATE for subclassability (GH#12)
b3ecfcfa 12
30e28763 131.84 - 2017-04-03
743a28db 14 - Restore 'dynamic_config => 0' missed in the Distar port
15
d4b1c554 161.83 - 2017-04-03
5872708b 17 - Support for DELETE ... RETURNING (GH#9)
b5f5aae4 18 - Port to Distar
85327cd5 19
27fa2a14 20revision 1.82 2017-03-20
21-------------------------
3d8630d6 22 - Add explicit dependency on Sub::Quote (GH#8)
8c15b421 23 - Fix syntax errors in ORDER BY docs (GH#7)
3d8630d6 24
f0724630 25revision 1.81_01 2017-02-28
26----------------------------
26fe4d30 27 - Fix order clauses with bind parameters in ->where
19b6ccce 28 - Fix ->insert($table, \@values) with >26 values (RT#112684)
bf782d2e 29 - Teach ::Tree that ILIKE (PostgreSQL) and REGEXP (MySQL) are binary ops
3d8d0a21 30 - Support for UPDATE ... RETURNING
389a3147 31 - Documentation improvements for ORDER BY
26fe4d30 32
4baf4bbe 33revision 1.81 2014-10-25
34----------------------------
a5f91feb 35 - Fix overly-enthusiastic parenthesis unroller (RT#99503)
36
cfc7db76 37revision 1.80 2014-10-05
38----------------------------
52ce7dca 39 - Fix erroneous behavior of is_literal_value($) wrt { -ident => ... }
ddd6fbb6 40 - Explicitly croak on top-level special ops (they didn't work anyway)
52ce7dca 41
0ca23f3b 42revision 1.79 2014-09-25
43----------------------------
0da0fe34 44 - New exportable functions: is_literal_value($) and is_plain_value($)
46be4313 45 - New attribute 'escape_char' allowing for proper escape of quote_chars
46 present in an identifier
b5a576d2 47 - Deprecate { "" => \... } constructs
422ed2de 48 - Treat { -value => undef } as plain undef in all cases
8aa76984 49 - Explicitly throw on { -ident => undef }
46be4313 50
b54fd911 51revision 1.78 2014-05-28
52----------------------------
08e16360 53 - Fix parsing of binary ops to correctly take up only a single LHS
54 element, instead of gobbling up the entire parse-to-date
0ec2e265 55 - Explicitly handle ROW_NUMBER() OVER as the snowflake-operator it is
70c6f0e9 56 - Improve signatures/documentation of is_same_sql_bind / eq_sql_bind
5f3fa0ac 57 - Retire script/format-sql - the utility needs more work to be truly
58 end-user convenient
08e16360 59
4c120a34 60revision 1.77 2014-01-17
61----------------------------
40f2f231 62 - Reintroduce { -not => undef } column operator (regression from 1.75)
63
f0770d6b 64revision 1.75 2013-12-27
65----------------------------
032dfe20 66 - *UPCOMING INCOMPATIBLE BUGFIX*: SQLA used to generate incorrect SQL
67 on undef-containing lists fed to -in and -not_in. An exception will
68 be raised for a while before properly fixing this, to avoid quiet
69 but subtle changes to query results in production
3cdadcbe 70 - Deprecate and warn when supplying an empty arrayref to like/not_like
71 operators (likely to be removed before 2.0)
032dfe20 72
3cdadcbe 73 - Warn when using an inequality operator with a multi-value array to
74 arrive at what amounts to a 1=1 condition (no pre-2.0 plans to fix
75 this behavior due to backwards comp concerns)
c84a4321 76 - Fix false negative comparison of ORDER BY <function> ASC
f0770d6b 77 - More improvements of incorrect parsing (placeholder at end of list
78 element)
3af02ccb 79 - Fix typos in POD and comments (RT#87776)
23401b81 80 - Augment -not_bool example with nesting (RT#89601)
c84a4321 81
3cb8f017 82revision 1.74 2013-06-04
83----------------------------
1de1d085 84 - Fix insufficient parenthesis unroll during operator comparison
0c2de280 85 - 'ORDER BY foo' and 'ORDER BY foo ASC' are now considered equal
86 by default (with a switch to reenable old behavior when necessary)
6f30911f 87 - Change parser to not eagerly slurp RHS expressions it doesn't recognize
2266ca5c 88
d9ff7a90 89revision 1.73 2012-07-10
b4bd7d31 90----------------------------
73835ff0 91 - Fix parsing of ORDER BY foo + ?
0bfe80fd 92 - Stop filling in placeholders in `format-sql` since it does not support
93 passing values for them anyway
af75bd59 94 - Fix parsing of NOT EXISTS
007f0853 95 - Fix over-eager parenthesis unrolling
0f9a26cb 96 - Fix deep recursion warnings while parsing obnoxiously long sql statements
7cc47319 97 - Fix incorrect comparison of malformed lists
6f2a5b66 98 - Fix incorrect reporting of mismatch-members in SQLA::Test
cc422895 99 - Migrate the -ident operator from DBIC into SQLA
100 - Migrate the -value operator from DBIC into SQLA
af75bd59 101
64b9e432 102revision 1.72 2010-12-21
103----------------------------
b6251592 104 - Extra checks of search arguments for possible SQL injection attacks
c01ac648 105 - Remove excess parentheses in debug SQL
257ecc8a 106 - Fix parsing of foo.* in SQLA::Tree
5e5cbf51 107 - Fix bindtype fail when using -between with arrayrefref literals
279eb282 108 - Add handling for NULL for -in
48d9f5f8 109 - The -nest operator has entered semi-deprecated status and has been
110 undocumented. Please do not use it in new code
257ecc8a 111
d7d3d158 112revision 1.71 2010-11-09
2b340ec7 113----------------------------
416cdb2e 114 - Add EXECUTING for clarity of long running SQL
66c2fcc3 115 - Add "squash_repeats" option to fix it such that repeated SQL gets ellided
b25246f0 116 except for placeholders
667dd26d 117 - Highlight transaction keywords
118 - Highlight HAVING
119 - Leave quotes from DBIC in bindargs
120 - Add error checking on "profile" for SQLA::Tree
121 - Hide bulk inserts from DBIx::Class
b912ee1e 122 - Fix missing doc (RT#62587)
c4d7cfcf 123 - Format functions in MySQL-friendly manner foo( ... ) vs foo ( ... )
fab0bed9 124
9f7f28c4 125revision 1.69 2010-10-22
126----------------------------
c0eaa9fd 127 - Add quotes for populated placeholders and make the background
128 magenta instead of cyan
129 - Color and indent pagination keywords
bd05b0bc 130 - Fix a silly bug which broke placeholder fill-in in DBIC
131 - Installs format-sql to format SQL passed in over STDIN
4d3dc03a 132 - Switch the tokenizer to precompiled regexes (massive speedup)
133 - Rudimentary handling of quotes ( 'WHERE' vs WHERE )
0336eddb 134 - Fix extended argument parsing by IN/BETWEEN
b3b79607 135 - Add proper handling of lists (foo,bar,?)
136 - Better handling of generic -function's during AST construction
137 - Special handle IS NOT? NULL
3a247d23 138 - Make sure unparse() does not destroy a passed in \@bindargs
b8db59b8 139 - Support ops with _'s in them (valid in Oracle)
efc991a0 140 - Properly parse both types of default value inserts
0ec3aec7 141 - Allow { -func => $val } as arguments to UPDATE
4d3dc03a 142
4ee5e99c 143revision 1.68 2010-09-16
144----------------------------
ee4227a7 145 - Document methods on Tree
9d11f0d4 146 - Add affordances for color coding placeholders
ee4227a7 147 - Change ::Tree::whitespace to whitespace_keyword
148
c22f502d 149revision 1.67_03 2010-09-11
fb272e73 150----------------------------
c22f502d 151 - Add docs for SQL::Abstract::Tree->new
2fed0b4b 152 - correcty merge profile and parameters
fb272e73 153 - added fill_in_placeholders option for excellent copy/pasta
154
ba0151e5 155revision 1.67_02 2010-09-08
156----------------------------
0d5df7d6 157 - rename DBIx::Class::Storage::PrettyPrinter to DBIx::Class::Storage::Debug::PrettyPrint
ba0151e5 158 - decreased a lot of indentation from ::Tree
0d5df7d6 159 - cleaned up handling of newlines inside of parens
ba0151e5 160
161revision 1.67_01 2010-09-06
162----------------------------
163 - Add SQL::Abstract::Tree
164 - Add unindexed DBIx::Class::Storage::PrettyPrinter
b864ba9b 165 - Better documentation of undef/NULL in where clause
b66dea8d 166 - Depend on bugfixed Module::Install (now again installs
167 on old < 5.8.3 perls)
b864ba9b 168
6262db95 169revision 1.67 2010-05-31 14:21 (UTC)
170----------------------------
54629227 171 - Fix SQL::Test failure when first chunk is an unrecognized
172 literal
173 - Generic -not operator tests
c178aa6c 174 - More columns-bindtype assertion checks
54629227 175
4414eec5 176revision 1.66 2010-04-27 02:44 (UTC)
177----------------------------
955e77ca 178 - Optimized the quoting mechanism, winning nearly 10%
179 speedup on repeatable sql generation
180
f3e44aee 181revision 1.65 2010-04-11 19:59 (UTC)
182----------------------------
183 - Rerelease last version to not include .svn files
184 and grab MANIFEST.SKIP from DBIx::Class so it
185 won't happen again
186
9d48860e 187revision 1.64 2010-04-11 16:58 (UTC)
188----------------------------
953d164e 189 - Fix multiple generic op handling regressions by
190 reverting the auto-equality assumption (turned out
191 to be a very very bad idea)
192
c167ebd8 193revision 1.63 2010-03-24 09:56 (UTC)
194----------------------------
2d2df6ba 195 - Add ILIKE to the core list of comparision ops
196
8d3bb2b1 197revision 1.62 2010-03-15 11:06 (UTC)
198----------------------------
3080e415 199 - Fixed open outer parens for a multi-line literal
f2532629 200 - Allow recursively-nested column-functions in WHERE
75151f36 201 - Bumped minimum perl to 5.6.2 and changed tests to
202 rely on core dependencies
171a709f 203
e6ea8200 204revision 1.61 2010-02-05 16:28 (UTC)
205----------------------------
fee677ba 206 - Allow INSERT to take additional attributes
207 - Support for INSERT ... RETURNING
b9a4fdae 208 - Another iteration of SQL::Abstract::Test fixes and improvements
209
0f2b8636 210revision 1.60 2009-09-22 11:03 (UTC)
211----------------------------
30d09fa9 212 - fix a well masked error in the sql-test tokenizer
213
2de6e226 214revision 1.59 2009-09-22 08:39 (UTC)
215----------------------------
216 - fixed a couple of untrapped undefined warnings
217 - allow -in/-between to accept literal sql in all logical
e41c3bdd 218 variants - see POD for details
2de6e226 219 - unroll multiple parenthesis around IN arguments to accomodate
e41c3bdd 220 crappy databases
bd6a65ca 221
277b5d3f 222revision 1.58 2009-09-04 15:20 (UTC)
223----------------------------
224 - expanded the scope of -bool and -not_bool operators
225 - added proper testing support
226
227revision 1.57 2009-09-03 20:18 (UTC)
228----------------------------
229 - added -bool and -not_bool operators
230
a120d3e3 231revision 1.56 2009-05-30 16:31 (UTC)
232----------------------------
233 - support for \[$sql, @bind] in order_by clauses e.g.:
234 { -desc => \['colA LIKE ?', 'somestring'] }
235
54871ee9 236revision 1.55 2009-05-17 22:54 (UTC)
237----------------------------
ce261791 238 - make sure that sql generation does not mutate the supplied
239 where condition structure
240
73081069 241revision 1.54 2009-05-07 17:23 (UTC)
242----------------------------
243 - allow special_operators to take both code refs and method names
244 (makes it possible to properly subclass the builtin ones)
245
4f0516bc 246revision 1.53 2009-04-30 14:58 (UTC)
247----------------------------
248 - make sure hash keys are sorted in all search sub-conditions
249 - switch installer from EU::MM to M::I
250
e965ac5d 251revision 1.52 2009-04-28 23:14 (UTC)
252----------------------------
9d48860e 253 - allow -between to handle [\"", \""] and \["", @bind]
e965ac5d 254 - allow order_by to handle -asc|desc => [qw/colA colB/] (artifact from DBIx::Class)
255 - more tests and clearing up of some corner cases
256 - t/10test.t does not run by default (developer only, too cpu intensive)
39ae3a83 257
22f1a437 258----------------------------
ef8c0c94 259revision 1.51 2009-03-28 10:00 (UTC)
e965ac5d 260 - fixed behavior of [-and => ... ] depending on the current
ef8c0c94 261 condition scope. This introduces backwards comp with 1.24
262
263----------------------------
22f1a437 264revision 1.50 2009-03-10 12:30 (UTC)
e9c9f6ee 265 - fixed the problem with values() not behaving the same as the rest of the code (RT#43483)
266 - fixed interjecting arrayrefref into a where clause
267 - added value-only insert test with a literal SQL snippet
268 - cleanup and enhancement of t/03values.t
269 - better handling of borked SQL in tests
270 - deal properly with parentheses in is_same_sql_bind()
271 - fixed test subs (is_same_*) in SQL::Abstract::Test to return the correct test value
272 - do not version MANIFEST
273
22f1a437 274 Version 1.50 was a major internal refactoring of SQL::Abstract.
275 Great care has been taken to preserve the published behavior
276 documented in previous versions in the 1.* family; however,
277 some features that were previously undocumented, or behaved.
278 differently from the documentation, had to be changed in order
279 to clarify the semantics. Hence, client code that was relying
280 on some dark areas of SQL::Abstract v1.* might behave differently
281 in v1.50.
282
e9c9f6ee 283----------------------------
a1450b90 284revision 1.49_04 2009-03-03
285 - add support for a [\%column_meta => value] bind value format
286
287----------------------------
288revision 1.49_03 2009-02-17
289 - clarify syntax of \['...', @bind] when used with a bindtype
290 of 'columns'
291
292----------------------------
293revision 1.49_02 2009-02-16
294 - added an AST-aware SQL::Abstract::Test library for sql syntax tests
295 - vastly expanded test coverage
296 - support for the { operator => \'...'|\['...', @bind] } syntax
297 allowing to embed arbitrary operators on the LHS
edbb91b5 298 - fixed multiple regressions wrt DBIx::Class
a1450b90 299
e3f9dff4 300----------------------------
a1450b90 301revision 1.49_01 2009-02-11
302 - support for literal SQL through the [$sql, bind] syntax.
e3f9dff4 303 - added -nest1, -nest2 or -nest_1, -nest_2, ...
304 - optional support for array datatypes
305 - defensive programming : check arguments to functions/methods
306 - fixed bug with global logic of -and/-or (no side-effects any more)
307 - changed logic for distributing an op over arrayrefs
308 - fixed semantics of _bindtype on array args
a1450b90 309 - dropped the _anoncopy of the %where tree. No longer necessary.
310 - dropped the _modlogic function
8a68b5be 311 - Make col => [] and col => {$op => [] } DTRT or die instead of generating
a1450b90 312 broken SQL. Added tests for this.
22f1a437 313 - Added { -desc => 'column' } order by support
a1450b90 314 - Tiny "$_"-related fix for { -desc => 'columns'} order by support
22f1a437 315 tests + docs
86298391 316
e3dd5e89 317----------------------------
318revision 1.20
319date: 2005/08/18 18:41:58; author: nwiger; state: Exp; lines: +104 -50
320- added patch from Dan Kubb enabling quote_char and name_sep options
321- added patch from Andy Grundman to enhance _anoncopy for deep refs
322----------------------------
323revision 1.19
324date: 2005/04/29 18:20:30; author: nwiger; state: Exp; lines: +34 -20
325added _anoncopy to prevent destroying original; updated docs
326----------------------------
327revision 1.18
328date: 2005/03/07 20:14:12; author: nwiger; state: Exp; lines: +201 -65
329added support for -and, -or, and -nest; see docs for details
330----------------------------
331revision 1.17
332date: 2004/08/25 20:11:27; author: nwiger; state: Exp; lines: +58 -46
333added patch from Eric Kolve to iterate over all hashref elements
334----------------------------
335revision 1.16
336date: 2004/06/10 17:20:01; author: nwiger; state: Exp; lines: +178 -12
337added bindtype param to allow this to work with Orasuck 9+
338----------------------------
339revision 1.15
340date: 2003/11/05 23:40:40; author: nwiger; state: Exp; lines: +18 -6
341several bugfixes, including _convert being applied wrong and
342the edge case field => { '!=', [qw/this that/] } not working
343----------------------------
344revision 1.14
345date: 2003/11/04 21:20:33; author: nwiger; state: Exp; lines: +115 -34
346added patch from Philip Collins, and also added 'convert' option
347----------------------------
348revision 1.13
349date: 2003/05/21 17:22:29; author: nwiger; state: Exp; lines: +230 -74
350added "IN" and "BETWEEN" operator support, as well as "NOT"
351modified where() to support ORDER BY, and fixed some bugs too
352added PERFORMANCE and FORMBUILDER doc sections
353fixed several bugs in _recurse_where(), it now works as expected
354added test suite, many thanks to Chas Owens
355modified all hash access to return keys sorted, to allow cached queries
356----------------------------
357revision 1.12
358date: 2003/05/08 20:10:56; author: nwiger; state: Exp; lines: +181 -96
3591.11 interim checking; major bugfixes and order_by, 1.12 will go to CPAN
360----------------------------
361revision 1.11
362date: 2003/05/02 00:07:30; author: nwiger; state: Exp; lines: +52 -12
363many minor enhancements to add querying flexibility
364----------------------------
365revision 1.10
366date: 2002/09/27 18:06:25; author: nwiger; state: Exp; lines: +6 -2
367added precatch for messed up where string
368----------------------------
369revision 1.9
370date: 2002/08/29 18:04:35; author: nwiger; state: Exp; lines: +4 -3
371CPAN
372----------------------------
373revision 1.8
374date: 2001/11/07 22:18:12; author: nwiger; state: Exp; lines: +31 -14
375added embedded SCALAR ref capability to insert() and update()
376----------------------------
377revision 1.7
378date: 2001/11/07 01:23:28; author: nwiger; state: Exp; lines: +3 -3
379damn uninit warning
380----------------------------
381revision 1.6
382date: 2001/11/06 21:09:44; author: nwiger; state: Exp; lines: +14 -6
383oops, had to actually *implement* the order by for select()!
384----------------------------
385revision 1.5
386date: 2001/11/06 03:13:16; author: nwiger; state: Exp; lines: +43 -4
387lots of docs
388----------------------------
389revision 1.4
390date: 2001/11/06 03:07:42; author: nwiger; state: Exp; lines: +16 -7
391added extra layer of ()'s to ensure correct semantics on AND
392----------------------------
393revision 1.3
394date: 2001/11/06 01:16:31; author: nwiger; state: Exp; lines: +11 -10
395updated all statements so that they use wantarray to just return SQL if asked
396----------------------------
397revision 1.2
398date: 2001/10/26 22:23:46; author: nwiger; state: Exp; lines: +112 -15
399added scalar ref for SQL verbatim in where, fixed bugs, array ref, docs
400----------------------------
401revision 1.1
402date: 2001/10/24 00:26:43; author: nwiger; state: Exp;
403Initial revision