Hi Lukas.
I have the following table:
CREATE TABLE `partitioned_version` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`description` varchar(2048) DEFAULT NULL,
`account_id` bigint(20) DEFAULT NULL,
`data_for_date` date NOT NULL,
`component_version` varchar(100) DEFAULT NULL,
`status` smallint(6) DEFAULT NULL,
`fb_job_id` bigint(20) DEFAULT NULL,
`total_data_count` bigint(20) DEFAULT NULL,
`processing_time` bigint(20) DEFAULT NULL,
`report_generation_time` bigint(20) DEFAULT NULL,
`processing_rate` float DEFAULT NULL,
`api_version` tinyint(4) DEFAULT NULL,
`create_component_version` varchar(100) DEFAULT NULL,
`report_type` tinyint(4) NOT NULL DEFAULT ''0'',
PRIMARY KEY (`id`,`create_date`),
KEY `account_id_date_partitioned_version_idx` (`account_id`,
`data_for_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (TO_DAYS(create_date))
(PARTITION PART_2016_AUG VALUES LESS THAN (736573) ENGINE = InnoDB,
PARTITION PART_2016_SEP VALUES LESS THAN (736603) ENGINE = InnoDB,
PARTITION PART_2016_OCT VALUES LESS THAN (736634) ENGINE = InnoDB,
PARTITION PART_2016_NOV VALUES LESS THAN (736664) ENGINE = InnoDB,
PARTITION PART_2016_DEC VALUES LESS THAN (736695) ENGINE = InnoDB,
PARTITION PART_2017_JAN VALUES LESS THAN (736726) ENGINE = InnoDB,
PARTITION PART_2017_FEB VALUES LESS THAN (736754) ENGINE = InnoDB,
PARTITION PART_2017_MAR VALUES LESS THAN (736785) ENGINE = InnoDB,
PARTITION PART_2017_APR VALUES LESS THAN (736815) ENGINE = InnoDB,
PARTITION PART_2017_MAY VALUES LESS THAN (736846) ENGINE = InnoDB,
PARTITION PART_2017_JUN VALUES LESS THAN (736876) ENGINE = InnoDB,
PARTITION PART_2017_JUL VALUES LESS THAN (736907) ENGINE = InnoDB,
PARTITION PART_2017_AUG VALUES LESS THAN (736938) ENGINE = InnoDB,
PARTITION PART_2017_SEP VALUES LESS THAN (736968) ENGINE = InnoDB,
PARTITION PART_2017_OCT VALUES LESS THAN (736999) ENGINE = InnoDB,
PARTITION PART_2017_NOV VALUES LESS THAN (737029) ENGINE = InnoDB,
PARTITION PART_2017_DEC VALUES LESS THAN (737060) ENGINE = InnoDB,
PARTITION PART_2018_JAN VALUES LESS THAN (737091) ENGINE = InnoDB,
PARTITION PART_2018_FEB VALUES LESS THAN (737119) ENGINE = InnoDB,
PARTITION PART_2018_MAR VALUES LESS THAN (737150) ENGINE = InnoDB,
PARTITION PART_2018_APR VALUES LESS THAN (737180) ENGINE = InnoDB,
PARTITION PART_2018_MAY VALUES LESS THAN (737211) ENGINE = InnoDB,
PARTITION PART_2018_JUN VALUES LESS THAN (737241) ENGINE = InnoDB,
PARTITION PART_2018_JUL VALUES LESS THAN (737272) ENGINE = InnoDB) */
As you can see in this table I have two PRIMARY keys: "id" and "create_date"
But when I try insert new row (record.store()) then I got "ID = NULL"
Why?
Because here in method
org.jooq.impl.AbstractDMLQuery#selectReturning
has line
if (returning.size() == 1 && new Fields<Record>(returning).field(field) !=
null) {
but in my case "returning.size() == 2" because I have two PRIMARY KEYS
Also when I try do the simple insert via MySQL query:
"insert into partitioned_version (create_date) values (NOW())"
I have possibility to insert new data AND in "partitioned_version" I see
the new row.
So, why I got "ID = NULL" when I did "record.store()"?
Thanks,
Vova
--
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.
