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

Client Program Displays field differently with \G

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Incomplete
        • Affects Version/s: 5.5.40
        • Fix Version/s: N/A
        • Component/s: OTHER
        • Labels:
          None

          Description

          I was working trying to remove some corrupt data from a table and noticed that the field was being displayed differently depending on whether or not I used the \G modifier on the query...

          
mysql> select pid from players where id=29354221;
+------------+
| pid        |
+------------+
|  s p c i a |
+------------+
1 row in set (0.00 sec)

mysql> select pid from players where id=29354221\G
*************************** 1. row ***************************
pid:
1 row in set (0.00 sec)

mysql> select hex(pid) from players where id=29354221\G
*************************** 1. row ***************************
hex(pid): 00730070006300690061
1 row in set (0.01 sec)

            Gliffy Diagrams

              Attachments

                Activity

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

                Could you please paste the output of SHOW CREATE TABLE players and SHOW VARIABLES?
                Thanks.

                Show
                elenst Elena Stepanova added a comment - Could you please paste the output of SHOW CREATE TABLE players and SHOW VARIABLES ? Thanks.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Closing as incomplete for now.
                Please comment to re-open if you have the requested information.

                Show
                elenst Elena Stepanova added a comment - Closing as incomplete for now. Please comment to re-open if you have the requested information.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    steveb3210 Stephen Blackstone
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Due:
                      Created:
                      Updated:
                      Resolved: