Details
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 cursor-protocol
-
- Stalled
-
-
MDEV-33936 Select from view defined as SELECT DATE_FORMAT(..., %h) gives incorrect result
-
- Open
-