Issues

Select view

Select search mode

 
50 of

duplicate key in table while using tmp table for group by a json data

Description

This is an upstream bug.

There is an unexpected duplicate error when running a select query with group by a json data.

When the internal_tmp_mem_storage_engine

  • TempTable

  • MEMORY

The select query is below

The table structure is

The execution plan is

We can skip the error by using a different index.

reproduce

  • create table

  • add data

  • run the select query

Environment

None

AFFECTED CS IDs

CS0054281

Details

Assignee

Reporter

Upstream Bug URL

Needs QA

Yes

Priority

Smart Checklist

Created last week
Updated last week

Activity

Show:

Flag notifications