Adminer / Bugs and Features / #779 [MySQL] Default value for tinytext field messed up after altering table

#779 [MySQL] Default value for tinytext field messed up after altering table

Milestone: Git

Status: closed-fixed

Owner: nobody

Labels: MySQL (74) alter table (2) default values (2)

Priority: 5

Updated: 2021-02-07

Created: 2021-01-26

Creator: Gordon Tyler

Private: No

Created a table with a tinytext field and a default value that is meant to hold a URL. When I use the alter table link after that, it shows quotes around that default value. If I make another change to the table, the default value for that field will now have the quotes escaped as part of the new default value.

Discussion

Gordon Tyler - 2021-01-26

Adminer 4.7.8
PHP Version 7.4.9
System Linux 3.10.108
Build Date Oct 28 2020 12:36:30
Server API FPM/FastCGI
Version mysqlnd 7.4.9
Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions mysqli,pdo_mysql

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2021-02-07

status: open --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2021-02-07

This is really weird. Thanks for reporting, fixed.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

[MySQL] Default value for tinytext field messed up after altering table

Database management in a single PHP file

Group

Searches

Help

#779 [MySQL] Default value for tinytext field messed up after altering table

Discussion