MySQLDatabaseMetadata.getColumns returns 0 as datatype for TINYINT columns

[Stefan Anzinger]

Translation is missing, add Translation for TINYINT to org.drizzle.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 + <<<<<<
                    " END";

[Stefan Anzinger (stefan-anzinger)]

The same applies to SMALLINT

[Fox (13524752199-g)]

The same to the CHAR in MySQL