Skip Menu |
 

This queue is for tickets about the SQL-Abstract-Limit CPAN distribution.

Report information
The Basics
Id: 112033
Status: new
Priority: 0/
Queue: SQL-Abstract-Limit

People
Owner: Nobody in particular
Requestors: lukasz [...] hejnak.pl
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in:
  • 0.11
  • 0.12
  • 0.13
  • 0.14
  • 0.141
Fixed in: (no value)



Subject: Double quoting when calling select() with a limit, when quote_char is set
Download (untitled) / with headers
text/plain 598b
Example code: my $sa = SQL::Abstract::Limit->new( quote_char => q{`}, name_sep => q{.}, limit_dialect => q{LimitXY} ); my ($stmt, @bind) = $sa->select(q{table}, undef, {field=>1}, q{id}, 1); print $stmt; Output: SELECT * FROM ``table`` WHERE ( `field` = ? ) ORDER BY `id` LIMIT 1 Expected: SELECT * FROM `table` WHERE ( `field` = ? ) ORDER BY `id` LIMIT 1 Also note that the same code without the limit specified outputs: SELECT * FROM `table` WHERE ( field = ? ) ORDER BY id While SQL::Abstract for the same case returns: SELECT * FROM `table` WHERE ( `field` = ? ) ORDER BY `id`
From: lukasz [...] hejnak.pl
Download (untitled) / with headers
text/plain 200b
Also since I saw this package is up on github, I can try fixing it myself as soon as I have some spare time. So if you (the author) don't have time for this, you can just sit back and wait for a PR :)


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.