/* Copyright (C) 2002-2007 MySQL AB This program is free software; you can redistribute it and/or modify it under the terms of version 2 of the GNU General Public License as  published by the Free Software Foundation. There are special exceptions to the terms and conditions of the GPL  as it is applied to this software. View the full text of the  exception in file EXCEPTIONS-CONNECTOR-J in the directory of this  software distribution. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */package testsuite.regression;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.DriverPropertyInfo;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.sql.Statement;import java.sql.Types;import java.util.HashMap;import java.util.Properties;import testsuite.BaseTestCase;import com.mysql.jdbc.Driver;import com.mysql.jdbc.Field;import com.mysql.jdbc.NonRegisteringDriver;import com.mysql.jdbc.SQLError;/** * Regression tests for DatabaseMetaData *  * @author Mark Matthews * @version $Id: MetaDataRegressionTest.java,v 1.1.2.1 2005/05/13 18:58:38 *          mmatthews Exp $ */public class MetaDataRegressionTest extends BaseTestCase {	/**	 * Creates a new MetaDataRegressionTest.	 * 	 * @param name	 *            the name of the test	 */	public MetaDataRegressionTest(String name) {		super(name);	}	/**	 * Runs all test cases in this test suite	 * 	 * @param args	 */	public static void main(String[] args) {		junit.textui.TestRunner.run(MetaDataRegressionTest.class);	}	/**	 * DOCUMENT ME!	 * 	 * @throws Exception	 *             ...	 */	public void testBug2607() throws Exception {		try {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug2607");			this.stmt					.executeUpdate("CREATE TABLE testBug2607 (field1 INT PRIMARY KEY)");			this.rs = this.stmt.executeQuery("SELECT field1 FROM testBug2607");			ResultSetMetaData rsmd = this.rs.getMetaData();			assertTrue(!rsmd.isAutoIncrement(1));		} finally {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug2607");		}	}	/**	 * Tests fix for BUG#2852, where RSMD is not returning correct (or matching)	 * types for TINYINT and SMALLINT.	 * 	 * @throws Exception	 *             if the test fails.	 */	public void testBug2852() throws Exception {		try {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug2852");			this.stmt					.executeUpdate("CREATE TABLE testBug2852 (field1 TINYINT, field2 SMALLINT)");			this.stmt.executeUpdate("INSERT INTO testBug2852 VALUES (1,1)");			this.rs = this.stmt.executeQuery("SELECT * from testBug2852");			assertTrue(this.rs.next());			ResultSetMetaData rsmd = this.rs.getMetaData();			assertTrue(rsmd.getColumnClassName(1).equals(					this.rs.getObject(1).getClass().getName()));			assertTrue("java.lang.Integer".equals(rsmd.getColumnClassName(1)));			assertTrue(rsmd.getColumnClassName(2).equals(					this.rs.getObject(2).getClass().getName()));			assertTrue("java.lang.Integer".equals(rsmd.getColumnClassName(2)));		} finally {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug2852");		}	}	/**	 * Tests fix for BUG#2855, where RSMD is not returning correct (or matching)	 * types for FLOAT.	 * 	 * @throws Exception	 *             if the test fails.	 */	public void testBug2855() throws Exception {		try {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug2855");			this.stmt.executeUpdate("CREATE TABLE testBug2855 (field1 FLOAT)");			this.stmt.executeUpdate("INSERT INTO testBug2855 VALUES (1)");			this.rs = this.stmt.executeQuery("SELECT * from testBug2855");			assertTrue(this.rs.next());			ResultSetMetaData rsmd = this.rs.getMetaData();			assertTrue(rsmd.getColumnClassName(1).equals(					this.rs.getObject(1).getClass().getName()));			assertTrue("java.lang.Float".equals(rsmd.getColumnClassName(1)));		} finally {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug2855");		}	}	/**	 * Tests fix for BUG#3570 -- inconsistent reporting of column type	 * 	 * @throws Exception	 *             if an error occurs	 */	public void testBug3570() throws Exception {		String createTableQuery = " CREATE TABLE testBug3570(field_tinyint TINYINT"				+ ",field_smallint SMALLINT"				+ ",field_mediumint MEDIUMINT"				+ ",field_int INT"				+ ",field_integer INTEGER"				+ ",field_bigint BIGINT"				+ ",field_real REAL"				+ ",field_float FLOAT"				+ ",field_decimal DECIMAL"				+ ",field_numeric NUMERIC"				+ ",field_double DOUBLE"				+ ",field_char CHAR(3)"				+ ",field_varchar VARCHAR(255)"				+ ",field_date DATE"				+ ",field_time TIME"				+ ",field_year YEAR"				+ ",field_timestamp TIMESTAMP"				+ ",field_datetime DATETIME"				+ ",field_tinyblob TINYBLOB"				+ ",field_blob BLOB"				+ ",field_mediumblob MEDIUMBLOB"				+ ",field_longblob LONGBLOB"				+ ",field_tinytext TINYTEXT"				+ ",field_text TEXT"				+ ",field_mediumtext MEDIUMTEXT"				+ ",field_longtext LONGTEXT"				+ ",field_enum ENUM('1','2','3')"				+ ",field_set SET('1','2','3'))";		try {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug3570");			this.stmt.executeUpdate(createTableQuery);			ResultSet dbmdRs = this.conn.getMetaData().getColumns(					this.conn.getCatalog(), null, "testBug3570", "%");			this.rs = this.stmt.executeQuery("SELECT * FROM testBug3570");			ResultSetMetaData rsmd = this.rs.getMetaData();			while (dbmdRs.next()) {				String columnName = dbmdRs.getString(4);				int typeFromGetColumns = dbmdRs.getInt(5);				int typeFromRSMD = rsmd.getColumnType(this.rs						.findColumn(columnName));				//				// TODO: Server needs to send these types correctly....				//				if (!"field_tinyblob".equals(columnName)						&& !"field_tinytext".equals(columnName)) {					assertTrue(columnName + " -> type from DBMD.getColumns("							+ typeFromGetColumns							+ ") != type from RSMD.getColumnType("							+ typeFromRSMD + ")",							typeFromGetColumns == typeFromRSMD);				}			}		} finally {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug3570");		}	}	/**	 * Tests char/varchar bug	 * 	 * @throws Exception	 *             if any errors occur	 */	public void testCharVarchar() throws Exception {		try {			this.stmt.execute("DROP TABLE IF EXISTS charVarCharTest");			this.stmt.execute("CREATE TABLE charVarCharTest ("					+ "  TableName VARCHAR(64)," + "  FieldName VARCHAR(64),"					+ "  NextCounter INTEGER);");			String query = "SELECT TableName, FieldName, NextCounter FROM charVarCharTest";			this.rs = this.stmt.executeQuery(query);			ResultSetMetaData rsmeta = this.rs.getMetaData();			assertTrue(rsmeta.getColumnTypeName(1).equalsIgnoreCase("VARCHAR"));			// is "CHAR", expected "VARCHAR"			assertTrue(rsmeta.getColumnType(1) == 12);			// is 1 (java.sql.Types.CHAR), expected 12 (java.sql.Types.VARCHAR)		} finally {			this.stmt.execute("DROP TABLE IF EXISTS charVarCharTest");		}	}	/**	 * Tests fix for BUG#1673, where DatabaseMetaData.getColumns() is not	 * returning correct column ordinal info for non '%' column name patterns.	 * 	 * @throws Exception	 *             if the test fails for any reason	 */	public void testFixForBug1673() throws Exception {		try {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug1673");			this.stmt					.executeUpdate("CREATE TABLE testBug1673 (field_1 INT, field_2 INT)");			DatabaseMetaData dbmd = this.conn.getMetaData();			int ordinalPosOfCol2Full = 0;			this.rs = dbmd.getColumns(this.conn.getCatalog(), null,					"testBug1673", null);			while (this.rs.next()) {				if (this.rs.getString(4).equals("field_2")) {					ordinalPosOfCol2Full = this.rs.getInt(17);				}			}			int ordinalPosOfCol2Scoped = 0;			this.rs = dbmd.getColumns(this.conn.getCatalog(), null,					"testBug1673", "field_2");			while (this.rs.next()) {				if (this.rs.getString(4).equals("field_2")) {					ordinalPosOfCol2Scoped = this.rs.getInt(17);				}			}			assertTrue("Ordinal position in full column list of '"					+ ordinalPosOfCol2Full					+ "' != ordinal position in pattern search, '"					+ ordinalPosOfCol2Scoped + "'.",					(ordinalPosOfCol2Full != 0)							&& (ordinalPosOfCol2Scoped != 0)							&& (ordinalPosOfCol2Scoped == ordinalPosOfCol2Full));		} finally {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug1673");		}	}	/**	 * Tests bug reported by OpenOffice team with getColumns and LONGBLOB	 * 	 * @throws Exception	 *             if any errors occur	 */	public void testGetColumns() throws Exception {		try {			this.stmt					.execute("CREATE TABLE IF NOT EXISTS longblob_regress(field_1 longblob)");			DatabaseMetaData dbmd = this.conn.getMetaData();			ResultSet dbmdRs = null;			try {				dbmdRs = dbmd.getColumns("", "", "longblob_regress", "%");				while (dbmdRs.next()) {					dbmdRs.getInt(7);				}			} finally {				if (dbmdRs != null) {					try {						dbmdRs.close();					} catch (SQLException ex) {						;					}				}			}		} finally {			this.stmt.execute("DROP TABLE IF EXISTS longblob_regress");		}	}	/**	 * Tests fix for Bug#	 * 	 * @throws Exception	 *             if an error occurs	 */	public void testGetColumnsBug1099() throws Exception {		try {			this.stmt					.executeUpdate("DROP TABLE IF EXISTS testGetColumnsBug1099");			DatabaseMetaData dbmd = this.conn.getMetaData();			this.rs = dbmd.getTypeInfo();			StringBuffer types = new StringBuffer();			HashMap alreadyDoneTypes = new HashMap();			while (this.rs.next()) {				String typeName = this.rs.getString("TYPE_NAME");				String createParams = this.rs.getString("CREATE_PARAMS");				if ((typeName.indexOf("BINARY") == -1)						&& !typeName.equals("LONG VARCHAR")) {					if (!alreadyDoneTypes.containsKey(typeName)) {						alreadyDoneTypes.put(typeName, null);						if (types.length() != 0) {							types.append(", \n");						}						int typeNameLength = typeName.length();						StringBuffer safeTypeName = new StringBuffer(								typeNameLength);						for (int i = 0; i < typeNameLength; i++) {							char c = typeName.charAt(i);							if (Character.isWhitespace(c)) {								safeTypeName.append("_");							} else {								safeTypeName.append(c);							}						}						types.append(safeTypeName.toString());						types.append("Column ");						types.append(typeName);						if (typeName.indexOf("CHAR") != -1) {							types.append(" (1)");						} else if (typeName.equalsIgnoreCase("enum")								|| typeName.equalsIgnoreCase("set")) {							types.append("('a', 'b', 'c')");						}					}				}			}			this.stmt.executeUpdate("CREATE TABLE testGetColumnsBug1099("					+ types.toString() + ")");			dbmd.getColumns(null, this.conn.getCatalog(),					"testGetColumnsBug1099", "%");		} finally {			this.stmt					.executeUpdate("DROP TABLE IF EXISTS testGetColumnsBug1099");		}	}	/**	 * Tests whether or not unsigned columns are reported correctly in	 * DBMD.getColumns	 * 	 * @throws Exception	 */	public void testGetColumnsUnsigned() throws Exception {		try {			this.stmt.executeUpdate("DROP TABLE IF EXISTS testGetUnsignedCols");