Hi all,
please consider the following short shell script: #!/bin/sh sqlite3 --version rm -f 1.sqlite3 2.sqlite3 echo 'CREATE TABLE test ( a VARCHAR );' | sqlite3 1.sqlite3 echo 'CREATE TABLE test ( a VARCHAR NOT NULL );' | sqlite3 2.sqlite3 sqldiff --schema 1.sqlite3 2.sqlite3 | wc -l Running on Ubuntu 16.04, the output for me is 3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f 0 So sqldiff --schema produces an empty difference when there is a real, observable difference between the two schemas. IMHO, sqldiff should emit DDL along the lines of https://www.sqlite.org/lang_altertable.html#otheralter to change the schema, or at least https://www.sqlite.org/sqldiff.html should mention this shortcoming in the "Limitations" section. Best regards, and thanks to every involved in making sqlite, Moritz _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users