[sqlite] SQLDIFF problem

2015-12-01 Thread Richard Hipp
On 12/1/15, jungle Boogie wrote: > On 30 November 2015 at 06:27, Richard Hipp wrote: >>> Just curious. Why does SQLite allow those? Legacy (i.e. >>> backward-compatibility)? Valid in ANSI SQL? --DD >> >> I don't know if it is valid ANSI SQL or not. But SQLite has always >> allowed it, so we have

[sqlite] SQLDIFF problem

2015-12-01 Thread jungle Boogie
On 30 November 2015 at 06:27, Richard Hipp wrote: >> Just curious. Why does SQLite allow those? Legacy (i.e. >> backward-compatibility)? Valid in ANSI SQL? --DD > > I don't know if it is valid ANSI SQL or not. But SQLite has always > allowed it, so we have to support it now for legacy. How does

[sqlite] SQLDIFF problem

2015-11-30 Thread Tony Papadimitriou
30, 2015 12:41 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLDIFF problem On 29 Nov 2015 at 18:55, tonyp at acm.org wrote: > Here?s a report about an SQLDIFF utility problem. > sqldiff: SQL statement error: near "IS": syntax error > > To repr

[sqlite] SQLDIFF problem

2015-11-30 Thread Dominique Devienne
On Mon, Nov 30, 2015 at 2:50 PM, Richard Hipp wrote: > https://www.sqlite.org/src/info/64263ccb8f9835c6 "tables with zero-length column names" Just curious. Why does SQLite allow those? Legacy (i.e. backward-compatibility)? Valid in ANSI SQL? --DD

[sqlite] SQLDIFF problem

2015-11-30 Thread Tim Streater
On 29 Nov 2015 at 18:55, tonyp at acm.org wrote: > Here?s a report about an SQLDIFF utility problem. > sqldiff: SQL statement error: near "IS": syntax error > > To reproduce, put the schema below (produced automatically by .IMPORT from a > CSV file so don?t bother with its appearance ? but it wor

[sqlite] SQLDIFF problem

2015-11-30 Thread Richard Hipp
On 11/30/15, Dominique Devienne wrote: > On Mon, Nov 30, 2015 at 2:50 PM, Richard Hipp wrote: > >> https://www.sqlite.org/src/info/64263ccb8f9835c6 > > > "tables with zero-length column names" > > Just curious. Why does SQLite allow those? Legacy (i.e. > backward-compatibility)? Valid in ANSI SQL

[sqlite] SQLDIFF problem

2015-11-30 Thread Richard Hipp
https://www.sqlite.org/src/info/64263ccb8f9835c6 -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLDIFF problem

2015-11-29 Thread to...@acm.org
Here?s a report about an SQLDIFF utility problem. sqldiff: SQL statement error: near "IS": syntax error To reproduce, put the schema below (produced automatically by .IMPORT from a CSV file so don?t bother with its appearance ? but it works in sqlite3) inside some file like xxx.sql, and then do