[MDEV-34215] SELECT DATE_FORMAT(..., %h) gives incorrect result with cursor protocol - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5(EOL), 10.6(EOL), 10.11, 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL)
Fix Version/s: 10.11.20, 11.4.14, 11.8.10, 12.3.4, 13.1.2
Component/s: Temporal Types
Labels:
- contribution

Bug Category:
Unexpected results
Release Note Summary:
The DATE_FORMAT SQL function when a negative result returned had an incorrect result when used in a VIEW or the cursor protocol; Fixed thanks to Rion Bora

Description

SELECT DATE_FORMAT(..., %h) gives incorrect result with cursor protocol. Problem repeats only with option %h (hour with 2 digits between 01-12).
Case: (run MTR test with --cursor-protocol):

CREATE VIEW v AS SELECT DATE_FORMAT(TIME'-01:01:01','%h');

SELECT * FROM v;

DROP VIEW v;

Expected result:

DATE_FORMAT(TIME'-01:01:01','%h')

-01

Actual result:

DATE_FORMAT(TIME'-01:01:01','%h')

-0

Attachments

Issue Links

relates to

MDEV-31005 Make working ./mtr --cursor-protocol

Stalled

MDEV-33936 Select from view defined as SELECT DATE_FORMAT(..., %h) gives incorrect result

Open

Activity

People

Assignee:: Georgi Kodinov

Reporter:: Lena Startseva

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-05-22 13:09

Updated:: 2026-10-01 23:30

Resolved:: 2026-10-01 23:30

Time Tracking

Estimated:

Remaining:

Logged:

40m

Git Integration

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