search

krummas / DrizzleJDBC

A BSD licensed JDBC driver for Drizzle and MySQL
BSD 3-Clause "New" or "Revised" License
31 stars 22 forks source link

GetColumns returns 0 as datatype for some datatypes, different from mysql driver. #37

Open templefox opened 9 years ago

templefox commented 9 years ago

change jdbc.CommonDatabaseMetaData.dataTypeClause: protected final String dataTypeClause = " CASE data_type" + " WHEN 'int' THEN " + Types.INTEGER + " WHEN 'mediumint' THEN "+Types.INTEGER + " WHEN 'varchar' THEN " + Types.VARCHAR + " WHEN 'datetime' THEN " + Types.TIMESTAMP + " WHEN 'date' THEN " + Types.DATE + " WHEN 'time' THEN " + Types.TIME + " WHEN 'text' THEN " + Types.VARCHAR + " WHEN 'bigint' THEN " + Types.BIGINT + " WHEN 'varbinary' THEN " + Types.VARBINARY + " WHEN 'timestamp' THEN " + Types.TIMESTAMP + " WHEN 'double' THEN " + Types.DOUBLE + " WHEN 'bit' THEN " + Types.BIT +

" WHEN 'tinyint' THEN " + Types.TINYINT + <<<<<< " WHEN 'char' THEN " + Types.CHAR+ <<<<<< " END";