{"record":{"id":"db751f9b0e877bbb","repo":"prestodb/presto","slug":"not-supported-db751f","errorCode":"NOT_SUPPORTED","errorMessage":"Unsupported column type: %s","messagePattern":"Unsupported column type: (.+?)","errorType":"error_code","errorClass":"PrestoException","httpStatus":400,"severity":"error","filePath":"presto-mysql/src/main/java/com/facebook/presto/plugin/mysql/MySqlClient.java","lineNumber":182,"sourceCode":"                new String[] {\"TABLE\", \"VIEW\"});\n    }\n\n    @Override\n    protected String getTableSchemaName(ResultSet resultSet)\n            throws SQLException\n    {\n        // MySQL uses catalogs instead of schemas\n        return resultSet.getString(\"TABLE_CAT\");\n    }\n\n    @Override\n    protected String toSqlType(Type type)\n    {\n        if (REAL.equals(type)) {\n            return \"float\";\n        }\n        if (TIME_WITH_TIME_ZONE.equals(type) || TIMESTAMP_WITH_TIME_ZONE.equals(type)) {\n            throw new PrestoException(NOT_SUPPORTED, \"Unsupported column type: \" + type.getDisplayName());\n        }\n        if (type instanceof TimestampType) {\n            // In order to preserve microsecond information for TIMESTAMP_MICROSECONDS\n            return \"datetime(6)\";\n        }\n        if (VARBINARY.equals(type)) {\n            return \"mediumblob\";\n        }\n        if (isVarcharType(type)) {\n            VarcharType varcharType = (VarcharType) type;\n            if (varcharType.isUnbounded()) {\n                return \"longtext\";\n            }\n            if (varcharType.getLengthSafe() <= 255) {\n                return \"tinytext\";\n            }\n            if (varcharType.getLengthSafe() <= 65535) {\n                return \"text\";","sourceCodeStart":164,"sourceCodeEnd":200,"githubUrl":"https://github.com/prestodb/presto/blob/55bb57d202de3b926896fa966c2c4a44c779634e/presto-mysql/src/main/java/com/facebook/presto/plugin/mysql/MySqlClient.java#L164-L200","documentation":"MySQL connector DDL error in toSqlType: a column type being written for CREATE TABLE has no MySQL mapping — notably TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE are unsupported, and the %s names the offending Presto type. Fired when creating or altering a MySQL table with such a column.","triggerScenarios":"Thrown at presto-mysql/src/main/java/com/facebook/presto/plugin/mysql/MySqlClient.java:182 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Use TIMESTAMP or VARCHAR instead of TIMESTAMP WITH TIME ZONE","Cast/convert the column type before creating the table in MySQL","Avoid DDL that emits time-zone-carrying types toward MySQL"],"exampleFix":null,"handlingStrategy":"type-guard","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"55bb57d202de3b926896fa966c2c4a44c779634e","analyzedAt":"2026-09-04T12:50:26.162Z","contentChangedAt":"2026-09-04T12:50:26.162Z","schemaVersion":2},"datasetVersion":"2026-09-11T21:17:09.523Z"}