|
Problem IT13725
|
Status: Closed |
AN INSERT FROM AN EXTERNAL TABLE INTO A FRAGMENTED RAW TABLE WITH PDQ SET DOESN'T UPDATE THE 'CURRENT SERIAL VALUE'
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
If you create a fragmented raw table with
SERIAL/SERIAL8/BIGSERIAL columns and load it from an external
table using
insert into raw_table select * from ext_table;
with a PDQ set to anything > 0, the current
SERIAL/SERIAL8/BIGSERIAL value of the raw table is not updated
properly.
An example:
set pdqpriority 60;
insert into tab1 select * from tab1_ext; -- tab1 is a raw table
with 2 fragments and a SERIAL column
100 row(s) inserted.
$ oncheck -pt testdb:tab1 | grep "serial value"
Current serial value 2
Current serial value 1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* load from external tables using light appends and a 1 to 1 *
* relationship between thread and fragment *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
The problem happens only in the unique combination of following
conditions:
- insert from external table ...
- ... into fragmented ...
- ... raw table ...
- with PDQ set
So avoiding any one of the conditions will allow you to achieve
the expected result, even though at the cost of some performance
penalty. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.02.2016
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
