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?
Terry.
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: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted
