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

Different justification behaviour for integer mysql client output

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL)
    • 10.2.16, 10.3.8
    • libmariadb
    • None

    Description

      Justification is different between Columnstore

      To reproduce:

      connect with mysql client.

       
      		 
      Columnstore 1.1
      		 
       
      		 
       MariaDB [(none)]> select 'blub',sum(3454435+43244);
      		 
       +------+--------------------+
      		 
       | blub | sum(3454435+43244) |
      		 
       +------+--------------------+
      		 
       | blub | 3497679            |
      		 
       


       MariaDB 10.1
      		 
       
       MariaDB [mysql]>  select 'blub',sum(3454435+43244);
      		 
       +------+--------------------+
      		 
       | blub | sum(3454435+43244) |
      		 
       +------+--------------------+
      		 
       | blub |            3497679 |
      		 
       +------+--------------------+

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15459 Window Functions seems to return string instead of numbers

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            Something has changed on the client side between 10.2.1 and 10.2.2:

            $ /data/releases/10.2.2/bin/mysql -uroot --protocol=tcp -e "select 'blub',sum(3454435+43244);"
            		 
            +------+--------------------+
            		 
            | blub | sum(3454435+43244) |
            		 
            +------+--------------------+
            		 
            | blub | 3497679            |
            		 
            +------+--------------------+
            		 
            $ /data/releases/10.2.1/bin/mysql -uroot --protocol=tcp -e "select 'blub',sum(3454435+43244);"
            		 
            +------+--------------------+
            		 
            | blub | sum(3454435+43244) |
            		 
            +------+--------------------+
            		 
            | blub |            3497679 |
            		 
            +------+--------------------+

            elenst Elena Stepanova added a comment - Something has changed on the client side between 10.2.1 and 10.2.2: $ /data/releases/10.2.2/bin/mysql -uroot --protocol=tcp -e "select 'blub',sum(3454435+43244);" + ------+--------------------+ | blub | sum (3454435+43244) | + ------+--------------------+ | blub | 3497679 | + ------+--------------------+ $ /data/releases/10.2.1/bin/mysql -uroot --protocol=tcp -e "select 'blub',sum(3454435+43244);" + ------+--------------------+ | blub | sum (3454435+43244) | + ------+--------------------+ | blub | 3497679 | + ------+--------------------+
            georg Georg Richter added a comment - - edited

            It will be pushed after merge of diverged branches is finished.

            The IS_NUM macro was never updated (MariaDB Connector/C was built on top of LGPL MySQL 3.23.58 client library).

            Additional todo's:

            • Prefixing all macro's with MARIADB_ prefix (for backwards compatibiliry we will still support the IS_ macros
            • Adding documentation for definitions
            georg Georg Richter added a comment - - edited It will be pushed after merge of diverged branches is finished. The IS_NUM macro was never updated (MariaDB Connector/C was built on top of LGPL MySQL 3.23.58 client library). Additional todo's: Prefixing all macro's with MARIADB_ prefix (for backwards compatibiliry we will still support the IS_ macros Adding documentation for definitions

            People

              georg Georg Richter
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.