maria-discuss team mailing list archive

Thread
Date

Since MariaDB 10.1 aggregate functions return different field type for columns with date values

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Stefan Langenmaier <stefan.langenmaier@xxxxxxxxxxx>
Date: Tue, 2 Jul 2019 17:38:29 +0200
Openpgp: preference=signencrypt
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.1

Hi all,

If I execute the following query on MariaDB 10.1 or later, the result
contains a column with a datetime field type (MYSQL_TYPE_DATETIME):

SELECT MIN(NOW()) AS t

On older versions or any version of MySQL this column is a text type
(MYSQL_TYPE_VAR_STRING).

https://dev.mysql.com/doc/dev/mysql-server/latest/field__types_8h.html

Is there a possibility to use the old behavior in newer version?

Best regards,
Stefan

-- 
Stefan Langenmaier
Senior Operations Engineer

makandra GmbH
Werner-von-Siemens-Str. 6
86159 Augsburg

Fon +49 (0) 821 58866 178

Geschäftsführer: Dr. Thomas Eisenbarth, Henning Koch
Amtsgericht Augsburg, HRB 24202

Follow ups

Re: Since MariaDB 10.1 aggregate functions return different field type for columns with date values
From: Sergei Golubchik, 2019-07-03