[MCOL-5255] lc_time_names - Jira

XML

Word

Printable

Columnstore ignores lc_time_names settings:

Columnstore:

insert into test.test2_cs(id,date_string, date_date,date_datetime) values (1,'2022-10-10 15:45:15', date(now()), now());

set lc_time_names='es_ES';

select monthname(date_string) from test.test2_cs;

select monthname(date_date) from test.test2_cs;

select monthname(date_datetime) from test.test2_cs;

result is always in english:

---------------------------------
innodb:

insert into test.test1(id,date_string, date_date,date_datetime) values (1,'2022-10-10 15:45:15', date(now()), now());

set lc_time_names='es_ES';

select monthname(date_string) from test.test1;

select monthname(date_date) from test.test1;

select monthname(date_datetime) from test.test1;

result is in spanish!

duplicates

MCOL-4032 Fix DAYNAME(), MONTHNAME() and DATE_FORMAT() to use MDB Locale

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