Re: SQLDialectNotSupportedException when using nested select with extract function

[Lukas Eder]

This issue can be reproduced using the following code:

--------------------------------------------------------------------
Field<Timestamp> now = create().currentTimestamp();

Field<Integer> year = now.extract(DatePart.YEAR).as("y");
Field<Integer> month = now.extract(DatePart.MONTH).as("m");
Field<Integer> day = now.extract(DatePart.DAY).as("dd");

create.select().from(create().select(year, month, day)).fetchOne();
--------------------------------------------------------------------