TiDB expression index allows row function

[wjhuang2016]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> CREATE TABLE t (j JSON, KEY k (((j,j))));
Query OK, 0 rows affected (0.01 sec)

In MySQL:

mysql> CREATE TABLE t (j JSON, KEY k (((j,j))));
ERROR 3800 (HY000): Expression of functional index 'k' cannot refer to a row value.

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

3. What did you see instead (Required)

4. Affected version (Required)

Score

50

SIG Slack Channel

You can join #sig-ddl on slack in your spare time to discuss and get help with mentors or others.

Mentor(s)

• @wjhuang2016

Recommended Skills

• DDL

Learning Materials

N/A

[wangggong]

/pick-up

[ti-challenge-bot]

Pick up success.

[ti-challenge-bot]

@wangggong You did not submit PR within 7 days, so give up automatically.

[wangggong]

/pick-up

[ti-challenge-bot]

Pick up success.

[sre-bot]

Integrity check:
RCA symptom trigger_condition affect_version fix_version fields are empty

Please comment /info to get template

[ti-srebot]

Please edit this comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA)

Didn't forbid row() function.

2. Symptom

Expression index allows row function

row function, expression index.

3. All Trigger Conditions

row function, expression index.

4. Workaround (optional)

5. Affected versions

[v4.0.0:v4.0.99]

6. Fixed versions

unplanned