forked from docs/doc-exports
Yang, Tong
3f5759eed2
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Yang, Tong <yangtong2@huawei.com> Co-committed-by: Yang, Tong <yangtong2@huawei.com>
2.5 KiB
2.5 KiB
Why Is Incorrect Output Displayed When I Perform Query with Filter on Decimal Data Type Values?
Question
Why is incorrect output displayed when I perform query with filter on decimal data type values?
For example:
select * from carbon_table where num = 1234567890123456.22;
Output:
+------+---------------------+--+ | name | num | +------+---------------------+--+ | IAA | 1234567890123456.22 | | IAA | 1234567890123456.21 | +------+---------------------+--+
Answer
To obtain accurate output, append BD to the number.
For example:
select * from carbon_table where num = 1234567890123456.22BD;
Output:
+------+---------------------+--+ | name | num | +------+---------------------+--+ | IAA | 1234567890123456.22 | +------+---------------------+--+
Parent topic: CarbonData FAQ