linux-traipu team mailing list archive

[Stefan Anzinger <1433738@xxxxxxxxxxxxxxxxxx>]

The same applies to SMALLINT

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/1433738

Title:
  MySQLDatabaseMetadata.getColumns returns 0 as datatype for TINYINT
  columns

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

Bug description:
  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";

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/1433738/+subscriptions