Details
-
Task
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
Provide a server mode to prevent truncation of numerical data:
Test case :
use test; |
set sql_mode = 'STRICT_TRANS_TABLES'; |
drop table if exists t; |
create table t(c DECIMAL(4,2) not null); |
insert into t(c) values (1.234); |
show warnings;
|
select * from t; |
Instead of warning provide a mechanism to error.