Hi Craig, Thanks for the additional info. I made a mistake. I didn't realise that you referred to jOOQ 3.1.0 in your E-Mail subject. There was an implicit fix that was introduced in jOOQ 3.2.0 with this issue here: https://github.com/jOOQ/jOOQ/issues/2606
Essentially, the SQLDialect.family() info was not correctly used prior to jOOQ 3.2.0, which leads to the SQLSERVER2008 dialect being essentially unusable in jOOQ 3.1.0 I'm sorry I cannot provide any more help, here Lukas 2014-04-08 15:57 GMT+02:00 Craig Flichel <[email protected]>: > Lukas, > > Yes it still happens. Here is a simpler version of what i'm doing. It also > causes the warning. > > CREATE TABLE test ( > ID bigint IDENTITY NOT NULL , > CODE nvarchar(10) NOT NULL , > C_ID bigint NULL , > VALUE numeric(19,4) NULL , > [RULE] nvarchar(20) NOT NULL , > [TYPE] nvarchar(20) NOT NULL , > F_ID bigint NOT NULL , > T_ID bigint NULL , > REVISION_ID bigint NOT NULL , > CREATED_DATE datetime2(3) NOT NULL , > LAST_UPDATED_TIME datetime2(3) NOT NULL , > VERSION int NOT NULL > ) > GO > ALTER TABLE dbo.[test] ADD CONSTRAINT test_PK PRIMARY KEY CLUSTERED ( ID ) > GO > ALTER TABLE dbo.[test] ADD CONSTRAINT test_UK_01 UNIQUE NONCLUSTERED ( > CODE, REVISION_ID ) > GO > > SELECT > [2].[ID],[2].[CODE],[2].[C_ID],[2].[VALUE],[2].[RULE],[2].[TYPE],[2].[F_ID],[2].[T_ID],[2].[REVISION_ID],[2].[CREATED_DATE],[2].[LAST_UPDATED_TIME],[2].[VERSION] > FROM [test] [2] > WHERE [2].[REVISION_ID] = ? > ORDER BY [2].[CODE] > > Craig > -- 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]. For more options, visit https://groups.google.com/d/optout.
