1

Topic: Support with

Is available last MySQL 10.1.26-MariaDB-0+deb9u1
However, requests with with do not work. For example, examples here from here:
http://mysqlserverteam.com/mysql-8-0-la … ysql-ctes/
And from here
https://dev.mysql.com/doc/refman/8.0/en/with.html
In particular does not work

WITH cte (col1, col2) AS
(
SELECT 1, 2
UNION ALL
SELECT 3, 4
)
SELECT col1, col2 FROM cte;

The error text:

wrote:

[1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' cte (col1, col2) AS
(
SELECT 1, 2
UNION ALL
SELECT 3, 4
)
SELECT col1, col ' at line 1!

Question: with and did not include or something  somewhere is necessary?

2

Re: Support with

Judging by an inscription "Pre-General Availability Draft: 2018-01-12", in the near future it is not necessary to wait.
And, especially, not in release  5-month's prescription.