[#MDEV-8984] LEAST datatype error

[MDEV-8984] LEAST datatype error Created: 2015-10-22 Updated: 2016-03-24
Status:	Open
Project:	MariaDB Server
Component/s:	OTHER
Affects Version/s:	10.1.8
Fix Version/s:	10.1

Type:

Bug

Priority:

Minor

Reporter:

Diego Dupin

Assignee:

Alexander Barkov

Resolution:

Unresolved

Votes:

Labels:

None

Issue Links:

Relates
relates to	~~MDEV-4848~~	Wrong metadata or column type for LEA...	Closed

Description

Problem : When LEAST function compare 2 bigintegers, datatype decimal is return.

example:

drop table if exists t1; create table t1 as select LEAST(100, 18446744073709551615) as a; show columns from t1;

now return type is "decimal(20,0)". In previous version, was "bigint(21)".

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