Bug #96643 SQL Syntax checker rejects valid MariaDB

• Submitted: 25 Aug 2019 1:02
• Modified: 26 Aug 2019 7:24
• Reporter: Christopher Hartsough
• Status: Not a Bug
• Category: MySQL Workbench: SQL Editor
• Severity: S7 (Test Cases)
• Version: 8.0.17
• OS: Windows (Microsoft Windows 10 Pro)
• CPU Architecture: Any
• Tags: WBBugReporter

[25 Aug 2019 1:02] Christopher Hartsough

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Chris Hartsough\AppData\Roaming\MySQL\Workbench\log\wb.log]

I can't find the one(s) where it didn't work.

If MySQL uses a different syntax, could you, please warn and allow the stuff to be sent and see what the horse has to say?

Chris

How to repeat:
run this:

CREATE TABLE z (x INT) WITH SYSTEM VERSIONING
  PARTITION BY SYSTEM_TIME LIMIT 100000 (
    PARTITION p0 HISTORY,
    PARTITION p1 HISTORY,
    PARTITION pcur CURRENT
  );

I copied it from the knowledge base.

Suggested fix:
If MySQL uses a different syntax, could you, please warn and allow the stuff to be sent and see what the horse has to say?

Chris

[26 Aug 2019 7:24] Mike Lischke

MySQL Workbench is only designed for and tested with MySQL. No other RDBMS is supported.