ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases

[Edwin Groothuis]

>Number:         94668
>Category:       ports
>Synopsis:       databases/p5-DBD-SQLite doesn't like new SQLite databases
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Mar 19 01:50:12 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     Edwin Groothuis
>Release:        FreeBSD 6.0-RELEASE i386
>Organization:
-
>Environment:
System: FreeBSD k7.mavetju 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov 3 09:36:13 UTC 2005 root at x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386


>Description:

Databases created with sqlite3 can't be read with p5-DBD-SQLite anymore.

>How-To-Repeat:

[~/s] edwin at k7>sqlite3 foo.db
SQLite version 3.3.4
Enter ".help" for instructions
sqlite> create table foo ( bar int);
sqlite> .schema
CREATE TABLE foo ( bar int);
sqlite> [~/s] edwin at k7>ls -al
total 10
drwxr-xr-x   2 edwin  edwin   512 Mar 19 12:36 .
drwxr-xr-x  81 edwin  edwin  5632 Mar 19 12:36 ..
-rw-r--r--   1 edwin  edwin  2048 Mar 19 12:36 foo.db

[~/s] edwin at k7>perl -we 'use DBI;use strict; my $dbh=DBI-name=foo.db","","");my $sth=$dbh->prepare("SELECT * FROM foo");'
DBD::SQLite::db prepare failed: unsupported file format(1) at dbdimp.c line 269 at -e line 1.

>Fix:

I would normally say "upgrade to the latest version", but there is
no never version available from CPAN. Nor in rt.cpan.org. Nor
anywhere else.
>Release-Note:
>Audit-Trail:
>Unformatted: