Hi,
I just noticed that the key()-method in my generated record does not return 
the actual primary key of that table but only a key type of Record1 (and 
not Record3). 


I'm using jOOQ 3.8.6 and MySQL 5.6.16.
Here is the table schema:

CREATE TABLE `config_preset_track_part` (
 `trackId` int(10) NOT NULL,
 `configId` int(10) NOT NULL,
 `trackPartIndex` int(10) NOT NULL,
 `checkPointIndex` int(10) NOT NULL,
 PRIMARY KEY (`trackId`,`trackPartIndex`,`checkPointIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Edit: It works fine when I define the primary key columns in order, so this


CREATE TABLE `config_preset_track_part` (
`trackId` int(10) NOT NULL,
`trackPartIndex` int(10) NOT NULL,
`checkPointIndex` int(10) NOT NULL,
`configId` int(10) NOT NULL,
 PRIMARY KEY (`trackId`,`trackPartIndex`,`checkPointIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

works.

-- 
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.

Reply via email to