| Bug #56320 | group_concat results is showing as BLOB format whiel dates | ||
|---|---|---|---|
| Submitted: | 27 Aug 2010 5:45 | Modified: | 27 Aug 2010 7:21 |
| Reporter: | Anil Alpati | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.45 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[27 Aug 2010 5:58]
Valeriy Kravchuk
It is shown as blob because the result is BLOB:
macbook-pro:5.1 openxs$ bin/mysql --column-type-info -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.51-debug Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select group_concat(curdate())
-> ;
Field 1: `group_concat(curdate())`
Catalog: `def`
Database: ``
Table: ``
Org_table: ``
Type: BLOB
Collation: binary (63)
Length: 1024
Max_length: 10
Decimals: 0
Flags: BINARY
+-------------------------+
| group_concat(curdate()) |
+-------------------------+
| 2010-08-27 |
+-------------------------+
1 row in set (0.00 sec)
I do not know what exact version of Query Browser or Workbench do you use (MySQL Workbench 5.2.26 shows me the result as text), but this is definitely not a server bug.
[27 Aug 2010 7:21]
Anil Alpati
I am using "QueryBrowser 1.2.17" Version not "MySQL Workbench 5.2.26" Okay... currently type casting the date as string and displaying as given below mysql> select CAST(group_concat(curdate()) as DATE); +---------------------------------------+ | CAST(group_concat(curdate()) as DATE) | +---------------------------------------+ | 2010-08-27 | +---------------------------------------+ 1 row in set (0.00 sec)
Description: When ever I execute this query in query browser select group_concat(curdate()) Output show as BLOB format. I could not able to see date As the same query which I execute in command line . I am able to exact output Below is result is just for your reference mysql> select group_concat(curdate()) -> ; +-------------------------+ | group_concat(curdate()) | +-------------------------+ | 2010-08-27 | +-------------------------+ 1 row in set (0.00 sec) mysql> Please help me out to fix this issue Awaiting from your response at your earliest. Thanks a ton! How to repeat: same as aboe