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

Owner: Nobody in particular
Requestors: NHORNE [...]

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, from mailto left join vacant on = WHERE 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/ 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 (, 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 infrastructure.

Please report any issues with to