diff options
| author | Alexander Barkov <bar@mariadb.com> | 2022-08-02 16:23:08 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2022-08-05 22:23:40 +0400 |
| commit | 3ebbfd88a0360938e3a5a480265beb2a71b1268a (patch) | |
| tree | 2168fd64b64e21aa391746019414055b326fb0b8 /sql/item_cmpfunc.cc | |
| parent | 97d16c7544c40430facda441dab89fa4b23468a0 (diff) | |
| download | mariadb-git-3ebbfd88a0360938e3a5a480265beb2a71b1268a.tar.gz | |
MDEV-29159 Patch for MDEV-28918 introduces more inconsistency than it solves, breaks usability
1. Store assignment failures on incompatible data types now raise errors if:
- STRICT_ALL_TABLES or STRICT_TRANS_TABLES sql_mode is used, and
- IGNORE is not used
Otherwise, only a warning is raised and the statement continues.
2. Changing the error/warning test as follows:
-ERROR HY000: Illegal parameter data types inet6 and int for operation 'SET'
+ERROR HY000: Cannot cast 'int' as 'inet6' in assignment of `db`.`t`.`col`
so in case of a big table it's easier to see which column has the problem.
The new error text is also applied to SP variables.
Diffstat (limited to 'sql/item_cmpfunc.cc')
0 files changed, 0 insertions, 0 deletions