type conversion error from jdbc oracle resource external table

[tiannan-sr]

Steps to reproduce the behavior (Required)

1. create resource external table

mysql>  create external table jdbc_ext_tbl_oracle_type_timestamp_test (
    -> type_timestamp string
    -> ) ENGINE=jdbc PROPERTIES (
    ->     "resource"="jdbc_ora_res_b8ccbb14_11e9_11ef_83fb_00163e0e489a",
    ->     "table"="tbl_oracle_type_text_date"
    -> );
Query OK, 0 rows affected (0.00 sec)

2. select error:

mysql> select * from jdbc_ext_tbl_oracle_type_timestamp_test order by 1;
ERROR 1064 (HY000): Type mismatches on column[type_timestamp], JDBC result type is oracle Timestamp, please set the type to datetime

Expected behavior (Required)

select ok

Real behavior (Required)

select error

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()

---

mysql> select current_version();
+-------------------+
| current_version() |
+-------------------+
| main-97fd498      |
+-------------------+
1 row in set (0.00 sec)