Sql parse bug

[anywo]

version: 1.0.0-rc.3
SQL:SELECT * FROM ( WITH RECURSIVE org_tree AS ( SELECT id, name, parent_id, node_type, 0 AS level FROM base WHERE id = $ROOT_ID$ UNION ALL SELECT o.id, o.name, o.parent_id, o.node_type, ot.level + 1 FROM base o INNER JOIN org_tree ot ON o.parent_id = ot.id ) SELECT * FROM org_tree ORDER BY level, id ) AS DATART_VTABLE LIMIT 1000 OFFSET 0
DB: MYSQL
EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Incorrect syntax near the keyword 'RECURSIVE' at line 1, column 23.
Was expecting one of:
<BRACKET_QUOTED_IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<HYPHENATED_IDENTIFIER> ...
...
<UNICODE_QUOTED_IDENTIFIER> ...