pingcap / pingcap/tidb

return tikv error `Unexpected return field type Double`

Open
#40,327 0 comments 0 reactions 0 assignees View on GitHub
fuzz/sqlancer severity/moderate sig/execution type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```
CREATE TABLE t97(c0 INTEGER , PRIMARY KEY(c0))PARTITION BY HASH(c0) PARTITIONS 7;
CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW v0(c0) AS SELECT (+ (NULL)) FROM t97;
SELECT v0.c0 FROM v0 GROUP BY (CASE VERSION() WHEN ((-1902713788)REGEXP(COT(v0.c0))) THEN (+ (v0.c0)) ELSE ((((v0.c0)LIKE(v0.c0)))<(((v0.c0)OR('t')))) END ), v0.c0, (CASE v0.c0 WHEN -2145519999 THEN '[Nw{pbCu' ELSE ((((v0.c0)NOT REGEXP(-582125583)))<<(-763628832)) END ) HAVING AVG(v0.c0) ORDER BY v0.c0;
```

it will return tikv error

```
[components/tidb_query_aggr/src/impl_sum.rs:45]: Unexpected return field type Double
```

### 2. What did you expect to see? (Required)

### 3. What did you see instead (Required)

### 4. What is your TiDB version? (Required)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.