Peter Rabbitson [Sun, 2 Jun 2013 13:38:35 +0000]
Stop differentiating between ORDER BY foo and ORDER BY foo ASC by default
Peter Rabbitson [Sun, 2 Jun 2013 12:16:36 +0000]
Drop the silly Dumpered bind comparison
Peter Rabbitson [Sat, 1 Jun 2013 20:02:17 +0000]
Pave the road to more global state
(Yes, yes an object is saner, but it means a thought out interface and
all that, and then it means optimization of when and how do we do the
modification passes, and really I am not after this stuff at the moment)
Dagfinn Ilmari Mannsåker [Sun, 14 Apr 2013 10:53:32 +0000]
Revert "Add support for NULLS FIRST/LAST in ORDER BY"
Despite being an ISO/ANSI SQL feature, it's apparently not supported by
enough databses to have by default.
This reverts commits
2266ca5c0bf34c24ba7fbf6448ad1c34a082f240 and
b137b0744a3aaea3df1ba497345378e9d3f8da40.
Olaf Alders [Wed, 6 Feb 2013 20:34:35 +0000]
Normalize the select docs s/$table/$source/
Peter Rabbitson [Fri, 11 May 2012 04:47:09 +0000]
Fix false-negative function comparisons
Dagfinn Ilmari Mannsåker [Tue, 5 Feb 2013 19:12:46 +0000]
Fix -nulls value case-insensitivity
Dagfinn Ilmari Mannsåker [Sat, 26 Jan 2013 18:32:09 +0000]
Add support for NULLS FIRST/LAST in ORDER BY
Arthur Axel 'fREW' Schmidt [Tue, 10 Jul 2012 21:22:41 +0000]
release 1.73
Arthur Axel 'fREW' Schmidt [Wed, 30 May 2012 02:05:22 +0000]
release 1.73_01
Arthur Axel 'fREW' Schmidt [Fri, 20 Apr 2012 18:46:28 +0000]
fix regression introduced in 6f2a5b6
Arthur Axel 'fREW' Schmidt [Fri, 20 Apr 2012 18:24:11 +0000]
Stop filling in placeholders in `format-sql`
Peter Rabbitson [Wed, 11 Apr 2012 05:12:57 +0000]
Pull in some dependency bugfixes
Peter Rabbitson [Tue, 29 Nov 2011 04:55:59 +0000]
Upgrade M::I
Peter Rabbitson [Sun, 20 Mar 2011 09:30:17 +0000]
Migrate -ident and -value from dbic, reorganize docs
Ryan P. Kelly [Wed, 29 Jun 2011 03:54:51 +0000]
Document with the right name
Naveed Massjouni [Fri, 22 Apr 2011 22:08:21 +0000]
Cleaning up docs as ribasushi suggested. Made it clear that literal sql
should be used as a last resort. Provided an example for testing IS NOT NULL.
Peter Rabbitson [Sun, 7 Aug 2011 03:54:03 +0000]
Cleanup parser a bit more, anchor everything correctly, etc
Alexander Hartmaier [Fri, 29 Jul 2011 13:14:35 +0000]
Add test for SQL statement that used to fail before the refactor
Peter Rabbitson [Sat, 6 Aug 2011 20:22:28 +0000]
Massively refactor arbitrary sql parser code
Now it deals much better with malformedness, does not recurse to insanely
deep evels, and reports much much better errors on test mismatches
Peter Rabbitson [Mon, 1 Aug 2011 10:14:49 +0000]
Fix over-eager parenthesis unrolling (only legal in AND/OR)
Peter Rabbitson [Mon, 1 Aug 2011 10:03:29 +0000]
Promote AS to a binop of sorts
Peter Rabbitson [Sat, 19 Mar 2011 23:30:26 +0000]
Do not import Carp functions into the namespace
Justin Hunter [Fri, 8 Apr 2011 00:38:54 +0000]
_debug not debug, RT#67179
Justin Hunter [Fri, 1 Apr 2011 14:47:29 +0000]
fix some pod per RT65556
Justin Hunter [Fri, 1 Apr 2011 14:12:45 +0000]
fix git url, RT67137
Arthur Axel 'fREW' Schmidt [Tue, 29 Mar 2011 14:37:50 +0000]
take out useless _table option
Peter Rabbitson [Fri, 7 Jan 2011 09:40:14 +0000]
Add some crazy malformed SQL to make sure things do not throw
It looks like the empty-not-undef fix in
7cc47319 also fixes the general
issue of throwing on unknown operators (e.g. reverting
af75bd59 would
still yield passing code, though the AST will still be incorrect).
Add a currently passing test as a reminder of what stuff to look for
Peter Rabbitson [Fri, 7 Jan 2011 09:18:32 +0000]
Fix incorrect comparison of malformed lists
AND OR and , must have both a lhs and a rhs, if neither is
present add a [], which will properly trip the comparison
later on.
Peter Rabbitson [Fri, 7 Jan 2011 09:05:06 +0000]
Fix recursion warnings while parsing extremely long lists
Peter Rabbitson [Wed, 22 Dec 2010 15:45:39 +0000]
Fix stupid not exists omission
Arthur Axel 'fREW' Schmidt [Tue, 21 Dec 2010 17:53:00 +0000]
Release 1.72
Peter Rabbitson [Tue, 21 Dec 2010 16:24:29 +0000]
Consolidate the injection_guard checks, fix bobby's name
Peter Rabbitson [Tue, 21 Dec 2010 12:56:07 +0000]
injection_guard implementation
Peter Rabbitson [Tue, 21 Dec 2010 11:01:43 +0000]
Require bugfixed CAG
Peter Rabbitson [Tue, 21 Dec 2010 10:26:09 +0000]
Undocument -nest with extreme prejudice
-nest is a wart that never served any reasonable purpose. While
DBIC is outright deprecating it, SQLA is simply undocumenting it,
committing to keep all tests intact (but not committing to
reimplement -nest in the Data::Query adapter).
Wes Malone [Tue, 30 Nov 2010 03:41:49 +0000]
Removed excess parentheses in generated SQL
Peter Rabbitson [Sun, 5 Dec 2010 20:02:29 +0000]
Fix stupid assumption in parenthesis unroller
Peter Rabbitson [Sun, 5 Dec 2010 18:21:51 +0000]
Pass options to _insert_returning and allow bind rvs
Justin Hunter [Wed, 1 Dec 2010 00:03:50 +0000]
add handling for NULL when using -in
Peter Rabbitson [Sun, 28 Nov 2010 01:31:25 +0000]
Better diagnostics (unparse the parent of the failed chunk)
Peter Rabbitson [Sat, 27 Nov 2010 22:54:42 +0000]
Ask for a faster CAG, switch to MI::AI
Peter Rabbitson [Wed, 24 Nov 2010 16:44:40 +0000]
Warnfree tests
Peter Rabbitson [Wed, 24 Nov 2010 16:42:56 +0000]
Fix retardation in -between bind handling
Arthur Axel 'fREW' Schmidt [Sat, 13 Nov 2010 05:39:46 +0000]
migrate _parenthesis_unroll to SQL::Abstract::Tree
Dagfinn Ilmari Mannsåker [Tue, 9 Nov 2010 11:40:31 +0000]
Fix parsing of foo.* in SQLA::Tree
Peter Rabbitson [Tue, 9 Nov 2010 11:20:51 +0000]
Release 1.71
Peter Rabbitson [Tue, 9 Nov 2010 11:14:34 +0000]
Disable dbic-tests when no dbic is present
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 04:44:09 +0000]
Release 1.70
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 04:40:38 +0000]
sort changes by importance
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 01:12:49 +0000]
no raw ASCII
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 01:11:59 +0000]
better quoting logic
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 00:45:46 +0000]
Leave quotes from DBIC in bindargs
Peter Rabbitson [Mon, 8 Nov 2010 03:04:01 +0000]
Make resulting SQL work on MySQL
Peter Rabbitson [Mon, 8 Nov 2010 03:03:18 +0000]
gitignore
Peter Rabbitson [Mon, 8 Nov 2010 02:56:34 +0000]
Reenable show_progress in example
Arthur Axel 'fREW' Schmidt [Sat, 6 Nov 2010 23:46:14 +0000]
Document repo
Arthur Axel 'fREW' Schmidt [Wed, 3 Nov 2010 02:36:14 +0000]
Fix missing doc (RT#62587)
Arthur Axel 'fREW' Schmidt [Fri, 29 Oct 2010 01:40:24 +0000]
Add error checking on "profile" for SQLA::Tree
Arthur Axel 'fREW' Schmidt [Thu, 28 Oct 2010 04:24:49 +0000]
Highlight HAVING
Arthur Axel 'fREW' Schmidt [Tue, 26 Oct 2010 01:39:10 +0000]
docs for pretty printer
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 21:15:40 +0000]
fixup tests
Arthur Axel 'fREW' Schmidt [Tue, 26 Oct 2010 01:21:28 +0000]
fix precedence for executing in new
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 21:06:44 +0000]
tests for bulk insert
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:59:47 +0000]
Do not show_progress by default
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:58:51 +0000]
squash_repeats > no_repeats
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:20:29 +0000]
test for no-repeats
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 14:44:29 +0000]
Add "no_repeats" option to fix it such that repeated SQL may be ellided except for placeholders
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 21:04:36 +0000]
try DBIC colorizer!
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 20:45:00 +0000]
better bulk insert support
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 20:41:46 +0000]
allow disabling of show_progress; _ some accessors
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 20:30:26 +0000]
Add EXECUTING for clarity of long running SQL
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 17:10:06 +0000]
make console color profile a bit easier to read
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 17:05:00 +0000]
Highlight transaction keywords
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 16:43:00 +0000]
Hide bulk inserts from DBIx::Class
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 02:18:52 +0000]
fix pagination keywords
Arthur Axel "fREW" Schmidt [Sat, 23 Oct 2010 01:49:36 +0000]
fix placeholder quoting
Arthur Axel "fREW" Schmidt [Fri, 22 Oct 2010 14:32:27 +0000]
release SQL::Abstract 1.69
Arthur Axel "fREW" Schmidt [Fri, 22 Oct 2010 04:12:18 +0000]
fix tree tests
Peter Rabbitson [Thu, 21 Oct 2010 17:11:29 +0000]
Add support for { -op => $foo } in UPDATE arguments
Refactor unary op handlers to allow overrides at any level
Makes for very very hairy internals, but immensely useful for upstream
Peter Rabbitson [Thu, 21 Oct 2010 14:51:31 +0000]
Fix default value inserts (an op can have an empty arglist)
Peter Rabbitson [Thu, 21 Oct 2010 13:53:11 +0000]
Fix incorrect padding
Peter Rabbitson [Thu, 21 Oct 2010 13:36:51 +0000]
Proper placeholder support in the AST
Peter Rabbitson [Thu, 21 Oct 2010 13:21:26 +0000]
Properly support ops containing _'s (valid in Oracle)
Peter Rabbitson [Thu, 21 Oct 2010 12:49:11 +0000]
Preserve \@bindargs passed to unparse()
Peter Rabbitson [Thu, 21 Oct 2010 12:39:16 +0000]
Add list support, and various mini-fixes
John Napiorkowski [Wed, 20 Oct 2010 18:01:23 +0000]
examined placeholder status a bit more carefully
John Napiorkowski [Wed, 20 Oct 2010 17:49:40 +0000]
added test for the html profile destroyed placeholder problem
Arthur Axel "fREW" Schmidt [Fri, 15 Oct 2010 00:31:47 +0000]
fix placeholder surround and add complex test
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 08:46:41 +0000]
Changes for past two commits
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 08:39:57 +0000]
s// does not return the modified string, $_ does
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 08:26:07 +0000]
make format-sql actually useful
Arthur Axel "fREW" Schmidt [Sat, 9 Oct 2010 07:57:12 +0000]
add a couple more examples
Peter Rabbitson [Wed, 29 Sep 2010 16:55:23 +0000]
Fix bogus test (does not pass yet)
Peter Rabbitson [Wed, 29 Sep 2010 16:54:53 +0000]
t/01generate.t
Peter Rabbitson [Mon, 27 Sep 2010 06:54:06 +0000]
These 'optimizations' are silly
Peter Rabbitson [Thu, 23 Sep 2010 10:51:29 +0000]
Fix bindtype omission in -in handling
Peter Rabbitson [Wed, 22 Sep 2010 14:19:34 +0000]
Backout errnoeusly committed stuff
Peter Rabbitson [Wed, 22 Sep 2010 14:14:40 +0000]
Fix incomplete handling of IN/BETWEEN sub-args
Peter Rabbitson [Wed, 22 Sep 2010 10:09:34 +0000]
Replace one more grep with a regex