Skip Menu |
 

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

Report information
The Basics
Id: 105934
Status: rejected
Priority: 0/
Queue: SQL-Statement

People
Owner: Nobody in particular
Requestors: NHORNE [...] cpan.org
Cc:
AdminCc:

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



Subject: Does LEFT JOIN work?
Download (untitled) / with headers
text/plain 361b
When I try this query: select mailto.email, vacant.email from mailto left join vacant on mailto.email = vacant.email WHERE vacant.email IS NULL I get this error: DBD::CSV::st execute failed: Use of uninitialized value $key_vals[0] in join or string at /home/njh/perl5/perlbrew/perls/perl-5.23.0/lib/site_perl/5.23.0/SQL/Statement.pm line 831, <GEN10> line 2.
Download (untitled) / with headers
text/plain 163b
As long as DBD::CSV uses SQL::Statement, the answer is no. Maybe in a later release of SQL::Statement or when an improved successor takes over. Best regards, Jens
Download (untitled) / with headers
text/plain 201b
Since this is a known limitation of SQL::Statement (https://metacpan.org/pod/SQL::Statement#BUGS-AND-LIMITATIONS), you can send patches or hire a developer. Adding a ticket won't solve change anything.


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.