[MDEV-5956] DAYNAME() behaves like WEEKDAY() in numeric context Created: 2014-03-26  Updated: 2017-11-05

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

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None


 Description    

mysql> select weekday(now()),dayname(now()),dayname(now())+1;
 
+----------------+----------------+------------------+
 
| weekday(now()) | dayname(now()) | dayname(now())+1 |
 
+----------------+----------------+------------------+
 
|              2 | Wednesday      |                3 |
 
+----------------+----------------+------------------+
 
1 row in set (0.00 sec)

3 is wrong for the third column.
It's not clear why 'Wednesday'+1 should return 3.
The expected result is 1 with a warning.

 Comments   
Comment by Sergei Golubchik [ 2014-03-31 ]

should we document it or fix?

Comment by Alexander Barkov [ 2014-04-01 ]

I'd better fix this.
We have WEEKDAY() for use as a number.

Generated at Thu Feb 08 07:08:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.