When expression results in data overflow, no error or warning was returned

Bug #461490 reported by mroberts
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
InfiniDB Community
Confirmed
Medium
Unassigned

Bug Description

When aggregate functions result in a value larger than what Calpont can handle,
an overflow error is returned. But for expression in the projection results in
an overflow, it will just return whatever values there is, without error or
warnings. The user, or automated result checker, will not be able to know
if such condition has occurred and will get the incorrect data.

The same also occurs to the expression in the where caluse. Incorrect result
will be returned.

Example of overflow:

create table t1 (col1 decimal(6,4)) engine=infinidb;
insert into t1 values (10.0001);
select col1*2.0002*2.0000002*0.999999999999 from t1;

mroberts (mroberts)
Changed in infinidb:
importance: Undecided → Medium
status: New → Confirmed
mroberts (mroberts)
description: updated
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.