[MDEV-38635] TO_DATE: UBSAN errors in item_timefunc.h upon comparison with a view column - Jira

XML

Word

Printable

Type: Bug
Status: Open (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: N/A
Fix Version/s: 12.3
Component/s: Views
Labels:
None
Environment:

Hide
cmake . -DPLUGIN_TOKUDB=NO -DPLUGIN_COLUMNSTORE=NO -DPLUGIN_XPAND=NO -DWITH_EMBEDDED_SERVER=NO -DCMAKE_BUILD_TYPE=Debug -DWITH_UBSAN=YES -DMYSQL_MAINTAINER_MODE=OFF -DCMAKE_C_FLAGS="-Og -march=native -mtune=native" -DCMAKE_CXX_FLAGS="-Og -march=native -mtune=native" -DWITH_SAFEMALLOC=OFF

gcc 12.2.0 libubsan1:amd64 12.2.0-14

Show
cmake . -DPLUGIN_TOKUDB=NO -DPLUGIN_COLUMNSTORE=NO -DPLUGIN_XPAND=NO -DWITH_EMBEDDED_SERVER=NO -DCMAKE_BUILD_TYPE=Debug -DWITH_UBSAN=YES -DMYSQL_MAINTAINER_MODE=OFF -DCMAKE_C_FLAGS="-Og -march=native -mtune=native" -DCMAKE_CXX_FLAGS="-Og -march=native -mtune=native" -DWITH_SAFEMALLOC=OFF gcc 12.2.0 libubsan1:amd64 12.2.0-14

CREATE ALGORITHM=TEMPTABLE VIEW v AS select '2026-01-01' AS a;

SELECT * FROM v WHERE TO_DATE('10','HH') = a;

DROP VIEW v;

bb-12.3-MDEV-19683-to_date 7cbf7a8c641379d4318067607b71704956e87e5e
/data/bld/preview-12.3/bb-12.3-MDEV-19683-to_date-ubsan/sql/item_timefunc.h:1796:7: runtime error: load of value 2779096485, which is not a valid value for type 'PARSE_TYPE_FLAGS'

is caused by

MDEV-19683 Add support for Oracle TO_DATE()

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