Hi All!
I installed 3.23.22 from source on the weekend without any problems..
But later (today) i relalized that some of the queries return different
result since the upgrade.
The problem itself:
on 3.23.21:
select date_add(curdate(),INTERVAL 1 DAY) -> "2000-08-08"
on 3.23.22:
select date_add(curdate(),INTERVAL 1 DAY) -> "2000-08-08 00:00:00"
it changes the return value to datetime, which is bad in a query where
the original field is a date and your where condition looks like
date_add(<date column>, INTERVAL <integer column> days)<curdate()
hope this helps. thanx for the great support.
4 messages in com.mysql.lists.bugsdate_add behaviour changed between 3....