[MDEV-459] DNAMES: column_list returns an empty string if at least one column has a symbolic name Created: 2012-08-16  Updated: 2012-08-20  Resolved: 2012-08-20

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.0

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-377 Name support for dynamic columns Closed

 Description   

select column_list(column_create('a', 'val1'));
# +-----------------------------------------+
# | column_list(column_create('a', 'val1')) |
# +-----------------------------------------+
# |                                         |
# +-----------------------------------------+
# 1 row in set (0.00 sec)
 
select length(column_list(column_create('a', 'val1')));
# +-------------------------------------------------+
# | length(column_list(column_create('a', 'val1'))) |
# +-------------------------------------------------+
# |                                               0 |
# +-------------------------------------------------+
# 1 row in set (0.00 sec)
 

For numeric identifiers seems to work all right:

select column_list(column_create(1, 'val1'));
 
# +---------------------------------------+
# | column_list(column_create(1, 'val1')) |
# +---------------------------------------+
# | `1`                                   |
# +---------------------------------------+
# 1 row in set (0.00 sec)
 
select length(column_list(column_create(1, 'val1')));
# +-----------------------------------------------+
# | length(column_list(column_create(1, 'val1'))) |
# +-----------------------------------------------+
# |                                             3 |
# +-----------------------------------------------+
# 1 row in set (0.00 sec)

bzr version-info

revision-id: elenst@ubuntu11.home-20120813090607-jtuq5p0umts16h5h
date: 2012-08-13 13:06:07 +0400
build-date: 2012-08-16 04:26:14 +0400
revno: 3490



 Comments   
Comment by Oleksandr Byelkin [ 2012-08-20 ]

Fixed

Generated at Thu Feb 08 06:28:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.