[DBD-SQLite] substr w/ two parameters

[Jesse Erdmann]

All,

Is there a quick fix to allow substr to be called with two parameters
instead of three?  Sometime in 3.5 the official SQLite distribution
made the third parameter optional and it looks like there is code
within the sqlite3.c that makes queries using that form of the
function.  However, when I execute a SQL statement in my Perl code
using either DBD::SQLite 1.31 or 1.32.1 I get an error saying prepare
failed and that substr was being called with the wrong number of
arguments.

Using the same query in the sqlite3 command line utility executes
appropriately.  Thanks!

-- 
Jesse Erdmann
Bioinformatics Analyst
Masonic Cancer Center
University of Minnesota
jerdmann at umn.edu
612-626-3123

jesse at jesseerdmann.com
Twitter: http://twitter.com/jesseerdmann