Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.3.37, 10.4.27, 10.5.18, 10.6.10, 10.7.7, 10.8.6, 10.9.4, 10.10.2, 10.11.1
Description
The below worked fine so far, as expected, but starts to throw unexpected
ERROR 1292 (22007) at line 15: Truncated incorrect DECIMAL value: '#'
|
in most recent releases. I looked over the 10.3.37 (lowest version release I can reproduce this on) release notes and changelog page, but could not find any change that seemed to be related to this change in behavior ...
drop table if exists t1; |
drop table if exists t2; |
|
create table t1(c1 varchar(1)); |
create table t2(c1 varchar(1)); |
|
set session sql_mode = STRICT_TRANS_TABLES; |
|
insert into t1(c1) values('#'); |
|
insert into t2(c1) |
select if(c1 = '#', c1 = 0, c1) as c1 |
from t1; |
|
Attachments
Issue Links
- is caused by
-
MDEV-29540 Incorrect sequence values in INSERT SELECT
- Closed