WITH statement (aka CTE) on MariaDB 10.2+ not supported?

Dear JetBrainers,

I'm testing your promising DataGrip IDE. Most of things are really brilliant. There is one thing I'm missing: Starting with MariaDB 10.2 there is the WITH statement known as CTE (common table expression) that other databases are having for a long time but not MySQL.

https://mariadb.com/kb/en/mariadb/with/

DataGrip didn't recognizes this statement.

USE db;

WITH test AS
(
SELECT 1
)
SELECT * FROM test;

Table 'db.test' doesn't exist

If I'm switching the dialect from MySQL to Oracle or SQLite it is working fine. Is it possible to add a MariaDB 10.2+ profile to support these things? There are other need things in 10.2. like windowing functions that (maybe?) need some fine tuning on the MySQL dialect?

Best Regards

Miguel

6

Please sign in to leave a comment.