[ https://issues.jboss.org/browse/TEIIDDES-311?page=com.atlassian.jira.plug... ] Mark Drilling commented on TEIIDDES-311: ---------------------------------------- Yes, this is still an issue. I created a BQT project in Designer by importing from an Oracle BQT instance. Then exported the DDL and tried to run it against a MySQL 5.5 database. Ran into a couple issues which prevented import: 1- Create table syntax for FLOAT columns failed. "FLOATNUM FLOAT", and "FLOATNUM FLOAT(126,5)" are valid for example but not "FLOATNUM FLOAT(126)" 2- Create table syntax "CHARVALUE CHAR(1) DEFAULT('1')" failed, should be "CHARVALUE CHAR(1) DEFAULT '1'" There may be more issues, these are the first two I hit... Syntax reference is at http://dev.mysql.com/doc/refman/5.1/en/create-table.html -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira