为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.0-alpha-1201-g4cd837aad
- 【问题描述】:
我从 mysql dump 出来一份数据文件导入 tidb (docker-compose 启动) 中, 查询数据时报错:ERROR 1815 (HY000): Internal : Can't find a proper physical plan for this query
表结构如下:
CREATE TABLE `uploads` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`original_filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`filesize` int(11) NOT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`sha1` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`origin` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`retain_hours` int(11) DEFAULT NULL,
`extension` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`thumbnail_width` int(11) DEFAULT NULL,
`thumbnail_height` int(11) DEFAULT NULL,
`etag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_uploads_on_sha1` (`sha1`),
KEY `index_uploads_on_etag` (`etag`),
KEY `index_uploads_on_id_and_url` (`id`,`url`),
KEY `index_uploads_on_url` (`url`),
KEY `index_uploads_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci