Bug #112908 for DBD-SQLite: Query returns different results under mod

Thu Mar 10 07:34:14 2016 JIRA [...] cpan.org - Ticket created

Subject:

Query returns different results under mod_perl

I ran into an issue with mod_perl and DBD::SQLite.
I used the following query to check whether table exists
"SELECT name FROM sqlite_master WHERE type='table' AND name='data'"

Under mod_perl it will return nothing even though the table does exist. Without mod_perl it returns correct result

Thu Mar 10 07:58:49 2016 ishigaki [...] cpan.org - Correspondence added

On Thu Mar 10 21:34:14 2016, JIRA wrote: Show quoted text

> I ran into an issue with mod_perl and DBD::SQLite. > I used the following query to check whether table exists > "SELECT name FROM sqlite_master WHERE type='table' AND name='data'" > > Under mod_perl it will return nothing even though the table does > exist. Without > mod_perl it returns correct result

Not sure what's actually going on from what you've written here, but could you check the following first? 1) if you connect to the database you expect (by specifying a full path to the database file) 2) if DBI/DBD::SQLite are loaded correctly, and have the expected version

Thu Mar 10 07:58:49 2016 The RT System itself - Status changed from 'new' to 'open'

Thu Mar 10 14:05:01 2016 JIRA [...] cpan.org - Correspondence added

Dne 2016-03-10 07:58:49, ISHIGAKI napsal(a):
Show quoted text

> On Thu Mar 10 21:34:14 2016, JIRA wrote:

> > I ran into an issue with mod_perl and DBD::SQLite.
> > I used the following query to check whether table exists
> > "SELECT name FROM sqlite_master WHERE type='table' AND name='data'"
> >
> > Under mod_perl it will return nothing even though the table does
> > exist. Without
> > mod_perl it returns correct result

>
>
> Not sure what's actually going on from what you've written here, but
> could you check the following first?
>
> 1) if you connect to the database you expect (by specifying a full
> path to the database file)
>
> 2) if DBI/DBD::SQLite are loaded correctly, and have the expected
> version

Never mind. Figured it out. I had my sql queries stored in __DATA__ section and was reading them using Data::Section::Simple.
That doesn't work under mod_perl.

Thu Mar 10 17:50:59 2016 ishigaki [...] cpan.org - Correspondence added

On Fri Mar 11 04:05:01 2016, JIRA wrote: Show quoted text

> Dne 2016-03-10 07:58:49, ISHIGAKI napsal(a):

> > On Thu Mar 10 21:34:14 2016, JIRA wrote:

> > > I ran into an issue with mod_perl and DBD::SQLite. > > > I used the following query to check whether table exists > > > "SELECT name FROM sqlite_master WHERE type='table' AND name='data'" > > > > > > Under mod_perl it will return nothing even though the table does > > > exist. Without > > > mod_perl it returns correct result

> > > > > > Not sure what's actually going on from what you've written here, but > > could you check the following first? > > > > 1) if you connect to the database you expect (by specifying a full > > path to the database file) > > > > 2) if DBI/DBD::SQLite are loaded correctly, and have the expected > > version

> > Never mind. Figured it out. I had my sql queries stored in __DATA__ > section and > was reading them using Data::Section::Simple. > That doesn't work under mod_perl.

OK. Closed.

Thu Mar 10 17:51:00 2016 ishigaki [...] cpan.org - Status changed from 'open' to 'resolved'

Bug #112908 for DBD-SQLite: Query returns different results under mod_perl