can't detect pk in some DBMS

[deffence1776]

In some DBMS, DatabaseMetaData#getPrimaryKeys returns COLUMN_NAME in lowercase.
(I tried sqlite3)

I think you should add String#toUpperCase when you get primarykey's column name at org.assertj.db.type.Table#collectPrimaryKeyName

     while (resultSet.next()) {
        String columnName = resultSet.getString("COLUMN_NAME").toUpperCase();
        if (getColumnsNameList().indexOf(columnName) != -1) {
          pksNameList.add(columnName);
        }
      }

Thank you.

[tnazare]

#33

[regis1512]

Sorry to have be long to implement a solution.
You can now find new classes : LetterCase and all associated classes (especially SourceWithLetterCase and DataSourceWithLetterCase) which are here to fix this problem.

When you instantiate a SourceWithLetterCase or DataSourceWithLetterCase, you can indicate the behavior (the conversion like upper and lower and the comparison) with the letter case of the tables, columns and primary keys.
I hope that with this flexibility that all the users can find a compatible solution with their database.
Please note that the solution is extensible because LetterCase use CaseComparison and CaseConversion which are interfaces.

[regis1512]

And thank to tnazare for his proposition