pingcap / pingcap/tidb

Unstable result while executing query

Aperta
#65,653 3 commenti 0 reazioni 0 assegnatari Vedi su GitHub
contribution may-affects-7.1 may-affects-7.5 may-affects-8.1 may-affects-8.5 severity/major sig/planner type/bug
Lingua principale
Go
Stelle
40.5k
Fork
6.2k
Metriche di merge delle PR
Metriche PR in attesa

Descrizione

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
```sql
CREATE TABLE t0(c0 CHAR , c1 BLOB(173) , c2 CHAR );

UPDATE t0 SET c0='K', c2=-493926160;
ALTER TABLE t0 DROP c1;
CREATE ALGORITHM=UNDEFINED VIEW v0(c0) AS SELECT t0.c2 FROM t0 WHERE t0.c0;
REPLACE INTO t0 VALUES (NULL, '0'), ('0', 'X'), ('A', '0');
ADMIN CHECKSUM TABLE t0;
INSERT INTO t0(c0) VALUES ('6');

ALTER TABLE t0 ADD PRIMARY KEY(c2);
REPLACE INTO t0 VALUES ('g', '1');

INSERT IGNORE INTO t0 VALUES ('_', '(');
REPLACE INTO t0(c2) VALUES ('p');
UPDATE t0 SET c2=t0.c2, c0=((818354575)AND(-498102208)) WHERE 0.31994056953914873;
REPLACE INTO t0(c0, c2) VALUES ('A', '8');
ALTER TABLE t0 DISABLE KEYS;
REPLACE INTO t0(c0) VALUES ('-'), ('遞');
REPLACE INTO t0(c2, c0) VALUES (NULL, '-');

SELECT t0.c0 FROM t0 NATURAL RIGHT JOIN v0 GROUP BY ((v0.c0) IS NOT NULL) HAVING '0' UNION ALL SELECT t0.c0 FROM t0 NATURAL RIGHT JOIN v0 GROUP BY ((v0.c0) IS NOT NULL) HAVING (NOT ('0')) UNION ALL SELECT t0.c0 FROM t0 NATURAL RIGHT JOIN v0 GROUP BY ((v0.c0) IS NOT NULL) HAVING (('0') IS NULL);

```

### 2. What did you expect to see? (Required)
Executing last query will always return same result

### 3. What did you see instead (Required)
Executing last query multiple times will return different results

### 4. What is your TiDB version? (Required)
8.0.11-TiDB-v9.0.0-beta.1.pre-640-g24903d6b24

Guida per i contributori

Apri la guida per i contributori

Direzione di ricerca

Start by running the supplied SQL reproduction on TiDB 8.0.11-TiDB-v9.0.0-beta.1.pre-640-g24903d6b24 and repeatedly execute the final SELECT. Focus on its NATURAL RIGHT JOIN, GROUP BY, HAVING, and UNION ALL clauses; done means the final query returns the same result on every execution.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Valutazione

Stack tecnologico
go, sql
Ambito
databases
Tipo di issue
Bug
Difficoltà
4/5
Tempo stimato
3-5 giorni
Stato di attività
Tranquilla
Chiarezza
Abbastanza chiara
Idoneità per principianti
42/100

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.