Nothing & Nothing. Just returns SQLITE_OK, doesn't enter into Callback.
To avoid any doubts, when I change query to "select sql from sqlite_master 
where (type='table' AND name='TABLE_NAME');"
I do enter into Callback and have a result.
Perhaps, PRAGMA is somehow broken or disabled in my sqlite. But once again, it 
doesn't work nor on precompiled official binaries, neither on my own very 
straight-forward (without any special -D flags) compilation of amalgamation.
We are using VFS however, may be that can be ill-implemented somehow so it 
makes PRAGMA not to work..
I don't know what to think anymore.
It looks like will have to parse the SQL Create statement, eventually..

> Date: Wed, 21 Sep 2016 13:47:41 +0700
> From: danielk1...@gmail.com
> To: sqlite-users@mailinglists.sqlite.org
> Subject: Re: [sqlite] A problem with 'pragma table_info(...)'
> 
> On 09/21/2016 01:44 PM, Stepan Zakharov wrote:
> > Yes, of course it looks different.pragma table_info(TABLENAME);Where 
> > TABLENAME is my table name.I've tried it with single-quotes as well: pragma 
> > table_info('TABLENAME');No results in any case.And no errors. Returns 
> > SQLITE_OK.A very strange behaviour.
> 
> Does "PRAGMA table_info('sqlite_master');" return any results?
> 
> What does "PRAGMA compile_options;" say?
> 
> Dan.
> 
> 
> 
> 
> >
> >> To: sqlite-users@mailinglists.sqlite.org
> >> From: clem...@ladisch.de
> >> Date: Wed, 21 Sep 2016 08:27:32 +0200
> >> Subject: Re: [sqlite] A problem with 'pragma table_info(...)'
> >>
> >> Stepan Zakharov wrote:
> >>> it does not return any results
> >> That is because the table name is not correctly quoted:
> >>
> >>    sqlite> pragma table_info(...);
> >>    Error: near ".": syntax error
> >>
> >> Or does your statement look different?
> >>
> >>
> >> Regards,
> >> Clemens
> >> _______________________________________________
> >> sqlite-users mailing list
> >> sqlite-users@mailinglists.sqlite.org
> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >                                     
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
                                          
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to