Hi,

As requested opening a bug report.

I have few tables with partitions and some of them show me this error in diff command -
command : skeema diff --debug
response:
The original state ("from" side of diff) contains unexpected or unsupported clauses in SHOW CREATE TABLE.
--- original state expected CREATE
+++ original state actual SHOW CREATE
@@ -6 +6 @@
-/!50500 PARTITION BY LIST COLUMNS(category)
+/!50500 PARTITION BY LIST COLUMNS(category)

Environment

• Skeema version: skeema version 1.9.0-community, commit abea99e, released 2022-12-01T00:01:11Z
• Database vendor, version, OS/platform: AWS Managed RDS MySQL version 8.0.28
• Any other environmental notes or special configuration:

To Reproduce
Steps to reproduce the behavior.
Schema of the table -
CREATE TABLE expenses (
expense_date date NOT NULL,
category varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
amount decimal(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
/*!50500 PARTITION BY LIST COLUMNS(category)
(PARTITION p01 VALUES IN ('food') ENGINE = InnoDB,
PARTITION p02 VALUES IN ('flights','ground transportation') ENGINE = InnoDB,
PARTITION p03 VALUES IN ('leisure','customer entertainment') ENGINE = InnoDB,
PARTITION p04 VALUES IN ('communications') ENGINE = InnoDB,
PARTITION p05 VALUES IN ('fees') ENGINE = InnoDB,
PARTITION p06 VALUES IN ('lodging') ENGINE = InnoDB) */

run commands :
skeema pull
skeema diff

Expected behavior
Want to understand why the diff command is failing.

Additional context
We have few more tables but seems issue may be related.

Regards,
Nikhilesh Jannu