@Test public void testTypeLookup() throws PEException { class TestData { TestColumnDef tcd = null; MysqlType mt = null; TestData(TestColumnDef tcd, MysqlType mt) { this.tcd = tcd; this.mt = mt; } } TestData[] testData = { new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 65535), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 255), MysqlType.TINYTEXT), new TestData( new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777215), MysqlType.MEDIUMTEXT), new TestData( new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777216), MysqlType.LONGTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BIT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.BIT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.TINYINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 3), MysqlType.TINYINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 6), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 5), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_NUM, 22), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NULL, 0, 0), MysqlType.NULL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TIMESTAMP, MysqlNativeConstants.FLDPKT_FLAG_NOT_NULL + MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_ZEROFILL + MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_ON_UPDATE_NOW, 19), MysqlType.TIMESTAMP), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 20), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 9), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DATE, 0, 0), MysqlType.DATE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TIME, 0, 0), MysqlType.TIME), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DATETIME, 0, 0), MysqlType.DATETIME), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_YEAR, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_ZEROFILL + MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.YEAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_ENUM, 0, 0), MysqlType.ENUM), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SET, 0, 0), MysqlType.SET), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_BLOB, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.ALTTINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_NOT_NULL, 16777216), MysqlType.ALTLONGBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_BLOB, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_MEDIUM_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.ALTMEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777216), MysqlType.LONGBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, 0, 255), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, 0, 10), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 10), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NOT_NULL, 2048), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 2048), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 20), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 20), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 10), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 255), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 64), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 65), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 1), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 1), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 10), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 64), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65), MysqlType.BINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BIT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED, 1), MysqlType.BIT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BIT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED, 1), MysqlType.BIT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BIT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED, 10), MysqlType.BIT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BIT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED, 64), MysqlType.BIT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777216), MysqlType.LONGBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 4294967295L), MysqlType.LONGBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65535), MysqlType.BLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.BOOL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.BOOL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 30), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 765), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 192), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 195), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DATE, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 10), MysqlType.DATE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DATETIME, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 19), MysqlType.DATETIME), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 10), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 2), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 3), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 65), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 66), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_NUM, 22), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 22), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_NUM, 2), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 2), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_NUM, 22), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 2), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 2), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_FLOAT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 12), MysqlType.FLOAT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_NUM, 22), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 10), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 10), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 255), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 64), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 65), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.TINYINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 6), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 9), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONGLONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 20), MysqlType.BIGINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_LONG, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.INT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777215), MysqlType.MEDIUMTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 4294967295L), MysqlType.LONGBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 4294967295L), MysqlType.LONGTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 9), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 8), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 10), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 255), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 64), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 65), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777215), MysqlType.MEDIUMTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_INT24, MysqlNativeConstants.FLDPKT_FLAG_NUM, 9), MysqlType.MEDIUMINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.CHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_NEWDECIMAL, MysqlNativeConstants.FLDPKT_FLAG_NUM, 11), MysqlType.DECIMAL), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 30), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 4294967295L), MysqlType.LONGTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 4294967295L), MysqlType.LONGTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 765), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 768), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 192), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 195), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_DOUBLE, MysqlNativeConstants.FLDPKT_FLAG_NUM, 22), MysqlType.DOUBLE), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 6), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 5), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 1), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 10), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 255), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 64), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_SHORT, MysqlNativeConstants.FLDPKT_FLAG_NUM, 65), MysqlType.SMALLINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 65535), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 255), MysqlType.TINYTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777215), MysqlType.MEDIUMTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777216), MysqlType.LONGTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 21844), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 21845), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 21846), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 255), MysqlType.TINYTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 256), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 32768), MysqlType.TEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 64), MysqlType.TINYTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 65), MysqlType.TINYTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 65536), MysqlType.MEDIUMTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TIME, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 8), MysqlType.TIME), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TIMESTAMP, MysqlNativeConstants.FLDPKT_FLAG_NOT_NULL + MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_ZEROFILL + MysqlNativeConstants.FLDPKT_FLAG_BINARY + MysqlNativeConstants.FLDPKT_FLAG_TIMESTAMP + MysqlNativeConstants.FLDPKT_FLAG_ON_UPDATE_NOW, 19), MysqlType.TIMESTAMP), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.TINYBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.TINYINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_NUM, 3), MysqlType.TINYINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_TINY, MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.TINYINT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 255), MysqlType.TINYTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 1), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 10), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 4294967295L), MysqlType.LONGBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 255), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 256), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 64), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_BINARY, 65), MysqlType.VARBINARY), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB + MysqlNativeConstants.FLDPKT_FLAG_BINARY, 16777215), MysqlType.MEDIUMBLOB), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 3), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 30), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 16777215), MysqlType.MEDIUMTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 4294967295L), MysqlType.LONGTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 255), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 256), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 64), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 65), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_BLOB, MysqlNativeConstants.FLDPKT_FLAG_BLOB, 65536), MysqlType.MEDIUMTEXT), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NONE, 1), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_VAR_STRING, MysqlNativeConstants.FLDPKT_FLAG_NOT_NULL, 0), MysqlType.VARCHAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_YEAR, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_ZEROFILL + MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.YEAR), new TestData(new TestColumnDef(MyFieldType.FIELD_TYPE_YEAR, MysqlNativeConstants.FLDPKT_FLAG_UNSIGNED + MysqlNativeConstants.FLDPKT_FLAG_ZEROFILL + MysqlNativeConstants.FLDPKT_FLAG_NUM, 4), MysqlType.YEAR), }; MysqlNative msn = (MysqlNative) Singletons.require(DBNative.class); int i = 0; MysqlNativeType mnt; for (TestData rec : testData) { MyFieldType mft = rec.tcd.getFieldType(); mnt = msn.getNativeTypeFromMyFieldType(mft, rec.tcd.getFlags(), rec.tcd.getMaxLen(1)); assertNotNull(mnt); assertEquals("Invalid map of field type - loop index is: " + i, rec.mt.name(), NativeType.fixNameForType(mnt.getTypeName())); i++; } }
public MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen) throws PEException { final MysqlNativeTypeCatalog typeCatalog = (MysqlNativeTypeCatalog) Singletons.require(DBNative.class).getTypeCatalog(); return typeCatalog.findType(mft, flags, maxLen, true); }
MysqlNative extends DBNative { public MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen) throws PEException { final MysqlNativeTypeCatalog typeCatalog = (MysqlNativeTypeCatalog) Singletons.require(DBNative.class).getTypeCatalog(); return typeCatalog.findType(mft, flags, maxLen, true); } }
MysqlNative extends DBNative { public MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen) throws PEException { final MysqlNativeTypeCatalog typeCatalog = (MysqlNativeTypeCatalog) Singletons.require(DBNative.class).getTypeCatalog(); return typeCatalog.findType(mft, flags, maxLen, true); } MysqlNative(NativeCharSetCatalog charSetCat, NativeCollationCatalog nativeColCat, DBType dbType); }
MysqlNative extends DBNative { public MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen) throws PEException { final MysqlNativeTypeCatalog typeCatalog = (MysqlNativeTypeCatalog) Singletons.require(DBNative.class).getTypeCatalog(); return typeCatalog.findType(mft, flags, maxLen, true); } MysqlNative(NativeCharSetCatalog charSetCat, NativeCollationCatalog nativeColCat, DBType dbType); @Override NativeCharSetCatalog getSupportedCharSets(); @Override NativeCollationCatalog getSupportedCollations(); MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen); @Override String getColumnDefForQuery(UserColumn uc); @Override String getDataTypeForQuery(UserColumn uc); @Override ColumnMetadata getParameterColumnInfo(ParameterMetaData pmd, int colIdx); @Override UserColumn updateUserColumn(UserColumn iuc, Type schemaType); @Override Emitter getEmitter(); @Override SQLCommand getDropDatabaseStmt(final VariableStoreSource vs, String databaseName); @Override SQLCommand getCreateDatabaseStmt(final VariableStoreSource vs, String databaseName, boolean ine, String defaultCharSet, String defaultCollation); @Override SQLCommand getAlterDatabaseStmt(final VariableStoreSource vs, String databaseName, String defaultCharSet, String defaultCollation); @Override SQLCommand getCreateUserCommand(final VariableStoreSource vs, User user); @Override SQLCommand getGrantPriviledgesCommand(final VariableStoreSource vs, String userDeclaration, String databaseName); @Override SQLCommand getDropDatabaseStmt(final Charset connectionCharset, String databaseName); @Override SQLCommand getCreateDatabaseStmt(final Charset connectionCharset, String databaseName, boolean ine, String defaultCharSet, String defaultCollation); @Override SQLCommand getAlterDatabaseStmt(final Charset connectionCharset, String databaseName, String defaultCharSet, String defaultCollation); @Override SQLCommand getCreateUserCommand(final Charset connectionCharset, User user); @Override SQLCommand getGrantPriviledgesCommand(final Charset connectionCharset, String userDeclaration, String databaseName); @Override String getUserDeclaration(User user, boolean pword); @Override String getEmptyCatalogName(); @Override String getPasswordForAuth(User user, SSConnection ssConn); @Override String getSessionVariableConfigName(); @Override String getStatusVariableConfigName(); @Override String getSetSessionVariableStatement(String assignmentClause); @Override String getSetAutocommitStatement(String value); @Override void assertValidCharacterSet(String value); @Override void assertValidCollation(String value); @Override String getDefaultServerCharacterSet(); @Override String getDefaultServerCollation(); @Override String getDefaultServerBinaryCollation(); @Override boolean beginImpliesCommit(); @Override boolean ddlImpliesCommit(); @Override boolean exceptionAbortsTxn(PEException e); @Override int convertTransactionIsolationLevel(String in); @Override String convertTransactionIsolationLevel(int level); @Override String getTableRenameStatement(String existingTableName, String newTableName); @Override int getMaxAliasNameLen(); @Override void convertColumnMetadataToUserColumn(ColumnMetadata cm, UserColumn uc); @Override int getMaxNumColsInIndex(); @Override ForeignKeyAction getDefaultOnDeleteAction(); @Override ForeignKeyAction getDefaultOnUpdateAction(); @Override long getMaxTableCommentLength(); @Override long getMaxTableFieldCommentLength(); }
MysqlNative extends DBNative { public MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen) throws PEException { final MysqlNativeTypeCatalog typeCatalog = (MysqlNativeTypeCatalog) Singletons.require(DBNative.class).getTypeCatalog(); return typeCatalog.findType(mft, flags, maxLen, true); } MysqlNative(NativeCharSetCatalog charSetCat, NativeCollationCatalog nativeColCat, DBType dbType); @Override NativeCharSetCatalog getSupportedCharSets(); @Override NativeCollationCatalog getSupportedCollations(); MysqlNativeType getNativeTypeFromMyFieldType(MyFieldType mft, int flags, long maxLen); @Override String getColumnDefForQuery(UserColumn uc); @Override String getDataTypeForQuery(UserColumn uc); @Override ColumnMetadata getParameterColumnInfo(ParameterMetaData pmd, int colIdx); @Override UserColumn updateUserColumn(UserColumn iuc, Type schemaType); @Override Emitter getEmitter(); @Override SQLCommand getDropDatabaseStmt(final VariableStoreSource vs, String databaseName); @Override SQLCommand getCreateDatabaseStmt(final VariableStoreSource vs, String databaseName, boolean ine, String defaultCharSet, String defaultCollation); @Override SQLCommand getAlterDatabaseStmt(final VariableStoreSource vs, String databaseName, String defaultCharSet, String defaultCollation); @Override SQLCommand getCreateUserCommand(final VariableStoreSource vs, User user); @Override SQLCommand getGrantPriviledgesCommand(final VariableStoreSource vs, String userDeclaration, String databaseName); @Override SQLCommand getDropDatabaseStmt(final Charset connectionCharset, String databaseName); @Override SQLCommand getCreateDatabaseStmt(final Charset connectionCharset, String databaseName, boolean ine, String defaultCharSet, String defaultCollation); @Override SQLCommand getAlterDatabaseStmt(final Charset connectionCharset, String databaseName, String defaultCharSet, String defaultCollation); @Override SQLCommand getCreateUserCommand(final Charset connectionCharset, User user); @Override SQLCommand getGrantPriviledgesCommand(final Charset connectionCharset, String userDeclaration, String databaseName); @Override String getUserDeclaration(User user, boolean pword); @Override String getEmptyCatalogName(); @Override String getPasswordForAuth(User user, SSConnection ssConn); @Override String getSessionVariableConfigName(); @Override String getStatusVariableConfigName(); @Override String getSetSessionVariableStatement(String assignmentClause); @Override String getSetAutocommitStatement(String value); @Override void assertValidCharacterSet(String value); @Override void assertValidCollation(String value); @Override String getDefaultServerCharacterSet(); @Override String getDefaultServerCollation(); @Override String getDefaultServerBinaryCollation(); @Override boolean beginImpliesCommit(); @Override boolean ddlImpliesCommit(); @Override boolean exceptionAbortsTxn(PEException e); @Override int convertTransactionIsolationLevel(String in); @Override String convertTransactionIsolationLevel(int level); @Override String getTableRenameStatement(String existingTableName, String newTableName); @Override int getMaxAliasNameLen(); @Override void convertColumnMetadataToUserColumn(ColumnMetadata cm, UserColumn uc); @Override int getMaxNumColsInIndex(); @Override ForeignKeyAction getDefaultOnDeleteAction(); @Override ForeignKeyAction getDefaultOnUpdateAction(); @Override long getMaxTableCommentLength(); @Override long getMaxTableFieldCommentLength();  }