Using the ubuntu 14.04 mariadb (5.5.46), convert_tz unexpectedly
returns a time with fractional seconds if its first argument is an
expression using a column. This doesn't happen with mysqldb 5.5.46.
Example:
select
convert_tz(concat('2006-05-25 17:45:00',''),'+00:00','+00:00') no_columns_used,
convert_tz(concat('2006-05-25 17:45:00',blank),'+00:00','+00:00') column_used
from (select '' blank) foo \G
*************************** 1. row ***************************
no_columns_used: 2006-05-25 17:45:00
column_used: 2006-05-25 17:45:00.000000
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
