Bug #60719 | Field info in EXPLAIN EXT./GROUP BY WITH ROLLUP says NOT NULL and contains NULL | ||
---|---|---|---|
Submitted: | 1 Apr 2011 8:40 | Modified: | 11 Feb 2018 13:27 |
Reporter: | - - | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.5.10, 5.5.9 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | explain, extended, null |
[1 Apr 2011 8:40]
- -
[1 Apr 2011 8:57]
Valeriy Kravchuk
Verified on Windows XP: C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql -uroot -proot -P3312 --column- type-info test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.9 MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT q.server, q.cnt -> FROM ( -> SELECT 'test1' server, 1 cnt -> UNION ALL SELECT 'test2', 2 -> ) q -> GROUP BY q.server WITH ROLLUP; Field 1: `server` Catalog: `def` Database: `` Table: `q` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 15 Max_length: 5 Decimals: 0 Flags: NOT_NULL Field 2: `cnt` Catalog: `def` Database: `` Table: `q` Org_table: `` Type: LONGLONG Collation: binary (63) Length: 20 Max_length: 1 Decimals: 0 Flags: NOT_NULL NUM +--------+-----+ | server | cnt | +--------+-----+ | test1 | 1 | | test2 | 2 | | NULL | 2 | +--------+-----+ 3 rows in set (0.05 sec)
[11 Feb 2018 13:27]
Roy Lyseng
Posted by developer: Closing bug as it has been suspended for more than 6 years.