[MDEV-14084] Select 1='' results TRUE Created: 2017-10-17 Updated: 2017-11-20 Resolved: 2017-11-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data types, Optimizer, Parser |
| Affects Version/s: | 10.2.9 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | miracee | Assignee: | Sergei Golubchik |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | datatype, regression | ||
| Environment: |
Ubuntu 16.04 |
||
| Description |
|
In cli
It results 1 Same with
Looks like the empty string will be converted to numeric. Btw. this is mariadb only. MySQL results 0. Best Regards, Susanne |
| Comments |
| Comment by Elena Stepanova [ 2017-10-18 ] |
|
Please paste the actual unabridged output from the client demonstrating the result, and also the output of SHOW VARIABLES from the same session. |