[CONJ-1156] getTables should be ordered as expected Created: 2024-02-03  Updated: 2024-02-03

Status: Open
Project: MariaDB Connector/J
Component/s: JDBC compatibility
Affects Version/s: 3.3.2
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Jin Kwon Assignee: Diego Dupin
Resolution: Unresolved Votes: 0
Labels: None
Environment:

mysql-connector-j:8.3.0



 Description   

According the documentation, result should be ordered by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM and TABLE_NAME.

And here comes what I got.

group is not sorted according to Comparator$$Lambda/0x00000008000fc680 comparator because element 5:
  Table(super=AbstractMetadataType(super=com.github.jinahya.database.metadata.bind.Table@6e3762ff, unmappedValues={}),
    tableCat=information_schema,
    tableSchem=null,
    tableName=COLLATIONS,
    tableType=SYSTEM VIEW,
    remarks=, typeCat=null, typeSchem=null, typeName=null, selfReferencingColName=null, refGeneration=null)
is not less or equal than element 6:
  Table(super=AbstractMetadataType(super=com.github.jinahya.database.metadata.bind.Table@110ad0d1, unmappedValues={}),
    tableCat=information_schema,
    tableSchem=null,
    tableName=COLLATION_CHARACTER_SET_APPLICABILITY,
    tableType=SYSTEM VIEW,
    remarks=, typeCat=null, typeSchem=null, typeName=null, selfReferencingColName=null, refGeneration=null)


Generated at Thu Feb 08 03:21:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.