Hi,
I've run into some issues using the DSL.timestampAdd function with Teradata.
Here is my code, a simple select statement.
DSLContext create = *using*(SQLDialect.*TERADATA*);
Select select = create.select(DSL.*timestampAdd*(SHIP_DATE, 480, DatePart.
*MINUTE*)).from(SALES_VIEW);
This is the sql that is generated:
select ("sales_view"."Ship_Date" + cast('0 00:' || lpad(cast(480 as
varchar(2)), 2, '0') || ':00' as interval day to second)) from "sales_view"
Running this generated sql in Teradata, produces the following error:
"[Error 3798] [SQLState 42000] A column or character expression is larger
than the max size."
I, admittedly, don't have much experience with Teradata. I'm trying to use
JOOQ to translate my queries. Am I doing something wrong? Is it a problem
with how I have my database configured?
It seems like JOOQ should output sql more like the following, which works:
select ("sales_view"."Ship_Date" + INTERVAL '10' MINUTE) from "sales_view"
Thank you,
Sam Nelson
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/41138299-12ed-4478-b607-0ec615ca5b1a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
