[MDEV-5880] Inconsistent field flags for int_field and COALESCE(int_field) Created: 2014-03-17  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.36, 10.0.9
Fix Version/s: 5.5

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: 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.
Generated at Thu Feb 08 07:07:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.