Skip to content

[BUG] tispark read tiflash timestamp error #1951

@marsishandsome

Description

@marsishandsome

tisparkBranch=master & release-2.4 & release-2.4;
tidbVersion=v4.0.11;
testTiFlash=true;

https://internal.pingcap.net/idc-jenkins/blue/rest/organizations/jenkins/pipelines/tispark_regression_test_daily/runs/2681/nodes/132/steps/654/log/?start=0

[2021-03-14T16:40:54.318Z] 21/03/15 00:41:42 ERROR SharedSQLContext: TiSpark over TiFlash failed when executing: select col_timestamp0 from test_945071674 where col_bit < 1

[2021-03-14T16:40:54.318Z] org.scalatest.exceptions.TestFailedException: Failed with

[2021-03-14T16:40:54.318Z] TiFlash:		[len: 4] = List(2015-02-17 13:26:51.0),List(2017-03-22 22:06:53.0),List(1994-12-15 05:26:46.0),List(1970-01-01 17:00:01.0)

[2021-03-14T16:40:54.318Z] TiDB:			[len: 4] = List(2015-02-17 13:26:51.0),List(2017-03-22 22:06:53.0),List(1994-12-15 05:26:46.0),List(1969-12-31 17:00:01.0)

[2021-03-14T16:40:54.318Z] TiFlash Plan:

[2021-03-14T16:40:54.318Z] == Physical Plan ==

[2021-03-14T16:40:54.318Z] *(1) Project [col_timestamp0#244002]

[2021-03-14T16:40:54.318Z] +- *(1) Filter (isnotnull(col_bit#244003L) AND (col_bit#244003L < 1))

[2021-03-14T16:40:54.318Z]    +- *(1) ColumnarToRow

[2021-03-14T16:40:54.318Z]       +- TiFlash CoprocessorRDD{[table: test_945071674] TableScan, Columns: col_bit@BIT, col_timestamp0@TIMESTAMP, KeyRange: [([t\200\000\000\000\000\000\000{_r\000\000\000\000\000\000\000\000], [t\200\000\000\000\000\000\000{_s\000\000\000\000\000\000\000\000])], startTs: 423556573530947585} EstimatedCount:10

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions