You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/03/24 05:12:47 UTC
[GitHub] [shardingsphere] TeslaCN commented on issue #16311: Shardingsphere-proxy can not create very large table
TeslaCN commented on issue #16311:
URL: https://github.com/apache/shardingsphere/issues/16311#issuecomment-1077153427
Hi @whyliyi
I tried your SQL and it worked in ShardingSphere-Proxy. Could you check again?
```
☁ ~ mysql -h 127.0.0.1 -P 13306 -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 8.0.28-ShardingSphere-Proxy 5.1.1-SNAPSHOT-d71cac1 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use freedom;
Database changed
mysql>
mysql> CREATE TABLE `t_order` (
-> `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
n36` -> `order_no` varchar(32) DEFAULT NULL COMMENT '',
ng -> `order_status` tinyint DEFAULT NULL COMMENT '2)',
-> `except_sign_reason` varchar(255) DEFAULT NULL COMMENT '',
C -> `order_tags` varchar(255) DEFAULT NULL COMMENT '',
ch -> `order_marks` varchar(255) DEFAULT NULL COMMENT '',
-> `package_count` int DEFAULT NULL COMMENT '',
-> `assess_money` double(10,2) DEFAULT NULL COMMENT '(102)',
-> `amount_price` double(10,2) DEFAULT NULL COMMENT ' - ()',
-> `discount_price` double(10,2) DEFAULT NULL COMMENT ' - ',
-> `payment_price` double(10,2) DEFAULT NULL COMMENT '',
-> `trans_mode` tinyint DEFAULT NULL,
-> `store_mode` tinyint DEFAULT NULL,
-> `goods_type` tinyint DEFAULT NULL COMMENT '',
-> `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
-> `end_time` datetime DEFAULT NULL COMMENT '',
5 -> `print_time` datetime DEFAULT NULL COMMENT '',
-> `description` varchar(255) DEFAULT NULL COMMENT 'comments',
e -> `description2` varchar(255) DEFAULT NULL COMMENT 'long comment.',
-> `description3` varchar(255) DEFAULT NULL COMMENT 'very long comment.',
-> `description4` varchar(255) DEFAULT NULL COMMENT ' very very long comment.',
-> `description5` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description6` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description7` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description8` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description9` varchar(255) DEFAULT NULL COMMENT 'ng comment.',
-> `description10` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description11` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description12` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description13` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description14` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description15` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description16` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description17` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description18` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description19` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description20` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description21` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description22` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description23` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description24` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description25` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description26` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description27` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description28` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description29` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description30` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description31` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description32` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description33` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description34` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description35` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description36` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description37` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description38` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description39` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description40` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description41` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description42` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description43` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description44` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description45` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description46` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description47` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description48` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description49` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> `description50` varchar(255) DEFAULT NULL COMMENT 'I have a very very long comment.',
-> PRIMARY KEY (`id`) USING BTREE,
-> INDEX `order_no_idx`(`order_no`) USING BTREE
-> ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.12 sec)
mysql>
```
--
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