1 package Data::Query::Renderer::SQL::MySQL;
3 use Data::Query::Constants;
4 use Data::Query::ExprHelpers;
7 extends 'Data::Query::Renderer::SQL::Naive';
9 with 'Data::Query::Renderer::SQL::Slice::LimitXY';
11 has needs_inner_join => (is => 'ro', default => sub { 0 });
13 around _format_join_keyword => sub {
14 my ($orig, $self) = (shift, shift);
16 if ($dq->{'Data::Query::Renderer::SQL::MySQL.straight_join'}) {
17 return $self->_format_keyword('STRAIGHT_JOIN');
18 } elsif ($self->needs_inner_join and $dq->{on} and !$dq->{outer}) {
19 return $self->_format_keyword('INNER JOIN');
21 return $self->$orig(@_);
24 sub _insert_default_values {
26 $self->_format_keyword('VALUES'), qw( ( ) );
29 foreach my $type (qw(update delete)) {
30 around "_render_${type}" => sub {
31 my ($orig, $self) = (shift, shift);
32 $self->$orig($self->_maybe_double_subquery(@_));
36 sub _maybe_double_subquery {
38 my $target = $dq->{target};
40 foreach my $key (qw(set where)) {
41 next unless $dq->{$key};
42 $new->{$key} = map_dq_tree {
46 if (is_Identifier($target)) {
47 my $ident = $target->{elements}[0];
48 +{ DQ_IDENTIFIER ,=> sub {
49 my @el = @{$_[0]->{elements}};
50 $found = 1 if @el == 1 and $el[0] eq $ident;
53 } elsif (is_Literal($target)) {
54 my $ident = $target->{literal} or die "Can't handle complex literal";
55 +{ DQ_LITERAL ,=> sub {
56 my $lit = $_[0]->{literal};
57 $found = 1 if $lit and $lit eq $ident;
61 die "Can't handle target type ".$target->{type};
65 \Select([ Identifier('*') ], Alias('_forced_double_subquery', $_));