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

XML

Word

Printable

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()

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