[MDEV-22791] SHOW COLUMNS for TEXT NOT NULL DEFAULT differ from VARCHAR NOT NULL DEFAULT Created: 2020-06-03 Updated: 2023-04-27 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Admin statements, Data types |
| Affects Version/s: | 10.2, 10.3, 10.4, 10.5 |
| Fix Version/s: | 10.4, 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Sergey Chernomorets | Assignee: | Alexander Barkov |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
10.3.22-MariaDB-log |
||
| Description |
|
SHOW COLUMNS show '' as default value for TEXT and empty field for VARCHAR
In both cases information_schema show same value:
|