Bug with SMALLINT in VARRAY

[jdorlon]

Hello,

This bug was reported as part of another bug earlier this year. I want to post this again separately so it's easier to find.

To reproduce the problem, first run this script:

Code: Select all

create or replace type sbool20 as varray(20) of  smallint; 

create table demo_error (id number not null, bparms  sbool20) ;

Next, try this SQL in a TSmartQuery:

Code: Select all

select * from demo_error;

It throws the error: Field 'BPARMS[0]' is of an unknown type

 The problem still exists in version 11.2.4. I am using RAD Studio 10.1 Berlin. Compiling in both 32 and 64 bit. Oracle Client and Server are both 19c. Not using Direct mode.

Thank you

John

[MaximG]

Thank you for the information. We will investigate the described issue and let you know the results shortly.