11 years agorequire explicit nulls first/last
Matt S Trout [Mon, 4 Nov 2013 01:30:07 +0000]
require explicit nulls first/last

11 years agouse INNER for old mysqls
Matt S Trout [Mon, 4 Nov 2013 00:42:59 +0000]
use INNER for old mysqls

11 years agomake map_descending available as map_dq_tree via ExprHelpers
Matt S Trout [Sun, 3 Nov 2013 23:33:35 +0000]
make map_descending available as map_dq_tree via ExprHelpers

11 years agoadd double subquery handling to MySQL code
Matt S Trout [Fri, 1 Nov 2013 06:59:31 +0000]
add double subquery handling to MySQL code

11 years agorewrite GenericSubquery to handle multiple order columns
Matt S Trout [Fri, 1 Nov 2013 01:45:55 +0000]
rewrite GenericSubquery to handle multiple order columns

11 years agorespect order_is_stable even with no ORDER BY (assume single row return)
Matt S Trout [Sat, 12 Oct 2013 18:53:57 +0000]
respect order_is_stable even with no ORDER BY (assume single row return)

11 years agoswitch where wrapping order to look better (and make DBIC oraclejoin.t happy)
Matt S Trout [Sat, 12 Oct 2013 15:59:02 +0000]
switch where wrapping order to look better (and make DBIC oraclejoin.t happy)

11 years agoonly default in $_ if @_ is empty, not if $_[0] exists but is undef
Matt S Trout [Wed, 9 Oct 2013 18:18:17 +0000]
only default in $_ if @_ is empty, not if $_[0] exists but is undef

11 years agoadd scan_dq_nodes helper
Matt S Trout [Mon, 7 Oct 2013 13:42:55 +0000]
add scan_dq_nodes helper

11 years agodefault the default_inside_alias in case of a full SELECT list of ASed things
Matt S Trout [Mon, 7 Oct 2013 03:03:12 +0000]
default the default_inside_alias in case of a full SELECT list of ASed things

11 years agodon't gensym for unqualified versions of already selected columns
Matt S Trout [Mon, 7 Oct 2013 00:58:36 +0000]
don't gensym for unqualified versions of already selected columns

11 years agoCleanup after Moo
Peter Rabbitson [Mon, 17 Jun 2013 08:30:47 +0000]
Cleanup after Moo

11 years agoRender empty insert value lists as DEFAULT VALUES
Dagfinn Ilmari Mannsåker [Sat, 23 Mar 2013 10:18:46 +0000]
Render empty insert value lists as DEFAULT VALUES

Except for MySQL, which is Special™, as usual.

11 years agoPreserve NULLS ordering in SubqueryRemap
Dagfinn Ilmari Mannsåker [Fri, 22 Mar 2013 23:12:43 +0000]
Preserve NULLS ordering in SubqueryRemap

11 years agoLimitXY Slice dialect
Matt S Trout [Thu, 21 Mar 2013 03:20:49 +0000]
LimitXY Slice dialect

11 years agoadd slice_subquery method for DBIC introspection
Matt S Trout [Thu, 21 Mar 2013 03:01:02 +0000]
add slice_subquery method for DBIC introspection

11 years agoallow optional hashref as final arg to helpers
Matt Phillips [Mon, 18 Mar 2013 13:31:28 +0000]
allow optional hashref as final arg to helpers

11 years agodon't negate undef in Slice/FetchFirst
Matt S Trout [Mon, 18 Mar 2013 00:37:29 +0000]
don't negate undef in Slice/FetchFirst

11 years agoRETURNING ... INTO support
Matt S Trout [Sun, 17 Mar 2013 22:31:06 +0000]
RETURNING ... INTO support

11 years agoPRIOR rendering for CONNECT BY
Matt S Trout [Sun, 17 Mar 2013 21:47:21 +0000]
PRIOR rendering for CONNECT BY

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

11 years agonested where nodes
Matt S Trout [Wed, 5 Dec 2012 13:33:04 +0000]
nested where nodes

11 years agofixed incorrect is_Literal usage
Matt Phillips [Tue, 27 Nov 2012 20:45:32 +0000]
fixed incorrect is_Literal usage

12 years agoadd slice stability requirement code
Matt S Trout [Mon, 15 Oct 2012 21:20:02 +0000]
add slice stability requirement code

12 years agoseparate to_sql mechanism
Matt S Trout [Thu, 11 Oct 2012 15:27:46 +0000]
separate to_sql mechanism

12 years agodemonstrate limit dialects
Matt S Trout [Thu, 11 Oct 2012 12:45:05 +0000]
demonstrate limit dialects

12 years agolimit/offset
Matt S Trout [Thu, 11 Oct 2012 12:34:10 +0000]
limit/offset

12 years agoorder by somewhat working
Matt S Trout [Thu, 11 Oct 2012 12:24:16 +0000]
order by somewhat working

12 years agoselect+join+where
Matt S Trout [Thu, 11 Oct 2012 12:07:51 +0000]
select+join+where

12 years agobeginnings of declarative code
Matt S Trout [Thu, 11 Oct 2012 12:01:12 +0000]
beginnings of declarative code

12 years agoSELECT a, b FROM foo
Prog Rammer [Fri, 7 Sep 2012 17:56:23 +0000]
SELECT a, b FROM foo

12 years agocosmetic
Prog Rammer [Mon, 27 Aug 2012 20:16:29 +0000]
cosmetic

12 years agotest for between
Prog Rammer [Mon, 27 Aug 2012 20:14:53 +0000]
test for between

12 years agotest for count(*)
Prog Rammer [Mon, 27 Aug 2012 18:29:25 +0000]
test for count(*)

12 years agoleft outer join
Prog Rammer [Mon, 27 Aug 2012 16:25:52 +0000]
left outer join

12 years agosimple group by test
Prog Rammer [Mon, 27 Aug 2012 16:18:37 +0000]
simple group by test

12 years agoanother way to join
Prog Rammer [Mon, 27 Aug 2012 16:08:47 +0000]
another way to join

from ilmari++ in irc

12 years agofixups for HAVING clauses
Matt S Trout [Sat, 25 Aug 2012 18:47:08 +0000]
fixups for HAVING clauses

12 years agowhitespace
Prog Rammer [Fri, 24 Aug 2012 20:09:18 +0000]
whitespace

12 years agolike sql.t but using ExprHelpers directly
Prog Rammer [Fri, 24 Aug 2012 20:00:38 +0000]
like sql.t but using ExprHelpers directly

Only a few features that I've figured out so far.

12 years agodon't deparenthesise subqueries with a group by
Matt S Trout [Thu, 23 Aug 2012 18:27:39 +0000]
don't deparenthesise subqueries with a group by

12 years agorandomised crazy order by support for subquery remap
Matt S Trout [Thu, 23 Aug 2012 18:27:21 +0000]
randomised crazy order by support for subquery remap

12 years agonuke old attempt at generic subquery
Matt S Trout [Thu, 23 Aug 2012 18:26:58 +0000]
nuke old attempt at generic subquery

12 years agoslightly better error messages
Matt S Trout [Thu, 23 Aug 2012 12:33:37 +0000]
slightly better error messages

12 years agofix desc detection for genericsubq
Matt S Trout [Sat, 18 Aug 2012 12:25:57 +0000]
fix desc detection for genericsubq

12 years agofirst cut at GenericSubquery
Matt S Trout [Fri, 17 Aug 2012 14:32:23 +0000]
first cut at GenericSubquery

12 years agoworking RowNum.pm
Matt S Trout [Fri, 17 Aug 2012 12:40:01 +0000]
working RowNum.pm

12 years agobeginnings of RowNum.pm
Matt S Trout [Thu, 16 Aug 2012 17:53:39 +0000]
beginnings of RowNum.pm

12 years agominor helper tweaks
Matt S Trout [Thu, 16 Aug 2012 17:34:23 +0000]
minor helper tweaks

12 years agoworking RowNumberOver
Matt S Trout [Thu, 16 Aug 2012 16:33:08 +0000]
working RowNumberOver

12 years agoRemove array expansion in Literal()
Matt Phillips [Fri, 17 Aug 2012 16:47:01 +0000]
Remove array expansion in Literal()

Was breaking SQL::Abstract testsuite.

12 years agofunctionalise order mapping
Matt S Trout [Sun, 29 Jul 2012 17:19:00 +0000]
functionalise order mapping

12 years agomore functional select list generation
Matt S Trout [Sun, 29 Jul 2012 15:20:05 +0000]
more functional select list generation

12 years agoslight syntactical cleanup
Matt S Trout [Sat, 28 Jul 2012 19:48:06 +0000]
slight syntactical cleanup

12 years agoadd compose routine and refactor FetchFirst to functional style
Matt S Trout [Sat, 28 Jul 2012 18:56:32 +0000]
add compose routine and refactor FetchFirst to functional style

12 years agoclean up FetchFirst more
Matt S Trout [Sat, 28 Jul 2012 18:06:58 +0000]
clean up FetchFirst more

12 years agoimport cleanups
Matt S Trout [Sat, 28 Jul 2012 17:57:48 +0000]
import cleanups

12 years agoremove debugging code
Matt S Trout [Sat, 28 Jul 2012 17:57:12 +0000]
remove debugging code

12 years agofirst expansion to using helper subs
Matt S Trout [Sat, 28 Jul 2012 17:48:52 +0000]
first expansion to using helper subs

12 years agofixup! first cut of rno sketch
Arthur Axel 'fREW' Schmidt [Sat, 28 Jul 2012 17:37:01 +0000]
fixup! first cut of rno sketch

12 years agofirst cut of rno sketch
Matt S Trout [Sat, 28 Jul 2012 16:52:56 +0000]
first cut of rno sketch

12 years agofix expr.include to generate alias nodes correctly
Matt S Trout [Sat, 28 Jul 2012 11:38:59 +0000]
fix expr.include to generate alias nodes correctly

12 years agofirst whack at GenericSubQ, half works
Matt S Trout [Sun, 27 May 2012 18:54:32 +0000]
first whack at GenericSubQ, half works

12 years agoMOAR order
Matt S Trout [Mon, 7 May 2012 06:16:12 +0000]
MOAR order

12 years agoFIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:58:32 +0000]
FIRST ? SKIP ?

12 years agoimplement FIRST ? SKIP ?
Matt S Trout [Sun, 6 May 2012 23:25:01 +0000]
implement FIRST ? SKIP ?

12 years agofixup gensym behaviour
Matt S Trout [Fri, 20 Apr 2012 10:52:46 +0000]
fixup gensym behaviour

12 years agoORDER BY never generates ASC
Matt S Trout [Fri, 20 Apr 2012 10:52:37 +0000]
ORDER BY never generates ASC

12 years agoSlice implementations as roles
Matt S Trout [Fri, 20 Apr 2012 10:03:30 +0000]
Slice implementations as roles

12 years agoallow a group by node without a list
Matt S Trout [Fri, 20 Apr 2012 03:52:42 +0000]
allow a group by node without a list

12 years agohandle nested rather than unrolled joins
Matt S Trout [Mon, 16 Apr 2012 14:03:00 +0000]
handle nested rather than unrolled joins

12 years agoallow '' literals though wtf
Matt S Trout [Mon, 16 Apr 2012 13:46:25 +0000]
allow '' literals though wtf

12 years agorename alias node content
Matt S Trout [Mon, 16 Apr 2012 12:34:10 +0000]
rename alias node content

12 years agoslice type
Matt S Trout [Mon, 16 Apr 2012 07:11:08 +0000]
slice type

12 years agoON and LEFT/RIGHT
Matt S Trout [Sat, 14 Apr 2012 19:17:23 +0000]
ON and LEFT/RIGHT

12 years agoinitial group by support
Matt S Trout [Sat, 14 Apr 2012 17:10:39 +0000]
initial group by support

12 years agoalways_quote might be set with no quote chars
Matt S Trout [Sat, 14 Apr 2012 04:35:13 +0000]
always_quote might be set with no quote chars

12 years agolast direct hash access (I think)
Matt S Trout [Sat, 14 Apr 2012 02:54:44 +0000]
last direct hash access (I think)

12 years agoadd more attributes
Matt S Trout [Sat, 14 Apr 2012 02:54:16 +0000]
add more attributes

12 years agoinitial Mooification
Matt S Trout [Sat, 14 Apr 2012 02:48:51 +0000]
initial Mooification

12 years agofix test to pass, come back to it later
Matt S Trout [Sat, 14 Apr 2012 02:48:42 +0000]
fix test to pass, come back to it later

13 years agostart sketching out a Perl renderer
Matt S Trout [Sat, 13 Aug 2011 14:31:54 +0000]
start sketching out a Perl renderer

13 years agoclean up code to use intersperse
Matt S Trout [Sun, 31 Jul 2011 20:39:00 +0000]
clean up code to use intersperse

13 years agoINSERT support
Matt S Trout [Sun, 31 Jul 2011 19:39:06 +0000]
INSERT support

13 years agorefactor DELETE and add UPDATE
Matt S Trout [Sun, 31 Jul 2011 15:03:46 +0000]
refactor DELETE and add UPDATE

13 years agoDELETE support
Matt S Trout [Sun, 31 Jul 2011 10:01:32 +0000]
DELETE support

13 years agoadd constant for DQ_WHERE
Matt S Trout [Sun, 31 Jul 2011 09:11:55 +0000]
add constant for DQ_WHERE

13 years agoparens around BETWEEN
Matt S Trout [Sun, 31 Jul 2011 05:44:52 +0000]
parens around BETWEEN

13 years agogrudginly implement lc_keywords
Matt S Trout [Sun, 31 Jul 2011 05:38:30 +0000]
grudginly implement lc_keywords

13 years agoadd multipart literal support
Matt S Trout [Sun, 31 Jul 2011 01:20:46 +0000]
add multipart literal support

13 years agoallow a single literal arg to BETWEEN
Matt S Trout [Sun, 31 Jul 2011 00:59:37 +0000]
allow a single literal arg to BETWEEN

13 years agodisable quoting of function names in apply op
Matt S Trout [Sat, 30 Jul 2011 23:39:10 +0000]
disable quoting of function names in apply op

13 years agodefault to unop/binop based on args
Matt S Trout [Fri, 29 Jul 2011 19:59:02 +0000]
default to unop/binop based on args

13 years agoapply type op and NULL handling
Matt S Trout [Mon, 25 Jul 2011 15:04:45 +0000]
apply type op and NULL handling

13 years agoadd null, in, between etc. support
Matt S Trout [Mon, 25 Jul 2011 06:41:06 +0000]
add null, in, between etc. support

13 years agometadata for values, order by, values for literals
Matt S Trout [Sun, 17 Jul 2011 06:53:00 +0000]
metadata for values, order by, values for literals

13 years agosanify alias/SELECT list rendering
Matt S Trout [Sun, 17 Jul 2011 02:08:43 +0000]
sanify alias/SELECT list rendering

13 years agobeginnings of FROM, support for AS
Matt S Trout [Sun, 17 Jul 2011 00:41:01 +0000]
beginnings of FROM, support for AS

14 years agotest AS export
Matt S Trout [Sat, 16 Oct 2010 02:05:27 +0000]
test AS export

14 years agoclean up sql.t somewhat
Matt S Trout [Sat, 16 Oct 2010 01:54:30 +0000]
clean up sql.t somewhat