Bug #96643 SQL Syntax checker rejects valid MariaDB
Submitted: 25 Aug 2019 1:02 Modified: 26 Aug 2019 7:24
Reporter: Christopher Hartsough Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S7 (Test Cases)
Version:8.0.17 OS:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: 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.