[GitHub] [shardingsphere] 1a23-pangqiu commented on issue #25488: SQLParsingException: no viable alternative at input

[via GitHub]

1a23-pangqiu commented on issue #25488:
URL: 
https://github.com/apache/shardingsphere/issues/25488#issuecomment-1541278903

   > <img alt="图像" width="808" 
src="https://user-images.githubusercontent.com/19788130/237253263-7a0a56fd-646b-40b7-b322-fa09bf005ee9.png";>
 我测试了这个sql在mysql5.7中无法执行。
   -- metersphere_prod_and_corp.test_case definition
   
   ```
   CREATE TABLE `test_case` (
     `id` varchar(50) NOT NULL COMMENT 'Test case ID',
     `node_id` varchar(50) NOT NULL COMMENT 'Node ID this case belongs to',
     `test_id` varchar(2000) DEFAULT NULL,
     `node_path` varchar(999) NOT NULL COMMENT 'Node path this case belongs to',
     `project_id` varchar(50) NOT NULL COMMENT 'Project ID this test belongs 
to',
     `name` varchar(255) NOT NULL COMMENT 'Test case name',
     `type` varchar(25) DEFAULT NULL COMMENT 'Test case type',
     `maintainer` varchar(50) DEFAULT NULL COMMENT 'Test case maintainer',
     `priority` varchar(50) DEFAULT NULL COMMENT 'Test case priority',
     `method` varchar(15) DEFAULT NULL COMMENT 'Test case method type',
     `caseabstract` text COMMENT '用例摘要',
     `prerequisite` text COMMENT 'Test case prerequisite condition',
     `remark` text COMMENT 'Test case remark',
     `steps` text COMMENT 'Test case steps (JSON format)',
     `create_time` bigint(13) NOT NULL COMMENT 'Create timestamp',
     `update_time` bigint(13) NOT NULL COMMENT 'Update timestamp',
     `sort` int(11) DEFAULT NULL COMMENT 'Import test case sort',
     `num` int(11) DEFAULT NULL COMMENT 'Manually controlled growth identifier',
     `other_test_name` varchar(200) DEFAULT NULL,
     `review_status` varchar(25) DEFAULT NULL,
     `tags` varchar(1000) DEFAULT NULL,
     `demand_id` varchar(120) DEFAULT NULL,
     `demand_name` varchar(999) DEFAULT NULL,
     `follow_people` varchar(100) DEFAULT NULL,
     `status` varchar(25) DEFAULT NULL,
     `step_description` text,
     `expected_result` text,
     `custom_fields` text COMMENT 'CustomField',
     `step_model` varchar(10) DEFAULT NULL COMMENT 'Test case step model',
     `custom_num` varchar(64) DEFAULT NULL COMMENT 'custom num',
     `create_user` varchar(100) DEFAULT NULL,
     `original_status` varchar(50) DEFAULT NULL,
     `delete_time` bigint(13) DEFAULT NULL COMMENT 'Delete timestamp',
     `delete_user_id` varchar(64) DEFAULT NULL COMMENT 'Delete user id',
     `order` bigint(20) NOT NULL COMMENT '自定义排序，间隔5000',
     `case_public` tinyint(1) DEFAULT NULL COMMENT '是否是公共用例',
     `version_id` varchar(50) DEFAULT NULL COMMENT '版本ID',
     `ref_id` varchar(50) DEFAULT NULL COMMENT '指向初始版本ID',
     `latest` tinyint(1) DEFAULT '0' COMMENT '是否为最新版本 0:否，1:是',
     `automation` tinyint(1) DEFAULT NULL COMMENT '是否自动化 0:否, 1:是',
     PRIMARY KEY (`id`),
     KEY `test_case_version_id_index` (`version_id`),
     KEY `test_case_ref_id_index` (`ref_id`),
     KEY `test_case_node_id_IDX` (`node_id`) USING HASH,
     KEY `test_case_project_id_IDX` (`project_id`) USING BTREE
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
   ```
   I tested that this sql can be executed in Mysql5.7.34


-- 
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-unsubscr...@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org