[MDEV-35121] Although the CASE WHEN clause returns the same value as the direct concatenation, FIELD yields different results in each case. - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 11.4.2
Fix Version/s: N/A
Component/s: Data types
Labels:
None
Environment:
ubuntu 20.04

Description

select FIELD((case when true then ('i' || 'o') else '0' end), 'c') as c0;

+----+

| c0 |

+----+

|  0 |

+----+

1 row in set, 2 warnings (0.00 sec)

select FIELD(('i' || 'o'), 'c') as c0;

+----+

| c0 |

+----+

|  1 |

+----+

1 row in set, 3 warnings (0.00 sec)

The condition for CASE WHEN is TRUE, so this clause should return the result of ('i' || 'o'). This statement should return the same value as select FIELD(('i' || 'o'), 'c') as c0;, but the actual result is not the same.

Attachments

Activity

Ascending order - Click to sort in descending order

HeShan created issue - 2024-10-11 03:17

Daniel Black made changes - 2024-10-11 07:57

Field	Original Value	New Value
Fix Version/s		10.5 [ 23123 ]

Daniel Black made changes - 2024-10-11 07:57

Component/s

Data types [ 13906 ]

Daniel Black made changes - 2024-10-11 08:01

Assignee

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2024-11-21 08:17

issue.field.resolutiondate

2024-11-21 08:17:45.0

2024-11-21 08:17:45.28

Alexander Barkov made changes - 2024-11-21 08:17

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Not a Bug [ 6 ]
Status	Open [ 1 ]	Closed [ 6 ]

People

Assignee:: Alexander Barkov

Reporter:: HeShan

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2024-10-11 03:17

Updated:: 2024-11-21 08:17

Resolved:: 2024-11-21 08:17

Git Integration

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

MariaDB Server