You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "adam-sunhao (via GitHub)" <gi...@apache.org> on 2023/05/22 09:41:21 UTC
[GitHub] [shardingsphere] adam-sunhao opened a new issue, #25847: Couldn't get metadata from ShardingShpere-Proxy
adam-sunhao opened a new issue, #25847:
URL: https://github.com/apache/shardingsphere/issues/25847
## Bug Report
### Which version of ShardingSphere did you use?
5.3.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Development environment
MySQL 8.0.26
mysql-connector-java 8.0.26 (connect to ShardingSphere-Proxy)
### Expected behavior
Using jdbc DatabaseMetaData to get columns or indexInfo
### Actual behavior
throw a exception
java.lang.IllegalStateException: Unsupported SQL operator: `IS`
### Example codes for reproduce this issue (such as a github link).
Here is code snipped from seata, after I changed the driver version from 8.0.26 to 5.1.47, then I could get meta data from logical tables .
`
private TableMeta resultSetMetaToSchema(ResultSetMetaData rsmd, DatabaseMetaData dbmd)
throws SQLException {
//always "" for mysql
String schemaName = rsmd.getSchemaName(1);
String catalogName = rsmd.getCatalogName(1);
/*
* use ResultSetMetaData to get the pure table name
* can avoid the problem below
*
* select * from account_tbl
* select * from account_TBL
* select * from `account_tbl`
* select * from account.account_tbl
*/
String tableName = rsmd.getTableName(1);
TableMeta tm = new TableMeta();
tm.setTableName(tableName);
/*
* here has two different type to get the data
* make sure the table name was right
* 1. show full columns from xxx from xxx(normal)
* 2. select xxx from xxx where catalog_name like ? and table_name like ?(informationSchema=true)
*/
try (ResultSet rsColumns = dbmd.getColumns(catalogName, schemaName, tableName, "%");
ResultSet rsIndex = dbmd.getIndexInfo(catalogName, schemaName, tableName, false, true);
ResultSet onUpdateColumns = dbmd.getVersionColumns(catalogName, schemaName, tableName)) {
while (rsColumns.next()) {
ColumnMeta col = new ColumnMeta();
col.setTableCat(rsColumns.getString("TABLE_CAT"));
col.setTableSchemaName(rsColumns.getString("TABLE_SCHEM"));
col.setTableName(rsColumns.getString("TABLE_NAME"));
col.setColumnName(rsColumns.getString("COLUMN_NAME"));
col.setDataType(rsColumns.getInt("DATA_TYPE"));
col.setDataTypeName(rsColumns.getString("TYPE_NAME"));
col.setColumnSize(rsColumns.getInt("COLUMN_SIZE"));
col.setDecimalDigits(rsColumns.getInt("DECIMAL_DIGITS"));
col.setNumPrecRadix(rsColumns.getInt("NUM_PREC_RADIX"));
col.setNullAble(rsColumns.getInt("NULLABLE"));
col.setRemarks(rsColumns.getString("REMARKS"));
col.setColumnDef(rsColumns.getString("COLUMN_DEF"));
col.setSqlDataType(rsColumns.getInt("SQL_DATA_TYPE"));
col.setSqlDatetimeSub(rsColumns.getInt("SQL_DATETIME_SUB"));
col.setCharOctetLength(rsColumns.getInt("CHAR_OCTET_LENGTH"));
col.setOrdinalPosition(rsColumns.getInt("ORDINAL_POSITION"));
col.setIsNullAble(rsColumns.getString("IS_NULLABLE"));
col.setIsAutoincrement(rsColumns.getString("IS_AUTOINCREMENT"));
if (tm.getAllColumns().containsKey(col.getColumnName())) {
throw new NotSupportYetException("Not support the table has the same column name with different case yet");
}
tm.getAllColumns().put(col.getColumnName(), col);
}
while (onUpdateColumns.next()) {
tm.getAllColumns().get(onUpdateColumns.getString("COLUMN_NAME")).setOnUpdate(true);
}
while (rsIndex.next()) {
String indexName = rsIndex.getString("INDEX_NAME");
String colName = rsIndex.getString("COLUMN_NAME");
ColumnMeta col = tm.getAllColumns().get(colName);
if (tm.getAllIndexes().containsKey(indexName)) {
IndexMeta index = tm.getAllIndexes().get(indexName);
index.getValues().add(col);
} else {
IndexMeta index = new IndexMeta();
index.setIndexName(indexName);
index.setNonUnique(rsIndex.getBoolean("NON_UNIQUE"));
index.setIndexQualifier(rsIndex.getString("INDEX_QUALIFIER"));
index.setIndexName(rsIndex.getString("INDEX_NAME"));
index.setType(rsIndex.getShort("TYPE"));
index.setOrdinalPosition(rsIndex.getShort("ORDINAL_POSITION"));
index.setAscOrDesc(rsIndex.getString("ASC_OR_DESC"));
index.setCardinality(rsIndex.getInt("CARDINALITY"));
index.getValues().add(col);
if ("PRIMARY".equalsIgnoreCase(indexName)) {
index.setIndextype(IndexType.PRIMARY);
} else if (!index.isNonUnique()) {
index.setIndextype(IndexType.UNIQUE);
} else {
index.setIndextype(IndexType.NORMAL);
}
tm.getAllIndexes().put(indexName, index);
}
}
if (tm.getAllIndexes().isEmpty()) {
throw new ShouldNeverHappenException("Could not found any index in the table: " + tableName);
}
}
return tm;
}
`
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] adam-sunhao commented on issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "adam-sunhao (via GitHub)" <gi...@apache.org>.
adam-sunhao commented on issue #25847:
URL: https://github.com/apache/shardingsphere/issues/25847#issuecomment-1560376274
2023-05-19 18:31:05.821 [nioEventLoopGroup-3-8] DEBUG o.a.shardingsphere.db.protocol.codec.PacketCodec - Read from client d37ba447 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| e9 14 00 00 03 53 45 4c 45 43 54 20 54 41 42 4c |.....SELECT TABL|
|00000010| 45 5f 53 43 48 45 4d 41 20 41 53 20 54 41 42 4c |E_SCHEMA AS TABL|
|00000020| 45 5f 43 41 54 2c 20 4e 55 4c 4c 20 41 53 20 54 |E_CAT, NULL AS T|
|00000030| 41 42 4c 45 5f 53 43 48 45 4d 2c 20 54 41 42 4c |ABLE_SCHEM, TABL|
|00000040| 45 5f 4e 41 4d 45 2c 20 43 4f 4c 55 4d 4e 5f 4e |E_NAME, COLUMN_N|
|00000050| 41 4d 45 2c 43 41 53 45 20 20 57 48 45 4e 20 55 |AME,CASE WHEN U|
|00000060| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000070| 27 44 45 43 49 4d 41 4c 27 20 54 48 45 4e 20 33 |'DECIMAL' THEN 3|
|00000080| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000090| 5f 54 59 50 45 29 3d 27 44 45 43 49 4d 41 4c 20 |_TYPE)='DECIMAL |
|000000a0| 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e 20 33 |UNSIGNED' THEN 3|
|000000b0| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|000000c0| 5f 54 59 50 45 29 3d 27 54 49 4e 59 49 4e 54 27 |_TYPE)='TINYINT'|
|000000d0| 20 54 48 45 4e 20 43 41 53 45 20 57 48 45 4e 20 | THEN CASE WHEN |
|000000e0| 4c 4f 43 41 54 45 28 27 28 31 29 27 2c 20 43 4f |LOCATE('(1)', CO|
|000000f0| 4c 55 4d 4e 5f 54 59 50 45 29 20 21 3d 20 30 20 |LUMN_TYPE) != 0 |
|00000100| 54 48 45 4e 20 2d 37 20 45 4c 53 45 20 2d 36 20 |THEN -7 ELSE -6 |
|00000110| 45 4e 44 20 20 57 48 45 4e 20 55 50 50 45 52 28 |END WHEN UPPER(|
|00000120| 44 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4e 59 |DATA_TYPE)='TINY|
|00000130| 49 4e 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 |INT UNSIGNED' TH|
|00000140| 45 4e 20 43 41 53 45 20 57 48 45 4e 20 4c 4f 43 |EN CASE WHEN LOC|
|00000150| 41 54 45 28 27 28 31 29 27 2c 20 43 4f 4c 55 4d |ATE('(1)', COLUM|
|00000160| 4e 5f 54 59 50 45 29 20 21 3d 20 30 20 54 48 45 |N_TYPE) != 0 THE|
|00000170| 4e 20 2d 37 20 45 4c 53 45 20 2d 36 20 45 4e 44 |N -7 ELSE -6 END|
|00000180| 20 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 | WHEN UPPER(DAT|
|00000190| 41 5f 54 59 50 45 29 3d 27 42 4f 4f 4c 45 41 4e |A_TYPE)='BOOLEAN|
|000001a0| 27 20 54 48 45 4e 20 31 36 20 57 48 45 4e 20 55 |' THEN 16 WHEN U|
|000001b0| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|000001c0| 27 53 4d 41 4c 4c 49 4e 54 27 20 54 48 45 4e 20 |'SMALLINT' THEN |
+--------+-------------------------------------------------+----------------+
2023-05-19 18:31:05.822 [nioEventLoopGroup-3-8] DEBUG o.a.shardingsphere.db.protocol.codec.PacketCodec - Read from client d37ba447 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| e9 14 00 00 03 53 45 4c 45 43 54 20 54 41 42 4c |.....SELECT TABL|
|00000010| 45 5f 53 43 48 45 4d 41 20 41 53 20 54 41 42 4c |E_SCHEMA AS TABL|
|00000020| 45 5f 43 41 54 2c 20 4e 55 4c 4c 20 41 53 20 54 |E_CAT, NULL AS T|
|00000030| 41 42 4c 45 5f 53 43 48 45 4d 2c 20 54 41 42 4c |ABLE_SCHEM, TABL|
|00000040| 45 5f 4e 41 4d 45 2c 20 43 4f 4c 55 4d 4e 5f 4e |E_NAME, COLUMN_N|
|00000050| 41 4d 45 2c 43 41 53 45 20 20 57 48 45 4e 20 55 |AME,CASE WHEN U|
|00000060| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000070| 27 44 45 43 49 4d 41 4c 27 20 54 48 45 4e 20 33 |'DECIMAL' THEN 3|
|00000080| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000090| 5f 54 59 50 45 29 3d 27 44 45 43 49 4d 41 4c 20 |_TYPE)='DECIMAL |
|000000a0| 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e 20 33 |UNSIGNED' THEN 3|
|000000b0| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|000000c0| 5f 54 59 50 45 29 3d 27 54 49 4e 59 49 4e 54 27 |_TYPE)='TINYINT'|
|000000d0| 20 54 48 45 4e 20 43 41 53 45 20 57 48 45 4e 20 | THEN CASE WHEN |
|000000e0| 4c 4f 43 41 54 45 28 27 28 31 29 27 2c 20 43 4f |LOCATE('(1)', CO|
|000000f0| 4c 55 4d 4e 5f 54 59 50 45 29 20 21 3d 20 30 20 |LUMN_TYPE) != 0 |
|00000100| 54 48 45 4e 20 2d 37 20 45 4c 53 45 20 2d 36 20 |THEN -7 ELSE -6 |
|00000110| 45 4e 44 20 20 57 48 45 4e 20 55 50 50 45 52 28 |END WHEN UPPER(|
|00000120| 44 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4e 59 |DATA_TYPE)='TINY|
|00000130| 49 4e 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 |INT UNSIGNED' TH|
|00000140| 45 4e 20 43 41 53 45 20 57 48 45 4e 20 4c 4f 43 |EN CASE WHEN LOC|
|00000150| 41 54 45 28 27 28 31 29 27 2c 20 43 4f 4c 55 4d |ATE('(1)', COLUM|
|00000160| 4e 5f 54 59 50 45 29 20 21 3d 20 30 20 54 48 45 |N_TYPE) != 0 THE|
|00000170| 4e 20 2d 37 20 45 4c 53 45 20 2d 36 20 45 4e 44 |N -7 ELSE -6 END|
|00000180| 20 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 | WHEN UPPER(DAT|
|00000190| 41 5f 54 59 50 45 29 3d 27 42 4f 4f 4c 45 41 4e |A_TYPE)='BOOLEAN|
|000001a0| 27 20 54 48 45 4e 20 31 36 20 57 48 45 4e 20 55 |' THEN 16 WHEN U|
|000001b0| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|000001c0| 27 53 4d 41 4c 4c 49 4e 54 27 20 54 48 45 4e 20 |'SMALLINT' THEN |
|000001d0| 35 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |5 WHEN UPPER(DAT|
|000001e0| 41 5f 54 59 50 45 29 3d 27 53 4d 41 4c 4c 49 4e |A_TYPE)='SMALLIN|
|000001f0| 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e |T UNSIGNED' THEN|
|00000200| 20 35 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 | 5 WHEN UPPER(DA|
|00000210| 54 41 5f 54 59 50 45 29 3d 27 49 4e 54 27 20 54 |TA_TYPE)='INT' T|
|00000220| 48 45 4e 20 34 20 57 48 45 4e 20 55 50 50 45 52 |HEN 4 WHEN UPPER|
|00000230| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 49 4e 54 |(DATA_TYPE)='INT|
|00000240| 20 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e 20 | UNSIGNED' THEN |
|00000250| 34 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |4 WHEN UPPER(DAT|
|00000260| 41 5f 54 59 50 45 29 3d 27 46 4c 4f 41 54 27 20 |A_TYPE)='FLOAT' |
|00000270| 54 48 45 4e 20 37 20 57 48 45 4e 20 55 50 50 45 |THEN 7 WHEN UPPE|
|00000280| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 46 4c |R(DATA_TYPE)='FL|
|00000290| 4f 41 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 |OAT UNSIGNED' TH|
|000002a0| 45 4e 20 37 20 57 48 45 4e 20 55 50 50 45 52 28 |EN 7 WHEN UPPER(|
|000002b0| 44 41 54 41 5f 54 59 50 45 29 3d 27 44 4f 55 42 |DATA_TYPE)='DOUB|
|000002c0| 4c 45 27 20 54 48 45 4e 20 38 20 57 48 45 4e 20 |LE' THEN 8 WHEN |
|000002d0| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|000002e0| 3d 27 44 4f 55 42 4c 45 20 55 4e 53 49 47 4e 45 |='DOUBLE UNSIGNE|
|000002f0| 44 27 20 54 48 45 4e 20 38 20 57 48 45 4e 20 55 |D' THEN 8 WHEN U|
|00000300| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000310| 27 4e 55 4c 4c 27 20 54 48 45 4e 20 30 20 57 48 |'NULL' THEN 0 WH|
|00000320| 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 |EN UPPER(DATA_TY|
|00000330| 50 45 29 3d 27 54 49 4d 45 53 54 41 4d 50 27 20 |PE)='TIMESTAMP' |
|00000340| 54 48 45 4e 20 39 33 20 57 48 45 4e 20 55 50 50 |THEN 93 WHEN UPP|
|00000350| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 42 |ER(DATA_TYPE)='B|
|00000360| 49 47 49 4e 54 27 20 54 48 45 4e 20 2d 35 20 57 |IGINT' THEN -5 W|
|00000370| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|00000380| 59 50 45 29 3d 27 42 49 47 49 4e 54 20 55 4e 53 |YPE)='BIGINT UNS|
|00000390| 49 47 4e 45 44 27 20 54 48 45 4e 20 2d 35 20 57 |IGNED' THEN -5 W|
|000003a0| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|000003b0| 59 50 45 29 3d 27 4d 45 44 49 55 4d 49 4e 54 27 |YPE)='MEDIUMINT'|
|000003c0| 20 54 48 45 4e 20 34 20 57 48 45 4e 20 55 50 50 | THEN 4 WHEN UPP|
|000003d0| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4d |ER(DATA_TYPE)='M|
|000003e0| 45 44 49 55 4d 49 4e 54 20 55 4e 53 49 47 4e 45 |EDIUMINT UNSIGNE|
|000003f0| 44 27 20 54 48 45 4e 20 34 20 57 48 45 4e 20 55 |D' THEN 4 WHEN U|
|00000400| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000410| 27 44 41 54 45 27 20 54 48 45 4e 20 39 31 20 57 |'DATE' THEN 91 W|
|00000420| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|00000430| 59 50 45 29 3d 27 54 49 4d 45 27 20 54 48 45 4e |YPE)='TIME' THEN|
|00000440| 20 39 32 20 57 48 45 4e 20 55 50 50 45 52 28 44 | 92 WHEN UPPER(D|
|00000450| 41 54 41 5f 54 59 50 45 29 3d 27 44 41 54 45 54 |ATA_TYPE)='DATET|
|00000460| 49 4d 45 27 20 54 48 45 4e 20 39 33 20 57 48 45 |IME' THEN 93 WHE|
|00000470| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|00000480| 45 29 3d 27 59 45 41 52 27 20 54 48 45 4e 20 39 |E)='YEAR' THEN 9|
|00000490| 31 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |1 WHEN UPPER(DAT|
|000004a0| 41 5f 54 59 50 45 29 3d 27 56 41 52 43 48 41 52 |A_TYPE)='VARCHAR|
|000004b0| 27 20 54 48 45 4e 20 31 32 20 57 48 45 4e 20 55 |' THEN 12 WHEN U|
|000004c0| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|000004d0| 27 56 41 52 42 49 4e 41 52 59 27 20 54 48 45 4e |'VARBINARY' THEN|
|000004e0| 20 2d 33 20 57 48 45 4e 20 55 50 50 45 52 28 44 | -3 WHEN UPPER(D|
|000004f0| 41 54 41 5f 54 59 50 45 29 3d 27 42 49 54 27 20 |ATA_TYPE)='BIT' |
|00000500| 54 48 45 4e 20 2d 37 20 57 48 45 4e 20 55 50 50 |THEN -7 WHEN UPP|
|00000510| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4a |ER(DATA_TYPE)='J|
|00000520| 53 4f 4e 27 20 54 48 45 4e 20 2d 31 20 57 48 45 |SON' THEN -1 WHE|
|00000530| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|00000540| 45 29 3d 27 45 4e 55 4d 27 20 54 48 45 4e 20 31 |E)='ENUM' THEN 1|
|00000550| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000560| 5f 54 59 50 45 29 3d 27 53 45 54 27 20 54 48 45 |_TYPE)='SET' THE|
|00000570| 4e 20 31 20 57 48 45 4e 20 55 50 50 45 52 28 44 |N 1 WHEN UPPER(D|
|00000580| 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4e 59 42 |ATA_TYPE)='TINYB|
|00000590| 4c 4f 42 27 20 54 48 45 4e 20 2d 33 20 57 48 45 |LOB' THEN -3 WHE|
|000005a0| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|000005b0| 45 29 3d 27 54 49 4e 59 54 45 58 54 27 20 54 48 |E)='TINYTEXT' TH|
|000005c0| 45 4e 20 31 32 20 57 48 45 4e 20 55 50 50 45 52 |EN 12 WHEN UPPER|
+--------+-------------------------------------------------+----------------+
2023-05-19 18:31:05.823 [nioEventLoopGroup-3-8] DEBUG o.a.shardingsphere.db.protocol.codec.PacketCodec - Read from client d37ba447 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| e9 14 00 00 03 53 45 4c 45 43 54 20 54 41 42 4c |.....SELECT TABL|
|00000010| 45 5f 53 43 48 45 4d 41 20 41 53 20 54 41 42 4c |E_SCHEMA AS TABL|
|00000020| 45 5f 43 41 54 2c 20 4e 55 4c 4c 20 41 53 20 54 |E_CAT, NULL AS T|
|00000030| 41 42 4c 45 5f 53 43 48 45 4d 2c 20 54 41 42 4c |ABLE_SCHEM, TABL|
|00000040| 45 5f 4e 41 4d 45 2c 20 43 4f 4c 55 4d 4e 5f 4e |E_NAME, COLUMN_N|
|00000050| 41 4d 45 2c 43 41 53 45 20 20 57 48 45 4e 20 55 |AME,CASE WHEN U|
|00000060| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000070| 27 44 45 43 49 4d 41 4c 27 20 54 48 45 4e 20 33 |'DECIMAL' THEN 3|
|00000080| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000090| 5f 54 59 50 45 29 3d 27 44 45 43 49 4d 41 4c 20 |_TYPE)='DECIMAL |
|000000a0| 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e 20 33 |UNSIGNED' THEN 3|
|000000b0| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|000000c0| 5f 54 59 50 45 29 3d 27 54 49 4e 59 49 4e 54 27 |_TYPE)='TINYINT'|
|000000d0| 20 54 48 45 4e 20 43 41 53 45 20 57 48 45 4e 20 | THEN CASE WHEN |
|000000e0| 4c 4f 43 41 54 45 28 27 28 31 29 27 2c 20 43 4f |LOCATE('(1)', CO|
|000000f0| 4c 55 4d 4e 5f 54 59 50 45 29 20 21 3d 20 30 20 |LUMN_TYPE) != 0 |
|00000100| 54 48 45 4e 20 2d 37 20 45 4c 53 45 20 2d 36 20 |THEN -7 ELSE -6 |
|00000110| 45 4e 44 20 20 57 48 45 4e 20 55 50 50 45 52 28 |END WHEN UPPER(|
|00000120| 44 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4e 59 |DATA_TYPE)='TINY|
|00000130| 49 4e 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 |INT UNSIGNED' TH|
|00000140| 45 4e 20 43 41 53 45 20 57 48 45 4e 20 4c 4f 43 |EN CASE WHEN LOC|
|00000150| 41 54 45 28 27 28 31 29 27 2c 20 43 4f 4c 55 4d |ATE('(1)', COLUM|
|00000160| 4e 5f 54 59 50 45 29 20 21 3d 20 30 20 54 48 45 |N_TYPE) != 0 THE|
|00000170| 4e 20 2d 37 20 45 4c 53 45 20 2d 36 20 45 4e 44 |N -7 ELSE -6 END|
|00000180| 20 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 | WHEN UPPER(DAT|
|00000190| 41 5f 54 59 50 45 29 3d 27 42 4f 4f 4c 45 41 4e |A_TYPE)='BOOLEAN|
|000001a0| 27 20 54 48 45 4e 20 31 36 20 57 48 45 4e 20 55 |' THEN 16 WHEN U|
|000001b0| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|000001c0| 27 53 4d 41 4c 4c 49 4e 54 27 20 54 48 45 4e 20 |'SMALLINT' THEN |
|000001d0| 35 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |5 WHEN UPPER(DAT|
|000001e0| 41 5f 54 59 50 45 29 3d 27 53 4d 41 4c 4c 49 4e |A_TYPE)='SMALLIN|
|000001f0| 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e |T UNSIGNED' THEN|
|00000200| 20 35 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 | 5 WHEN UPPER(DA|
|00000210| 54 41 5f 54 59 50 45 29 3d 27 49 4e 54 27 20 54 |TA_TYPE)='INT' T|
|00000220| 48 45 4e 20 34 20 57 48 45 4e 20 55 50 50 45 52 |HEN 4 WHEN UPPER|
|00000230| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 49 4e 54 |(DATA_TYPE)='INT|
|00000240| 20 55 4e 53 49 47 4e 45 44 27 20 54 48 45 4e 20 | UNSIGNED' THEN |
|00000250| 34 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |4 WHEN UPPER(DAT|
|00000260| 41 5f 54 59 50 45 29 3d 27 46 4c 4f 41 54 27 20 |A_TYPE)='FLOAT' |
|00000270| 54 48 45 4e 20 37 20 57 48 45 4e 20 55 50 50 45 |THEN 7 WHEN UPPE|
|00000280| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 46 4c |R(DATA_TYPE)='FL|
|00000290| 4f 41 54 20 55 4e 53 49 47 4e 45 44 27 20 54 48 |OAT UNSIGNED' TH|
|000002a0| 45 4e 20 37 20 57 48 45 4e 20 55 50 50 45 52 28 |EN 7 WHEN UPPER(|
|000002b0| 44 41 54 41 5f 54 59 50 45 29 3d 27 44 4f 55 42 |DATA_TYPE)='DOUB|
|000002c0| 4c 45 27 20 54 48 45 4e 20 38 20 57 48 45 4e 20 |LE' THEN 8 WHEN |
|000002d0| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|000002e0| 3d 27 44 4f 55 42 4c 45 20 55 4e 53 49 47 4e 45 |='DOUBLE UNSIGNE|
|000002f0| 44 27 20 54 48 45 4e 20 38 20 57 48 45 4e 20 55 |D' THEN 8 WHEN U|
|00000300| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000310| 27 4e 55 4c 4c 27 20 54 48 45 4e 20 30 20 57 48 |'NULL' THEN 0 WH|
|00000320| 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 |EN UPPER(DATA_TY|
|00000330| 50 45 29 3d 27 54 49 4d 45 53 54 41 4d 50 27 20 |PE)='TIMESTAMP' |
|00000340| 54 48 45 4e 20 39 33 20 57 48 45 4e 20 55 50 50 |THEN 93 WHEN UPP|
|00000350| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 42 |ER(DATA_TYPE)='B|
|00000360| 49 47 49 4e 54 27 20 54 48 45 4e 20 2d 35 20 57 |IGINT' THEN -5 W|
|00000370| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|00000380| 59 50 45 29 3d 27 42 49 47 49 4e 54 20 55 4e 53 |YPE)='BIGINT UNS|
|00000390| 49 47 4e 45 44 27 20 54 48 45 4e 20 2d 35 20 57 |IGNED' THEN -5 W|
|000003a0| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|000003b0| 59 50 45 29 3d 27 4d 45 44 49 55 4d 49 4e 54 27 |YPE)='MEDIUMINT'|
|000003c0| 20 54 48 45 4e 20 34 20 57 48 45 4e 20 55 50 50 | THEN 4 WHEN UPP|
|000003d0| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4d |ER(DATA_TYPE)='M|
|000003e0| 45 44 49 55 4d 49 4e 54 20 55 4e 53 49 47 4e 45 |EDIUMINT UNSIGNE|
|000003f0| 44 27 20 54 48 45 4e 20 34 20 57 48 45 4e 20 55 |D' THEN 4 WHEN U|
|00000400| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000410| 27 44 41 54 45 27 20 54 48 45 4e 20 39 31 20 57 |'DATE' THEN 91 W|
|00000420| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|00000430| 59 50 45 29 3d 27 54 49 4d 45 27 20 54 48 45 4e |YPE)='TIME' THEN|
|00000440| 20 39 32 20 57 48 45 4e 20 55 50 50 45 52 28 44 | 92 WHEN UPPER(D|
|00000450| 41 54 41 5f 54 59 50 45 29 3d 27 44 41 54 45 54 |ATA_TYPE)='DATET|
|00000460| 49 4d 45 27 20 54 48 45 4e 20 39 33 20 57 48 45 |IME' THEN 93 WHE|
|00000470| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|00000480| 45 29 3d 27 59 45 41 52 27 20 54 48 45 4e 20 39 |E)='YEAR' THEN 9|
|00000490| 31 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |1 WHEN UPPER(DAT|
|000004a0| 41 5f 54 59 50 45 29 3d 27 56 41 52 43 48 41 52 |A_TYPE)='VARCHAR|
|000004b0| 27 20 54 48 45 4e 20 31 32 20 57 48 45 4e 20 55 |' THEN 12 WHEN U|
|000004c0| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|000004d0| 27 56 41 52 42 49 4e 41 52 59 27 20 54 48 45 4e |'VARBINARY' THEN|
|000004e0| 20 2d 33 20 57 48 45 4e 20 55 50 50 45 52 28 44 | -3 WHEN UPPER(D|
|000004f0| 41 54 41 5f 54 59 50 45 29 3d 27 42 49 54 27 20 |ATA_TYPE)='BIT' |
|00000500| 54 48 45 4e 20 2d 37 20 57 48 45 4e 20 55 50 50 |THEN -7 WHEN UPP|
|00000510| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4a |ER(DATA_TYPE)='J|
|00000520| 53 4f 4e 27 20 54 48 45 4e 20 2d 31 20 57 48 45 |SON' THEN -1 WHE|
|00000530| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|00000540| 45 29 3d 27 45 4e 55 4d 27 20 54 48 45 4e 20 31 |E)='ENUM' THEN 1|
|00000550| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000560| 5f 54 59 50 45 29 3d 27 53 45 54 27 20 54 48 45 |_TYPE)='SET' THE|
|00000570| 4e 20 31 20 57 48 45 4e 20 55 50 50 45 52 28 44 |N 1 WHEN UPPER(D|
|00000580| 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4e 59 42 |ATA_TYPE)='TINYB|
|00000590| 4c 4f 42 27 20 54 48 45 4e 20 2d 33 20 57 48 45 |LOB' THEN -3 WHE|
|000005a0| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|000005b0| 45 29 3d 27 54 49 4e 59 54 45 58 54 27 20 54 48 |E)='TINYTEXT' TH|
|000005c0| 45 4e 20 31 32 20 57 48 45 4e 20 55 50 50 45 52 |EN 12 WHEN UPPER|
|000005d0| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4d 45 44 |(DATA_TYPE)='MED|
|000005e0| 49 55 4d 42 4c 4f 42 27 20 54 48 45 4e 20 2d 34 |IUMBLOB' THEN -4|
|000005f0| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000600| 5f 54 59 50 45 29 3d 27 4d 45 44 49 55 4d 54 45 |_TYPE)='MEDIUMTE|
|00000610| 58 54 27 20 54 48 45 4e 20 2d 31 20 57 48 45 4e |XT' THEN -1 WHEN|
|00000620| 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 | UPPER(DATA_TYPE|
|00000630| 29 3d 27 4c 4f 4e 47 42 4c 4f 42 27 20 54 48 45 |)='LONGBLOB' THE|
|00000640| 4e 20 2d 34 20 57 48 45 4e 20 55 50 50 45 52 28 |N -4 WHEN UPPER(|
|00000650| 44 41 54 41 5f 54 59 50 45 29 3d 27 4c 4f 4e 47 |DATA_TYPE)='LONG|
|00000660| 54 45 58 54 27 20 54 48 45 4e 20 2d 31 20 57 48 |TEXT' THEN -1 WH|
|00000670| 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 |EN UPPER(DATA_TY|
|00000680| 50 45 29 3d 27 42 4c 4f 42 27 20 54 48 45 4e 20 |PE)='BLOB' THEN |
|00000690| 2d 34 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 |-4 WHEN UPPER(DA|
|000006a0| 54 41 5f 54 59 50 45 29 3d 27 54 45 58 54 27 20 |TA_TYPE)='TEXT' |
|000006b0| 54 48 45 4e 20 2d 31 20 57 48 45 4e 20 55 50 50 |THEN -1 WHEN UPP|
|000006c0| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 43 |ER(DATA_TYPE)='C|
|000006d0| 48 41 52 27 20 54 48 45 4e 20 31 20 57 48 45 4e |HAR' THEN 1 WHEN|
|000006e0| 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 | UPPER(DATA_TYPE|
|000006f0| 29 3d 27 42 49 4e 41 52 59 27 20 54 48 45 4e 20 |)='BINARY' THEN |
|00000700| 2d 32 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 |-2 WHEN UPPER(DA|
|00000710| 54 41 5f 54 59 50 45 29 3d 27 47 45 4f 4d 45 54 |TA_TYPE)='GEOMET|
|00000720| 52 59 27 20 54 48 45 4e 20 2d 32 20 57 48 45 4e |RY' THEN -2 WHEN|
|00000730| 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 | UPPER(DATA_TYPE|
|00000740| 29 3d 27 55 4e 4b 4e 4f 57 4e 27 20 54 48 45 4e |)='UNKNOWN' THEN|
|00000750| 20 31 31 31 31 20 57 48 45 4e 20 55 50 50 45 52 | 1111 WHEN UPPER|
|00000760| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 50 4f 49 |(DATA_TYPE)='POI|
|00000770| 4e 54 27 20 54 48 45 4e 20 2d 32 20 57 48 45 4e |NT' THEN -2 WHEN|
|00000780| 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 | UPPER(DATA_TYPE|
|00000790| 29 3d 27 4c 49 4e 45 53 54 52 49 4e 47 27 20 54 |)='LINESTRING' T|
|000007a0| 48 45 4e 20 2d 32 20 57 48 45 4e 20 55 50 50 45 |HEN -2 WHEN UPPE|
|000007b0| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 50 4f |R(DATA_TYPE)='PO|
|000007c0| 4c 59 47 4f 4e 27 20 54 48 45 4e 20 2d 32 20 57 |LYGON' THEN -2 W|
|000007d0| 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 |HEN UPPER(DATA_T|
|000007e0| 59 50 45 29 3d 27 4d 55 4c 54 49 50 4f 49 4e 54 |YPE)='MULTIPOINT|
|000007f0| 27 20 54 48 45 4e 20 2d 32 20 57 48 45 4e 20 55 |' THEN -2 WHEN U|
|00000800| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000810| 27 4d 55 4c 54 49 4c 49 4e 45 53 54 52 49 4e 47 |'MULTILINESTRING|
|00000820| 27 20 54 48 45 4e 20 2d 32 20 57 48 45 4e 20 55 |' THEN -2 WHEN U|
|00000830| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000840| 27 4d 55 4c 54 49 50 4f 4c 59 47 4f 4e 27 20 54 |'MULTIPOLYGON' T|
|00000850| 48 45 4e 20 2d 32 20 57 48 45 4e 20 55 50 50 45 |HEN -2 WHEN UPPE|
|00000860| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 47 45 |R(DATA_TYPE)='GE|
|00000870| 4f 4d 45 54 52 59 43 4f 4c 4c 45 43 54 49 4f 4e |OMETRYCOLLECTION|
|00000880| 27 20 54 48 45 4e 20 2d 32 20 57 48 45 4e 20 55 |' THEN -2 WHEN U|
|00000890| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|000008a0| 27 47 45 4f 4d 43 4f 4c 4c 45 43 54 49 4f 4e 27 |'GEOMCOLLECTION'|
|000008b0| 20 54 48 45 4e 20 2d 32 20 45 4c 53 45 20 31 31 | THEN -2 ELSE 11|
|000008c0| 31 31 20 45 4e 44 20 20 41 53 20 44 41 54 41 5f |11 END AS DATA_|
|000008d0| 54 59 50 45 2c 20 55 50 50 45 52 28 43 41 53 45 |TYPE, UPPER(CASE|
|000008e0| 20 57 48 45 4e 20 4c 4f 43 41 54 45 28 27 55 4e | WHEN LOCATE('UN|
|000008f0| 53 49 47 4e 45 44 27 2c 20 55 50 50 45 52 28 43 |SIGNED', UPPER(C|
|00000900| 4f 4c 55 4d 4e 5f 54 59 50 45 29 29 20 21 3d 20 |OLUMN_TYPE)) != |
|00000910| 30 20 41 4e 44 20 4c 4f 43 41 54 45 28 27 55 4e |0 AND LOCATE('UN|
|00000920| 53 49 47 4e 45 44 27 2c 20 55 50 50 45 52 28 44 |SIGNED', UPPER(D|
|00000930| 41 54 41 5f 54 59 50 45 29 29 20 3d 20 30 20 41 |ATA_TYPE)) = 0 A|
|00000940| 4e 44 20 4c 4f 43 41 54 45 28 27 53 45 54 27 2c |ND LOCATE('SET',|
|00000950| 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 | UPPER(DATA_TYPE|
|00000960| 29 29 20 3c 3e 20 31 20 41 4e 44 20 4c 4f 43 41 |)) <> 1 AND LOCA|
|00000970| 54 45 28 27 45 4e 55 4d 27 2c 20 55 50 50 45 52 |TE('ENUM', UPPER|
|00000980| 28 44 41 54 41 5f 54 59 50 45 29 29 20 3c 3e 20 |(DATA_TYPE)) <> |
|00000990| 31 20 54 48 45 4e 20 43 4f 4e 43 41 54 28 44 41 |1 THEN CONCAT(DA|
|000009a0| 54 41 5f 54 59 50 45 2c 20 27 20 55 4e 53 49 47 |TA_TYPE, ' UNSIG|
|000009b0| 4e 45 44 27 29 20 57 48 45 4e 20 55 50 50 45 52 |NED') WHEN UPPER|
|000009c0| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4e |(DATA_TYPE)='TIN|
|000009d0| 59 49 4e 54 27 20 54 48 45 4e 20 43 41 53 45 20 |YINT' THEN CASE |
|000009e0| 57 48 45 4e 20 4c 4f 43 41 54 45 28 27 28 31 29 |WHEN LOCATE('(1)|
|000009f0| 27 2c 20 43 4f 4c 55 4d 4e 5f 54 59 50 45 29 20 |', COLUMN_TYPE) |
|00000a00| 21 3d 20 30 20 54 48 45 4e 20 27 42 49 54 27 20 |!= 0 THEN 'BIT' |
|00000a10| 57 48 45 4e 20 4c 4f 43 41 54 45 28 27 55 4e 53 |WHEN LOCATE('UNS|
|00000a20| 49 47 4e 45 44 27 2c 20 55 50 50 45 52 28 43 4f |IGNED', UPPER(CO|
|00000a30| 4c 55 4d 4e 5f 54 59 50 45 29 29 20 21 3d 20 30 |LUMN_TYPE)) != 0|
|00000a40| 20 41 4e 44 20 4c 4f 43 41 54 45 28 27 55 4e 53 | AND LOCATE('UNS|
|00000a50| 49 47 4e 45 44 27 2c 20 55 50 50 45 52 28 44 41 |IGNED', UPPER(DA|
|00000a60| 54 41 5f 54 59 50 45 29 29 20 3d 20 30 20 54 48 |TA_TYPE)) = 0 TH|
|00000a70| 45 4e 20 27 54 49 4e 59 49 4e 54 20 55 4e 53 49 |EN 'TINYINT UNSI|
|00000a80| 47 4e 45 44 27 20 45 4c 53 45 20 44 41 54 41 5f |GNED' ELSE DATA_|
|00000a90| 54 59 50 45 20 45 4e 44 20 20 57 48 45 4e 20 55 |TYPE END WHEN U|
|00000aa0| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00000ab0| 27 50 4f 49 4e 54 27 20 54 48 45 4e 20 27 47 45 |'POINT' THEN 'GE|
|00000ac0| 4f 4d 45 54 52 59 27 20 57 48 45 4e 20 55 50 50 |OMETRY' WHEN UPP|
|00000ad0| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4c |ER(DATA_TYPE)='L|
|00000ae0| 49 4e 45 53 54 52 49 4e 47 27 20 54 48 45 4e 20 |INESTRING' THEN |
|00000af0| 27 47 45 4f 4d 45 54 52 59 27 20 57 48 45 4e 20 |'GEOMETRY' WHEN |
|00000b00| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|00000b10| 3d 27 50 4f 4c 59 47 4f 4e 27 20 54 48 45 4e 20 |='POLYGON' THEN |
|00000b20| 27 47 45 4f 4d 45 54 52 59 27 20 57 48 45 4e 20 |'GEOMETRY' WHEN |
|00000b30| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|00000b40| 3d 27 4d 55 4c 54 49 50 4f 49 4e 54 27 20 54 48 |='MULTIPOINT' TH|
|00000b50| 45 4e 20 27 47 45 4f 4d 45 54 52 59 27 20 57 48 |EN 'GEOMETRY' WH|
|00000b60| 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 |EN UPPER(DATA_TY|
|00000b70| 50 45 29 3d 27 4d 55 4c 54 49 4c 49 4e 45 53 54 |PE)='MULTILINEST|
|00000b80| 52 49 4e 47 27 20 54 48 45 4e 20 27 47 45 4f 4d |RING' THEN 'GEOM|
|00000b90| 45 54 52 59 27 20 57 48 45 4e 20 55 50 50 45 52 |ETRY' WHEN UPPER|
|00000ba0| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4d 55 4c |(DATA_TYPE)='MUL|
|00000bb0| 54 49 50 4f 4c 59 47 4f 4e 27 20 54 48 45 4e 20 |TIPOLYGON' THEN |
|00000bc0| 27 47 45 4f 4d 45 54 52 59 27 20 57 48 45 4e 20 |'GEOMETRY' WHEN |
|00000bd0| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|00000be0| 3d 27 47 45 4f 4d 45 54 52 59 43 4f 4c 4c 45 43 |='GEOMETRYCOLLEC|
|00000bf0| 54 49 4f 4e 27 20 54 48 45 4e 20 27 47 45 4f 4d |TION' THEN 'GEOM|
|00000c00| 45 54 52 59 27 20 57 48 45 4e 20 55 50 50 45 52 |ETRY' WHEN UPPER|
|00000c10| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 47 45 4f |(DATA_TYPE)='GEO|
|00000c20| 4d 43 4f 4c 4c 45 43 54 49 4f 4e 27 20 54 48 45 |MCOLLECTION' THE|
|00000c30| 4e 20 27 47 45 4f 4d 45 54 52 59 27 20 45 4c 53 |N 'GEOMETRY' ELS|
|00000c40| 45 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |E UPPER(DATA_TYP|
|00000c50| 45 29 20 45 4e 44 29 20 41 53 20 54 59 50 45 5f |E) END) AS TYPE_|
|00000c60| 4e 41 4d 45 2c 55 50 50 45 52 28 43 41 53 45 20 |NAME,UPPER(CASE |
|00000c70| 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f |WHEN UPPER(DATA_|
|00000c80| 54 59 50 45 29 3d 27 44 41 54 45 27 20 54 48 45 |TYPE)='DATE' THE|
|00000c90| 4e 20 31 30 20 57 48 45 4e 20 55 50 50 45 52 28 |N 10 WHEN UPPER(|
|00000ca0| 44 41 54 41 5f 54 59 50 45 29 3d 27 54 49 4d 45 |DATA_TYPE)='TIME|
|00000cb0| 27 20 20 54 48 45 4e 20 38 2b 28 43 41 53 45 20 |' THEN 8+(CASE |
|00000cc0| 57 48 45 4e 20 44 41 54 45 54 49 4d 45 5f 50 52 |WHEN DATETIME_PR|
|00000cd0| 45 43 49 53 49 4f 4e 3e 30 20 54 48 45 4e 20 44 |ECISION>0 THEN D|
|00000ce0| 41 54 45 54 49 4d 45 5f 50 52 45 43 49 53 49 4f |ATETIME_PRECISIO|
|00000cf0| 4e 2b 31 20 45 4c 53 45 20 44 41 54 45 54 49 4d |N+1 ELSE DATETIM|
|00000d00| 45 5f 50 52 45 43 49 53 49 4f 4e 20 45 4e 44 29 |E_PRECISION END)|
|00000d10| 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 41 | WHEN UPPER(DATA|
|00000d20| 5f 54 59 50 45 29 3d 27 44 41 54 45 54 49 4d 45 |_TYPE)='DATETIME|
|00000d30| 27 20 4f 52 20 20 55 50 50 45 52 28 44 41 54 41 |' OR UPPER(DATA|
|00000d40| 5f 54 59 50 45 29 3d 27 54 49 4d 45 53 54 41 4d |_TYPE)='TIMESTAM|
|00000d50| 50 27 20 20 54 48 45 4e 20 31 39 2b 28 43 41 53 |P' THEN 19+(CAS|
|00000d60| 45 20 57 48 45 4e 20 44 41 54 45 54 49 4d 45 5f |E WHEN DATETIME_|
|00000d70| 50 52 45 43 49 53 49 4f 4e 3e 30 20 54 48 45 4e |PRECISION>0 THEN|
|00000d80| 20 44 41 54 45 54 49 4d 45 5f 50 52 45 43 49 53 | DATETIME_PRECIS|
|00000d90| 49 4f 4e 2b 31 20 45 4c 53 45 20 44 41 54 45 54 |ION+1 ELSE DATET|
|00000da0| 49 4d 45 5f 50 52 45 43 49 53 49 4f 4e 20 45 4e |IME_PRECISION EN|
|00000db0| 44 29 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 |D) WHEN UPPER(DA|
|00000dc0| 54 41 5f 54 59 50 45 29 3d 27 59 45 41 52 27 20 |TA_TYPE)='YEAR' |
|00000dd0| 54 48 45 4e 20 34 20 57 48 45 4e 20 55 50 50 45 |THEN 4 WHEN UPPE|
|00000de0| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 54 49 |R(DATA_TYPE)='TI|
|00000df0| 4e 59 49 4e 54 27 20 41 4e 44 20 4c 4f 43 41 54 |NYINT' AND LOCAT|
|00000e00| 45 28 27 28 31 29 27 2c 20 43 4f 4c 55 4d 4e 5f |E('(1)', COLUMN_|
|00000e10| 54 59 50 45 29 20 21 3d 20 30 20 54 48 45 4e 20 |TYPE) != 0 THEN |
|00000e20| 31 20 57 48 45 4e 20 55 50 50 45 52 28 44 41 54 |1 WHEN UPPER(DAT|
|00000e30| 41 5f 54 59 50 45 29 3d 27 4d 45 44 49 55 4d 49 |A_TYPE)='MEDIUMI|
|00000e40| 4e 54 27 20 41 4e 44 20 4c 4f 43 41 54 45 28 27 |NT' AND LOCATE('|
|00000e50| 55 4e 53 49 47 4e 45 44 27 2c 20 55 50 50 45 52 |UNSIGNED', UPPER|
|00000e60| 28 43 4f 4c 55 4d 4e 5f 54 59 50 45 29 29 20 21 |(COLUMN_TYPE)) !|
|00000e70| 3d 20 30 20 54 48 45 4e 20 38 20 57 48 45 4e 20 |= 0 THEN 8 WHEN |
|00000e80| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|00000e90| 3d 27 4a 53 4f 4e 27 20 54 48 45 4e 20 31 30 37 |='JSON' THEN 107|
|00000ea0| 33 37 34 31 38 32 34 20 57 48 45 4e 20 55 50 50 |3741824 WHEN UPP|
|00000eb0| 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 47 |ER(DATA_TYPE)='G|
|00000ec0| 45 4f 4d 45 54 52 59 27 20 54 48 45 4e 20 36 35 |EOMETRY' THEN 65|
|00000ed0| 35 33 35 20 57 48 45 4e 20 55 50 50 45 52 28 44 |535 WHEN UPPER(D|
|00000ee0| 41 54 41 5f 54 59 50 45 29 3d 27 50 4f 49 4e 54 |ATA_TYPE)='POINT|
|00000ef0| 27 20 54 48 45 4e 20 36 35 35 33 35 20 57 48 45 |' THEN 65535 WHE|
|00000f00| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|00000f10| 45 29 3d 27 4c 49 4e 45 53 54 52 49 4e 47 27 20 |E)='LINESTRING' |
|00000f20| 54 48 45 4e 20 36 35 35 33 35 20 57 48 45 4e 20 |THEN 65535 WHEN |
|00000f30| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|00000f40| 3d 27 50 4f 4c 59 47 4f 4e 27 20 54 48 45 4e 20 |='POLYGON' THEN |
|00000f50| 36 35 35 33 35 20 57 48 45 4e 20 55 50 50 45 52 |65535 WHEN UPPER|
|00000f60| 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4d 55 4c |(DATA_TYPE)='MUL|
|00000f70| 54 49 50 4f 49 4e 54 27 20 54 48 45 4e 20 36 35 |TIPOINT' THEN 65|
|00000f80| 35 33 35 20 57 48 45 4e 20 55 50 50 45 52 28 44 |535 WHEN UPPER(D|
|00000f90| 41 54 41 5f 54 59 50 45 29 3d 27 4d 55 4c 54 49 |ATA_TYPE)='MULTI|
|00000fa0| 4c 49 4e 45 53 54 52 49 4e 47 27 20 54 48 45 4e |LINESTRING' THEN|
|00000fb0| 20 36 35 35 33 35 20 57 48 45 4e 20 55 50 50 45 | 65535 WHEN UPPE|
|00000fc0| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 4d 55 |R(DATA_TYPE)='MU|
|00000fd0| 4c 54 49 50 4f 4c 59 47 4f 4e 27 20 54 48 45 4e |LTIPOLYGON' THEN|
|00000fe0| 20 36 35 35 33 35 20 57 48 45 4e 20 55 50 50 45 | 65535 WHEN UPPE|
|00000ff0| 52 28 44 41 54 41 5f 54 59 50 45 29 3d 27 47 45 |R(DATA_TYPE)='GE|
|00001000| 4f 4d 45 54 52 59 43 4f 4c 4c 45 43 54 49 4f 4e |OMETRYCOLLECTION|
|00001010| 27 20 54 48 45 4e 20 36 35 35 33 35 20 57 48 45 |' THEN 65535 WHE|
|00001020| 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 |N UPPER(DATA_TYP|
|00001030| 45 29 3d 27 47 45 4f 4d 43 4f 4c 4c 45 43 54 49 |E)='GEOMCOLLECTI|
|00001040| 4f 4e 27 20 54 48 45 4e 20 36 35 35 33 35 20 57 |ON' THEN 65535 W|
|00001050| 48 45 4e 20 43 48 41 52 41 43 54 45 52 5f 4d 41 |HEN CHARACTER_MA|
|00001060| 58 49 4d 55 4d 5f 4c 45 4e 47 54 48 20 49 53 20 |XIMUM_LENGTH IS |
|00001070| 4e 55 4c 4c 20 54 48 45 4e 20 4e 55 4d 45 52 49 |NULL THEN NUMERI|
|00001080| 43 5f 50 52 45 43 49 53 49 4f 4e 20 57 48 45 4e |C_PRECISION WHEN|
|00001090| 20 43 48 41 52 41 43 54 45 52 5f 4d 41 58 49 4d | CHARACTER_MAXIM|
|000010a0| 55 4d 5f 4c 45 4e 47 54 48 20 3e 20 32 31 34 37 |UM_LENGTH > 2147|
|000010b0| 34 38 33 36 34 37 20 54 48 45 4e 20 32 31 34 37 |483647 THEN 2147|
|000010c0| 34 38 33 36 34 37 20 45 4c 53 45 20 43 48 41 52 |483647 ELSE CHAR|
|000010d0| 41 43 54 45 52 5f 4d 41 58 49 4d 55 4d 5f 4c 45 |ACTER_MAXIMUM_LE|
|000010e0| 4e 47 54 48 20 45 4e 44 29 20 41 53 20 43 4f 4c |NGTH END) AS COL|
|000010f0| 55 4d 4e 5f 53 49 5a 45 2c 36 35 35 33 35 20 41 |UMN_SIZE,65535 A|
|00001100| 53 20 42 55 46 46 45 52 5f 4c 45 4e 47 54 48 2c |S BUFFER_LENGTH,|
|00001110| 55 50 50 45 52 28 43 41 53 45 20 57 48 45 4e 20 |UPPER(CASE WHEN |
|00001120| 55 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 |UPPER(DATA_TYPE)|
|00001130| 3d 27 44 45 43 49 4d 41 4c 27 20 54 48 45 4e 20 |='DECIMAL' THEN |
|00001140| 4e 55 4d 45 52 49 43 5f 53 43 41 4c 45 20 57 48 |NUMERIC_SCALE WH|
|00001150| 45 4e 20 55 50 50 45 52 28 44 41 54 41 5f 54 59 |EN UPPER(DATA_TY|
|00001160| 50 45 29 3d 27 46 4c 4f 41 54 27 20 4f 52 20 55 |PE)='FLOAT' OR U|
|00001170| 50 50 45 52 28 44 41 54 41 5f 54 59 50 45 29 3d |PPER(DATA_TYPE)=|
|00001180| 27 44 4f 55 42 4c 45 27 20 54 48 45 4e 20 43 41 |'DOUBLE' THEN CA|
|00001190| 53 45 20 57 48 45 4e 20 4e 55 4d 45 52 49 43 5f |SE WHEN NUMERIC_|
|000011a0| 53 43 41 4c 45 20 49 53 20 4e 55 4c 4c 20 54 48 |SCALE IS NULL TH|
|000011b0| 45 4e 20 30 20 45 4c 53 45 20 4e 55 4d 45 52 49 |EN 0 ELSE NUMERI|
|000011c0| 43 5f 53 43 41 4c 45 20 45 4e 44 20 45 4c 53 45 |C_SCALE END ELSE|
|000011d0| 20 4e 55 4c 4c 20 45 4e 44 29 20 41 53 20 44 45 | NULL END) AS DE|
|000011e0| 43 49 4d 41 4c 5f 44 49 47 49 54 53 2c 31 30 20 |CIMAL_DIGITS,10 |
|000011f0| 41 53 20 4e 55 4d 5f 50 52 45 43 5f 52 41 44 49 |AS NUM_PREC_RADI|
|00001200| 58 2c 55 50 50 45 52 28 43 41 53 45 20 57 48 45 |X,UPPER(CASE WHE|
|00001210| 4e 20 49 53 5f 4e 55 4c 4c 41 42 4c 45 3d 27 4e |N IS_NULLABLE='N|
|00001220| 4f 27 20 54 48 45 4e 20 30 20 45 4c 53 45 20 43 |O' THEN 0 ELSE C|
|00001230| 41 53 45 20 57 48 45 4e 20 49 53 5f 4e 55 4c 4c |ASE WHEN IS_NULL|
|00001240| 41 42 4c 45 3d 27 59 45 53 27 20 54 48 45 4e 20 |ABLE='YES' THEN |
|00001250| 31 20 45 4c 53 45 20 32 20 45 4e 44 20 45 4e 44 |1 ELSE 2 END END|
|00001260| 29 20 41 53 20 4e 55 4c 4c 41 42 4c 45 2c 43 4f |) AS NULLABLE,CO|
|00001270| 4c 55 4d 4e 5f 43 4f 4d 4d 45 4e 54 20 41 53 20 |LUMN_COMMENT AS |
|00001280| 52 45 4d 41 52 4b 53 2c 43 4f 4c 55 4d 4e 5f 44 |REMARKS,COLUMN_D|
|00001290| 45 46 41 55 4c 54 20 41 53 20 43 4f 4c 55 4d 4e |EFAULT AS COLUMN|
|000012a0| 5f 44 45 46 2c 30 20 41 53 20 53 51 4c 5f 44 41 |_DEF,0 AS SQL_DA|
|000012b0| 54 41 5f 54 59 50 45 2c 30 20 41 53 20 53 51 4c |TA_TYPE,0 AS SQL|
|000012c0| 5f 44 41 54 45 54 49 4d 45 5f 53 55 42 2c 43 41 |_DATETIME_SUB,CA|
|000012d0| 53 45 20 57 48 45 4e 20 43 48 41 52 41 43 54 45 |SE WHEN CHARACTE|
|000012e0| 52 5f 4f 43 54 45 54 5f 4c 45 4e 47 54 48 20 3e |R_OCTET_LENGTH >|
|000012f0| 20 32 31 34 37 34 38 33 36 34 37 20 54 48 45 4e | 2147483647 THEN|
|00001300| 20 32 31 34 37 34 38 33 36 34 37 20 45 4c 53 45 | 2147483647 ELSE|
|00001310| 20 43 48 41 52 41 43 54 45 52 5f 4f 43 54 45 54 | CHARACTER_OCTET|
|00001320| 5f 4c 45 4e 47 54 48 20 45 4e 44 20 41 53 20 43 |_LENGTH END AS C|
|00001330| 48 41 52 5f 4f 43 54 45 54 5f 4c 45 4e 47 54 48 |HAR_OCTET_LENGTH|
|00001340| 2c 4f 52 44 49 4e 41 4c 5f 50 4f 53 49 54 49 4f |,ORDINAL_POSITIO|
|00001350| 4e 2c 20 49 53 5f 4e 55 4c 4c 41 42 4c 45 2c 20 |N, IS_NULLABLE, |
|00001360| 4e 55 4c 4c 20 41 53 20 53 43 4f 50 45 5f 43 41 |NULL AS SCOPE_CA|
|00001370| 54 41 4c 4f 47 2c 20 4e 55 4c 4c 20 41 53 20 53 |TALOG, NULL AS S|
|00001380| 43 4f 50 45 5f 53 43 48 45 4d 41 2c 20 4e 55 4c |COPE_SCHEMA, NUL|
|00001390| 4c 20 41 53 20 53 43 4f 50 45 5f 54 41 42 4c 45 |L AS SCOPE_TABLE|
|000013a0| 2c 20 4e 55 4c 4c 20 41 53 20 53 4f 55 52 43 45 |, NULL AS SOURCE|
|000013b0| 5f 44 41 54 41 5f 54 59 50 45 2c 49 46 20 28 45 |_DATA_TYPE,IF (E|
|000013c0| 58 54 52 41 20 4c 49 4b 45 20 27 25 61 75 74 6f |XTRA LIKE '%auto|
|000013d0| 5f 69 6e 63 72 65 6d 65 6e 74 25 27 2c 27 59 45 |_increment%','YE|
|000013e0| 53 27 2c 27 4e 4f 27 29 20 41 53 20 49 53 5f 41 |S','NO') AS IS_A|
|000013f0| 55 54 4f 49 4e 43 52 45 4d 45 4e 54 2c 20 49 46 |UTOINCREMENT, IF|
|00001400| 20 28 45 58 54 52 41 20 4c 49 4b 45 20 27 25 47 | (EXTRA LIKE '%G|
|00001410| 45 4e 45 52 41 54 45 44 25 27 2c 27 59 45 53 27 |ENERATED%','YES'|
|00001420| 2c 27 4e 4f 27 29 20 41 53 20 49 53 5f 47 45 4e |,'NO') AS IS_GEN|
|00001430| 45 52 41 54 45 44 43 4f 4c 55 4d 4e 20 46 52 4f |ERATEDCOLUMN FRO|
|00001440| 4d 20 49 4e 46 4f 52 4d 41 54 49 4f 4e 5f 53 43 |M INFORMATION_SC|
|00001450| 48 45 4d 41 2e 43 4f 4c 55 4d 4e 53 20 57 48 45 |HEMA.COLUMNS WHE|
|00001460| 52 45 20 54 41 42 4c 45 5f 53 43 48 45 4d 41 20 |RE TABLE_SCHEMA |
|00001470| 4c 49 4b 45 20 27 73 68 61 72 64 69 6e 67 5f 64 |LIKE 'sharding_d|
|00001480| 62 27 20 41 4e 44 20 54 41 42 4c 45 5f 4e 41 4d |b' AND TABLE_NAM|
|00001490| 45 20 4c 49 4b 45 20 27 74 5f 6f 72 64 65 72 27 |E LIKE 't_order'|
|000014a0| 20 41 4e 44 20 43 4f 4c 55 4d 4e 5f 4e 41 4d 45 | AND COLUMN_NAME|
|000014b0| 20 4c 49 4b 45 20 27 25 27 20 4f 52 44 45 52 20 | LIKE '%' ORDER |
|000014c0| 42 59 20 54 41 42 4c 45 5f 53 43 48 45 4d 41 2c |BY TABLE_SCHEMA,|
|000014d0| 20 54 41 42 4c 45 5f 4e 41 4d 45 2c 20 4f 52 44 | TABLE_NAME, ORD|
|000014e0| 49 4e 41 4c 5f 50 4f 53 49 54 49 4f 4e |INAL_POSITION |
+--------+-------------------------------------------------+----------------+
2023-05-19 18:31:05.826 [ShardingSphere-Command-28] DEBUG o.a.s.p.f.m.command.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME,CASE WHEN UPPER(DATA_TYPE)='DECIMAL' THEN 3 WHEN UPPER(DATA_TYPE)='DECIMAL UNSIGNED' THEN 3 WHEN UPPER(DATA_TYPE)='TINYINT' THEN CASE WHEN LOCATE('(1)', COLUMN_TYPE) != 0 THEN -7 ELSE -6 END WHEN UPPER(DATA_TYPE)='TINYINT UNSIGNED' THEN CASE WHEN LOCATE('(1)', COLUMN_TYPE) != 0 THEN -7 ELSE -6 END WHEN UPPER(DATA_TYPE)='BOOLEAN' THEN 16 WHEN UPPER(DATA_TYPE)='SMALLINT' THEN 5 WHEN UPPER(DATA_TYPE)='SMALLINT UNSIGNED' THEN 5 WHEN UPPER(DATA_TYPE)='INT' THEN 4 WHEN UPPER(DATA_TYPE)='INT UNSIGNED' THEN 4 WHEN UPPER(DATA_TYPE)='FLOAT' THEN 7 WHEN UPPER(DATA_TYPE)='FLOAT UNSIGNED' THEN 7 WHEN UPPER(DATA_TYPE)='DOUBLE' THEN 8 WHEN UPPER(DATA_TYPE)='DOUBLE UNSIGNED' THEN 8 WHEN UPPER(DATA_TYPE)='NULL' THEN 0 WHEN UPPER(DATA_TYPE)='TIMESTAM
P' THEN 93 WHEN UPPER(DATA_TYPE)='BIGINT' THEN -5 WHEN UPPER(DATA_TYPE)='BIGINT UNSIGNED' THEN -5 WHEN UPPER(DATA_TYPE)='MEDIUMINT' THEN 4 WHEN UPPER(DATA_TYPE)='MEDIUMINT UNSIGNED' THEN 4 WHEN UPPER(DATA_TYPE)='DATE' THEN 91 WHEN UPPER(DATA_TYPE)='TIME' THEN 92 WHEN UPPER(DATA_TYPE)='DATETIME' THEN 93 WHEN UPPER(DATA_TYPE)='YEAR' THEN 91 WHEN UPPER(DATA_TYPE)='VARCHAR' THEN 12 WHEN UPPER(DATA_TYPE)='VARBINARY' THEN -3 WHEN UPPER(DATA_TYPE)='BIT' THEN -7 WHEN UPPER(DATA_TYPE)='JSON' THEN -1 WHEN UPPER(DATA_TYPE)='ENUM' THEN 1 WHEN UPPER(DATA_TYPE)='SET' THEN 1 WHEN UPPER(DATA_TYPE)='TINYBLOB' THEN -3 WHEN UPPER(DATA_TYPE)='TINYTEXT' THEN 12 WHEN UPPER(DATA_TYPE)='MEDIUMBLOB' THEN -4 WHEN UPPER(DATA_TYPE)='MEDIUMTEXT' THEN -1 WHEN UPPER(DATA_TYPE)='LONGBLOB' THEN -4 WHEN UPPER(DATA_TYPE)='LONGTEXT' THEN -1 WHEN UPPER(DATA_TYPE)='BLOB' THEN -4 WHEN UPPER(DATA_TYPE)='TEXT' THEN -1 WHEN UPPER(DATA_TYPE)='CHAR' THEN 1 WHEN UPPER(DATA_TYPE)='BINARY' THEN -2 WHEN UPPER(DATA_TYPE)='GEOMETRY
' THEN -2 WHEN UPPER(DATA_TYPE)='UNKNOWN' THEN 1111 WHEN UPPER(DATA_TYPE)='POINT' THEN -2 WHEN UPPER(DATA_TYPE)='LINESTRING' THEN -2 WHEN UPPER(DATA_TYPE)='POLYGON' THEN -2 WHEN UPPER(DATA_TYPE)='MULTIPOINT' THEN -2 WHEN UPPER(DATA_TYPE)='MULTILINESTRING' THEN -2 WHEN UPPER(DATA_TYPE)='MULTIPOLYGON' THEN -2 WHEN UPPER(DATA_TYPE)='GEOMETRYCOLLECTION' THEN -2 WHEN UPPER(DATA_TYPE)='GEOMCOLLECTION' THEN -2 ELSE 1111 END AS DATA_TYPE, UPPER(CASE WHEN LOCATE('UNSIGNED', UPPER(COLUMN_TYPE)) != 0 AND LOCATE('UNSIGNED', UPPER(DATA_TYPE)) = 0 AND LOCATE('SET', UPPER(DATA_TYPE)) <> 1 AND LOCATE('ENUM', UPPER(DATA_TYPE)) <> 1 THEN CONCAT(DATA_TYPE, ' UNSIGNED') WHEN UPPER(DATA_TYPE)='TINYINT' THEN CASE WHEN LOCATE('(1)', COLUMN_TYPE) != 0 THEN 'BIT' WHEN LOCATE('UNSIGNED', UPPER(COLUMN_TYPE)) != 0 AND LOCATE('UNSIGNED', UPPER(DATA_TYPE)) = 0 THEN 'TINYINT UNSIGNED' ELSE DATA_TYPE END WHEN UPPER(DATA_TYPE)='POINT' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='LINESTRING' THEN 'GEOMETRY' WHEN UPPER(D
ATA_TYPE)='POLYGON' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='MULTIPOINT' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='MULTILINESTRING' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='MULTIPOLYGON' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='GEOMETRYCOLLECTION' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='GEOMCOLLECTION' THEN 'GEOMETRY' ELSE UPPER(DATA_TYPE) END) AS TYPE_NAME,UPPER(CASE WHEN UPPER(DATA_TYPE)='DATE' THEN 10 WHEN UPPER(DATA_TYPE)='TIME' THEN 8+(CASE WHEN DATETIME_PRECISION>0 THEN DATETIME_PRECISION+1 ELSE DATETIME_PRECISION END) WHEN UPPER(DATA_TYPE)='DATETIME' OR UPPER(DATA_TYPE)='TIMESTAMP' THEN 19+(CASE WHEN DATETIME_PRECISION>0 THEN DATETIME_PRECISION+1 ELSE DATETIME_PRECISION END) WHEN UPPER(DATA_TYPE)='YEAR' THEN 4 WHEN UPPER(DATA_TYPE)='TINYINT' AND LOCATE('(1)', COLUMN_TYPE) != 0 THEN 1 WHEN UPPER(DATA_TYPE)='MEDIUMINT' AND LOCATE('UNSIGNED', UPPER(COLUMN_TYPE)) != 0 THEN 8 WHEN UPPER(DATA_TYPE)='JSON' THEN 1073741824 WHEN UPPER(DATA_TYPE)='GEOMETRY' THEN 65535 WHEN UPPER(DATA_TYPE)='P
OINT' THEN 65535 WHEN UPPER(DATA_TYPE)='LINESTRING' THEN 65535 WHEN UPPER(DATA_TYPE)='POLYGON' THEN 65535 WHEN UPPER(DATA_TYPE)='MULTIPOINT' THEN 65535 WHEN UPPER(DATA_TYPE)='MULTILINESTRING' THEN 65535 WHEN UPPER(DATA_TYPE)='MULTIPOLYGON' THEN 65535 WHEN UPPER(DATA_TYPE)='GEOMETRYCOLLECTION' THEN 65535 WHEN UPPER(DATA_TYPE)='GEOMCOLLECTION' THEN 65535 WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN NUMERIC_PRECISION WHEN CHARACTER_MAXIMUM_LENGTH > 2147483647 THEN 2147483647 ELSE CHARACTER_MAXIMUM_LENGTH END) AS COLUMN_SIZE,65535 AS BUFFER_LENGTH,UPPER(CASE WHEN UPPER(DATA_TYPE)='DECIMAL' THEN NUMERIC_SCALE WHEN UPPER(DATA_TYPE)='FLOAT' OR UPPER(DATA_TYPE)='DOUBLE' THEN CASE WHEN NUMERIC_SCALE IS NULL THEN 0 ELSE NUMERIC_SCALE END ELSE NULL END) AS DECIMAL_DIGITS,10 AS NUM_PREC_RADIX,UPPER(CASE WHEN IS_NULLABLE='NO' THEN 0 ELSE CASE WHEN IS_NULLABLE='YES' THEN 1 ELSE 2 END END) AS NULLABLE,COLUMN_COMMENT AS REMARKS,COLUMN_DEFAULT AS COLUMN_DEF,0 AS SQL_DATA_TYPE,0 AS SQL_DATETIME_SUB,CAS
E WHEN CHARACTER_OCTET_LENGTH > 2147483647 THEN 2147483647 ELSE CHARACTER_OCTET_LENGTH END AS CHAR_OCTET_LENGTH,ORDINAL_POSITION, IS_NULLABLE, NULL AS SCOPE_CATALOG, NULL AS SCOPE_SCHEMA, NULL AS SCOPE_TABLE, NULL AS SOURCE_DATA_TYPE,IF (EXTRA LIKE '%auto_increment%','YES','NO') AS IS_AUTOINCREMENT, IF (EXTRA LIKE '%GENERATED%','YES','NO') AS IS_GENERATEDCOLUMN FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA LIKE 'sharding_db' AND TABLE_NAME LIKE 't_order' AND COLUMN_NAME LIKE '%' ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, hintValueContext=HintValueContext(shardingDatabaseValues={}, shardingTableValues={}, dataSourceName=, databaseShardingOnly=false, writeRouteOnly=false, useTraffic=false, skipSQLRewrite=false, disableAuditNames=, shadow=false))
2023-05-19 18:31:05.833 [ShardingSphere-Command-28] ERROR o.a.s.proxy.frontend.command.CommandExecutorTask - Exception occur:
java.lang.IllegalStateException: Unsupported SQL operator: `IS`
at com.google.common.base.Preconditions.checkState(Preconditions.java:589)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.BinaryOperationExpressionConverter.convertOperator(BinaryOperationExpressionConverter.java:96)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.BinaryOperationExpressionConverter.convert(BinaryOperationExpressionConverter.java:81)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.ExpressionConverter.convert(ExpressionConverter.java:75)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.CaseWhenExpressionConverter.convertWhenExprs(CaseWhenExpressionConverter.java:58)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.CaseWhenExpressionConverter.convert(CaseWhenExpressionConverter.java:44)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.ExpressionConverter.convert(ExpressionConverter.java:105)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.FunctionConverter.getFunctionParameters(FunctionConverter.java:63)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.FunctionConverter.convert(FunctionConverter.java:57)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.ExpressionConverter.convert(ExpressionConverter.java:96)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.projection.impl.ExpressionProjectionConverter.convert(ExpressionProjectionConverter.java:43)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.projection.ProjectionsConverter.getProjectionSQLNode(ProjectionsConverter.java:60)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.projection.ProjectionsConverter.convert(ProjectionsConverter.java:50)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.statement.select.SelectStatementConverter.convertSelect(SelectStatementConverter.java:65)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.statement.select.SelectStatementConverter.convert(SelectStatementConverter.java:51)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.SQLNodeConverterEngine.convert(SQLNodeConverterEngine.java:42)
at org.apache.shardingsphere.sqlfederation.optimizer.SQLOptimizeEngine.optimize(SQLOptimizeEngine.java:49)
at org.apache.shardingsphere.sqlfederation.advanced.AdvancedSQLFederationExecutor.execute(AdvancedSQLFederationExecutor.java:146)
at org.apache.shardingsphere.sqlfederation.advanced.AdvancedSQLFederationExecutor.executeQuery(AdvancedSQLFederationExecutor.java:114)
at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.doExecuteFederation(DatabaseConnector.java:288)
at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.execute(DatabaseConnector.java:205)
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:92)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.doExecuteCommand(CommandExecutorTask.java:114)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:109)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:77)
at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:60)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2023-05-19 18:31:05.833 [nioEventLoopGroup-3-8] DEBUG o.a.shardingsphere.db.protocol.codec.PacketCodec - Write to client d37ba447 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 3a 00 00 01 ff 30 75 23 48 59 30 30 30 55 6e 6b |:....0u#HY000Unk|
|00000010| 6e 6f 77 6e 20 65 78 63 65 70 74 69 6f 6e 3a 20 |nown exception: |
|00000020| 55 6e 73 75 70 70 6f 72 74 65 64 20 53 51 4c 20 |Unsupported SQL |
|00000030| 6f 70 65 72 61 74 6f 72 3a 20 60 49 53 60 |operator: `IS` |
+--------+-------------------------------------------------+----------------+
2023-05-19 18:31:23.619 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-05-19 18:31:23.619 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:24.013 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.013 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.014 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:24.074 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.074 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.075 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:53.633 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-05-19 18:31:53.633 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:54.025 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.025 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.025 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:54.085 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.085 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.085 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:54.493 [Atomikos:1] WARN com.atomikos.recovery.xa.XARecoveryManager - Error while retrieving xids from resource: the XA resource detected an internal error - will retry later
2023-05-19 18:31:54.493 [Atomikos:1] WARN com.atomikos.datasource.xa.XATransactionalResource - XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
com.mysql.cj.jdbc.MysqlXAException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
at com.mysql.cj.jdbc.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:344)
at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:189)
at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:117)
at com.atomikos.datasource.xa.RecoveryScan.recoverXids(RecoveryScan.java:32)
at com.atomikos.recovery.xa.XARecoveryManager.retrievePreparedXidsFromXaResource(XARecoveryManager.java:266)
at com.atomikos.recovery.xa.XARecoveryManager.recover(XARecoveryManager.java:94)
at com.atomikos.datasource.xa.XATransactionalResource.recover(XATransactionalResource.java:375)
at com.atomikos.icatch.imp.RecoveryDomainService.performRecovery(RecoveryDomainService.java:81)
at com.atomikos.icatch.imp.RecoveryDomainService$1.alarm(RecoveryDomainService.java:56)
at com.atomikos.timing.PooledAlarmTimer.notifyListeners(PooledAlarmTimer.java:101)
at com.atomikos.timing.PooledAlarmTimer.run(PooledAlarmTimer.java:88)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1202)
at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:168)
... 12 common frames omitted
2023-05-19 18:31:54.500 [Atomikos:1] INFO com.atomikos.datasource.xa.XATransactionalResource - 1-ds_0: refreshed XAResource
2023-05-19 18:32:23.649 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-05-19 18:32:23.649 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:32:24.026 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.026 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.027 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:32:24.089 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.089 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.090 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Fill pool skipped, pool is at sufficient level.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "sandynz (via GitHub)" <gi...@apache.org>.
sandynz commented on issue #25847:
URL: https://github.com/apache/shardingsphere/issues/25847#issuecomment-1561052385
Looks the exception is from federation.
@strongduanmu could you help to verify it?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "sandynz (via GitHub)" <gi...@apache.org>.
sandynz commented on issue #25847:
URL: https://github.com/apache/shardingsphere/issues/25847#issuecomment-1559149998
Hi @adam-sunhao , thanks for you feedback.
Could you supply full error message and stack trace?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #25847:
URL: https://github.com/apache/shardingsphere/issues/25847#issuecomment-1562097264
Hi @adam-sunhao, can you test with master branch? I think is operator has been supported now.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] adam-sunhao commented on issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "adam-sunhao (via GitHub)" <gi...@apache.org>.
adam-sunhao commented on issue #25847:
URL: https://github.com/apache/shardingsphere/issues/25847#issuecomment-1562167696
> Hi @adam-sunhao, can you test with master branch? I think is operator has been supported now.
It works, thanks.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] adam-sunhao closed issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "adam-sunhao (via GitHub)" <gi...@apache.org>.
adam-sunhao closed issue #25847: Couldn't get metadata from ShardingShpere-Proxy
URL: https://github.com/apache/shardingsphere/issues/25847
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] adam-sunhao commented on issue #25847: Couldn't get metadata from ShardingShpere-Proxy
Posted by "adam-sunhao (via GitHub)" <gi...@apache.org>.
adam-sunhao commented on issue #25847:
URL: https://github.com/apache/shardingsphere/issues/25847#issuecomment-1560378145
+--------+-------------------------------------------------+----------------+
2023-05-19 18:31:05.826 [ShardingSphere-Command-28] DEBUG o.a.s.p.f.m.command.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY, value: MySQLComQueryPacket(sql=SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME,CASE WHEN UPPER(DATA_TYPE)='DECIMAL' THEN 3 WHEN UPPER(DATA_TYPE)='DECIMAL UNSIGNED' THEN 3 WHEN UPPER(DATA_TYPE)='TINYINT' THEN CASE WHEN LOCATE('(1)', COLUMN_TYPE) != 0 THEN -7 ELSE -6 END WHEN UPPER(DATA_TYPE)='TINYINT UNSIGNED' THEN CASE WHEN LOCATE('(1)', COLUMN_TYPE) != 0 THEN -7 ELSE -6 END WHEN UPPER(DATA_TYPE)='BOOLEAN' THEN 16 WHEN UPPER(DATA_TYPE)='SMALLINT' THEN 5 WHEN UPPER(DATA_TYPE)='SMALLINT UNSIGNED' THEN 5 WHEN UPPER(DATA_TYPE)='INT' THEN 4 WHEN UPPER(DATA_TYPE)='INT UNSIGNED' THEN 4 WHEN UPPER(DATA_TYPE)='FLOAT' THEN 7 WHEN UPPER(DATA_TYPE)='FLOAT UNSIGNED' THEN 7 WHEN UPPER(DATA_TYPE)='DOUBLE' THEN 8 WHEN UPPER(DATA_TYPE)='DOUBLE UNSIGNED' THEN 8 WHEN UPPER(DATA_TYPE)='NULL' THEN 0 WHEN UPPER(DATA_TYPE)='TIMESTAM
P' THEN 93 WHEN UPPER(DATA_TYPE)='BIGINT' THEN -5 WHEN UPPER(DATA_TYPE)='BIGINT UNSIGNED' THEN -5 WHEN UPPER(DATA_TYPE)='MEDIUMINT' THEN 4 WHEN UPPER(DATA_TYPE)='MEDIUMINT UNSIGNED' THEN 4 WHEN UPPER(DATA_TYPE)='DATE' THEN 91 WHEN UPPER(DATA_TYPE)='TIME' THEN 92 WHEN UPPER(DATA_TYPE)='DATETIME' THEN 93 WHEN UPPER(DATA_TYPE)='YEAR' THEN 91 WHEN UPPER(DATA_TYPE)='VARCHAR' THEN 12 WHEN UPPER(DATA_TYPE)='VARBINARY' THEN -3 WHEN UPPER(DATA_TYPE)='BIT' THEN -7 WHEN UPPER(DATA_TYPE)='JSON' THEN -1 WHEN UPPER(DATA_TYPE)='ENUM' THEN 1 WHEN UPPER(DATA_TYPE)='SET' THEN 1 WHEN UPPER(DATA_TYPE)='TINYBLOB' THEN -3 WHEN UPPER(DATA_TYPE)='TINYTEXT' THEN 12 WHEN UPPER(DATA_TYPE)='MEDIUMBLOB' THEN -4 WHEN UPPER(DATA_TYPE)='MEDIUMTEXT' THEN -1 WHEN UPPER(DATA_TYPE)='LONGBLOB' THEN -4 WHEN UPPER(DATA_TYPE)='LONGTEXT' THEN -1 WHEN UPPER(DATA_TYPE)='BLOB' THEN -4 WHEN UPPER(DATA_TYPE)='TEXT' THEN -1 WHEN UPPER(DATA_TYPE)='CHAR' THEN 1 WHEN UPPER(DATA_TYPE)='BINARY' THEN -2 WHEN UPPER(DATA_TYPE)='GEOMETRY
' THEN -2 WHEN UPPER(DATA_TYPE)='UNKNOWN' THEN 1111 WHEN UPPER(DATA_TYPE)='POINT' THEN -2 WHEN UPPER(DATA_TYPE)='LINESTRING' THEN -2 WHEN UPPER(DATA_TYPE)='POLYGON' THEN -2 WHEN UPPER(DATA_TYPE)='MULTIPOINT' THEN -2 WHEN UPPER(DATA_TYPE)='MULTILINESTRING' THEN -2 WHEN UPPER(DATA_TYPE)='MULTIPOLYGON' THEN -2 WHEN UPPER(DATA_TYPE)='GEOMETRYCOLLECTION' THEN -2 WHEN UPPER(DATA_TYPE)='GEOMCOLLECTION' THEN -2 ELSE 1111 END AS DATA_TYPE, UPPER(CASE WHEN LOCATE('UNSIGNED', UPPER(COLUMN_TYPE)) != 0 AND LOCATE('UNSIGNED', UPPER(DATA_TYPE)) = 0 AND LOCATE('SET', UPPER(DATA_TYPE)) <> 1 AND LOCATE('ENUM', UPPER(DATA_TYPE)) <> 1 THEN CONCAT(DATA_TYPE, ' UNSIGNED') WHEN UPPER(DATA_TYPE)='TINYINT' THEN CASE WHEN LOCATE('(1)', COLUMN_TYPE) != 0 THEN 'BIT' WHEN LOCATE('UNSIGNED', UPPER(COLUMN_TYPE)) != 0 AND LOCATE('UNSIGNED', UPPER(DATA_TYPE)) = 0 THEN 'TINYINT UNSIGNED' ELSE DATA_TYPE END WHEN UPPER(DATA_TYPE)='POINT' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='LINESTRING' THEN 'GEOMETRY' WHEN UPPER(D
ATA_TYPE)='POLYGON' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='MULTIPOINT' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='MULTILINESTRING' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='MULTIPOLYGON' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='GEOMETRYCOLLECTION' THEN 'GEOMETRY' WHEN UPPER(DATA_TYPE)='GEOMCOLLECTION' THEN 'GEOMETRY' ELSE UPPER(DATA_TYPE) END) AS TYPE_NAME,UPPER(CASE WHEN UPPER(DATA_TYPE)='DATE' THEN 10 WHEN UPPER(DATA_TYPE)='TIME' THEN 8+(CASE WHEN DATETIME_PRECISION>0 THEN DATETIME_PRECISION+1 ELSE DATETIME_PRECISION END) WHEN UPPER(DATA_TYPE)='DATETIME' OR UPPER(DATA_TYPE)='TIMESTAMP' THEN 19+(CASE WHEN DATETIME_PRECISION>0 THEN DATETIME_PRECISION+1 ELSE DATETIME_PRECISION END) WHEN UPPER(DATA_TYPE)='YEAR' THEN 4 WHEN UPPER(DATA_TYPE)='TINYINT' AND LOCATE('(1)', COLUMN_TYPE) != 0 THEN 1 WHEN UPPER(DATA_TYPE)='MEDIUMINT' AND LOCATE('UNSIGNED', UPPER(COLUMN_TYPE)) != 0 THEN 8 WHEN UPPER(DATA_TYPE)='JSON' THEN 1073741824 WHEN UPPER(DATA_TYPE)='GEOMETRY' THEN 65535 WHEN UPPER(DATA_TYPE)='P
OINT' THEN 65535 WHEN UPPER(DATA_TYPE)='LINESTRING' THEN 65535 WHEN UPPER(DATA_TYPE)='POLYGON' THEN 65535 WHEN UPPER(DATA_TYPE)='MULTIPOINT' THEN 65535 WHEN UPPER(DATA_TYPE)='MULTILINESTRING' THEN 65535 WHEN UPPER(DATA_TYPE)='MULTIPOLYGON' THEN 65535 WHEN UPPER(DATA_TYPE)='GEOMETRYCOLLECTION' THEN 65535 WHEN UPPER(DATA_TYPE)='GEOMCOLLECTION' THEN 65535 WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN NUMERIC_PRECISION WHEN CHARACTER_MAXIMUM_LENGTH > 2147483647 THEN 2147483647 ELSE CHARACTER_MAXIMUM_LENGTH END) AS COLUMN_SIZE,65535 AS BUFFER_LENGTH,UPPER(CASE WHEN UPPER(DATA_TYPE)='DECIMAL' THEN NUMERIC_SCALE WHEN UPPER(DATA_TYPE)='FLOAT' OR UPPER(DATA_TYPE)='DOUBLE' THEN CASE WHEN NUMERIC_SCALE IS NULL THEN 0 ELSE NUMERIC_SCALE END ELSE NULL END) AS DECIMAL_DIGITS,10 AS NUM_PREC_RADIX,UPPER(CASE WHEN IS_NULLABLE='NO' THEN 0 ELSE CASE WHEN IS_NULLABLE='YES' THEN 1 ELSE 2 END END) AS NULLABLE,COLUMN_COMMENT AS REMARKS,COLUMN_DEFAULT AS COLUMN_DEF,0 AS SQL_DATA_TYPE,0 AS SQL_DATETIME_SUB,CAS
E WHEN CHARACTER_OCTET_LENGTH > 2147483647 THEN 2147483647 ELSE CHARACTER_OCTET_LENGTH END AS CHAR_OCTET_LENGTH,ORDINAL_POSITION, IS_NULLABLE, NULL AS SCOPE_CATALOG, NULL AS SCOPE_SCHEMA, NULL AS SCOPE_TABLE, NULL AS SOURCE_DATA_TYPE,IF (EXTRA LIKE '%auto_increment%','YES','NO') AS IS_AUTOINCREMENT, IF (EXTRA LIKE '%GENERATED%','YES','NO') AS IS_GENERATEDCOLUMN FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA LIKE 'sharding_db' AND TABLE_NAME LIKE 't_order' AND COLUMN_NAME LIKE '%' ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, hintValueContext=HintValueContext(shardingDatabaseValues={}, shardingTableValues={}, dataSourceName=, databaseShardingOnly=false, writeRouteOnly=false, useTraffic=false, skipSQLRewrite=false, disableAuditNames=, shadow=false))
2023-05-19 18:31:05.833 [ShardingSphere-Command-28] ERROR o.a.s.proxy.frontend.command.CommandExecutorTask - Exception occur:
java.lang.IllegalStateException: Unsupported SQL operator: `IS`
at com.google.common.base.Preconditions.checkState(Preconditions.java:589)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.BinaryOperationExpressionConverter.convertOperator(BinaryOperationExpressionConverter.java:96)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.BinaryOperationExpressionConverter.convert(BinaryOperationExpressionConverter.java:81)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.ExpressionConverter.convert(ExpressionConverter.java:75)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.CaseWhenExpressionConverter.convertWhenExprs(CaseWhenExpressionConverter.java:58)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.CaseWhenExpressionConverter.convert(CaseWhenExpressionConverter.java:44)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.ExpressionConverter.convert(ExpressionConverter.java:105)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.FunctionConverter.getFunctionParameters(FunctionConverter.java:63)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.impl.FunctionConverter.convert(FunctionConverter.java:57)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.expression.ExpressionConverter.convert(ExpressionConverter.java:96)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.projection.impl.ExpressionProjectionConverter.convert(ExpressionProjectionConverter.java:43)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.projection.ProjectionsConverter.getProjectionSQLNode(ProjectionsConverter.java:60)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.segment.projection.ProjectionsConverter.convert(ProjectionsConverter.java:50)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.statement.select.SelectStatementConverter.convertSelect(SelectStatementConverter.java:65)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.statement.select.SelectStatementConverter.convert(SelectStatementConverter.java:51)
at org.apache.shardingsphere.sqlfederation.optimizer.converter.SQLNodeConverterEngine.convert(SQLNodeConverterEngine.java:42)
at org.apache.shardingsphere.sqlfederation.optimizer.SQLOptimizeEngine.optimize(SQLOptimizeEngine.java:49)
at org.apache.shardingsphere.sqlfederation.advanced.AdvancedSQLFederationExecutor.execute(AdvancedSQLFederationExecutor.java:146)
at org.apache.shardingsphere.sqlfederation.advanced.AdvancedSQLFederationExecutor.executeQuery(AdvancedSQLFederationExecutor.java:114)
at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.doExecuteFederation(DatabaseConnector.java:288)
at org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.execute(DatabaseConnector.java:205)
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:92)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.doExecuteCommand(CommandExecutorTask.java:114)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:109)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:77)
at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:60)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2023-05-19 18:31:05.833 [nioEventLoopGroup-3-8] DEBUG o.a.shardingsphere.db.protocol.codec.PacketCodec - Write to client d37ba447 :
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 3a 00 00 01 ff 30 75 23 48 59 30 30 30 55 6e 6b |:....0u#HY000Unk|
|00000010| 6e 6f 77 6e 20 65 78 63 65 70 74 69 6f 6e 3a 20 |nown exception: |
|00000020| 55 6e 73 75 70 70 6f 72 74 65 64 20 53 51 4c 20 |Unsupported SQL |
|00000030| 6f 70 65 72 61 74 6f 72 3a 20 60 49 53 60 |operator: `IS` |
+--------+-------------------------------------------------+----------------+
2023-05-19 18:31:23.619 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-05-19 18:31:23.619 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:24.013 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.013 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.014 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:24.074 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.074 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:24.075 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:53.633 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-05-19 18:31:53.633 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:54.025 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.025 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.025 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:54.085 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.085 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:31:54.085 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:31:54.493 [Atomikos:1] WARN com.atomikos.recovery.xa.XARecoveryManager - Error while retrieving xids from resource: the XA resource detected an internal error - will retry later
2023-05-19 18:31:54.493 [Atomikos:1] WARN com.atomikos.datasource.xa.XATransactionalResource - XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
com.mysql.cj.jdbc.MysqlXAException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
at com.mysql.cj.jdbc.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:344)
at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:189)
at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:117)
at com.atomikos.datasource.xa.RecoveryScan.recoverXids(RecoveryScan.java:32)
at com.atomikos.recovery.xa.XARecoveryManager.retrievePreparedXidsFromXaResource(XARecoveryManager.java:266)
at com.atomikos.recovery.xa.XARecoveryManager.recover(XARecoveryManager.java:94)
at com.atomikos.datasource.xa.XATransactionalResource.recover(XATransactionalResource.java:375)
at com.atomikos.icatch.imp.RecoveryDomainService.performRecovery(RecoveryDomainService.java:81)
at com.atomikos.icatch.imp.RecoveryDomainService$1.alarm(RecoveryDomainService.java:56)
at com.atomikos.timing.PooledAlarmTimer.notifyListeners(PooledAlarmTimer.java:101)
at com.atomikos.timing.PooledAlarmTimer.run(PooledAlarmTimer.java:88)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1202)
at com.mysql.cj.jdbc.MysqlXAConnection.recover(MysqlXAConnection.java:168)
... 12 common frames omitted
2023-05-19 18:31:54.500 [Atomikos:1] INFO com.atomikos.datasource.xa.XATransactionalResource - 1-ds_0: refreshed XAResource
2023-05-19 18:32:23.649 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=10, active=0, idle=10, waiting=0)
2023-05-19 18:32:23.649 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:32:24.026 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.026 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.027 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Fill pool skipped, pool is at sufficient level.
2023-05-19 18:32:24.089 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.089 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - After cleanup stats (total=1, active=0, idle=1, waiting=0)
2023-05-19 18:32:24.090 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Fill pool skipped, pool is at sufficient level.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org