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)

History Show all quoted text
  Sat Jul 18 13:57:53 2015 NHORNE [...] cpan.org - Ticket created
Subject: Does LEFT JOIN work?
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.
  Sat Jul 18 16:53:02 2015 REHSACK [...] cpan.org - Correspondence added
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
  Sat Jul 18 16:53:03 2015 The RT System itself - Status changed from 'new' to 'open'
  Fri Jul 31 13:59:56 2015 HMBRAND [...] cpan.org - Severity Normal changed to Wishlist
  Fri Jul 31 13:59:57 2015 HMBRAND [...] cpan.org - Broken in 0.48 deleted
  Fri Jul 31 13:59:57 2015 HMBRAND [...] cpan.org - Queue changed from DBD-CSV to SQL-Statement
  Fri Jul 31 14:06:23 2015 REHSACK [...] cpan.org - Correspondence added
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.
  Fri Jul 31 14:06:29 2015 REHSACK [...] cpan.org - Status changed from 'open' to 'rejected'