Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Re: [tdf-discuss] LO Base Enhancements

On 07/29/2014 12:06 AM, Terrence Enger wrote:
With respect to dynamic column typing in SQLite,
On Mon, 2014-07-28 at 20:34 -0400, Andrew Douglas Pitonyak wrote:
I think that this is intentional, so, I don't think it is actually
broken. I never bothered to investigate the motivation for it.
Certainly intentional.  Indeed, the web site for SQLite describes it
as a positive virtue.

I should have written "broken by design".

I find it personally annoying, but not broken. I think that what you
really mean is that you find it not usable for a certain application
that you have in mind.
The cost is in thinking about what a query may return:  comparisons do
not mean what we are used to.  For that matter, what does a value mean
when it is not in the domain in which it is supposedly defined?


Well said Terry, well said.

Your last paragraph is, I think, an excellent summary of one of the greatest disadvantages to SQLite. I t annoys me when I use specific DDL to create a DB, I then retrieve the types and such that were created, and the types are different than what I requested. I suppose that I should be happy that it is able to map to what they support.

Andrew Pitonyak
My Macro Document:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.