LEFT JOIN [track] [tracks]
ON [tracks].[cd] = [cds].[cdid]
)
- WHERE ( [artistid] = ? )
+ WHERE [artistid] = ?
)',
[
[{ sqlt_datatype => 'integer', dbic_colname => 'artistid' }
INNER JOIN [artist] [artist]
ON [artist].[artistid] = [cd].[artist]
)
- WHERE ( [trackid] = ? )
+ WHERE [trackid] = ?
)',
[
[{ sqlt_datatype => 'integer', dbic_colname => 'trackid' }
my $sa = $schema->storage->sql_maker;
# the legacy tests assume no quoting - leave things as-is
-local $sa->{quote_char};
+$sa->quote_char(undef);
# my ($self, $table, $fields, $where, $order, @rest) = @_;
my ($sql, @bind) = $sa->select(