json_table-rowid-needed.sql

create table t2 (
  color varchar(32),
  price int
);
insert into t2 values ("red", 100), ("blue", 50);
insert into t2 select * from t2;
insert into t2 select * from t2;

set optimizer_switch='firstmatch=off';
explain
select * 
from 
  json_table('[{"color": "blue", "price": 50},
               {"color": "red", "price": 100}]',
             '$[*]' columns( color varchar(100) path '$.color',
                          price text path '$.price'
                        )
             ) as T
where
  T.color in (select color from t2 where t2.price=T.price);