[IGNITE-13403] Update JDBC metadata to match actual capabilities

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.8.1
• Fix Version/s: 2.10, 2.9.1
• Component/s: sql
• Labels: 2.9.1-rc
• Release Note: fix the issue when Ignite JDBC drivers return metadata with invalid information about actual capabilities
• Ignite Flags: Release Notes Required
• Assignee: Taras Ledkov
• Reporter: Taras Ledkov
• Created: 04/Sep/20 08:10
• Updated: 03/Nov/20 15:11
• Resolved: 14/Sep/20 12:14

Description

In our JDBC metadata some capabilities are reported not to be supported, while in fact they are. E.g. I see

    /** {@inheritDoc} */
    @Override public boolean supportsAlterTableWithAddColumn() throws SQLException {
        return false;
    }

    /** {@inheritDoc} */
    @Override public boolean supportsAlterTableWithDropColumn() throws SQLException {
        return false;
    }

while in fact `ALTER TABLE ADD/DROP COLUMN` are supported.
Need to go through the list of capabilities and correct them.

Issue Links

• links to: GitHub Pull Request #8217
• links to: TCBot