Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: lyle.chen [...] sap.com
Cc:
AdminCc:

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



Subject: Unable to read any SQLite database if RTree tables are created in it
Date: Mon, 31 May 2010 06:28:29 +0200
To: "bug-DBD-SQLite [...] rt.cpan.org" <bug-DBD-SQLite [...] rt.cpan.org>
From: "Chen, Lyle" <lyle.chen [...] sap.com>
Download (untitled) / with headers
text/plain 533b
DBD-SQLite-1.29 Perl v5.10.1 CYGWIN_NT-5.1 Unable to read any SQLite database if RTree tables are created in it. The error output is, DBD::SQLite::db do failed: SQL logic error or missing database no such module: rtree at -e line 38. Is it possible to support a complete version of SQLite? For example, add -DSQLITE_ENABLE_RTREE=1 to the default make file? I find SQLite added a lot of new features after they released version 3. I really hope DBD-SQLite could support them well in the default build. Thanks, Lyle
Hi. If you want to use the RTree feature, you need to add extra CCFLAGS when you run Makefile.PL like this: $ perl Makefile.PL CCFLAGS=-DSQLITE_ENABLE_RTREE=1 Then, run "make", "make test" and "make install" as usual. DBD::SQLite should work fine with RTree. It's only disabled as the SQLite team disables it by default. If you still find some glitches related on rtree, please reopen this ticket. Thanks. Kenichi On 2010-5-31 Mon 00:28:52, lyle.chen@sap.com wrote: Show quoted text
> DBD-SQLite-1.29 > Perl v5.10.1 > CYGWIN_NT-5.1 > > Unable to read any > SQLite database if RTree tables are created in it. The error output > is, > > DBD::SQLite::db do failed: SQL logic error or missing > database > no such module: rtree at -e line 38. > > Is it possible to > support a complete version of SQLite? For example, add > -DSQLITE_ENABLE_RTREE=1 to the default make file? I find SQLite > added a lot of new features after they released version 3. I really > hope DBD-SQLite could support them well in the default build. > Thanks, > Lyle


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.