[ http://jira.codehaus.org/browse/CONTINUUM-1113?page=comments#action_84456
]
Rahul Thakur commented on CONTINUUM-1113:
-----------------------------------------
Hi Carlos,
I noticed you logged the issue for MySQL 5.0.27, I am on 5.024 and I am able to
create a table here, please see output below:
========================================================
E:\>
E:\>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.24-community-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> use test_mysql
Database changed
mysql>
mysql> CREATE TABLE `MYTABLE`
-> (
-> `NAME` VARCHAR(300) BINARY NOT NULL,
-> PRIMARY KEY (`NAME`)
-> ) ENGINE=INNODB;
Query OK, 0 rows affected (0.11 sec)
mysql> show create table MYTABLE \G;
*************************** 1. row ***************************
Table: MYTABLE
Create Table: CREATE TABLE `mytable` (
`NAME` varchar(300) character set latin1 collate latin1_bin NOT NULL,
PRIMARY KEY (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
ERROR:
No query specified
===========================================================
> Continuum doesn't work with MySQL
> ---------------------------------
>
> Key: CONTINUUM-1113
> URL: http://jira.codehaus.org/browse/CONTINUUM-1113
> Project: Continuum
> Issue Type: Improvement
> Components: Database
> Affects Versions: 1.1
> Reporter: Carlos Sanchez
> Assigned To: Carlos Sanchez
>
> 2006-10-20 19:23:14,288 [WrapperSimpleAppMain] ERROR RDBMS - Error thrown
> executing CREATE TABLE `PROJECTNOTIFIER_CONFIGURATION`
> [SNIP]
> 2006/10/20 19:23:14 | java.sql.SQLException: BLOB/TEXT column 'STRING_KEY'
> used in key specification without a key length
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
