[MDEV-31146] Spider: Remove table options by COMMENT Created: 2023-04-28  Updated: 2023-11-30

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Fix Version/s: 11.6

Type: Task Priority: Critical
Reporter: Ralf Gebhardt Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-32627 Spider: Add CONNECTION parsing of SQL... Open
is blocked by MDEV-28861 Spider: Deprecate table options by CO... Closed
Relates
relates to MDEV-27106 Spider: specify connection to data no... Closed

 Description   

MDEV-28861 deprecates the engine-defined options corresponding to major table options. So, we now can remove the table options, specified by COMMENT and CONNECTION, which have engine-defined option correspondence. Also, remove non-major, rarely used table options.

 Comments   
Comment by Sergei Golubchik [ 2023-05-30 ]

I suggest this to be done in steps:

  1. COMMENT is accepted, but SHOW CREATE TABLE shows options from MDEV-28861
  2. COMMENT causes a deprecation warning
  3. COMMENT is no longer parsed (after a some grace period after 2)

I'm afraid there's no proper way of implementing 1, so either we skip it or it'll be some kind of a hack (luckily, it's needed only temporarily, until 3)

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