#28 ResultSetMetaData BLOB/TEXT issue

[Arndt Jenssen]

ResultSetMetaData.getColumnTypeName(int)[419] returns
on BLOB fields "TEXT" if the column is binary marked
and "BLOB" if not.
This seems to be a bug, since it should be the other
way round.
Correct me please if I am wrong.

[Mark Matthews]

Logged In: YES
user_id=116907

Need sample table to reproduce.

[Nobody/Anonymous]

Logged In: NO

Here is a table that you can use to produce the error.
+----------------------+----------------+-------+--------+---------+---------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+----------------+-------+-------+---------+----------+
| MESSAGE_ID | varchar(50) | | PRI | | |
| FROM_ | blob | YES| | NULL | |
+---------------------+-----------------+------+-------+----------+----------

CREATE TABLE STATEMENT
mysql> create table testDB (MESSAGE_ID VARCHAR(50)
NOT NULL,FROM_ BLOB, PRIMARY
KEY(MESSAGE_ID));

INSERT DATA INTO TABLE STATMENTS
mysql> INSERT INTO testDB VALUES ('10001','SOMETHING
HERE');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO testDB VALUES ('10002','SOMETHING
THERE');
Query OK, 1 row affected (0.00 sec)

A call to getColumnTypeName(int) returns Text and a call to
getColumnType(int) returns -4.