Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 1841
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: dds [...] aueb.gr
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.21
Fixed in: (no value)



Subject: Table self-join does not work correctly
Environment: DBD::SQLite 0.21 (FreeBSD port) Perl, version 5.005_03 built for i386-freebsd FreeBSD spiti 4.6.2-RELEASE-p2 The sequence: CREATE TABLE SysViews( Id integer, Name varchar, EditView integer, PRIMARY KEY( Id)) INSERT INTO SysViews VALUES (1, 'foo', NULL) SELECT SysViews.Name FROM SysViews LEFT JOIN SysViews AS E ON E.Id = SysViews.EditView WHERE SysViews.Id = 1 incorrectly returns undef The same select in sqlite-2.7.3 correctly returns foo I believe upgrading DBD:SQLite to use the sqlite-2.7.3 code base might fix the problem since a quick diff showed a lot of changes in the JOIN code. An option for linking against the sqlite library might also be a good idea. Thanks, Diomidis
Date: Sun, 1 Dec 2002 20:39:29 +0000
Subject: Re: [cpan #1841] Table self-join does not work correctly
From: Matt Sergeant <matt [...] sergeant.org>
To: bug-DBD-SQLite [...] rt.cpan.org
RT-Send-Cc:
run: perl getsqlite.pl 2.7.3 before you compile DBD::SQLite, and it'll get the latest SQLite. On Sunday, Dec 1, 2002, at 15:10 Europe/London, Guest via RT wrote: Show quoted text
> > This message about DBD-SQLite was sent to you by guest via rt.cpan.org > > Full context and any attached attachments can be found at: > <URL: https://rt.cpan.org/Ticket/Display.html?id=1841 > > > Environment: > DBD::SQLite 0.21 (FreeBSD port) > Perl, version 5.005_03 built for i386-freebsd > FreeBSD spiti 4.6.2-RELEASE-p2 > > The sequence: > > CREATE TABLE SysViews( Id integer, Name varchar, EditView integer, > PRIMARY KEY( Id)) > > INSERT INTO SysViews VALUES (1, 'foo', NULL) > > SELECT SysViews.Name > FROM SysViews > LEFT JOIN SysViews AS E > ON E.Id = SysViews.EditView > WHERE SysViews.Id = 1 > > incorrectly returns undef > > The same select in sqlite-2.7.3 correctly returns foo > > I believe upgrading DBD:SQLite to use the sqlite-2.7.3 code base might > fix the problem since a > quick diff showed a lot of changes in the JOIN code. An option for > linking against the > sqlite library might also be a good idea. > > Thanks, Diomidis >
Marking resolved.