OK, the DBD 1.11 install creates a SQLite.so Library.
There is ONE in the perl site install directory.
The is another one burried down in /home which perl SHOULD not find....
The strings command finds version 3.2.7 in BOTH files.
Where else could perl possibly be finding a SQLite library?????
m christensen wrote:
My Perl code reports version 3.2.2 from $dbh->{sqlite_version}
My sqlite header file in the sqlite DBD 1.11 install dir clearly
states 'IT' is 3.2.7.
The DBD 1.11 install built fine, tested perfectly and installed
without errors.
There must be an older one that came with the OS install or something
which perl is finding first.
Thanks.
Dennis Cote wrote:
m christensen wrote:
I have a linux machine that saw one-to-many power outages.
I got a backup of everything and reinstalled it.
I have some code that uses Perl DBI and connects to several Oracle
Databases and builds several local sqlite databases.
It pulls a lot of data from Oracle and builds several hundred Meg of
sqlite tables before this failure.
I have the following code which HAD worked for months.
select count(distinct(rec_key))
from test_rows
where list = 'A';
Now it suddenly fails with a Prepare failed near 'DISTINCT' :
syntax error(1) at dbdimp.c line 269 error.
The code runs just fine with the same database file using the sqlite
command line tool.
I tried upgrading DBI from 1.48 to 1.5.
I tried downgrading the sqlite DBD to 1.09 (Which is what I THINK I
was running before), nothing helps.
Ideas.
It sounds familiar but I can't find any references for the life of
me...
SQLite has only supported the count(distinct(expression)) since
version 3.2.6.
I suspect that you have restored to an earlier version. You can check
the library version by executing
select sqlite_version();
HTH
Dennis Cote