Skip to content

date_format with "\n" as pattern has different behavior with MySQL  #32232

@lzmhhh123

Description

@lzmhhh123

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(dt datetime);

explain select * from t where dt <= date_format('2022-02-09', '%Y-%m-%d 16:33:00');

explain select * from t where dt <= date_format('2022-02-09', '%Y-%m-%d
16:33:00');

2. What did you expect to see? (Required)

The selection condition of execution plan in both sqls are le(test.t.dt, 2022-02-09 16:33:00.000000)

3. What did you see instead (Required)

The second is le(test.t.dt, NULL)

4. What is your TiDB version? (Required)

4.0, 5.0, 5.1, and older 5.1 versions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-4.0This bug affects 4.0.x versions.affects-5.0This bug affects 5.0.x versions.affects-5.1This bug affects 5.1.x versions.affects-5.2This bug affects 5.2.x versions.affects-5.3This bug affects 5.3.x versions.affects-5.4This bug affects the 5.4.x(LTS) versions.severity/majorsig/executionSIG executiontype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions