search

AnyhowStep / sql-compiler

An experimental SQL compiler
MIT License
0 stars 0 forks source link

Implement esoteric CREATE TABLE ... SELECT syntax #7

Open AnyhowStep opened 3 years ago

AnyhowStep commented 3 years ago

https://github.com/mysql/mysql-server/blob/5c8c085ba96d30d697d0baa54d67b102c232116b/sql/sql_yacc.yy#L5120-L5130

CREATE TABLE U (
  PARTITION BY KEY(X)
  SELECT 1 AS X
) 
UNION
(SELECT 2)
LIMIT 1;

SELECT * FROM U;