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?
MIME-Version: 1.0
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
Message-ID: <rt-4.0.18-32495-1437242273-634.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 361
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.
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-32495-1437242273-634.0-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <rt-4.0.18-32495-1437242273-634.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-1091-1437252782-1949.105934-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 163
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
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-32495-1437242273-634.0-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <rt-4.0.18-32495-1437242273-634.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-22783-1438365983-840.105934-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 201
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.