Skip to content

[SQLLIB] Incorrect DECIMAL division #5946

@mihaibudiu

Description

@mihaibudiu
CREATE TABLE test ("tt" DECIMAL(38,10));
create view  ff as select tt, tt / 100.0 as tt2 from test;

Inserting into tt the value 36 produces the result: 36, 3600.
The result is correct when dividing by 100, without a decimal point.

Metadata

Metadata

Assignees

Labels

SQL compilerRelated to the SQL compiler

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions