Return the current field definition in PROCEDURE ANALYSE

Registered by Alexey Kopytov on 2012-11-20

Extend PROCEDURE ANALYSE output with the current field definition, e.g.:

mysql> select * from t2 procedure analyse()\G
*************************** 1. row ***************************
             Field_name: test.t2.id
      Field_type: INT(11) NOT NULL
              Min_value: 1
              Max_value: 2
             Min_length: 1
             Max_length: 1
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 1.5000
                    Std: 0.5000
      Optimal_fieldtype: ENUM('1','2') NOT NULL
*************************** 2. row ***************************
             Field_name: test.t2.a
      Field_type: INT(11) NOT NULL
              Min_value: 1
              Max_value: 2
             Min_length: 1
             Max_length: 1
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 1.5000
                    Std: 0.5000
      Optimal_fieldtype: ENUM('1','2') NOT NULL
*************************** 3. row ***************************
             Field_name: test.t2.foo
      Field_type: INT(11) NOT NULL
              Min_value: 1
              Max_value: 2
             Min_length: 1
             Max_length: 1
       Empties_or_zeros: 0
                  Nulls: 0
Avg_value_or_avg_length: 1.5000
                    Std: 0.5000
      Optimal_fieldtype: ENUM('1','2') NOT NULL
3 rows in set (0.00 sec)

Blueprint information

Status:
Not started
Approver:
None
Priority:
Low
Drafter:
Alexey Kopytov
Direction:
Approved
Assignee:
None
Definition:
Approved
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.