Subject: | SQLite3 - Unexpected Error |
perl t.pl produces:
lloy0076@david:~/work/programming/pos$ perl t.pl
Use of uninitialized value in pattern match (m//) at /usr/local/share/perl/5.8.7/Class/DBI/SQLite.pm line 34.
Use of uninitialized value in pattern match (m//) at /usr/local/share/perl/5.8.7/Class/DBI/SQLite.pm line 44.
Use of uninitialized value in pattern match (m//) at /usr/local/share/perl/5.8.7/Class/DBI/SQLite.pm line 34.
Use of uninitialized value in pattern match (m//) at /usr/local/share/perl/5.8.7/Class/DBI/SQLite.pm line 44.
Use of uninitialized value in pattern match (m//) at /usr/local/share/perl/5.8.7/Class/DBI/SQLite.pm line 34.
Use of uninitialized value in pattern match (m//) at /usr/local/share/perl/5.8.7/Class/DBI/SQLite.pm line 44.
0.12
DBD::SQLite::db prepare_cached failed: near "FROM": syntax error(1) at dbdimp.c line 269 [for Statement "SELECT
FROM "testing"
"] at /usr/share/perl5/Ima/DBI.pm line 381.
---
perl m.pl:
lloy0076@david:~/work/programming/pos$ perl m.pl
$VAR1 = [
[
'1'
],
[
'2'
],
[
'3'
]
];
lloy0076@david:~/work/programming/pos$ sqlite3 foobar.sdb
SQLite version 3.2.8
Enter ".help" for instructions
Show quoted text
sqlite> select * from testing;
1
2
3
Show quoted textsqlite>
*hmmm*
Show quoted textsqlite> lloy0076@david:~/work/programming/pos$ perl -V
Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
Platform:
osname=linux, osvers=2.6.14.3, archname=i486-linux-gnu-thread-multi
uname='linux ninsei 2.6.14.3 #1 smp preempt mon nov 28 19:51:50 pst 2005 i686 gnulinux '
config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr -Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.7 -Dsitearch=/usr/local/lib/perl/5.8.7 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm -Duseshrplib -Dlibperl=libperl.so.5.8.7 -Dd_dosuid -des'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include'
ccversion='', gccversion='4.0.3 20051201 (prerelease) (Debian 4.0.2-5)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.3.5.so, so=so, useshrplib=true, libperl=libperl.so.5.8.7
gnulibc_version='2.3.5'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT
Locally applied patches:
SPRINTF0 - fixes for sprintf formatting issues - CVE-2005-3962
Built under linux
Compiled at Dec 15 2005 17:19:17
@INC:
/etc/perl
/usr/local/lib/perl/5.8.7
/usr/local/share/perl/5.8.7
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
DBD::SQLite is at version 1.11.
I am running Debian Sid (upgraded to latest mirrors as of report date [http://ftp.au.debian.org/]
Message body not shown because it is not plain text.