Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 临界分区查询报错，sql错误1105,interface conversion: interface{} is nil ,not types.Time
|
username: grafanab
[Test Environment for TiDB] Testing
[TiDB Version] 5.7.25-TiDB-v6.5.2
Table creation statement:
CREATE TABLE `test1` (
`ID` VARCHAR(50) NOT NULL COMMENT 'Primary Key',
`PARTITION_NO` INT(11) NOT NULL DEFAULT '0' COMMENT 'Partition',
`CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
PRIMARY KEY (`ID`,`PARTITION_NO`,`CREATE_TIME`) USING BTREE,
INDEX `index_partition_no` (`PARTITION_NO`) USING BTREE
)
COMMENT='Test Table'
ENGINE=InnoDB
PARTITION BY RANGE COLUMNS(PARTITION_NO,CREATE_TIME)
(PARTITION `2023p1` VALUES LESS THAN (200000,'2023-01-01'),
PARTITION `2023p2` VALUES LESS THAN (300000,'2023-01-01'));
When the partition value is 200000, querying results equal to 200000 will report an error. What is the reason?
Query SQL:
SELECT * FROM test1 WHERE PARTITION_NO = 200000SELECT * FROM test1 WHERE PARTITION_NO >= 200000
Both execution results report an error.
|
username: 
There’s no other way; we can only avoid this issue from the business side for now. Not sure if it’s a bug or if the version doesn’t support it.
|
username: 
|
username: 
|
username: