Function oracleTp2MySQLTp

driver/oracle/extractor/sql_parse.go:249–405

(td *oracle_ast.ColumnDef)

}

func oracleTp2MySQLTp(td *oracle_ast.ColumnDef) *ast.ColumnDef {
	columnName := IdentifierToString(td.ColumnName)
	column := &ast.ColumnDef{
		Name: &ast.ColumnName{
			Name: model.NewCIStr(columnName),
		},
	}
	for i := range td.Constraints {
		column.Options = append(column.Options, transConstraintOtoM(td.Constraints[i]))
	}

	tp := &types.FieldType{
		Flen:    types.UnspecifiedLength,
		Decimal: types.UnspecifiedLength,
	}

	switch td.Datatype.DataDef() {
	case oracle_element.DataDefBFile:
		tp.Tp = mysql.TypeVarchar
		tp.Flen = 255
	case oracle_element.DataDefBinaryFloat:
		tp.Tp = mysql.TypeFloat
	case oracle_element.DataDefBinaryDouble:
		tp.Tp = mysql.TypeDouble
	case oracle_element.DataDefBlob:
		tp.Tp = mysql.TypeLongBlob
		tp.Flag = mysql.BinaryFlag
		tp.Charset = "binary"
		tp.Collate = "binary"
	case oracle_element.DataDefChar:
		if *td.Datatype.(*oracle_element.Char).Size >= 1 && *td.Datatype.(*oracle_element.Char).Size <= 255 {
			tp.Tp = mysql.TypeString
			tp.Flen = *td.Datatype.(*oracle_element.Char).Size
		} else if *td.Datatype.(*oracle_element.Char).Size >= 256 && *td.Datatype.(*oracle_element.Char).Size <= 2000 {
			tp.Tp = mysql.TypeVarchar
			tp.Flen = *td.Datatype.(*oracle_element.Char).Size
		}
	case oracle_element.DataDefCharacter:
		if *td.Datatype.(*oracle_element.Char).Size >= 1 && *td.Datatype.(*oracle_element.Char).Size <= 255 {
			tp.Tp = mysql.TypeString
			tp.Flen = *td.Datatype.(*oracle_element.Char).Size
		} else if *td.Datatype.(*oracle_element.Char).Size >= 256 && *td.Datatype.(*oracle_element.Char).Size <= 2000 {
			tp.Tp = mysql.TypeVarchar
			tp.Flen = *td.Datatype.(*oracle_element.Char).Size
		}
	case oracle_element.DataDefClob:
		tp.Tp = mysql.TypeLongBlob
	case oracle_element.DataDefDate:
		tp.Tp = mysql.TypeDatetime
	case oracle_element.DataDefDecimal, oracle_element.DataDefDec:
		tp.Tp = mysql.TypeNewDecimal
		tp.Flen = td.Datatype.(*oracle_element.Number).Precision.Number
		tp.Decimal = LimitSize(*td.Datatype.(*oracle_element.Number).Scale)
	case oracle_element.DataDefDoublePrecision:
		tp.Tp = mysql.TypeDouble
	case oracle_element.DataDefFloat:
		tp.Tp = mysql.TypeDouble
	case oracle_element.DataDefInteger: