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
请先登录再写评论。