1 Revision history for SQL::Abstract
3 - Fix insufficient parenthesis unroll during operator comparison
4 - 'ORDER BY foo' and 'ORDER BY foo ASC' are now considered equal
5 by default (with a switch to reenable old behavior when necessary)
7 revision 1.73 2012-07-10
8 ----------------------------
9 - Fix parsing of ORDER BY foo + ?
10 - Stop filling in placeholders in `format-sql` since it does not support
11 passing values for them anyway
12 - Fix parsing of NOT EXISTS
13 - Fix over-eager parenthesis unrolling
14 - Fix deep recursion warnings while parsing obnoxiously long sql statements
15 - Fix incorrect comparison of malformed lists
16 - Fix incorrect reporting of mismatch-members in SQLA::Test
17 - Migrate the -ident operator from DBIC into SQLA
18 - Migrate the -value operator from DBIC into SQLA
20 revision 1.72 2010-12-21
21 ----------------------------
22 - Extra checks of search arguments for possible SQL injection attacks
23 - Remove excess parentheses in debug SQL
24 - Fix parsing of foo.* in SQLA::Tree
25 - Fix bindtype fail when using -between with arrayrefref literals
26 - Add handling for NULL for -in
27 - The -nest operator has entered semi-deprecated status and has been
28 undocumented. Please do not use it in new code
30 revision 1.71 2010-11-09
31 ----------------------------
32 - Add EXECUTING for clarity of long running SQL
33 - Add "squash_repeats" option to fix it such that repeated SQL gets ellided
34 except for placeholders
35 - Highlight transaction keywords
37 - Leave quotes from DBIC in bindargs
38 - Add error checking on "profile" for SQLA::Tree
39 - Hide bulk inserts from DBIx::Class
40 - Fix missing doc (RT#62587)
41 - Format functions in MySQL-friendly manner foo( ... ) vs foo ( ... )
43 revision 1.69 2010-10-22
44 ----------------------------
45 - Add quotes for populated placeholders and make the background
46 magenta instead of cyan
47 - Color and indent pagination keywords
48 - Fix a silly bug which broke placeholder fill-in in DBIC
49 - Installs format-sql to format SQL passed in over STDIN
50 - Switch the tokenizer to precompiled regexes (massive speedup)
51 - Rudimentary handling of quotes ( 'WHERE' vs WHERE )
52 - Fix extended argument parsing by IN/BETWEEN
53 - Add proper handling of lists (foo,bar,?)
54 - Better handling of generic -function's during AST construction
55 - Special handle IS NOT? NULL
56 - Make sure unparse() does not destroy a passed in \@bindargs
57 - Support ops with _'s in them (valid in Oracle)
58 - Properly parse both types of default value inserts
59 - Allow { -func => $val } as arguments to UPDATE
61 revision 1.68 2010-09-16
62 ----------------------------
63 - Document methods on Tree
64 - Add affordances for color coding placeholders
65 - Change ::Tree::whitespace to whitespace_keyword
67 revision 1.67_03 2010-09-11
68 ----------------------------
69 - Add docs for SQL::Abstract::Tree->new
70 - correcty merge profile and parameters
71 - added fill_in_placeholders option for excellent copy/pasta
73 revision 1.67_02 2010-09-08
74 ----------------------------
75 - rename DBIx::Class::Storage::PrettyPrinter to DBIx::Class::Storage::Debug::PrettyPrint
76 - decreased a lot of indentation from ::Tree
77 - cleaned up handling of newlines inside of parens
79 revision 1.67_01 2010-09-06
80 ----------------------------
81 - Add SQL::Abstract::Tree
82 - Add unindexed DBIx::Class::Storage::PrettyPrinter
83 - Better documentation of undef/NULL in where clause
84 - Depend on bugfixed Module::Install (now again installs
87 revision 1.67 2010-05-31 14:21 (UTC)
88 ----------------------------
89 - Fix SQL::Test failure when first chunk is an unrecognized
91 - Generic -not operator tests
92 - More columns-bindtype assertion checks
94 revision 1.66 2010-04-27 02:44 (UTC)
95 ----------------------------
96 - Optimized the quoting mechanism, winning nearly 10%
97 speedup on repeatable sql generation
99 revision 1.65 2010-04-11 19:59 (UTC)
100 ----------------------------
101 - Rerelease last version to not include .svn files
102 and grab MANIFEST.SKIP from DBIx::Class so it
105 revision 1.64 2010-04-11 16:58 (UTC)
106 ----------------------------
107 - Fix multiple generic op handling regressions by
108 reverting the auto-equality assumption (turned out
109 to be a very very bad idea)
111 revision 1.63 2010-03-24 09:56 (UTC)
112 ----------------------------
113 - Add ILIKE to the core list of comparision ops
115 revision 1.62 2010-03-15 11:06 (UTC)
116 ----------------------------
117 - Fixed open outer parens for a multi-line literal
118 - Allow recursively-nested column-functions in WHERE
119 - Bumped minimum perl to 5.6.2 and changed tests to
120 rely on core dependencies
122 revision 1.61 2010-02-05 16:28 (UTC)
123 ----------------------------
124 - Allow INSERT to take additional attributes
125 - Support for INSERT ... RETURNING
126 - Another iteration of SQL::Abstract::Test fixes and improvements
128 revision 1.60 2009-09-22 11:03 (UTC)
129 ----------------------------
130 - fix a well masked error in the sql-test tokenizer
132 revision 1.59 2009-09-22 08:39 (UTC)
133 ----------------------------
134 - fixed a couple of untrapped undefined warnings
135 - allow -in/-between to accept literal sql in all logical
136 variants - see POD for details
137 - unroll multiple parenthesis around IN arguments to accomodate
140 revision 1.58 2009-09-04 15:20 (UTC)
141 ----------------------------
142 - expanded the scope of -bool and -not_bool operators
143 - added proper testing support
145 revision 1.57 2009-09-03 20:18 (UTC)
146 ----------------------------
147 - added -bool and -not_bool operators
149 revision 1.56 2009-05-30 16:31 (UTC)
150 ----------------------------
151 - support for \[$sql, @bind] in order_by clauses e.g.:
152 { -desc => \['colA LIKE ?', 'somestring'] }
154 revision 1.55 2009-05-17 22:54 (UTC)
155 ----------------------------
156 - make sure that sql generation does not mutate the supplied
157 where condition structure
159 revision 1.54 2009-05-07 17:23 (UTC)
160 ----------------------------
161 - allow special_operators to take both code refs and method names
162 (makes it possible to properly subclass the builtin ones)
164 revision 1.53 2009-04-30 14:58 (UTC)
165 ----------------------------
166 - make sure hash keys are sorted in all search sub-conditions
167 - switch installer from EU::MM to M::I
169 revision 1.52 2009-04-28 23:14 (UTC)
170 ----------------------------
171 - allow -between to handle [\"", \""] and \["", @bind]
172 - allow order_by to handle -asc|desc => [qw/colA colB/] (artifact from DBIx::Class)
173 - more tests and clearing up of some corner cases
174 - t/10test.t does not run by default (developer only, too cpu intensive)
176 ----------------------------
177 revision 1.51 2009-03-28 10:00 (UTC)
178 - fixed behavior of [-and => ... ] depending on the current
179 condition scope. This introduces backwards comp with 1.24
181 ----------------------------
182 revision 1.50 2009-03-10 12:30 (UTC)
183 - fixed the problem with values() not behaving the same as the rest of the code (RT#43483)
184 - fixed interjecting arrayrefref into a where clause
185 - added value-only insert test with a literal SQL snippet
186 - cleanup and enhancement of t/03values.t
187 - better handling of borked SQL in tests
188 - deal properly with parentheses in is_same_sql_bind()
189 - fixed test subs (is_same_*) in SQL::Abstract::Test to return the correct test value
190 - do not version MANIFEST
192 Version 1.50 was a major internal refactoring of SQL::Abstract.
193 Great care has been taken to preserve the published behavior
194 documented in previous versions in the 1.* family; however,
195 some features that were previously undocumented, or behaved.
196 differently from the documentation, had to be changed in order
197 to clarify the semantics. Hence, client code that was relying
198 on some dark areas of SQL::Abstract v1.* might behave differently
201 ----------------------------
202 revision 1.49_04 2009-03-03
203 - add support for a [\%column_meta => value] bind value format
205 ----------------------------
206 revision 1.49_03 2009-02-17
207 - clarify syntax of \['...', @bind] when used with a bindtype
210 ----------------------------
211 revision 1.49_02 2009-02-16
212 - added an AST-aware SQL::Abstract::Test library for sql syntax tests
213 - vastly expanded test coverage
214 - support for the { operator => \'...'|\['...', @bind] } syntax
215 allowing to embed arbitrary operators on the LHS
216 - fixed multiple regressions wrt DBIx::Class
218 ----------------------------
219 revision 1.49_01 2009-02-11
220 - support for literal SQL through the [$sql, bind] syntax.
221 - added -nest1, -nest2 or -nest_1, -nest_2, ...
222 - optional support for array datatypes
223 - defensive programming : check arguments to functions/methods
224 - fixed bug with global logic of -and/-or (no side-effects any more)
225 - changed logic for distributing an op over arrayrefs
226 - fixed semantics of _bindtype on array args
227 - dropped the _anoncopy of the %where tree. No longer necessary.
228 - dropped the _modlogic function
229 - Make col => [] and col => {$op => [] } DTRT or die instead of generating
230 broken SQL. Added tests for this.
231 - Added { -desc => 'column' } order by support
232 - Tiny "$_"-related fix for { -desc => 'columns'} order by support
235 ----------------------------
237 date: 2005/08/18 18:41:58; author: nwiger; state: Exp; lines: +104 -50
238 - added patch from Dan Kubb enabling quote_char and name_sep options
239 - added patch from Andy Grundman to enhance _anoncopy for deep refs
240 ----------------------------
242 date: 2005/04/29 18:20:30; author: nwiger; state: Exp; lines: +34 -20
243 added _anoncopy to prevent destroying original; updated docs
244 ----------------------------
246 date: 2005/03/07 20:14:12; author: nwiger; state: Exp; lines: +201 -65
247 added support for -and, -or, and -nest; see docs for details
248 ----------------------------
250 date: 2004/08/25 20:11:27; author: nwiger; state: Exp; lines: +58 -46
251 added patch from Eric Kolve to iterate over all hashref elements
252 ----------------------------
254 date: 2004/06/10 17:20:01; author: nwiger; state: Exp; lines: +178 -12
255 added bindtype param to allow this to work with Orasuck 9+
256 ----------------------------
258 date: 2003/11/05 23:40:40; author: nwiger; state: Exp; lines: +18 -6
259 several bugfixes, including _convert being applied wrong and
260 the edge case field => { '!=', [qw/this that/] } not working
261 ----------------------------
263 date: 2003/11/04 21:20:33; author: nwiger; state: Exp; lines: +115 -34
264 added patch from Philip Collins, and also added 'convert' option
265 ----------------------------
267 date: 2003/05/21 17:22:29; author: nwiger; state: Exp; lines: +230 -74
268 added "IN" and "BETWEEN" operator support, as well as "NOT"
269 modified where() to support ORDER BY, and fixed some bugs too
270 added PERFORMANCE and FORMBUILDER doc sections
271 fixed several bugs in _recurse_where(), it now works as expected
272 added test suite, many thanks to Chas Owens
273 modified all hash access to return keys sorted, to allow cached queries
274 ----------------------------
276 date: 2003/05/08 20:10:56; author: nwiger; state: Exp; lines: +181 -96
277 1.11 interim checking; major bugfixes and order_by, 1.12 will go to CPAN
278 ----------------------------
280 date: 2003/05/02 00:07:30; author: nwiger; state: Exp; lines: +52 -12
281 many minor enhancements to add querying flexibility
282 ----------------------------
284 date: 2002/09/27 18:06:25; author: nwiger; state: Exp; lines: +6 -2
285 added precatch for messed up where string
286 ----------------------------
288 date: 2002/08/29 18:04:35; author: nwiger; state: Exp; lines: +4 -3
290 ----------------------------
292 date: 2001/11/07 22:18:12; author: nwiger; state: Exp; lines: +31 -14
293 added embedded SCALAR ref capability to insert() and update()
294 ----------------------------
296 date: 2001/11/07 01:23:28; author: nwiger; state: Exp; lines: +3 -3
298 ----------------------------
300 date: 2001/11/06 21:09:44; author: nwiger; state: Exp; lines: +14 -6
301 oops, had to actually *implement* the order by for select()!
302 ----------------------------
304 date: 2001/11/06 03:13:16; author: nwiger; state: Exp; lines: +43 -4
306 ----------------------------
308 date: 2001/11/06 03:07:42; author: nwiger; state: Exp; lines: +16 -7
309 added extra layer of ()'s to ensure correct semantics on AND
310 ----------------------------
312 date: 2001/11/06 01:16:31; author: nwiger; state: Exp; lines: +11 -10
313 updated all statements so that they use wantarray to just return SQL if asked
314 ----------------------------
316 date: 2001/10/26 22:23:46; author: nwiger; state: Exp; lines: +112 -15
317 added scalar ref for SQL verbatim in where, fixed bugs, array ref, docs
318 ----------------------------
320 date: 2001/10/24 00:26:43; author: nwiger; state: Exp;