Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.36, 10.0.9
-
None
-
None
Description
Run "mysql --column-type-info test" and execute this script:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a tinyint);
|
INSERT INTO t1 VALUES(1);
|
SELECT a, COALESCE(a) FROM t1;
|
The output is:
Field 1: `a`
|
Catalog: `def`
|
Database: `test`
|
Table: `t1`
|
Org_table: `t1`
|
Type: TINY
|
Collation: binary (63)
|
Length: 4
|
Max_length: 1
|
Decimals: 0
|
Flags: NUM
|
|
|
Field 2: `COALESCE(a)`
|
Catalog: `def`
|
Database: ``
|
Table: ``
|
Org_table: ``
|
Type: TINY
|
Collation: binary (63)
|
Length: 4
|
Max_length: 1
|
Decimals: 0
|
Flags: BINARY NUM
|
|
|
+------+-------------+
|
| a | COALESCE(a) |
|
+------+-------------+
|
| 1 | 1 |
|
+------+-------------+
|
1 row in set (0.00 sec)
|
Notice, "Flags" is NUM for the field, but "BINARY NUM" for the function.
It should be fixed to return the same flag sets.