https://bugs.freedesktop.org/show_bug.cgi?id=50575

--- Comment #7 from Terrence Enger <lo_b...@iseries-guru.com> 2012-06-07 
13:56:24 PDT ---
>From comment 6 ...
> So as far as I see sqlite DOES NOT CORRECTLY SUPPORT TIMESTAMPS, and


But more than that, sqlite does not enforce any data type (except an integer
primary key).  <http://www.sqlite.org/datatype3.html> "Datatypes In SQLite
Version 3" calls it a dynamic type system:

    In SQLite, the datatype of a value is associated with the value itself, not
    with its container.

The datatype of a column is merely advisory.  "Dynamic" is too pleasant a word;
I am tempted to call this "unreliable" and "broken".


This laxness makes me question the wisdom of bug 38811 "default to SQLite not
HSQLDB in Base".  Indeed, had I known earlier about the laxness, perhaps I
would
never have bothered to comment on bug 47520.  Just call me a grumpy old man.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to