Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-459

DNAMES: column_list returns an empty string if at least one column has a symbolic name

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 10.0.0
        • Component/s: None
        • Labels:
          None

          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

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-377 Name support for dynamic columns

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                  Activity

                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment -

                  Fixed

                  Show
                  sanja Oleksandr Byelkin added a comment - Fixed

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: