[MDEV-33084] LASTVAL(t1) and LASTVAL(T1) do not work well with lower-case-table-names=0 - Jira

I run this script:

create or replace sequence t1;

create or replace sequence T1;

select nextval(t1), lastval(t1);

select nextval(T1), lastval(T1);

select lastval(t1), lastval(T1);

The last statement returnt these results:

+-------------+-------------+

| lastval(t1) | lastval(T1) |

+-------------+-------------+

|        NULL |        NULL |

+-------------+-------------+

Look wrong. The expected result should be:

+-------------+-------------+

| lastval(t1) | lastval(T1) |

+-------------+-------------+

|           1 |           1 |

+-------------+-------------+

relates to

MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()

Alexander Barkov created issue - 2023-12-20 11:05

Alexander Barkov made changes - 2023-12-20 11:05

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-31340~~ [ ~~MDEV-31340~~ ]

Alexander Barkov made changes - 2023-12-20 12:27

Assignee

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2024-05-21 11:39

Daniel Bartholomew made changes - 2024-05-29 17:16

Fix Version/s		11.4.3 [ 29837 ]
Fix Version/s		11.5.2 [ 29838 ]

Daniel Bartholomew made changes - 2024-05-29 17:16

Fix Version/s	11.4.2 [ 29633 ]
Fix Version/s	11.5.1 [ 29634 ]

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

MariaDB Server