You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Failed to parse query. Proceeding with query execution
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "hour" <K_DATE_LITERAL>
at line 7, column 26.
SQL Example:
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)
);
Software Information:
JSqlParser 4.5
PostgreSQL
The text was updated successfully, but these errors were encountered:
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 minute
inCREATE TABLE...
parsing fails with:SQL Example:
Software Information:
The text was updated successfully, but these errors were encountered: