Trino (Latest Version) Cannot Query Fields with _QTY Suffix in Oracle 11g

[1315093275]

Trino Version: Latest
Oracle Version: 11g
JDBC Driver: Tried different ojdbc versions (e.g., ojdbc6, ojdbc8), but no success.
Error/Behavior:
Fields like ITEM_QTY, TOTAL_QTY, etc., do not appear in SHOW COLUMNS FROM oracle.schema.table.
Explicit queries (e.g., SELECT "ITEM_QTY" FROM oracle.schema.table) return errors like Column 'ITEM_QTY' cannot be resolved.

Troubleshooting Attempts
Verified Oracle Permissions: The Trino service account has SELECT privileges on the tables.
Quoted Identifiers: Tried both quoted and unquoted field names (e.g., ITEM_QTY, "ITEM_QTY").
Trino Metadata Refresh: Restarted Trino and reloaded the Oracle catalog.
JDBC Driver Swapping: Tested multiple ojdbc versions (no change in behavior).

Please help me, I don't understand anything

[ebyhr]

I recommend reading a type mapping section (especially numeric mapping) of Oracle connector: https://trino.io/docs/current/connector/oracle.html#type-mapping