← Back to branch summary

~maria-captains/mariadb-java-client/trunk

« back to all changes in this revision

Viewing changes to src/main/java/org/mariadb/jdbc/MySQLDatabaseMetaData.java

  • Committer: Vladislav Vaintroub
  • Date: 2013-09-20 14:55:18 UTC
  • Revision ID: wlad@montyprogram.com-20130920145518-ee3ys2xsr1c5ci0x
CONJ-66 : Extra rows (index parts that are not not parts of primary keys)  may be returned by DatabaseMetaData.getPrimaryKeys()

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/main/java/org/mariadb/jdbc/MySQLDatabaseMetaData.java
182
182
        String sql =
183
183
                "SELECT A.TABLE_SCHEMA TABLE_CAT, NULL TABLE_SCHEM, A.TABLE_NAME, A.COLUMN_NAME, B.SEQ_IN_INDEX KEY_SEQ, NULL PK_NAME "
184
184
                 + " FROM INFORMATION_SCHEMA.COLUMNS A, INFORMATION_SCHEMA.STATISTICS B"
185
 
                 + " WHERE A.COLUMN_KEY='pri'"
 
185
                 + " WHERE A.COLUMN_KEY='pri' AND B.INDEX_NAME='PRIMARY' "
186
186
                 + " AND "
187
187
                 + catalogCond("A.TABLE_SCHEMA",catalog)
188
188
                 + " AND "