You're probably right.
You can try this shorter schema and get the same problem.
create table xxx("" text);
However, my point was that if SQLite3 allows it, SQLDIFF should be able to
handle it also.
Thanks.
-----Original Message-----
From: Tim Streater
Sent: Monday, November 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 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 the following (I tried on a
> Win7
> machine):
>
> sqlite3 xxx.db < xxx.sql
> sqldiff xxx.db xxx.db
>
> SCHEMA (xxx.sql)
> --------------------
> CREATE TABLE raw(
> "Date" TEXT,
...
> "Contact Phone Number" TEXT,
> "" TEXT
> );
Well I don't imagine it's going to like:
"" TEXT
--
Cheers -- Tim
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
