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)

History Show all quoted text
  Mon May 31 00:28:52 2010 lyle.chen [...] sap.com - Ticket created
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>
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
  Mon May 31 01:36:21 2010 ishigaki [...] cpan.org - Correspondence added
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
  Mon May 31 01:36:22 2010 The RT System itself - Status changed from 'new' to 'open'
  Mon May 31 01:36:22 2010 ishigaki [...] cpan.org - Status changed from 'open' to 'resolved'