hailin0 commented on code in PR #5872:
URL: https://github.com/apache/seatunnel/pull/5872#discussion_r1400643407
##########
seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/catalog/sqlserver/SqlServerCatalog.java:
##########
@@ -100,91 +94,26 @@ protected String getSelectColumnsSql(TablePath tablePath) {
@Override
protected Column buildColumn(ResultSet resultSet) throws SQLException {
Review Comment:
| table\_name | column\_name | comment | column\_id | type | max\_length |
precision | scale | is\_nullable | default\_value | object\_id | name |
column\_id | system\_type\_id | user\_type\_id | max\_length | precision |
scale | collation\_name | is\_nullable | is\_ansi\_padded | is\_rowguidcol |
is\_identity | is\_computed | is\_filestream | is\_replicated |
is\_non\_sql\_subscribed | is\_merge\_published | is\_dts\_replicated |
is\_xml\_document | xml\_collection\_id | default\_object\_id |
rule\_object\_id | is\_sparse | is\_column\_set | generated\_always\_type |
generated\_always\_type\_desc | encryption\_type | encryption\_type\_desc |
encryption\_algorithm\_name | column\_encryption\_key\_id |
column\_encryption\_key\_database\_name | is\_hidden | is\_masked | graph\_type
| graph\_type\_desc |
| :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :---
| :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- |
:--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- |
:--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- |
:--- | :--- |
| full\_types\_1 | id | null | 1 | int | 4 | 10 | 0 | false | null |
1261963572 | id | 1 | 56 | 56 | 4 | 10 | 0 | null | false | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f1 | null | 2 | bit | 1 | 1 | 0 | true | null |
1261963572 | f1 | 2 | 104 | 104 | 1 | 1 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f2 | null | 3 | tinyint | 1 | 3 | 0 | true | null |
1261963572 | f2 | 3 | 48 | 48 | 1 | 3 | 0 | null | true | false | false | false
| false | false | false | false | false | false | false | 0 | 0 | 0 | false |
false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false | false
| null | null |
| full\_types\_1 | f3 | null | 4 | smallint | 2 | 5 | 0 | true | null |
1261963572 | f3 | 4 | 52 | 52 | 2 | 5 | 0 | null | true | false | false | false
| false | false | false | false | false | false | false | 0 | 0 | 0 | false |
false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false | false
| null | null |
| full\_types\_1 | f4 | null | 5 | int | 4 | 10 | 0 | true | null |
1261963572 | f4 | 5 | 56 | 56 | 4 | 10 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f5 | null | 6 | int | 4 | 10 | 0 | true | null |
1261963572 | f5 | 6 | 56 | 56 | 4 | 10 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f6 | null | 7 | bigint | 8 | 19 | 0 | true | null |
1261963572 | f6 | 7 | 127 | 127 | 8 | 19 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f7 | null | 8 | real | 4 | 24 | 0 | true | null |
1261963572 | f7 | 8 | 59 | 59 | 4 | 24 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f8 | null | 9 | real | 4 | 24 | 0 | true | null |
1261963572 | f8 | 9 | 59 | 59 | 4 | 24 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f9 | null | 10 | float | 8 | 53 | 0 | true | null |
1261963572 | f9 | 10 | 62 | 62 | 8 | 53 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f10 | null | 11 | decimal | 9 | 18 | 0 | true | null |
1261963572 | f10 | 11 | 106 | 106 | 9 | 18 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f11 | null | 12 | decimal | 17 | 38 | 18 | true | null |
1261963572 | f11 | 12 | 106 | 106 | 17 | 38 | 18 | null | true | false | false
| false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f12 | null | 13 | numeric | 9 | 18 | 0 | true | null |
1261963572 | f12 | 13 | 108 | 108 | 9 | 18 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f13 | null | 14 | numeric | 17 | 38 | 18 | true | null |
1261963572 | f13 | 14 | 108 | 108 | 17 | 38 | 18 | null | true | false | false
| false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f14 | null | 15 | money | 8 | 19 | 4 | true | null |
1261963572 | f14 | 15 | 60 | 60 | 8 | 19 | 4 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f15 | null | 16 | smallmoney | 4 | 10 | 4 | true | null |
1261963572 | f15 | 16 | 122 | 122 | 4 | 10 | 4 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f16 | null | 17 | char | 1 | 0 | 0 | true | null |
1261963572 | f16 | 17 | 175 | 175 | 1 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f17 | null | 18 | char | 1 | 0 | 0 | true | null |
1261963572 | f17 | 18 | 175 | 175 | 1 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f18 | null | 19 | nchar | 2 | 0 | 0 | true | null |
1261963572 | f18 | 19 | 239 | 239 | 2 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f19 | null | 20 | nchar | 2 | 0 | 0 | true | null |
1261963572 | f19 | 20 | 239 | 239 | 2 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f20 | null | 21 | varchar | 1 | 0 | 0 | true | null |
1261963572 | f20 | 21 | 167 | 167 | 1 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f21 | null | 22 | varchar | 1 | 0 | 0 | true | null |
1261963572 | f21 | 22 | 167 | 167 | 1 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f22 | null | 23 | varchar | -1 | 0 | 0 | true | null |
1261963572 | f22 | 23 | 167 | 167 | -1 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f23 | null | 24 | nvarchar | 2 | 0 | 0 | true | null |
1261963572 | f23 | 24 | 231 | 231 | 2 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f24 | null | 25 | nvarchar | 2 | 0 | 0 | true | null |
1261963572 | f24 | 25 | 231 | 231 | 2 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f25 | null | 26 | nvarchar | -1 | 0 | 0 | true | null |
1261963572 | f25 | 26 | 231 | 231 | -1 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | true | false | false | false | false
| false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f26 | null | 27 | text | 16 | 0 | 0 | true | null |
1261963572 | f26 | 27 | 35 | 35 | 16 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | false | false | false | false |
false | false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f27 | null | 28 | ntext | 16 | 0 | 0 | true | null |
1261963572 | f27 | 28 | 99 | 99 | 16 | 0 | 0 |
SQL\_Latin1\_General\_CP1\_CI\_AS | true | false | false | false | false |
false | false | false | false | false | false | 0 | 0 | 0 | false | false | 0 |
NOT\_APPLICABLE | null | null | null | null | null | false | false | null |
null |
| full\_types\_1 | f28 | null | 29 | xml | -1 | 0 | 0 | true | null |
1261963572 | f28 | 29 | 241 | 241 | -1 | 0 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f29 | null | 30 | binary | 1 | 0 | 0 | true | null |
1261963572 | f29 | 30 | 173 | 173 | 1 | 0 | 0 | null | true | true | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f30 | null | 31 | binary | 1 | 0 | 0 | true | null |
1261963572 | f30 | 31 | 173 | 173 | 1 | 0 | 0 | null | true | true | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f31 | null | 32 | varbinary | 1 | 0 | 0 | true | null |
1261963572 | f31 | 32 | 165 | 165 | 1 | 0 | 0 | null | true | true | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f32 | null | 33 | varbinary | 1 | 0 | 0 | true | null |
1261963572 | f32 | 33 | 165 | 165 | 1 | 0 | 0 | null | true | true | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f33 | null | 34 | varbinary | -1 | 0 | 0 | true | null |
1261963572 | f33 | 34 | 165 | 165 | -1 | 0 | 0 | null | true | true | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f34 | null | 35 | image | 16 | 0 | 0 | true | null |
1261963572 | f34 | 35 | 34 | 34 | 16 | 0 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f35 | null | 36 | date | 3 | 10 | 0 | true | null |
1261963572 | f35 | 36 | 40 | 40 | 3 | 10 | 0 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f36 | null | 37 | time | 5 | 16 | 7 | true | null |
1261963572 | f36 | 37 | 41 | 41 | 5 | 16 | 7 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f37 | null | 38 | time | 4 | 12 | 3 | true | null |
1261963572 | f37 | 38 | 41 | 41 | 4 | 12 | 3 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f38 | null | 39 | datetime | 8 | 23 | 3 | true | null |
1261963572 | f38 | 39 | 61 | 61 | 8 | 23 | 3 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f39 | null | 40 | datetime2 | 8 | 27 | 7 | true | null |
1261963572 | f39 | 40 | 42 | 42 | 8 | 27 | 7 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f40 | null | 41 | datetime2 | 7 | 23 | 3 | true | null |
1261963572 | f40 | 41 | 42 | 42 | 7 | 23 | 3 | null | true | false | false |
false | false | false | false | false | false | false | false | 0 | 0 | 0 |
false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null | false
| false | null | null |
| full\_types\_1 | f41 | null | 42 | datetimeoffset | 10 | 34 | 7 | true |
null | 1261963572 | f41 | 42 | 43 | 43 | 10 | 34 | 7 | null | true | false |
false | false | false | false | false | false | false | false | false | 0 | 0 |
0 | false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null |
false | false | null | null |
| full\_types\_1 | f42 | null | 43 | datetimeoffset | 9 | 30 | 3 | true |
null | 1261963572 | f42 | 43 | 43 | 43 | 9 | 30 | 3 | null | true | false |
false | false | false | false | false | false | false | false | false | 0 | 0 |
0 | false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null |
false | false | null | null |
| full\_types\_1 | f43 | null | 44 | smalldatetime | 4 | 16 | 0 | true |
null | 1261963572 | f43 | 44 | 58 | 58 | 4 | 16 | 0 | null | true | false |
false | false | false | false | false | false | false | false | false | 0 | 0 |
0 | false | false | 0 | NOT\_APPLICABLE | null | null | null | null | null |
false | false | null | null |
--
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]
