Skip Menu |

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

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

People
Owner: Nobody in particular
Requestors: bart.lateur [...] pandora.be
Cc:
AdminCc:

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



Subject: Crash when using path for database
Using the latest binary distribution for Win32, 0.17. If I try dbish dbi:SQLite:foo.db to launch the interactive shell (as per the docs), things work as expected. However, the database file foo.db is created in the current directory. As soon as I try to provide a path for the database, as in dbish dbi:SQLite:/foo.db dbish dbi:SQLite:e:/foo.db dbish dbi:SQLite:\foo.db dbish dbi:SQLite:e:\foo.db I get a dialog box from Windows, saying "This application has performed an illegal operation and will be terminated". The program is Perl. It works normally when trying SQLite's own command line tool, SQLite.exe (version unknown, latest), like this: sqlite /foo.db sqlite e:/foo.db sqlite \foo.db sqlite e:\foo.db A possible alternative, dbish "dbi:SQLite:dbname=e:\foo.db" has the same effect: a crash. Trying to use it in a normal script, also makes Perl crash in the same way: use DBI; $dbh = DBI->connect('dbi:SQLite:e:/foo.db', '', '', { RaiseError => 1 }); print "All is well\n"; $dbh->disconnect;
Marking stalled. I don't have a Win32 box to develop on, so this requires a patch from someone.
[MSERGEANT - Thu Dec 26 11:19:24 2002]: Show quoted text
> Marking stalled. I don't have a Win32 box to develop on, so this > requires a patch from someone.
With DBD::SQLite, v0.23, everything works under Win32, so this bug can most likely considered to be closed/vanished. D:\Downloads>perl -MDBD::SQLite -e "print $DBD::SQLite::VERSION" 0.23 D:\Downloads>type tmp.pl use DBI; $dbh = DBI->connect('dbi:SQLite:d:/foo.db', '', '', { RaiseError => 1 }); print "All is well\n"; $dbh->disconnect; D:\Downloads>perl -w tmp.pl All is well D:\Downloads>perl -V Summary of my perl5 (revision 5 version 6 subversion 1) configuration: Platform: osname=MSWin32, osvers=4.0, archname=MSWin32-x86-multi-thread uname='' config_args='undef' hint=recommended, useposix=true, d_sigaction=undef usethreads=undef use5005threads=undef useithreads=define usemultiplicity=def ine useperlio=undef d_sfio=undef uselargefiles=undef usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='cl', ccflags ='-nologo -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE - DNO_STRICT - DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS - DPERL_MSVCRT_READ FIX', optimize='-O1 -MD -DNDEBUG', cppflags='-DWIN32' ccversion='', gccversion='', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize =4 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='', ldflags ='-nologo -nodefaultlib -release - libpath:"f:\dev\dp\perl-5. 6_install\lib\CORE" -machine:x86' libpth="D:\Programme\Microsoft Visual Studio\VC98 \Lib" "D:\Programme\indigop erl-5.6\lib\CORE" libs= oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32 .lib advapi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib wsoc k32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib msvcrt.lib perllibs= oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib comd lg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib wsock32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib msvcrt.lib libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl56.lib Dynamic Linking: dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -release - libpath:"f: \dev\dp\perl-5.6_install\lib\CORE" -machine:x86' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY USE_ITHREADS PERL_IMPLICIT_CONTEXT PERL_IMP LICIT_SYS Locally applied patches: IndigoPerl Build 626 Built under MSWin32 Compiled at May 6 2001 21:37:25 @INC: D:/Programme/indigoperl-5.6/lib D:/Programme/indigoperl-5.6/site/lib . D:\Downloads>
Terrific. Marking resolved. Thanks for posting to RT for me!