Example 21 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2MySql_DataTypeTest_number_int method test_oracle2pg_int_17.
public void test_oracle2pg_int_17() throws Exception {
String sql = "number(17, 0)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToMySql(dataType);
assertEquals("bigint", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 22 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2MySql_DataTypeTest_number_int method test_oracle2pg_int_3.
public void test_oracle2pg_int_3() throws Exception {
String sql = "number(3, 0)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToMySql(dataType);
assertEquals("smallint", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 23 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2MySql_DataTypeTest_number_int method test_oracle2pg_int_8.
public void test_oracle2pg_int_8() throws Exception {
String sql = "number(8, 0)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToMySql(dataType);
assertEquals("int", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 24 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2MySql_DataTypeTest_number_int method test_oracle2pg_int_20.
public void test_oracle2pg_int_20() throws Exception {
String sql = "number(20, 0)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToMySql(dataType);
assertEquals("bigint", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 25 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2MySql_DataTypeTest_number_int method test_oracle2pg_int_1.
public void test_oracle2pg_int_1() throws Exception {
String sql = "number(1, 0)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToMySql(dataType);
assertEquals("tinyint", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Aggregations
SQLDataType (com.alibaba.druid.sql.ast.SQLDataType)93
SQLDataTypeImpl (com.alibaba.druid.sql.ast.SQLDataTypeImpl)7
SQLExpr (com.alibaba.druid.sql.ast.SQLExpr)7
SQLCharacterDataType (com.alibaba.druid.sql.ast.statement.SQLCharacterDataType)5
SQLAllColumnExpr (com.alibaba.druid.sql.ast.expr.SQLAllColumnExpr)4
SQLIntegerExpr (com.alibaba.druid.sql.ast.expr.SQLIntegerExpr)4
SQLNumericLiteralExpr (com.alibaba.druid.sql.ast.expr.SQLNumericLiteralExpr)3
SQLColumnDefinition (com.alibaba.druid.sql.ast.statement.SQLColumnDefinition)3
SQLVariantRefExpr (com.alibaba.druid.sql.ast.expr.SQLVariantRefExpr)2
SQLName (com.alibaba.druid.sql.ast.SQLName)1
SQLStatement (com.alibaba.druid.sql.ast.SQLStatement)1
SQLCharExpr (com.alibaba.druid.sql.ast.expr.SQLCharExpr)1
SQLIdentifierExpr (com.alibaba.druid.sql.ast.expr.SQLIdentifierExpr)1
SQLIntervalExpr (com.alibaba.druid.sql.ast.expr.SQLIntervalExpr)1
SQLMethodInvokeExpr (com.alibaba.druid.sql.ast.expr.SQLMethodInvokeExpr)1
SQLNullExpr (com.alibaba.druid.sql.ast.expr.SQLNullExpr)1
SQLAlterTableAlterColumn (com.alibaba.druid.sql.ast.statement.SQLAlterTableAlterColumn)1
SQLColumnConstraint (com.alibaba.druid.sql.ast.statement.SQLColumnConstraint)1
SQLColumnPrimaryKey (com.alibaba.druid.sql.ast.statement.SQLColumnPrimaryKey)1
SQLColumnUniqueKey (com.alibaba.druid.sql.ast.statement.SQLColumnUniqueKey)1
