New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error writing to TIMESTAMP/TIME WITH TIME ZONE array [CORE6303] #6545
Comments
Modified by: Tony Whyman (twhyman)summary: Error writing to TIMESTANP/TIME WITH TIME ZONE array => Error writing to TIMESTAMP/TIME WITH TIME ZONE array |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoff |
Commented by: @AlexPeshkoff Thats's almost for sure same bug |
Modified by: @AlexPeshkoff |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: Deferred until FDB will support new TIME WITH TIMEZONE data type introduced in FB 4.x. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Tony Whyman (twhyman)
I have set up a test of TIME/TIMESTAMP WITH TIME ZONE arrays. The test is failing when putslice is called, with the error message reporting an error writing data to the connection (send_packet/send).
The test table is created using:
Create Table FB4TestData_ARTZ (
RowID Integer not null,
TimeCol TIME WITH TIME ZONE [0:16],
TimestampCol TIMESTAMP WITH TIME ZONE [0:16],
Primary Key(RowID)
);
The test is run by filling each array with 17 values and then writing the array buffer to the server using "putslice". The SDL is identical to a known good SDL block for an array of TIMESTAMP (WITHOUT TIME ZONE) except that the data type is blr_sql_time_tz or blr_timestamp_tz as appropriate. I have seen a connection drop previously when using putslice when the SDL is mis-formatted. However, I can see no problem in this case.
The one oddity I can see is that the element size being returned from the metadata is "8" for a TIME WITH TIME ZONE array and "12" for a "TIMESTAMP WITH TIME ZONE" array. Given the data structures, I would have expected "6" and "10". However, I have also checked the metadata for non-array TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE columns and these also return "8" and "12" respectively. If I execute a 'SET BIND OF TIME ZONE TO EXTENDED' statement, then the non-array column sizes remain as "8" and "12" even though the data types have changed to SQL_TIME_TZ_EX and SQL_TIMESTAMP_TZ_EX, respectively. I presume that field alignment is being forced to a four byte boundary.
Commits: 23906ef
====== Test Details ======
Deferred until FDB will support new TIME WITH TIMEZONE data type introduced in FB 4.x.
Letter from Alex 21.07.2020 23:43
The text was updated successfully, but these errors were encountered: