0

I just stumbled over this:

mysql> select "abc" = 0;
+-----------+
| "abc" = 0 |
+-----------+
|         1 |
+-----------+
1 row in set, 1 warning (0.06 sec)

mysql> show warnings;
+---------+------+-----------------------------------------+
| Level   | Code | Message                                 |
+---------+------+-----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'abc' |
+---------+------+-----------------------------------------+
1 row in set (0.06 sec)

What's happening here? Where are the implicit type casts documented?

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by pritaeas
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.