Open navyaijm2017 opened 4 years ago
sre-bot
commented
4 years ago You've signing up successfully.
Your current score is: 0
Now you can pick up "medium" or "hard" task in these repos: Chaos Mesh
Please pick up "easy" task in these repos until you get 200 score: TiDB/TiKV/client-rust/PD/DM/BR/TiDB Dashboard/cherry-bot
Team Member:
navyaijm2017
commented
4 years ago 问题：相同的sql，sql_mode一样，但是在4.0上无法执行
sql：SELECT SUM(file_size) as fileSize,COUNT(id) as fileCount,DATE_FORMAT(create_time,'%Y-%m-%d') as dateTime FROM ois_file_record WHERE identify = 'vehicle' and storage_type = 4 and bucket_type = 2 and is_delete = 0 and create_time > '2019-12-01 00:00:00' and file_key LIKE '%/video_data/%' GROUP BY DATE_FORMAT(create_time,'%Y-%m-%d') \G
表结构：
CREATE TABLE ois_file_record (
id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '代理主键',
file_name varchar(128) NOT NULL DEFAULT '' COMMENT '文件名称（包含后缀名）',
file_folder varchar(64) NOT NULL DEFAULT '' COMMENT '文件夹名称（长度限制）',
file_key varchar(255) DEFAULT NULL COMMENT '',
file_type int(11) NOT NULL DEFAULT '6' COMMENT '',
file_size bigint(11) NOT NULL DEFAULT '0' COMMENT '',
identify varchar(32) NOT NULL DEFAULT '' COMMENT '',
storage_type int(11) NOT NULL COMMENT '',
bucket_type int(11) NOT NULL COMMENT '',
bucket_name varchar(32) NOT NULL DEFAULT '' COMMENT '',
status int(11) NOT NULL DEFAULT '1' COMMENT '',
is_delete int(11) NOT NULL DEFAULT '0' COMMENT '',
create_time datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (id),
KEY idx_file_key (file_key) USING HASH COMMENT '',
KEY idx_identify (identify) USING HASH COMMENT ''
) ENGINE=InnoDB AUTO_INCREMENT=98603554 DEFAULT CHARSET=utf8 COMMENT='文件记录表'
you06
commented
4 years ago @navyaijm2017 You need to open bug issues in here https://github.com/tidb-challenge-program/bug-hunting-issue/issues
Team Sign-up
NOTE: