Skip Menu |
 

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

Report information
The Basics
Id: 66859
Status: stalled
Priority: 0/
Queue: SQL-Statement

People
Owner: Nobody in particular
Requestors: julian [...] totalknockout.co.uk
Cc:
AdminCc:

Bug Information
Severity: Wishlist
Broken in: 1.33
Fixed in: (no value)



Download (untitled) / with headers
text/plain 724b
SQL::Statement does not handle functions in joins. (As discussed with Jens in email dd 23/03/2011) Code ======== #!/usr/bin/perl use strict; use SQL::Statement; use SQL::Parser; my $parser = SQL::Parser->new(); my $stmt = SQL::Statement->new($ARGV[0],$parser); ==================== $ ./testsql.pl "select p.name, d.name, d.description from person p, department d where upper(p.dept) = upper(d.name)" No equijoin condition in WHERE or ON clause at /opt/ActivePerl-5.12/lib/SQL/Statement.pm line 86 $ ./testsql.pl "select p.name, d.name, d.description from person p JOIN department d ON upper(p.dept) = upper(d.name)" No equijoin condition in WHERE or ON clause at /opt/ActivePerl-5.12/lib/SQL/Statement.pm line 86


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.