pingcap / pingcap/tidb

expression.Expression is *expression.ScalarFunction, not *expression.Column

Open
#42,875 2 comments 0 reactions 1 assignee Claimed by @hawkingrei View on GitHub
affects-7.1 may-affects-4.0 may-affects-5.0 may-affects-5.1 may-affects-5.2 may-affects-5.3 may-affects-5.4 may-affects-6.1 may-affects-6.5 severity/moderate sig/planner 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)

```

USE test;
DROP DATABASE IF EXISTS database9;
CREATE DATABASE database9;
USE database9;
CREATE TABLE t0(c0 SMALLINT UNSIGNED CHECK (c0) );
CREATE TABLE t1(c0 DECIMAL AS ((((('') IS NULL))^(c0))) STORED , c1 INTEGER ZEROFILL , c2 DOUBLE ZEROFILL CHECK ('') NOT NULL UNIQUE );
CREATE TABLE t1(c0 DECIMAL ZEROFILL DEFAULT -349695145 , c1 TEXT(321) NOT NULL , c2 NUMERIC AS (c1) STORED UNIQUE );
CREATE TABLE t1(c0 DECIMAL ZEROFILL );
UPDATE t0 SET c0=-1079722406 WHERE (CASE ((t0.c0)<<(USER())) WHEN (('~)㕸~!pex')REGEXP(-198662741)) THEN (((('')NOT REGEXP(NULL)))=(((-349695145)REGEXP(-1.079722406E9)))) WHEN t0.c0 THEN '+Inf' ELSE false END );
UPDATE t1 SET c0=NULL;
ALTER TABLE t0 DISABLE KEYS;
ADMIN CHECKSUM TABLE t1;
ALTER TABLE t0 ADD PRIMARY KEY(c0);
ALTER TABLE t1 ADD PRIMARY KEY(c0);
REPLACE DELAYED INTO t0 VALUES (-2049291756);
REPLACE INTO t0 VALUES (-1537926763), (510730486), ('컖?');
INSERT IGNORE INTO t0 VALUES (510730486);
ALTER TABLE t0 ADD PRIMARY KEY(c0);
ANALYZE TABLE t1 INDEX PRIMARY WITH 431 BUCKETS;
UPDATE t1 SET c0=((((CAST(false AS DATE))^(-235593334)))NOT REGEXP((- (t1.c0)))) WHERE (BINARY (CAST('2?' AS DECIMAL)));
CREATE UNIQUE INDEX i99 ON t1(c0);
ALTER TABLE t0 MODIFY c0 TEXT;
ALTER TABLE t1 CHANGE c0 c0 DECIMAL NOT NULL ;
ALTER TABLE t0 ADD PRIMARY KEY(c0);
ALTER TABLE t1 ORDER BY c0 DESC;
CREATE ALGORITHM=UNDEFINED VIEW v0(c0, c1, c2) AS SELECT t0.c0, NULL, CAST(t1.c0 AS SIGNED) FROM t0, t1 WHERE ((((t0.c0)OR('컖?')))OR(t0.c0)) GROUP BY 0.7136497069447663;
ALTER TABLE t0 ORDER BY c0 ASC;
ALTER TABLE t0 ADD PRIMARY KEY(c0);
ALTER TABLE t1 ORDER BY c0 ASC;
TRUNCATE t0;

SELECT /*+ MPP_1PHASE_AGG()*/t0.c0 FROM t1, t0 LEFT JOIN v0 ON ((v0.c1)=(CAST(t0.c0 AS TIME)));
interface conversion: expression.Expression is *expression.ScalarFunction, not *expression.Column
```

### 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.