/*******************************************************************************
* Copyright (c) 1998, 2015 Oracle and/or its affiliates. All rights reserved.
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* Oracle - initial API and implementation from Oracle TopLink
******************************************************************************/
package org.eclipse.persistence.tools.workbench.test.platformsplugin.model;
import java.sql.DatabaseMetaData;
import java.sql.Types;
import java.util.Map;
import junit.framework.Test;
import junit.framework.TestSuite;
public class MySQL4Tests extends PlatformTests {
public static Test suite() {
return new TestSuite(MySQL4Tests.class);
}
public MySQL4Tests(String name) {
super(name);
}
protected String[] driverJARNames() {
return new String[] {"mysql-connector-java-3.1.7-bin.jar"};
}
protected String driverClassName() {
return "com.mysql.jdbc.Driver";
}
protected String connectionURL() {
return "jdbc:mysql://" + this.serverName() + "/" + this.databaseName();
}
/**
* the MySQL 4.1 Server in Ottawa
*/
protected String serverName() {
return "tlsvrdb3.ca.oracle.com";
}
protected String databaseName() {
return this.userName();
}
/**
* the MySQL server is not set up with individual accounts
*/
protected String userName() {
return "COREDEV2";
}
protected String platformName() {
return "MySQL";
}
protected String expectedVersionNumber() {
return "4.1.15";
}
protected void appendColumnsToTableDDL(StringBuffer sb) {
sb.append(" BIT_COL BIT,"); sb.append(CR);
sb.append(" BOOL_COL BOOL,"); sb.append(CR);
sb.append(" BOOLEAN_COL BOOLEAN,"); sb.append(CR);
sb.append(" TINYINT_COL TINYINT,"); sb.append(CR);
sb.append(" BIGINT_COL BIGINT,"); sb.append(CR);
sb.append(" LONG_VARBINARY_COL LONG VARBINARY,"); sb.append(CR);
sb.append(" MEDIUMBLOB_COL MEDIUMBLOB,"); sb.append(CR);
sb.append(" LONGBLOB_COL LONGBLOB,"); sb.append(CR);
sb.append(" BLOB_COL BLOB,"); sb.append(CR);
sb.append(" TINYBLOB_COL TINYBLOB,"); sb.append(CR);
sb.append(" VARBINARY_20_COL VARBINARY(20),"); sb.append(CR);
sb.append(" BINARY_COL BINARY,"); sb.append(CR);
sb.append(" BINARY_20_COL BINARY(20),"); sb.append(CR);
sb.append(" LONG_VARCHAR_COL LONG VARCHAR,"); sb.append(CR);
sb.append(" MEDIUMTEXT_COL MEDIUMTEXT,"); sb.append(CR);
sb.append(" LONGTEXT_COL LONGTEXT,"); sb.append(CR);
sb.append(" TEXT_COL TEXT,"); sb.append(CR);
sb.append(" TINYTEXT_COL TINYTEXT,"); sb.append(CR);
sb.append(" CHAR_COL CHAR,"); sb.append(CR);
sb.append(" CHAR_20_COL CHAR(20),"); sb.append(CR);
sb.append(" NUMERIC_COL NUMERIC,"); sb.append(CR);
sb.append(" DECIMAL_COL DECIMAL,"); sb.append(CR);
sb.append(" DEC_COL DEC,"); sb.append(CR);
sb.append(" FIXED_COL FIXED,"); sb.append(CR);
sb.append(" INTEGER_COL INTEGER,"); sb.append(CR);
sb.append(" INT_COL INT,"); sb.append(CR);
sb.append(" MEDIUMINT_COL MEDIUMINT,"); sb.append(CR);
sb.append(" SMALLINT_COL SMALLINT,"); sb.append(CR);
sb.append(" FLOAT_COL FLOAT,"); sb.append(CR);
sb.append(" DOUBLE_COL DOUBLE,"); sb.append(CR);
sb.append(" DOUBLE_PRECISION_COL DOUBLE PRECISION,"); sb.append(CR);
sb.append(" REAL_COL REAL,"); sb.append(CR);
sb.append(" VARCHAR_20_COL VARCHAR(20),"); sb.append(CR);
sb.append(" ENUM_COL ENUM('a', 'b', 'c'),"); sb.append(CR);
sb.append(" SET_COL SET('aa', 'bb', 'cc'),"); sb.append(CR);
sb.append(" DATE_COL DATE,"); sb.append(CR);
sb.append(" TIME_COL TIME,"); sb.append(CR);
sb.append(" DATETIME_COL DATETIME,"); sb.append(CR);
sb.append(" TIMESTAMP_COL TIMESTAMP,"); sb.append(CR);
sb.append(" YEAR_COL YEAR"); sb.append(CR);
}
protected String tableName() {
return super.tableName().toLowerCase(); // ???
}
protected void verifyTable(Map metaDataMap) {
// BIT
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "DATA_TYPE", Types.TINYINT);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "TYPE_NAME", "tinyint");
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "COLUMN_SIZE", 1);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BIT_COL", "IS_NULLABLE", "YES");
// BOOL
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "DATA_TYPE", Types.TINYINT);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "TYPE_NAME", "tinyint");
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "COLUMN_SIZE", 1);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BOOL_COL", "IS_NULLABLE", "YES");
// BOOLEAN
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "DATA_TYPE", Types.TINYINT);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "TYPE_NAME", "tinyint");
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "COLUMN_SIZE", 1);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BOOLEAN_COL", "IS_NULLABLE", "YES");
// TINYINT
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "DATA_TYPE", Types.TINYINT);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "TYPE_NAME", "tinyint");
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "COLUMN_SIZE", 4);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "TINYINT_COL", "IS_NULLABLE", "YES");
// BIGINT
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "DATA_TYPE", Types.BIGINT);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "TYPE_NAME", "bigint");
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "COLUMN_SIZE", 20);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BIGINT_COL", "IS_NULLABLE", "YES");
// LONG VARBINARY
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "DATA_TYPE", Types.LONGVARBINARY);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "TYPE_NAME", "mediumblob");
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "COLUMN_SIZE", 16277215);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "LONG_VARBINARY_COL", "IS_NULLABLE", "YES");
// MEDIUMBLOB
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "DATA_TYPE", Types.LONGVARBINARY);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "TYPE_NAME", "mediumblob");
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "COLUMN_SIZE", 16277215);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "MEDIUMBLOB_COL", "IS_NULLABLE", "YES");
// LONGBLOB
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "DATA_TYPE", Types.LONGVARBINARY);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "TYPE_NAME", "longblob");
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "COLUMN_SIZE", 2147483647);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "LONGBLOB_COL", "IS_NULLABLE", "YES");
// BLOB
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "DATA_TYPE", Types.LONGVARBINARY);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "TYPE_NAME", "blob");
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "COLUMN_SIZE", 65535);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BLOB_COL", "IS_NULLABLE", "YES");
// TINYBLOB
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "DATA_TYPE", Types.BINARY);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "TYPE_NAME", "tinyblob");
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "COLUMN_SIZE", 255);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "TINYBLOB_COL", "IS_NULLABLE", "YES");
// VARBINARY(20)
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "DATA_TYPE", Types.OTHER);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "TYPE_NAME", "varbinary");
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "COLUMN_SIZE", 20);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "VARBINARY_20_COL", "IS_NULLABLE", "YES");
// BINARY
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "DATA_TYPE", Types.OTHER);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "TYPE_NAME", "binary");
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "COLUMN_SIZE", 1);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BINARY_COL", "IS_NULLABLE", "YES");
// BINARY(20)
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "DATA_TYPE", Types.OTHER);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "TYPE_NAME", "varbinary");
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "COLUMN_SIZE", 20);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "BINARY_20_COL", "IS_NULLABLE", "YES");
// LONG VARCHAR
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "DATA_TYPE", Types.LONGVARCHAR);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "TYPE_NAME", "mediumtext");
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "COLUMN_SIZE", 16277215);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "LONG_VARCHAR_COL", "IS_NULLABLE", "YES");
// MEDIUMTEXT
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "DATA_TYPE", Types.LONGVARCHAR);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "TYPE_NAME", "mediumtext");
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "COLUMN_SIZE", 16277215);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "MEDIUMTEXT_COL", "IS_NULLABLE", "YES");
// LONGTEXT
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "DATA_TYPE", Types.LONGVARCHAR);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "TYPE_NAME", "longtext");
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "COLUMN_SIZE", 2147483647);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "LONGTEXT_COL", "IS_NULLABLE", "YES");
// TEXT
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "DATA_TYPE", Types.LONGVARCHAR);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "TYPE_NAME", "text");
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "COLUMN_SIZE", 65535);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "TEXT_COL", "IS_NULLABLE", "YES");
// TINYTEXT
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "DATA_TYPE", Types.VARCHAR);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "TYPE_NAME", "tinytext");
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "COLUMN_SIZE", 255);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "TINYTEXT_COL", "IS_NULLABLE", "YES");
// CHAR
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "DATA_TYPE", Types.CHAR);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "TYPE_NAME", "char");
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "COLUMN_SIZE", 1);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "CHAR_COL", "IS_NULLABLE", "YES");
// CHAR(20)
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "DATA_TYPE", Types.VARCHAR);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "TYPE_NAME", "varchar");
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "COLUMN_SIZE", 20);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "CHAR_20_COL", "IS_NULLABLE", "YES");
// NUMERIC
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "DATA_TYPE", Types.DECIMAL);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "TYPE_NAME", "decimal");
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "COLUMN_SIZE", 10);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "NUMERIC_COL", "IS_NULLABLE", "YES");
// DECIMAL
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "DATA_TYPE", Types.DECIMAL);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "TYPE_NAME", "decimal");
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "COLUMN_SIZE", 10);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "DECIMAL_COL", "IS_NULLABLE", "YES");
// DEC
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "DATA_TYPE", Types.DECIMAL);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "TYPE_NAME", "decimal");
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "COLUMN_SIZE", 10);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "DEC_COL", "IS_NULLABLE", "YES");
// FIXED
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "DATA_TYPE", Types.DECIMAL);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "TYPE_NAME", "decimal");
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "COLUMN_SIZE", 10);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "FIXED_COL", "IS_NULLABLE", "YES");
// INTEGER
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "DATA_TYPE", Types.INTEGER);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "TYPE_NAME", "int");
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "COLUMN_SIZE", 11);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "INTEGER_COL", "IS_NULLABLE", "YES");
// INT
this.verifyColumnAttribute(metaDataMap, "INT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "INT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "INT_COL", "DATA_TYPE", Types.INTEGER);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "TYPE_NAME", "int");
this.verifyColumnAttribute(metaDataMap, "INT_COL", "COLUMN_SIZE", 11);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "INT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "INT_COL", "IS_NULLABLE", "YES");
// MEDIUMINT
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "DATA_TYPE", Types.INTEGER);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "TYPE_NAME", "mediumint");
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "COLUMN_SIZE", 9);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "MEDIUMINT_COL", "IS_NULLABLE", "YES");
// SMALLINT
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "DATA_TYPE", Types.SMALLINT);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "TYPE_NAME", "smallint");
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "COLUMN_SIZE", 6);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "SMALLINT_COL", "IS_NULLABLE", "YES");
// FLOAT
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "DATA_TYPE", Types.REAL);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "TYPE_NAME", "float");
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "COLUMN_SIZE", 12);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "FLOAT_COL", "IS_NULLABLE", "YES");
// DOUBLE
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "DATA_TYPE", Types.DOUBLE);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "TYPE_NAME", "double");
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "COLUMN_SIZE", 22);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_COL", "IS_NULLABLE", "YES");
// DOUBLE PRECISION
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "DATA_TYPE", Types.DOUBLE);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "TYPE_NAME", "double");
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "COLUMN_SIZE", 22);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "DOUBLE_PRECISION_COL", "IS_NULLABLE", "YES");
// REAL
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "DATA_TYPE", Types.DOUBLE);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "TYPE_NAME", "double");
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "COLUMN_SIZE", 22);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "REAL_COL", "IS_NULLABLE", "YES");
// VARCHAR(20)
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "DATA_TYPE", Types.VARCHAR);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "TYPE_NAME", "varchar");
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "COLUMN_SIZE", 20);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "VARCHAR_20_COL", "IS_NULLABLE", "YES");
// ENUM
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "DATA_TYPE", Types.CHAR);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "TYPE_NAME", "enum");
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "COLUMN_SIZE", 2);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "ENUM_COL", "IS_NULLABLE", "YES");
// SET
this.verifyColumnAttribute(metaDataMap, "SET_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "SET_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "SET_COL", "DATA_TYPE", Types.CHAR);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "TYPE_NAME", "set");
this.verifyColumnAttribute(metaDataMap, "SET_COL", "COLUMN_SIZE", 3);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "SET_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "SET_COL", "IS_NULLABLE", "YES");
// DATE
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "DATA_TYPE", Types.DATE);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "TYPE_NAME", "date");
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "COLUMN_SIZE", 10);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "DATE_COL", "IS_NULLABLE", "YES");
// TIME
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "DATA_TYPE", Types.TIME);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "TYPE_NAME", "time");
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "COLUMN_SIZE", 8);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "TIME_COL", "IS_NULLABLE", "YES");
// DATETIME
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "DATA_TYPE", Types.TIMESTAMP);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "TYPE_NAME", "datetime");
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "COLUMN_SIZE", 19);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "DATETIME_COL", "IS_NULLABLE", "YES");
// TIMESTAMP
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "DATA_TYPE", Types.TIMESTAMP);
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "TYPE_NAME", "timestamp");
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "COLUMN_SIZE", 19);
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "COLUMN_DEF", "CURRENT_TIMESTAMP");
this.verifyColumnAttribute(metaDataMap, "TIMESTAMP_COL", "IS_NULLABLE", "YES");
// YEAR
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "TABLE_CAT", "");
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "TABLE_SCHEM", null);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "TABLE_NAME", this.tableName());
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "DATA_TYPE", Types.DATE);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "TYPE_NAME", "year");
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "COLUMN_SIZE", 4);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "DECIMAL_DIGITS", 0);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "NUM_PREC_RADIX", 10);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "NULLABLE", DatabaseMetaData.columnNullable);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "REMARKS", "");
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "COLUMN_DEF", null);
this.verifyColumnAttribute(metaDataMap, "YEAR_COL", "IS_NULLABLE", "YES");
}
}