Failed to parse query. Proceeding with query execution
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "hour" <K_DATE_LITERAL>
at line 7, column 26.
CREATE TABLE films (
code char(5),
title varchar(40),
did integer,
date_prod date,
kind varchar(10),
len interval hour to minute,
CONSTRAINT production UNIQUE(date_prod)
);
Failing SQL Feature:
When parsing an example (taken from the postgres website: https://www.postgresql.org/docs/current/sql-createtable.html) that uses
interval hour to minuteinCREATE TABLE...parsing fails with:SQL Example:
Software Information: