Skip Menu |

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

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

People
Owner: Nobody in particular
Requestors: ribasushi [...] leporine.io
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 1.41_01
Fixed in: (no value)



Subject: New libsqlite segfaults on relatively benign SQL
Attached is a complete standalone test. Works on 1.40, segfaults on 1.41_01. Cheers
Subject: sqlite_crash.t
use strict; use warnings; use DBI; my $dbh = DBI->connect('DBI:SQLite::memory:', undef, undef, { RaiseError => 1, AutoCommit => 1 }); $dbh->do($_) for ( 'CREATE TABLE "twokeys" ( "artist" integer NOT NULL, "cd" integer NOT NULL, PRIMARY KEY ("artist", "cd") )', 'CREATE TABLE "fourkeys" ( "foo" integer NOT NULL, "bar" integer NOT NULL, "hello" integer NOT NULL, "goodbye" integer NOT NULL, "sensors" character(10) NOT NULL, "read_count" int, PRIMARY KEY ("foo", "bar", "hello", "goodbye") )', 'CREATE TABLE "fourkeys_to_twokeys" ( "f_foo" integer NOT NULL, "f_bar" integer NOT NULL, "f_hello" integer NOT NULL, "f_goodbye" integer NOT NULL, "t_artist" integer NOT NULL, "t_cd" integer NOT NULL, "autopilot" character NOT NULL, "pilot_sequence" integer, PRIMARY KEY ("f_foo", "f_bar", "f_hello", "f_goodbye", "t_artist", "t_cd") )', 'INSERT INTO fourkeys ( bar, foo, goodbye, hello, read_count, sensors) VALUES ( 1, 1, 1, 1, 1, 1 )', 'INSERT INTO twokeys ( artist, cd) VALUES ( 1, 1 )', 'INSERT INTO fourkeys_to_twokeys ( autopilot, f_bar, f_foo, f_goodbye, f_hello, pilot_sequence, t_artist, t_cd) VALUES ( 1, 1, 1, 1, 1, 1, 1, 1 )', 'DELETE FROM fourkeys_to_twokeys WHERE f_bar = 1 AND f_foo = 1 AND f_goodbye = 1 AND f_hello = 1 AND t_artist = 1 AND t_cd = 1' ); print "\nok 1 - All good\n1..1\n"
Thanks for the report. SQLite 3.8.0.1 with a fix to this issue, and DBD::SQLite 1.41_02 with the updated library were released. On Thu Aug 29 16:13:38 2013, RIBASUSHI wrote: Show quoted text
> Attached is a complete standalone test. Works on 1.40, segfaults on 1.41_01. > > Cheers
Subject: Re: [rt.cpan.org #88228] New libsqlite segfaults on relatively benign SQL
Date: Fri, 30 Aug 2013 09:13:49 +0000
To: Kenichi Ishigaki via RT <bug-DBD-SQLite [...] rt.cpan.org>
From: ribasushi [...] cpan.org
On Thu, Aug 29, 2013 at 02:54:24PM -0400, Kenichi Ishigaki via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=88228 > > > Thanks for the report. SQLite 3.8.0.1 with a fix to this issue, and DBD::SQLite 1.41_02 with the updated library were released.
Fix confirmed - the DBIC test suite (which triggered this originally) now does not crash with 1.41_02. Cheers