Skip to content

Decimal to numeric fails on INSERT

picodata> pico.sql([[
create table "T" ("id" integer not null, "r" double, primary key ("id"))
using memtx distributed by ("id") option (timeout = 3);
]])
2023-07-25 18:42:47.111 [6047] main/112/governor_loop I> applying pending schema change
2023-07-25 18:42:47.111 [6047] main/112/governor_loop I> calling proc_apply_schema_change, instance_id: i1
2023-07-25 18:42:47.112 [6047] main/112/governor_loop I> applied schema change on instance, instance_id: i1
2023-07-25 18:42:47.112 [6047] main/112/governor_loop I> finalizing schema change, op: DdlCommit 
2023-07-25 18:42:47.113 [6047] main/112/governor_loop I> nothing to do, waiting for events to handle
---
- row_count: 1
...
picodata> pico.sql([[insert into "T" values (1, 2.5)]])
2023-07-25 18:42:52.409 [6047] main/103/interactive vshard.rs:77 E> LuaError(ExecutionError("sbroad: failed to create transaction: RolledBack(FailedTo(Insert, Some(Space), \"tarantool error: FieldType: Tuple field 3 (r) type does not match one required by operation: expected double, got extension\"))")): dml_on_some
---
- null
- 'sbroad: Lua error (IR dispatch): LuaError(ExecutionError("sbroad: failed to create transaction: RolledBack(FailedTo(Insert, Some(Space), \"tarantool error: FieldType: Tuple field 3 (r) type does not match one required by operation: expected double,got extension\"))"))'