[GitHub] [shardingsphere] MaricoHan commented on issue #21894: Integer CastException occur when select in subquery

[GitBox <gi...@apache.org>]

MaricoHan commented on issue #21894:
URL: https://github.com/apache/shardingsphere/issues/21894#issuecomment-1304703930

   > Hi @MaricoHan, can you provide your configuration and table init sql?
   
   Hi @strongduanmu,as shown below
   ```sql
   Create Table: CREATE TABLE `t_accounts` (
     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
     `project_id` bigint unsigned NOT NULL DEFAULT '0' ,
     `address` char(42) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
     `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
     `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
     PRIMARY KEY (`id`) USING BTREE,
     UNIQUE KEY `uidx_address` (`address`) USING BTREE,
     KEY `idx_project_id` (`project_id`) USING BTREE,
     KEY `idx_created_at` (`created_at`) USING BTREE,
     KEY `idx_updated_at` (`updated_at`) USING BTREE,
   ) ENGINE=InnoDB AUTO_INCREMENT=355479852 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
   ```
   server.yaml
   ```yaml
   props:
    max-connections-size-per-query: 1
    kernel-executor-size: 16  # Infinite by default.
    proxy-frontend-flush-threshold: 128  # The default value is 128.
    proxy-hint-enabled: false
    sql-show: false
    check-table-metadata-enabled: false
      # Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.
      # The default value is -1, which means set the minimum value for different JDBC drivers.
    proxy-backend-query-fetch-size: -1
    proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.
      # Available options of proxy backend executor suitable: OLAP(default), OLTP. The OLTP option may reduce time cost of writing packets to client, but it may increase the latency of SQL execution
      # and block other clients if client connections are more than `proxy-frontend-executor-size`, especially executing slow SQL.
    proxy-backend-executor-suitable: OLAP
    proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.
    sql-federation-enabled: true
      # Available proxy backend driver type: JDBC (default), ExperimentalVertx
    proxy-backend-driver-type: JDBC
    proxy-mysql-default-version: 8.0.23 # In the absence of schema name, the default version will be used.
    proxy-default-port: 3307 # Proxy default port.
    proxy-netty-backlog: 1024 # Proxy netty backlog.
   ```
   
   


-- 
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