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

Please sign in to leave a comment.