search

pingcap / tispark

TiSpark is built for running Apache Spark on top of TiDB/TiKV
Apache License 2.0
880 stars 244 forks source link

[BUG] Return empty data #2649

Closed shiyuhang0 closed 1 year ago

shiyuhang0 commented 1 year ago

Describe the bug

What did you do SQL

CREATE TABLE  `test`.`s4` (
`LISTID` int(5) NOT NULL,
`INST_NO` varchar(5) NOT NULL,
UNIQUE KEY `idx_listinst` (`LISTID`,`INST_NO`)
) 

insert into s4 values (1,'1')

TiSpark

spark.sql("select * from tidb_catalog.test.s4 where LISTID = 1").show()

return empty

TiSpark version : v3.1.2