10 years agoSplit comma separated clauses onto multiple lines people/f0rk/format-sql
Ryan P. Kelly [Wed, 29 Jun 2011 04:21:20 +0000]
Split comma separated clauses onto multiple lines

10 years agoSplit AND'ed or OR'ed clauses onto separate lines
Ryan P. Kelly [Wed, 29 Jun 2011 04:20:30 +0000]
Split AND'ed or OR'ed clauses onto separate lines

10 years agoPort fce4b7a9 from the DQ branch (with warning expectation ammendments)
Dagfinn Ilmari Mannsåker [Fri, 6 Dec 2013 17:24:22 +0000]
Port fce4b7a9 from the DQ branch (with warning expectation ammendments)

10 years agoReintroduce handling of IS( NOT) ops
Peter Rabbitson [Thu, 26 Dec 2013 08:23:06 +0000]
Reintroduce handling of IS( NOT) ops

This is undocumented syntax, but it is very likely someone is using it in
the wild, and the previous inequality op handler rewrite broke this

10 years agoExtensive tests and deprecations of multivalue/no value inequality op calls
Peter Rabbitson [Thu, 26 Dec 2013 05:47:18 +0000]
Extensive tests and deprecations of multivalue/no value inequality op calls

All sql-generation tests match pre <= 1.74 behavior (except for the newly
added rlike operator, which now warns while it simply did not work with
undefs before)

10 years agoMove test to a better location (no changes)
Peter Rabbitson [Thu, 26 Dec 2013 05:28:02 +0000]
Move test to a better location (no changes)

10 years agoNormalize handling of expected warnings/exceptions in tests
Peter Rabbitson [Thu, 26 Dec 2013 05:26:51 +0000]
Normalize handling of expected warnings/exceptions in tests

10 years agoRemove many of the settled-by-time comments, modernize a bit
Peter Rabbitson [Thu, 26 Dec 2013 05:07:25 +0000]
Remove many of the settled-by-time comments, modernize a bit

10 years agoCentralize handling of in-test dumpering
Peter Rabbitson [Thu, 26 Dec 2013 04:29:17 +0000]
Centralize handling of in-test dumpering

10 years agoExtra stopword (we need to find a way to introduce dialects...)
Peter Rabbitson [Sun, 22 Dec 2013 11:36:59 +0000]
Extra stopword (we need to find a way to introduce dialects...)

10 years agoNo tabs, no trailers
Peter Rabbitson [Wed, 18 Dec 2013 13:50:36 +0000]
No tabs, no trailers

10 years agoMake it clearer in examples that bool takes expressions
Peter Rabbitson [Wed, 18 Dec 2013 13:25:05 +0000]
Make it clearer in examples that bool takes expressions

timbunce++

10 years agoTest BETWEEN after the IN debacle (luckily it throws in all expected cases)
Peter Rabbitson [Wed, 18 Dec 2013 10:15:20 +0000]
Test BETWEEN after the IN debacle (luckily it throws in all expected cases)

Generalize the emitted exception text

10 years agoWe already have Storable as a dep, this is pointless
Peter Rabbitson [Wed, 18 Dec 2013 10:20:23 +0000]
We already have Storable as a dep, this is pointless

10 years agoAnd yet more improvements in the parsing engine
Peter Rabbitson [Tue, 17 Dec 2013 23:33:31 +0000]
And yet more improvements in the parsing engine

Streamline the construction of -MISC (gah I hate that name) nodes, and make
sure we do not treat placeholders as list element node terminator

10 years agoDo not yell loudly on TODOified is_same_* tests
Peter Rabbitson [Wed, 18 Dec 2013 08:15:50 +0000]
Do not yell loudly on TODOified is_same_* tests

10 years agoClarify in => undef exception (based on 90c87778)
Dagfinn Ilmari Mannsåker [Sun, 8 Dec 2013 17:01:03 +0000]
Clarify in => undef exception (based on 90c87778)

10 years agoBackport undef-with-in tests from DQ, add "roadwork ahead" exceptions
Peter Rabbitson [Wed, 18 Dec 2013 08:48:36 +0000]
Backport undef-with-in tests from DQ, add "roadwork ahead" exceptions

This is an amalgamation of test changes from 5b67050, 39221d2 and 038b0a7
ilmari++

10 years agoExtra test from the DQ branch (passes in 1.5)
Dagfinn Ilmari Mannsåker [Tue, 3 Dec 2013 17:17:29 +0000]
Extra test from the DQ branch (passes in 1.5)

10 years agoDocument and test non-reference { -in => ... }
Dagfinn Ilmari Mannsåker [Wed, 4 Dec 2013 15:16:13 +0000]
Document and test non-reference { -in => ... }

Also test the documented but untested { -in => [] } optimisation.

10 years agoFix typos in POD and comments (RT#87776)
Dagfinn Ilmari Mannsåker [Mon, 12 Aug 2013 20:03:16 +0000]
Fix typos in POD and comments (RT#87776)

10 years agoKill the plan
Peter Rabbitson [Sun, 9 Jun 2013 11:36:46 +0000]
Kill the plan

10 years agoFinish a RHS branch before applying ASC/DESC mods
Peter Rabbitson [Sun, 9 Jun 2013 11:28:35 +0000]
Finish a RHS branch before applying ASC/DESC mods

10 years agorelease 1.74 v1.74
Peter Rabbitson [Tue, 4 Jun 2013 21:06:24 +0000]
release 1.74

10 years agoNo dynamic deps
Peter Rabbitson [Tue, 4 Jun 2013 21:05:40 +0000]
No dynamic deps

10 years agoMake tests pass without Storable
Peter Rabbitson [Tue, 4 Jun 2013 21:02:23 +0000]
Make tests pass without Storable

10 years agoAdded (now passing) test for @@ full text search
Mark A. Stratman [Mon, 3 Dec 2012 18:46:13 +0000]
Added (now passing) test for @@ full text search

10 years agoStop unknown token processing early in case a potential unknown function lies ahead
Peter Rabbitson [Tue, 4 Jun 2013 17:11:20 +0000]
Stop unknown token processing early in case a potential unknown function lies ahead

10 years agoAdd (now passing) reassembly test
Arthur Axel 'fREW' Schmidt [Wed, 17 Oct 2012 14:01:23 +0000]
Add (now passing) reassembly test

10 years agoChange parser to not eagerly slurp RHS expressions it doesn't recognize
Peter Rabbitson [Tue, 4 Jun 2013 16:08:25 +0000]
Change parser to not eagerly slurp RHS expressions it doesn't recognize

10 years agoThe ORDER BY parsing fix in 73835ff0 only worked by accident
Peter Rabbitson [Tue, 4 Jun 2013 15:11:13 +0000]
The ORDER BY parsing fix in 73835ff0 only worked by accident

Remove a number of workarounds introduced before the parser rewrite - none of
them help, and one of them was in fact the reason multi-member ORDER BY
did not function correctly

10 years agoAll roundtrip tests now look for the exact string
Peter Rabbitson [Sun, 2 Jun 2013 15:17:06 +0000]
All roundtrip tests now look for the exact string

Merge test files while at it

10 years agoStop differentiating between ORDER BY foo and ORDER BY foo ASC by default
Peter Rabbitson [Sun, 2 Jun 2013 13:38:35 +0000]
Stop differentiating between ORDER BY foo and ORDER BY foo ASC by default

10 years agoDrop the silly Dumpered bind comparison
Peter Rabbitson [Sun, 2 Jun 2013 12:16:36 +0000]
Drop the silly Dumpered bind comparison

10 years agoPave the road to more global state
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)

11 years agoRevert "Add support for NULLS FIRST/LAST in ORDER BY"
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.

11 years agoNormalize the select docs s/$table/$source/
Olaf Alders [Wed, 6 Feb 2013 20:34:35 +0000]
Normalize the select docs s/$table/$source/

11 years agoFix false-negative function comparisons
Peter Rabbitson [Fri, 11 May 2012 04:47:09 +0000]
Fix false-negative function comparisons

11 years agoFix -nulls value case-insensitivity
Dagfinn Ilmari Mannsåker [Tue, 5 Feb 2013 19:12:46 +0000]
Fix -nulls value case-insensitivity

11 years agoAdd support for NULLS FIRST/LAST in ORDER BY
Dagfinn Ilmari Mannsåker [Sat, 26 Jan 2013 18:32:09 +0000]
Add support for NULLS FIRST/LAST in ORDER BY

11 years agorelease 1.73 v1.73
Arthur Axel 'fREW' Schmidt [Tue, 10 Jul 2012 21:22:41 +0000]
release 1.73

11 years agorelease 1.73_01 v1.73_01
Arthur Axel 'fREW' Schmidt [Wed, 30 May 2012 02:05:22 +0000]
release 1.73_01

11 years agofix regression introduced in 6f2a5b6
Arthur Axel 'fREW' Schmidt [Fri, 20 Apr 2012 18:46:28 +0000]
fix regression introduced in 6f2a5b6

12 years agoStop filling in placeholders in `format-sql`
Arthur Axel 'fREW' Schmidt [Fri, 20 Apr 2012 18:24:11 +0000]
Stop filling in placeholders in `format-sql`

12 years agoPull in some dependency bugfixes
Peter Rabbitson [Wed, 11 Apr 2012 05:12:57 +0000]
Pull in some dependency bugfixes

12 years agoUpgrade M::I
Peter Rabbitson [Tue, 29 Nov 2011 04:55:59 +0000]
Upgrade M::I

12 years agoMigrate -ident and -value from dbic, reorganize docs
Peter Rabbitson [Sun, 20 Mar 2011 09:30:17 +0000]
Migrate -ident and -value from dbic, reorganize docs

12 years agoDocument with the right name
Ryan P. Kelly [Wed, 29 Jun 2011 03:54:51 +0000]
Document with the right name

12 years agoCleaning up docs as ribasushi suggested. Made it clear that literal sql
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.

12 years agoCleanup parser a bit more, anchor everything correctly, etc
Peter Rabbitson [Sun, 7 Aug 2011 03:54:03 +0000]
Cleanup parser a bit more, anchor everything correctly, etc

12 years agoAdd test for SQL statement that used to fail before the refactor
Alexander Hartmaier [Fri, 29 Jul 2011 13:14:35 +0000]
Add test for SQL statement that used to fail before the refactor

12 years agoMassively refactor arbitrary sql parser code
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

12 years agoFix over-eager parenthesis unrolling (only legal in AND/OR)
Peter Rabbitson [Mon, 1 Aug 2011 10:14:49 +0000]
Fix over-eager parenthesis unrolling (only legal in AND/OR)

12 years agoPromote AS to a binop of sorts
Peter Rabbitson [Mon, 1 Aug 2011 10:03:29 +0000]
Promote AS to a binop of sorts

12 years agoDo not import Carp functions into the namespace
Peter Rabbitson [Sat, 19 Mar 2011 23:30:26 +0000]
Do not import Carp functions into the namespace

13 years ago_debug not debug, RT#67179
Justin Hunter [Fri, 8 Apr 2011 00:38:54 +0000]
_debug not debug, RT#67179

13 years agofix some pod per RT65556
Justin Hunter [Fri, 1 Apr 2011 14:47:29 +0000]
fix some pod per RT65556

13 years agofix git url, RT67137
Justin Hunter [Fri, 1 Apr 2011 14:12:45 +0000]
fix git url, RT67137

13 years agotake out useless _table option
Arthur Axel 'fREW' Schmidt [Tue, 29 Mar 2011 14:37:50 +0000]
take out useless _table option

13 years agoAdd some crazy malformed SQL to make sure things do not throw
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

13 years agoFix incorrect comparison of malformed lists
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.

13 years agoFix recursion warnings while parsing extremely long lists
Peter Rabbitson [Fri, 7 Jan 2011 09:05:06 +0000]
Fix recursion warnings while parsing extremely long lists

13 years agoFix stupid not exists omission
Peter Rabbitson [Wed, 22 Dec 2010 15:45:39 +0000]
Fix stupid not exists omission

13 years agoRelease 1.72 v1.72
Arthur Axel 'fREW' Schmidt [Tue, 21 Dec 2010 17:53:00 +0000]
Release 1.72

13 years agoConsolidate the injection_guard checks, fix bobby's name
Peter Rabbitson [Tue, 21 Dec 2010 16:24:29 +0000]
Consolidate the injection_guard checks, fix bobby's name

13 years agoinjection_guard implementation
Peter Rabbitson [Tue, 21 Dec 2010 12:56:07 +0000]
injection_guard implementation

13 years agoRequire bugfixed CAG
Peter Rabbitson [Tue, 21 Dec 2010 11:01:43 +0000]
Require bugfixed CAG

13 years agoUndocument -nest with extreme prejudice
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).

13 years agoRemoved excess parentheses in generated SQL
Wes Malone [Tue, 30 Nov 2010 03:41:49 +0000]
Removed excess parentheses in generated SQL

13 years agoFix stupid assumption in parenthesis unroller
Peter Rabbitson [Sun, 5 Dec 2010 20:02:29 +0000]
Fix stupid assumption in parenthesis unroller

13 years agoPass options to _insert_returning and allow bind rvs
Peter Rabbitson [Sun, 5 Dec 2010 18:21:51 +0000]
Pass options to _insert_returning and allow bind rvs

13 years agoadd handling for NULL when using -in
Justin Hunter [Wed, 1 Dec 2010 00:03:50 +0000]
add handling for NULL when using -in

13 years agoBetter diagnostics (unparse the parent of the failed chunk)
Peter Rabbitson [Sun, 28 Nov 2010 01:31:25 +0000]
Better diagnostics (unparse the parent of the failed chunk)

13 years agoAsk for a faster CAG, switch to MI::AI
Peter Rabbitson [Sat, 27 Nov 2010 22:54:42 +0000]
Ask for a faster CAG, switch to MI::AI

13 years agoWarnfree tests
Peter Rabbitson [Wed, 24 Nov 2010 16:44:40 +0000]
Warnfree tests

13 years agoFix retardation in -between bind handling
Peter Rabbitson [Wed, 24 Nov 2010 16:42:56 +0000]
Fix retardation in -between bind handling

13 years agomigrate _parenthesis_unroll to SQL::Abstract::Tree
Arthur Axel 'fREW' Schmidt [Sat, 13 Nov 2010 05:39:46 +0000]
migrate _parenthesis_unroll to SQL::Abstract::Tree

13 years agoFix parsing of foo.* in SQLA::Tree
Dagfinn Ilmari Mannsåker [Tue, 9 Nov 2010 11:40:31 +0000]
Fix parsing of foo.* in SQLA::Tree

13 years agoRelease 1.71 v1.71
Peter Rabbitson [Tue, 9 Nov 2010 11:20:51 +0000]
Release 1.71

13 years agoDisable dbic-tests when no dbic is present
Peter Rabbitson [Tue, 9 Nov 2010 11:14:34 +0000]
Disable dbic-tests when no dbic is present

13 years agoRelease 1.70 v1.70
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 04:44:09 +0000]
Release 1.70

13 years agosort changes by importance
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 04:40:38 +0000]
sort changes by importance

13 years agono raw ASCII
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 01:12:49 +0000]
no raw ASCII

13 years agobetter quoting logic
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 01:11:59 +0000]
better quoting logic

13 years agoLeave quotes from DBIC in bindargs
Arthur Axel 'fREW' Schmidt [Tue, 9 Nov 2010 00:45:46 +0000]
Leave quotes from DBIC in bindargs

13 years agoMake resulting SQL work on MySQL
Peter Rabbitson [Mon, 8 Nov 2010 03:04:01 +0000]
Make resulting SQL work on MySQL

13 years agogitignore
Peter Rabbitson [Mon, 8 Nov 2010 03:03:18 +0000]
gitignore

13 years agoReenable show_progress in example
Peter Rabbitson [Mon, 8 Nov 2010 02:56:34 +0000]
Reenable show_progress in example

13 years agoDocument repo
Arthur Axel 'fREW' Schmidt [Sat, 6 Nov 2010 23:46:14 +0000]
Document repo

13 years agoFix missing doc (RT#62587)
Arthur Axel 'fREW' Schmidt [Wed, 3 Nov 2010 02:36:14 +0000]
Fix missing doc (RT#62587)

13 years agoAdd error checking on "profile" for SQLA::Tree
Arthur Axel 'fREW' Schmidt [Fri, 29 Oct 2010 01:40:24 +0000]
Add error checking on "profile" for SQLA::Tree

13 years agoHighlight HAVING
Arthur Axel 'fREW' Schmidt [Thu, 28 Oct 2010 04:24:49 +0000]
Highlight HAVING

13 years agodocs for pretty printer
Arthur Axel 'fREW' Schmidt [Tue, 26 Oct 2010 01:39:10 +0000]
docs for pretty printer

13 years agofixup tests
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 21:15:40 +0000]
fixup tests

13 years agofix precedence for executing in new
Arthur Axel 'fREW' Schmidt [Tue, 26 Oct 2010 01:21:28 +0000]
fix precedence for executing in new

13 years agotests for bulk insert
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 21:06:44 +0000]
tests for bulk insert

13 years agoDo not show_progress by default
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:59:47 +0000]
Do not show_progress by default

13 years agosquash_repeats > no_repeats
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:58:51 +0000]
squash_repeats > no_repeats

13 years agotest for no-repeats
Arthur Axel 'fREW' Schmidt [Sun, 24 Oct 2010 20:20:29 +0000]
test for no-repeats

13 years agoAdd "no_repeats" option to fix it such that repeated SQL may be ellided except for...
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