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?
>
> 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+unsubscribe@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