Sqlite JDBC Issue
Sqlite JDBC :
I have a bug in Jdbc driver. The method DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException; does not correctly return the value in resultSet.getInt(11 ) - NULLABLE OR NOT. Please make sure that also the Primary Key columns have the correct value here. I consider a column mandatory ( not null ) if : DatabaseMetaData.columnNoNulls == rs.getInt(11)
One more request for Sqlite : Would be great if you would support adding foreign keys after the table has been created. This is highly required by database design tools. All users are creating the foreign keys after the table has been created. This would be a great advantage for thouse who intend to a real database design. So please add commands for ALTER TABLE... ADD CONSTRAINT ... FOREIGN KEY ( col1, col2 ) REFERENCES ... ( col1, col2 ).