You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
drop table if exists tb5;
create table tb5(a double, b float);
insert into tb5 (a, b) values (184467440737095516160, 184467440737095516160);
select * from tb5 where cast(a as unsigned int)=0;
show warnings;
2. What did you expect to see? (Required)
Result same
3. What did you see instead (Required)
Not same
Unistore
mysql> show warnings;
+---------+------+-------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------+
| Warning | 1690 | constant 1.844674407370955e+20 overflows bigint |
+---------+------+-------------------------------------------------+
1 row in set (0.00 sec)
create table tb5(a int(10));
insert into tb5 (a) values (10);
select * from tb5 where a - -9223372036854775808;
-Error 1690 (22003): BIGINT value is out of range in '(Column#0 - -9223372036854775808)'+Error 1690 (22003): BIGINT value is out of range in '(10 - -9223372036854775808)'
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
Result same
3. What did you see instead (Required)
Not same
Unistore
TiKV
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: