Database request: Oceanbase

[dabenlee]

Problem

I can connect Oceanbase with mysql connect string, It works fine on quering data, but I can't edit data in the data grid and commit.
It would be great to fully support Oceanbase database.

Proposed solution

None

Alternatives considered

None

Related database type

None

[J2TeamNNL]

PR that adds an OceanBase type and makes grid saves work when the server is opened as MySQL or as OceanBase:

• Fork PR: feat(plugin-mysql): add OceanBase MySQL-mode connection type J2TeamNNL/TablePro#7
• Upstream compare: main...J2TeamNNL:cursor/oceanbase-mysql-flavor-c3a9

OceanBase MySQL mode reports a 5.7 banner, so the driver treated it as MySQL 5.7. Tables without an explicit PK keep a hidden __pk_increment (and sometimes __pk_cluster_column) that SHOW FULL COLUMNS and SELECT * omit. Grid query worked; commit did not, because the UPDATE had no usable PK in the result columns. This PR sniffs OceanBase from the banner even on a MySQL connection, projects the hidden key, and matches saves on it.

Live OceanBase was not measured in this environment (no Docker). Unit tests use captured banners and catalog rows. Oracle mode is out of scope.

[J2TeamNNL]

PR that adds an OceanBase type and makes grid saves work when the server is opened as MySQL or as OceanBase: #2741