[MCOL-5255] lc_time_names Created: 2022-10-10  Updated: 2022-11-01

Status: Confirmed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.4.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: andreas eschbacher Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Mariadb 10.6.10 Columnstore 6.4.3

Attachments: File columnstore.sql     File innodb.sql    
Issue Links:
Duplicate
duplicates MCOL-4032 Fix DAYNAME(), MONTHNAME() and DATE_F... Open

 Description   

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!

 Comments   
Comment by alexey vorovich (Inactive) [ 2022-10-12 ]

aeae81 First of all, the team would like to thank you for the detailed bug reports.
that helps a lot.
One small request.
In majority of cases you do upload a full .sql script that builds tables and shows the problem. If you could do that in *all *cases that would help us

thnks

Generated at Thu Feb 08 02:56:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.