On 18 Oct 2011, at 6:46am, Sylvain Pointeau wrote:
> Is it normal that fromuid of the table exits is STRING ?
> I think it should be TEXT to be surely processed as text and not float
If you're writing your database especially for SQLite you should specify 'TEXT'
not 'STRING'. However, SQLite
On Tue, Oct 18, 2011 at 8:30 AM, Nick Gammon wrote:
>
> On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote:
>
> > Is it normal that fromuid of the table exits is STRING ?
> > I think it should be TEXT to be surely processed as text and not float
>
> That was an error. However
On 18/10/2011, at 4:46 PM, Sylvain Pointeau wrote:
> Is it normal that fromuid of the table exits is STRING ?
> I think it should be TEXT to be surely processed as text and not float
That was an error. However it shouldn't take SQLite 2.5 seconds to handle *any*
numeric literal. Especially as
Is it normal that fromuid of the table exits is STRING ?
I think it should be TEXT to be surely processed as text and not float
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 18/10/2011, at 3:38 PM, Dan Kennedy wrote:
> Now fixed here:
>
> http://www.sqlite.org/src/ci/59bb999c8b?sbs=0
Thanks!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 10/18/2011 03:17 AM, Nick Gammon wrote:
On 17/10/2011, at 9:55 PM, Dan Kennedy wrote:
Did you download the binary from the website or build it yourself?
If the latter, which compiler are you using? And what level of
optimization is enabled?
I initially observed the problem with version
On 17/10/2011, at 9:55 PM, Dan Kennedy wrote:
> Did you download the binary from the website or build it yourself?
> If the latter, which compiler are you using? And what level of
> optimization is enabled?
I initially observed the problem with version 3.7.7.1, as embedded in my
application
On 10/17/2011 04:33 PM, Nick Gammon wrote:
Hello,
Running under Windows XP, using sqlite3.exe version:
3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177
...
Trying under Mac OS/X (Lion) does not appear to exhibit this
problem.
No problem with that version on Linux either.
On 17 Oct 2011, at 10:33am, Nick Gammon wrote:
> Running under Windows XP, using sqlite3.exe version:
>
> 3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177 [snip]
>
> Trying under Mac OS/X (Lion) does not appear to exhibit this problem.
Just a note that the version of the
On 17/10/2011, at 8:33 PM, Nick Gammon wrote:
> ...
> The following SQL:
>
> ...
> SELECT * FROM exits WHERE fromuid = '2E515665758C87202B281C7FC';
>
>
> Takes over 2 seconds to execute (in particular, the SELECT statement).
>
Further to the above, changing the column type from
Hello,
Running under Windows XP, using sqlite3.exe version:
3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177
As follows:
sqlite3 foo.db
The following SQL:
DROP TABLE IF EXISTS rooms;
DROP TABLE IF EXISTS exits;
CREATE TABLE IF NOT EXISTS rooms (
11 matches
Mail list logo