#10939: Disable Default value Column property for BLOB and TEXT datatype in MySQL 5.0+

Shavi57 reported 2013-12-02T12:54:03Z · last modified 2017-05-18T03:02:19Z

Dev	tomconrad
QA	ivangron

Priority	Low
Complexity	Unknown

Component	DB - MySQL
Version	19.0

Aqua Data Studio 15.0.0-dev-37

Database version: MySQL 5.6.12

Disable Default value Column property for BLOB and TEXT datatype in MySQL 5.0+

1. Go to Schema Browser-> Expand Databases node->Expand desired Database-> Select Table node-> Right click on Table node-> Select Create Table option

2. Enter table name: test-> Enter column name c1 with datatype: blob-> Enter column name c2 with datatype: text

3. Select row of Column c1-> Go to Column Properties

The Default Value field is editable even though the BLOB datatype does not support Default value.

3.Select row of Column c2-> Go to Column Properties

The Default Value field is editable even though the TEXT datatype does not support Default value.

Reference Link:

All Comments (4) Change History

SachinPrakash 2017-03-17T23:38:28Z

@dev: fix only if < 1 hr.

tomconrad 2017-05-09T20:54:55Z

svn# 54311 - Set the default field disabled for Blob, Geometry and Text datatypes.

Shavi57 2017-05-11T09:30:19Z

Verified in ADS 19-alpha-5. Please refer latest attached screenshot.

tariqrahiman 2017-05-18T03:02:19Z

Verified in ADS v19.0.0-alpha-8