ERROR: feature is not supported: Ext(1, [11, 7, 4, 39, 25, 35, 96, 23, 32, 92]) cannot be represented as a value of type Float8

One of our clients complained about this error during execution of a quite regular query:

postgres=> select * from card_balance where card_sk=1000;
ERROR:  feature is not supported: Ext(1, [11, 7, 4, 39, 25, 35, 96, 23, 32, 92]) cannot be represented as a value of type Float8.

I didn't manage to repoduce this error, but it can be easily fixed by adding a new combination of rmpv::Value and type in PgValue::try_from_rmpv.

changed milestone to %24.6 - Plugins and Tiers

added 1 deleted label

assigned to @UngiftedPoet

changed title from ERROR: feature is not supported: Ext(1, [11, 7, 4, 39, 25, 35, 96, 23, 32, 92]) to ERROR: feature is not supported: Ext(1, [11, 7, 4, 39, 25, 35, 96, 23, 32, 92]) cannot be represented as a value of type Float8

mentioned in merge request !1215 (closed)

changed the description

It turned out to be a case with a number column containing a decimal value, here are steps to reproduce:

postgres=> create table n (n number, primary key (n)) distributed by (n);
CREATE TABLE
postgres=> insert into n values (1), (2.5), (70427.19236017205)
postgres-> ;
INSERT 0 3
postgres=> select * from n;
ERROR:  feature is not supported: Ext(1, [1, 2, 93]) cannot be represented as a value of type Float8

It was decided to remove number type support

closed

changed milestone to %24.5 - Lowercase