Error writing an array of NUMERIC(24,6) to the database when using FB4
Development Snapshot
-------------------------------------------------------------------------------------------
Key: CORE-6302
URL: http://tracker.firebirdsql.org/browse/CORE-6302
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Beta 1
Environment: Using the FB4 Development Snapshot under Linux Mint 19.3
AMD64
Reporter: Tony Whyman
I have created a table as follows in order to test out FB4 array handling with
the new datatypes.
Create Table FB4TestData_DECFloat_AR
RowID Integer not null,
Float16 DecFloat(16) [0:16],
Float34 DecFloat(34) [0:16],
BigNumber NUMERIC(24,6) [0:16],
Primary Key(RowID)
);
The metadata indicates that the first two arrays are arrays of DecFloat(16) and
DecFloat(34) respectively, while the latter is an INT128 array with a scale
factor of -6.
Running separate tests on each array column: the first two perform as expected
with both read and write operations successful and the read results
corresponding to the write. However, the "putslice" API method fails when
writing the NUMERIC(24,6) array type with the error message:
column not array or invalid dimensions (expected 0, encountered 1).
The SDL for the putslice is the same as for the Float34 array except for the
data type and scale factor. The SDL is generated following src/yvalve/array.epp
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel