[MDEV-20826] Wrong result of MIN(inet6) with GROUP BY - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5
Fix Version/s: 10.5.0
Component/s: Data types
Labels:
None

Description

CREATE OR REPLACE TABLE t1 (id INT, a INET6) ENGINE=MyISAM;

INSERT INTO t1 VALUES (1, 'fff::'),(1, '8888::');

SELECT MIN(a), MAX(a) FROM t1 GROUP BY id;

+--------+--------+

| MIN(a) | MAX(a) |

+--------+--------+

| 8888:: | fff::  |

+--------+--------+

Looks wrong. The INET6 value '8888::' is greater than 'fff::'.

Attachments

Issue Links

relates to

MDEV-274 The data type for IPv6/IPv4 addresses in MariaDB

Closed

MDEV-20784 Testing for MDEV-274 (INET6, data type for IPv6/IPv4 addresses)

Closed

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2019-10-14 14:18

Alexander Barkov made changes - 2019-10-14 14:18

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-20784~~ [ ~~MDEV-20784~~ ]

Alexander Barkov made changes - 2019-10-14 14:18

Link

This issue relates to ~~MDEV-274~~ [ ~~MDEV-274~~ ]

Alexander Barkov made changes - 2019-10-14 14:32

issue.field.resolutiondate

2019-10-14 14:32:16.0

2019-10-14 14:32:16.98

Alexander Barkov made changes - 2019-10-14 14:32

Fix Version/s		10.5.0 [ 23709 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:50

Workflow

MariaDB v3 [ 100409 ]

MariaDB v4 [ 156862 ]

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2019-10-14 14:18

Updated:: 2019-10-14 14:32

Resolved:: 2019-10-14 14:32

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server