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": "union operations in subqueries (expressions)",
    "query": "select * from user where id in (select * from user union select * from user_extra)",
    "plan": "VT12001: unsupported: '*' expression in cross-shard query"
  },
  {
    "comment": "TODO: Implement support for select with a target destination",
    "query": "select * from `user[-]`.user_metadata",
    "plan": "VT12001: unsupported: SELECT with a target destination"
  },
  {
    "comment": "Unsupported INSERT statement with a target destination",
    "query": "insert into `user[-]`.user_metadata (a, b) values (1,2)",
    "plan": "VT12001: unsupported: INSERT with a target destination"
  },
  {
    "comment": "Unsupported delete statement with a replica target destination",
    "query": "DELETE FROM `user[-]@replica`.user_metadata limit 1",
    "plan": "VT09002: delete statement with a replica target"

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