Latest versionsfixlist
15.0.xC1.5 FixList
14.10.xC13.7 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT44970 Status: Closed

RUNNING A QUERY WITH "SELECT ... FROM FINAL TABLE(INSERT ...);" RETURNS
DATA IN PRIMARY BUT NOT IN UPDATABLE SECONDARY

product:
INFORMIX SERVER / 5725A3900 / E10 -
Problem description:
The syntax "SELECT ... FROM final TABLE(INSERT...);" returns
data on a Primary server but not on an Updatable Secondary.

SELECT
id AS ID,
ip AS IP,
port AS Port,
protocol_id AS ProtocolID,
read_position_start AS ReadPositionStart,
read_position_amount AS ReadPositionAmount
FROM final TABLE(
INSERT INTO mytab
(ip, port, protocol_id,  read_position_start,
read_position_amount)
VALUES('10.0.0.211',3030,1,0,0));

On a Primary server it returns:

id                  1
ip                  10.0.0.211
port                3030
protocolid          1
readpositionstart   0
readpositionamount  0

2 row(s) retrieved.

Database closed.

But on an HDR Updatable Secondary it returns:

1 row(s) retrieved.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* 1                                                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Customer runs a query with "SELECT ... FROM final            *
* TABLE(INSERT ...);" on a Primary server and it returns data, *
* but if it is executed on an Updatable Secondary it does not  *
* return data.                                                 *
****************************************************************
* RECOMMENDATION:                                              *
* Do not use this undocumented and unsupported query syntax.   *
****************************************************************
Local Fix:


Solution




Workaround


****************************************************************
* USERS AFFECTED:                                              *
* 1                                                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Customer runs a query with "SELECT ... FROM final            *
* TABLE(INSERT ...);" on a Primary server and it returns data, *
* but if it is executed on an Updatable Secondary it does not  *
* return data.                                                 *
****************************************************************
* RECOMMENDATION:                                              *
* Do not use this undocumented and unsupported query syntax.   *
****************************************************************


Comment


This syntax is not documented/supported on Informix Dynamic
Server.  Therefore, no change will be made to support it on a
secondary server.


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.11.2023
04.01.2024
04.01.2024


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)