Example 16 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_chars method test_oracle2pg_varchar_8000.
public void test_oracle2pg_varchar_8000() throws Exception {
String sql = "varchar(8000)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("TEXT", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 17 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_chars method test_oracle2pg_bfile.
public void test_oracle2pg_bfile() throws Exception {
String sql = "bfile";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("VARCHAR(255)", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 18 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_chars method test_oracle2pg_varchar2_8000.
public void test_oracle2pg_varchar2_8000() throws Exception {
String sql = "varchar2(8000)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("TEXT", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 19 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_double method test_oracle2pg_number_star.
public void test_oracle2pg_number_star() throws Exception {
String sql = "number(*)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("DOUBLE PRECISION", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 20 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_double method test_oracle2pg_real.
public void test_oracle2pg_real() throws Exception {
String sql = "real";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("DOUBLE PRECISION", 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
