[Dbix-class] Re: quote_char, order_by and DESC

[Matt S Trout]

On Fri, Oct 19, 2007 at 03:35:08PM +0200, Adam Sjøgren wrote:
> On Thu, 18 Oct 2007 18:55:43 +0100, Matt wrote:
> 
> > On Thu, Oct 18, 2007 at 04:39:54PM +0200, Adam Sjøgren wrote:
> 
> >> $schema->storage->sql_maker->quote_char('"');
> >> $schema->storage->sql_maker->name_sep('.');
> 
> >> This works fine until a search needs to be ordered descending; passing
> >> order_by=>'name DESC' results in:
> 
> > \'name DESC'
> 
> Ah, thanks. (I guess you meant \'"name" DESC').
> 
> There was some discussion about it last year, and a patch:
> 
>  <http://thread.gmane.org/gmane.comp.lang.perl.modules.dbix-class/1001>
> 
> I guess that faded away?

The issue is it should really be fixed in SQL::Abstract. Which needs a refactor
first.

If you want to see it happen, help with the refac :)

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/