Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

should not set tiflash replica while create temporary table like a table with tiflash replica #24993

Closed
aytrack opened this issue May 31, 2021 · 2 comments · Fixed by #25036
Closed
Labels
severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@aytrack
Copy link
Contributor

aytrack commented May 31, 2021

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

set tidb_enable_noop_functions = 1;
drop table if exists tbl_1, tb1;
create table tbl_1 (a int);
alter table tbl_1 set tiflash replica 1;
create temporary table tb1 like tbl_1;
select * from information_schema.tiflash_replica;

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

doesn't set tiflash replica for tb1

3. What did you see instead (Required)

MySQL >  select * from information_schema.tiflash_replica;
+--------------+------------+----------+---------------+-----------------+-----------+----------+
| TABLE_SCHEMA | TABLE_NAME | TABLE_ID | REPLICA_COUNT | LOCATION_LABELS | AVAILABLE | PROGRESS |
+--------------+------------+----------+---------------+-----------------+-----------+----------+
| test         | tbl_1      | 79       | 1             |                 | 1         | 1.0      |
| test         | tb1        | 82       | 1             |                 | 1         | 1.0      |
+--------------+------------+----------+---------------+-----------------+-----------+----------+

4. What is your TiDB version? (Required)

MySQL root@127.0.0.1:test> select tidb_version()\G
***************************[ 1. row ]***************************
tidb_version() | Release Version: v5.1.0-alpha-14-gd1b3e4711-dirty
Edition: Community
Git Commit Hash: d1b3e47111a34a2d3e9ca9aec94292f822c2f5a4
Git Branch: HEAD
UTC Build Time: 2021-05-30 19:56:32
GoVersion: go1.13.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
@tisonkun
Copy link
Contributor

tisonkun commented Jun 1, 2021

Please refer this issue to the tracking issue of temporary table #24169 .

@ti-srebot
Copy link
Contributor

ti-srebot commented Jun 3, 2021

Bug

1. Root Cause Analysis (RCA) (optional)

Did not check setting tiflash replicas for temporary tabes.

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

unreleased

6. Fixed versions

master

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants