Have WITH statements been deprecated?

runs · June 23, 2023, 9:01pm

When I run:

WITH user_first_video AS (
    SELECT
        userId,
        MIN(DATE(createdAt)) AS first_video_date
    FROM VideoProject
    GROUP BY userId
)

select * from user_first_video

I get:

VT12001: unsupported: WITH expression in SELECT statement

I remember WITH expressions used to be possible in Metabase. Has this been deprecated?

sfa · June 24, 2023, 10:50am

Isn't it a Vitess, and not Metabase, warning ?

github.com

vitessio/vitess/blob/main/go/vt/vtgate/planbuilder/testdata/unsupported_cases.json

[
  {
    "comment": "natural join",
    "query": "select * from user natural join user_extra",
    "plan": "VT12001: unsupported: natural join"
  },
  {
    "comment": "natural left join",
    "query": "select * from user natural left join user_extra",
    "plan": "VT12001: unsupported: natural left join"
  },
  {
    "comment": "natural right join",
    "query": "select * from user natural right join user_extra",
    "plan": "VT12001: unsupported: natural right join"
  },
  {
    "comment": "subqueries not supported in group by",
    "query": "select id from user group by id, (select id from user_extra)",
    "plan": "VT12001: unsupported: subqueries in GROUP BY"

This file has been truncated. show original

Luiggi · June 24, 2023, 1:47pm

Metabase doesn’t parse the sql you write, this is something an error at the database level