Am Samstag, den 07.05.2011, 03:00 +0000 schrieb
sqlite-mana...@googlecode.com:
> Comment #6 on issue 608 by mrinal.k...@gmail.com: select date('2011-04-29',
> quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17
> http://code.google.com/p/sqlite-manager/issues/detail?id=608
>
> This is the equivalent output on my computer; and Firefox 3.6.17 has sqlite
> 3.7.4 (as you have reported)
>
> user@user-office-laptop:~$ sqlite3 --version
> 3.7.4
> user@user-office-laptop:~$ sqlite3
> SQLite version 3.7.4
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> select date('2011-04-29', quote(-3) || 'day');
Wait a minute. The previous sql produces 'NULL' output, yes? If so, it's
an sqlite3 problem with that 3.7.4 version, because with my 3.6.16, it's
correct as you can see in my previous mail:
-------- Weitergeleitete Nachricht --------
> Von: Thomas Mittelstaedt <tmsta...@t-mittelstaedt.de>
> Reply-to: tmsta...@t-mittelstaedt.de
> An: sqlite-mana...@googlecode.com
> Betreff: Re: Issue 608 in sqlite-manager: select date('2011-04-29',
> quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17
> Datum: Sat, 07 May 2011 04:40:17 +0200
>
> Am Samstag, den 07.05.2011, 01:41 +0000 schrieb
> sqlite-mana...@googlecode.com:
> > Comment #4 on issue 608 by mrinal.k...@gmail.com: select date('2011-04-29',
> >
> > quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17
> > http://code.google.com/p/sqlite-manager/issues/detail?id=608
> >
> > sqlite manager in firefox uses the sqlite library which is included with
> > firefox and not the one separately installed on the computer. It is
> > possible that the firefox version 3.6.17 includes a higher version of
> > sqlite library as compared to the earlier firefox versions.
> > According to your report, firefox 3.6.17 includes sqlite 3.7.4
> > My firefox and Ubuntu have exactly this version of sqlite.
> >
>
> tom@linux1:~$ sqlite3 --version
> 3.6.16
> tom@linux1:~$ sqlite3
> SQLite version 3.6.16
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> select date('2011-04-29', quote(-3) || 'day');
> 2011-04-26
> sqlite>
>
--
thomas
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
