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,
  "Time" TEXT,
  "Time Zone" TEXT,
  "Name" TEXT,
  "Type" TEXT,
  "Status" TEXT,
  "Currency" TEXT,
  "Gross" TEXT,
  "Fee" TEXT,
  "Net" TEXT,
  "From Email Address" TEXT,
  "To Email Address" TEXT,
  "Transaction ID" TEXT unique,
  "Counterparty Status" TEXT,
  "Address Status" TEXT,
  "Item Title" TEXT,
  "Item ID" TEXT,
  "Shipping and Handling Amount" TEXT,
  "Insurance Amount" TEXT,
  "Sales Tax" TEXT,
  "Option 1 Name" TEXT,
  "Option 1 Value" TEXT,
  "Option 2 Name" TEXT,
  "Option 2 Value" TEXT,
  "Auction Site" TEXT,
  "Buyer ID" TEXT,
  "Item URL" TEXT,
  "Closing Date" TEXT,
  "Escrow Id" TEXT,
  "Invoice Id" TEXT,
  "Reference Txn ID" TEXT,
  "Invoice Number" TEXT,
  "Custom Number" TEXT,
  "Receipt ID" TEXT,
  "Balance" TEXT,
  "Address Line 1" TEXT,
  "Address Line 2/District/Neighborhood" TEXT,
  "Town/City" TEXT,
  "State/Province/Region/County/Territory/Prefecture/Republic" TEXT,
  "Zip/Postal Code" TEXT,
  "Country" TEXT,
  "Contact Phone Number" TEXT,
  "" TEXT
);

Reply via email to