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