From 09c7f9d765e2a58c3e74eee0ed03612d19ee7f9f Mon Sep 17 00:00:00 2001 From: Matthew Somerville Date: Wed, 26 Jun 2019 11:25:36 +0100 Subject: Turn on quote_names. --- perllib/FixMyStreet/DB/ResultSet/Problem.pm | 9 ++------- 1 file changed, 2 insertions(+), 7 deletions(-) (limited to 'perllib/FixMyStreet/DB/ResultSet/Problem.pm') diff --git a/perllib/FixMyStreet/DB/ResultSet/Problem.pm b/perllib/FixMyStreet/DB/ResultSet/Problem.pm index 4f7c1dc5f..72a9852fc 100644 --- a/perllib/FixMyStreet/DB/ResultSet/Problem.pm +++ b/perllib/FixMyStreet/DB/ResultSet/Problem.pm @@ -141,7 +141,7 @@ sub _recent { $query->{photo} = { '!=', undef } if $photos; my $attrs = { - order_by => { -desc => 'coalesce(confirmed, created)' }, + order_by => { -desc => \'coalesce(confirmed, created)' }, rows => $num, }; @@ -207,11 +207,6 @@ sub around_map { sub timeline { my ( $rs ) = @_; - my $prefetch = - $rs->result_source->storage->sql_maker->quote_char ? - [ qw/user/ ] : - []; - return $rs->search( { -or => { @@ -221,7 +216,7 @@ sub timeline { } }, { - prefetch => $prefetch, + prefetch => 'user', } ); } -- cgit v1.2.3