Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.3.7, 10.2
Description
When I create a table, I get different presentations when I execute the DESCRIBE statement for the default values of the text based fields.
For example, If I create a varchar field, I get the default value without quotation marks when I execute the DESCRIBE statement, but when I create a text field (text, tinytext, mediumtext or longtext), I get the default value with quotation marks when I execute the DESCRIBE statement.
I have attached a test case file.
The actual result is:
+-------------+--------------+------+-----+---------+----------------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------------+--------------+------+-----+---------+----------------+
|
| id | int(11) | NO | PRI | NULL | auto_increment | |
| some_number | int(11) | NO | | 0 | |
|
| some_text1 | char(255) | NO | | | |
|
| some_text2 | varchar(255) | NO | | | |
|
| some_text3 | text | NO | | '' | | |
| some_text4 | tinytext | NO | | '' | | |
| some_text5 | mediumtext | NO | | '' | | |
| some_text6 | longtext | NO | | '' | | |
+-------------+--------------+------+-----+---------+----------------+
|
The expected result is:
+-------------+--------------+------+-----+---------+----------------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------------+--------------+------+-----+---------+----------------+
|
| id | int(11) | NO | PRI | NULL | auto_increment | |
| some_number | int(11) | NO | | 0 | |
|
| some_text1 | char(255) | NO | | | |
|
| some_text2 | varchar(255) | NO | | | |
|
| some_text3 | text | NO | | | |
|
| some_text4 | tinytext | NO | | | |
|
| some_text5 | mediumtext | NO | | | |
|
| some_text6 | longtext | NO | | | |
|
+-------------+--------------+------+-----+---------+----------------+
|