[MDEV-20829] Ugly name qualification in ER_TRUNCATED_WRONG_VALUE_FOR_FIELD message Created: 2019-10-14  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None


 Description    

create procedure pr(a int) select a;
 
set sql_mode='';
 
call pr('foo');
 
set sql_mode='STRICT_ALL_TABLES';
 
call pr('foo');
 
drop procedure pr;


MariaDB [test]> show warnings;
 
+---------+------+--------------------------------------------------------------+
 
| Level   | Code | Message                                                      |
 
+---------+------+--------------------------------------------------------------+
 
| Warning | 1366 | Incorrect integer value: 'foo' for column ``.``.`a` at row 1 |
 
+---------+------+--------------------------------------------------------------+
 
1 row in set (0.000 sec)


ERROR 1366 (22007): Incorrect integer value: 'foo' for column ``.``.`a` at row 1



 Comments   
Comment by Elena Stepanova [ 2021-03-17 ]

Here is another variation:

10.6

 
MariaDB [test]> SELECT * FROM (SELECT 1 AS a) t1 JOIN (SELECT CAST('2021-12-12' AS DATE) AS b) t2 ON t1.a = t2.b;
 
Empty set, 1 warning (0.001 sec)
 
 
 
MariaDB [test]> show warnings;
 
+---------+------+------------------------------------------------------------------------+
 
| Level   | Code | Message                                                                |
 
+---------+------+------------------------------------------------------------------------+
 
| Warning | 1292 | Incorrect datetime value: '1' for column ``.`(temporary)`.`a` at row 1 |
 
+---------+------+------------------------------------------------------------------------+
 
1 row in set (0.000 sec)

Generated at Thu Feb 08 09:02:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.