Re: [sqlite] Troubles with sqlile sql

2017-01-29 Thread Simon Slavin
On 30 Jan 2017, at 3:48am, David Niklas wrote: > I've not heard of a UNION (It seems that the wikibooks article is > incomplete* ) That page is documentation for some other version of SQL, neither the SQL standard nor SQLite. A copy of the SQL specification for 1992 can be

Re: [sqlite] Troubles with sqlile sql

2017-01-29 Thread David Niklas
I'm going to reply to both messages at once. On Sat, 28 Jan 2017 15:44:07 -0500 Richard Hipp wrote: > On 1/28/17, David Niklas wrote: > > > > # ALTER TABLE processors ADD CONSTRAINT bit NOT NULL > > Error: near "CONSTRAINT": syntax error > > > > # ALTER TABLE

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-29 Thread Richard Hipp
On 1/29/17, James K. Lowden wrote: > > I wonder what pricey embedded environment both supports dlopen(2) and > does not support C99, in this day and age. > One of the test platforms for SQLite is an old iBook I bought back in approximately 2002. Dunno if it support C99

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-29 Thread Keith Medcalf
On Sunday, 29 January, 2017 19:50, Simon Slavin , said: > On 30 Jan 2017, at 12:06am, Scott Robison wrote: > > I'm not sure how big the market is, but there are older computers in use > > in areas that might be running older OS because anything

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-29 Thread Scott Robison
On Jan 29, 2017 5:49 PM, "Simon Slavin" wrote: On 30 Jan 2017, at 12:06am, Scott Robison wrote: > I'm not sure how big the market is, but there are older computers in use in > areas that might be running older OS because anything newer is too

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-29 Thread Simon Slavin
On 30 Jan 2017, at 12:06am, Scott Robison wrote: > I'm not sure how big the market is, but there are older computers in use in > areas that might be running older OS because anything newer is too bloated. The emphasis is shifted to non-modern compilers because a large

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-29 Thread Scott Robison
I'm not sure how big the market is, but there are older computers in use in areas that might be running older OS because anything newer is too bloated. If maintaining ANSI C compatibility truly becomes a burden, sure. If it isn't then why not? On Jan 29, 2017 4:36 PM, "James K. Lowden"

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

2017-01-29 Thread James K. Lowden
On Sat, 28 Jan 2017 11:49:19 +1100 "dandl" wrote: > >>>Sticking with C90 is perfectly rational if you're still running > >>>Windows 98 on a Pentium III at 500 Mhz with 256 MB RAM. Else, > >>>really, it's not too soon to adopt a 6-year old standard, C11. > > There are plenty