[MDEV-7306] Client Program Displays field differently with \G Created: 2014-12-11  Updated: 2014-12-27  Due: 2014-12-27  Resolved: 2014-12-27

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 5.5.40
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Stephen Blackstone Assignee: Unassigned
Resolution: Incomplete Votes: 0
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)
 
 



 Comments   
Comment by Elena Stepanova [ 2014-12-12 ]

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

Comment by Elena Stepanova [ 2014-12-27 ]

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

Generated at Thu Feb 08 07:18:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.