zy-kkk opened a new pull request, #34869:
URL: https://github.com/apache/doris/pull/34869
## Proposed changes
Issue Number: close #xxx
Doris > select * from ob_mysql.test.all_types;
+-----------+------------+-------------+-------+----------+-----------+-----------+----------+---------+---------+----------+------+-----------+------+--------+------------+--------------------------+---------------------+----------+------------------+---------+------+---------+--------------+-------+--------------------------+----------------------------------------------------+-----------------+------+----------------------------+--------------+--------+
| tinyint_u | smallint_u | mediumint_u | int_u | bigint_u | decimal_u |
double_u | float_u | boolean | tinyint | smallint | year | mediumint | int |
bigint | date | timestamp | datetime | float
| double | decimal | char | varchar | time | text | blob
| json | set
| bit | binary | varbinary | enum |
+-----------+------------+-------------+-------+----------+-----------+-----------+----------+---------+---------+----------+------+-----------+------+--------+------------+--------------------------+---------------------+----------+------------------+---------+------+---------+--------------+-------+--------------------------+----------------------------------------------------+-----------------+------+----------------------------+--------------+--------+
| 201 | 301 | 401 | 501 | 601 | 3.14159 |
4.1415926 | 5.141592 | 1 | -123 | -301 | 2012 | -401 | -501 |
-601 | 2012-10-30 | 2012-10-25 12:05:36.3457 | 2012-10-25 08:08:08 | -4.14145
| -5.1400000001 | -6.1400 | row1 | line1 | 09:09:09.567 | text1 |
0x48656C6C6F20576F726C64 | {"age": 30, "city": "London", "name": "Alice"} |
Option1,Option3 | 0x2A | 0x48656C6C6F00000000000000 | 0x48656C6C6F | Value2 |
| 202 | 302 | 402 | 502 | 602 | 4.14159 |
5.1415926 | 6.141592 | 0 | -124 | -302 | 2013 | -402 | -502 |
-602 | 2012-11-01 | 2012-10-26 02:08:39.3457 | 2013-10-26 08:09:18 | -5.14145
| -6.1400000001 | -7.1400 | row2 | line2 | 09:11:09.567 | text2 |
0xE86F6C6C6F20576F726C67 | {"age": 18, "city": "ChongQing", "name": "Gaoxin"} |
Option1,Option2 | 0x2F | 0x58676C6C6F00000000000000 | 0x88656C6C9F | Value3 |
| NULL | 302 | NULL | 502 | 602 | 4.14159 |
NULL | 6.141592 | NULL | -124 | -302 | 2013 | -402 | -502 |
-602 | NULL | 2012-10-26 02:08:39.3457 | 2013-10-26 08:09:18 | -5.14145 |
NULL | -7.1400 | row2 | NULL | 09:11:09.567 | text2 |
0xE86F6C6C6F20576F726C67 | NULL |
NULL | 0x2F | NULL | 0x88656C6C9F | Value3 |
| 203 | 303 | 403 | 503 | 603 | 7.14159 |
8.1415926 | 9.141592 | 0 | NULL | -402 | 2017 | -602 | -902 |
-1102 | 2012-11-02 | NULL | 2013-10-27 08:11:18 | -5.14145
| -6.1400000000001 | -7.1400 | row3 | line3 | 09:11:09.567 | text3 |
0xE86F6C6C6F20576F726C67 | {"age": 24, "city": "ChongQing", "name": "ChenQi"} |
Option2 | 0x2F | 0x58676C6C6F00000000000000 | NULL | Value1 |
+-----------+------------+-------------+-------+----------+-----------+-----------+----------+---------+---------+----------+------+-----------+------+--------+------------+--------------------------+---------------------+----------+------------------+---------+------+---------+--------------+-------+--------------------------+----------------------------------------------------+-----------------+------+----------------------------+--------------+--------+
4 rows in set (0.56 sec)
```
Doris > select * from ob_oracle.ZYK.TEST_ALL_TYPES;
+------+------+------+------------+------+------+--------+--------------------+------+--------------------+----------------+-----------------+------------+--------------------+----------------+-----------------+------------+---------------------+---------+--------+---------+-------+--------+-------+-----------+---------------------+-------------------------+----------------------------+----------------------------+----------------------------+-------+-------------------+
| ID | N1 | N2 | N3 | N4 | N5 | N6 | N7
| N8 | N9 | TINYINT_VALUE1 | SMALLINT_VALUE1 | INT_VALUE1 |
BIGINT_VALUE1 | TINYINT_VALUE2 | SMALLINT_VALUE2 | INT_VALUE2 |
BIGINT_VALUE2 | COUNTRY | CITY | ADDRESS | NAME | NUM1 | NUM2 |
NUM4 | T1 | T2 | T3
| T4 | T5 | T6 | T7
|
+------+------+------+------------+------+------+--------+--------------------+------+--------------------+----------------+-----------------+------------+--------------------+----------------+-----------------+------------+---------------------+---------+--------+---------+-------+--------+-------+-----------+---------------------+-------------------------+----------------------------+----------------------------+----------------------------+-------+-------------------+
| 1 | 111 | 123 | 7456123.89 | 573 | 34 | 673.43 |
34.126399993896484 | 60 | 23.231000900268555 | 99 |
9999 | 999999999 | 999999999999999999 | 999 | 99999 |
9999999999 | 9999999999999999999 | 1 | china | beijing | alice | 123.45
| 12300 | 0.0012345 | 2022-01-21 05:23:01 | 2019-11-12 20:33:57.999 |
2019-11-12 20:33:57.999998 | 2019-11-12 20:33:57.999996 | 2019-11-12
20:33:57.999997 | 223-9 | 12 10:23:1.123457 |
| 2 | NULL | NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL
| NULL | NULL | NULL | NULL
|
+------+------+------+------------+------+------+--------+--------------------+------+--------------------+----------------+-----------------+------------+--------------------+----------------+-----------------+------------+---------------------+---------+--------+---------+-------+--------+-------+-----------+---------------------+-------------------------+----------------------------+----------------------------+----------------------------+-------+-------------------+
2 rows in set (0.35 sec)
```
## Further comments
If this is a relatively large or complex change, kick off the discussion at
[[email protected]](mailto:[email protected]) by explaining why you
chose the solution you did and what alternatives you considered, etc...
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
