[MDEV-26021] Character major lambda causes error in MariaDB monitor Created: 2021-06-25  Updated: 2021-08-07

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Insert
Affects Version/s: 10.5.10
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Karl Klepper Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

docker official

Attachments: GIF File ixh.gif    

 Description    

Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 32603
 
Server version: 10.5.10-MariaDB-1:10.5.10+maria~focal-log mariadb.org binary distribution
 
 
 
 CREATE TABLE `test` (
 
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
 
  `comment` char(60) COLLATE utf8_bin NOT NULL,
 
  UNIQUE KEY `id` (`id`)
 
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

In MariaDB monitor, the statement 

INSERT INTO test (comment) VALUES  'AΛΣ · IXH · XAN';

results in 

M:783520 [ci4]>\cINSERT INTO test (comment) VALUES  'A

No problem in adminer.

 Comments   
Comment by Sergei Golubchik [ 2021-07-17 ]

what locale did you set? what terminal emulator do you use?

Comment by Karl Klepper [ 2021-07-17 ]

1.

~# localectl
 
   System Locale: LANG=en_US.UTF-8
 
       VC Keymap: us
 
      X11 Layout: n/a

2.

SuperPuTTY

3.

~# localectl list-locales
 
C.utf8
 
en_AG
 
en_AU
 
en_AU.utf8
 
en_BW
 
en_BW.utf8
 
en_CA
 
en_CA.utf8
 
en_DK
 
en_DK.utf8
 
en_GB
 
en_GB.iso885915
 
en_GB.utf8
 
en_HK
 
en_HK.utf8
 
en_IE
 
en_IE.utf8
 
en_IE@euro
 
en_IL
 
en_IN
 
en_NG
 
en_NZ
 
en_NZ.utf8
 
en_PH
 
en_PH.utf8
 
en_SC.utf8
 
en_SG
 
en_SG.utf8
 
en_US
 
en_US.iso885915
 
en_US.utf8
 
en_ZA
 
en_ZA.utf8
 
en_ZM
 
en_ZW
 
en_ZW.utf8

4. adminer used: offcial docker container

Comment by Sergei Golubchik [ 2021-07-29 ]

it worked for me in the same locale, same server version, on focal. But not in SuperPuTTY. Could you try other console tools? bash? vi? anything linked with old readline?

Comment by Karl Klepper [ 2021-07-29 ]

I'd like to but don't know what to do.

I fired up plain PuTTY but that one didn't even accept my insert string. SmarTTY does not accept these characters either. Same with PuttyTabs or KiTTY, they are all based on PuTTY. Windows ssh shows same symptoms.

Unfortunately I don't understand your hint. How could I connect to the linux server from windows with bash or vi?

Comment by Karl Klepper [ 2021-07-29 ]

I tried with Bitvise xterm also. The screenshot shows that the terminal can cope with these characters, the mysql client does not (each inserted from clipboard).

Comment by Sergei Golubchik [ 2021-08-07 ]

wlad, any windows specific comments or questions here?

Comment by Vladislav Vaintroub [ 2021-08-07 ]

Nope, I have no idea of the terminal emulators that are mentioned here. If the Windows bash does not play well, here one can file a bug https://github.com/microsoft/WSL/issues

Generated at Thu Feb 08 09:42:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.