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.
