Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: du4mi [...] gmx.de
Cc:
AdminCc:

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



Subject: Vacuum failed.DBD::SQLite::db do failed: SQL logic error or missing database at E:\sql.pl
Download (untitled) / with headers
text/plain 1.1k
DBD-SQLite 2.8.6 ActiveState v5.8.0 built for MSWin32-x86-multi-thread tested on Windows2000 SP3 German and WindowsXP SP1 German I can't vacuum database from script. I get following error: DBD::SQLite::db do failed: SQL logic error or missing database at H:\test.pl line 5. test.pl: ------------------------------ #!/usr/bin/perl -w use strict; use DBI; my $dbh = 'DBI'->connect('dbi:SQLite:dbname=sql'); $dbh->do("vacuum"); $dbh->disconnect; -------------------------------- other methods (select etc) is ok, only vacuum fails. With command line sqlite.exe I can vacuum without problem. my sql-file: ------------------------------------------------ E:\sqlite\2>sqlite.exe sql SQLite version 2.8.6 Enter ".help" for instructions Show quoted text
sqlite> create table tab1 (a,b,c,d); sqlite> insert into tab1 values ('q','e','e','e'); sqlite> select * from tab1;
q|e|e|e ---------------------------------------------- other methods (select etc) is ok, only vacuum fails. With command line sqlite.exe I can vacuum without problem. ------------------------------------------------- Show quoted text
sqlite> delete from tab1 where a like '%'; sqlite> select * from tab1; sqlite> vacuum; sqlite>


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.