MySQL DataType - BLOB becomes LONGBLOB

Description

Create table like so:

CREATE TABLE TESTBLOB(
BLOB_NULL BLOB NULL,
BLOB_NOTNULL BLOB NOT NULL
);

Snapshot says this:

<changeSet author="robert" id="1383674467554-4">
<createTable tableName="testblob">
<column name="BLOB_NULL" type="LONGBLOB"/>
<column name="BLOB_NOTNULL" type="LONGBLOB">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>

Environment

Linux and MySQL

Activity

Show:
Kevin Chappell
November 22, 2013, 6:29 PM

Nathan,

Thanks for getting all of the MySQL datatypes fixed! We'll get the changes into the next release of DaticalDB.

Best,

Kevin Chappell
VP Engineering
Datical, Inc.
mobile: (415) 425-4975
email: kevinchappell@datical.com<kevinchappell@datical.com>

From: "Nathan Voxland (JIRA)" <jira@liquibase.jira.com<jira@liquibase.jira.com>>
Date: Wednesday, November 20, 2013 at 4:36 PM
To: Kevin Chappell <kevinchappell@datical.com<kevinchappell@datical.com>>
Subject: [JIRA] () MySQL DataType - BLOB becomes LONGBLOB

https://liquibase.jira.com/secure/useravatar?avatarId=10062 Nathan Voxland<https://liquibase.jira.com/secure/ViewProfile.jspa?name=nvoxland>closed an issue as Fixed

Liquibase Core<https://liquibase.jira.com/browse/CORE> / [Bug] <https://liquibase.jira.com/browse/CORE-1589> CORE-1589<https://liquibase.jira.com/browse/CORE-1589>
MySQL DataType - BLOB becomes LONGBLOB<https://liquibase.jira.com/browse/CORE-1589>

Change By: Nathan Voxland<https://liquibase.jira.com/secure/ViewProfile.jspa?name=nvoxland>
Resolution: Fixed
Status: OpenClosed

[Add Comment]<https://liquibase.jira.com/browse/CORE-1589#add-comment> Add Comment<https://liquibase.jira.com/browse/CORE-1589#add-comment>

This message was sent by Atlassian JIRA (v6.2-OD-03#6206-sha1:1444450)
[Atlassian logo]

Fixed

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Major