[MDEV-29542] The first character in column name has lowercase instead of uppercase in view created on table " mysql.user" Created: 2022-09-15  Updated: 2023-09-26  Resolved: 2023-09-26

Status: Closed
Project: MariaDB Server
Component/s: Views
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.4.32

Type: Bug Priority: Major
Reporter: Lena Startseva Assignee: Oleksandr Byelkin
Resolution: Not a Bug Votes: 0
Labels: view-protocol

Issue Links:
PartOf
is part of MDEV-27691 make working view-protocol Open
Problem/Incident
is caused by MDEV-17658 change the structure of mysql.user table Closed

 Description   

Test:

create view v1 as select host,user from mysql.user where (host,user) = ('localhost','test');
 
select * from v1;
 
drop view v1;

Expected result:

Host	User

Actual result:

host	user

Problem appeared after MDEV-17658

 Comments   
Comment by Oleksandr Byelkin [ 2022-12-01 ]

It looks like SELECT take the name from the field, but VIEW takes name from SELECT list name

Comment by Oleksandr Byelkin [ 2023-09-26 ] 

create view v1 as select Host,User from mysql.user where (host,user) = ('localhost','test');
 
select * from v1;
 
Host	User
 
drop view v1;

so it is how you name it and everything is OK

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