[MDEV-31852] COERCIBILITY(NULL) returns 6 instead of 5 Created: 2023-08-04  Updated: 2023-08-16  Resolved: 2023-08-16

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 10.6.14
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

The KB says that COERCIBILITY(NULL) should return 5, but it returns 6.

https://mariadb.com/kb/en/coercibility/

Steps to reproduce

SELECT COERCIBILITY(NULL);

Actual results

MariaDB [(none)]> SELECT COERCIBILITY(NULL);
 
+--------------------+
 
| COERCIBILITY(NULL) |
 
+--------------------+
 
|                  6 |
 
+--------------------+
 
1 row in set (0.000 sec)

Expected results

According to the KB, it should return 5.

 Comments   
Comment by Alexander Barkov [ 2023-08-16 ]

ralf.gebhardt, GeoffMontee, the KB article was wrong.
I've updated it and added more examples.

Generated at Thu Feb 08 10:26:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.