setting lc_time_names has no effect (MariaDB)

[aedion-a]

Introduction

SET lc_time_names doesn't work in SQLPage but works directly on MariaDB.

To Reproduce

In DB Editor (DBeaver) :

SELECT @@lc_time_names; 
-- en_US
SELECT MONTHNAME(CURRENT_DATE);
-- June

SET lc_time_names = 'fr_FR';
SELECT @@lc_time_names;
-- fr_FR
SELECT MONTHNAME(CURRENT_DATE);
-- Juin

Actual behavior

In SQLPage

SET lc_time_names = 'fr_FR';

set $monthn0  = MONTHNAME(CURRENT_DATE);

select 'text'      as component,
        $monthn0   as contents_md;
-- June

Version information

• OS: Ubuntu 24.04 LTS
• mariadb Ver 15.1 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
• SQLPage 0.44

[lovasoa]

Hi !

I understand this may be surprising, but this is documented in sqlpage's sql guide: https://sql-page.com/extensions-to-sql. SET lc_time_names = 'fr_FR'; sets a SQLPage variable, not a MySQL variable.

If you want to set a global mysql variable, the best way to do so in in sqlpage/on_connect.sql