Joining a table to its own JSON column - bad pop-up hint

Toad for Oracle - Beta
1

Have a simple JSON join. This joins the JSON pseudo table to the row that it came from. The editor hint is "Rule 5807: Avoid cartesian queries...". By definition, this join cannot create a cartesian join.

SELECT t.col1
              tj.col1,
              tj.col2
  FROM my_table t,
   JSON_TABLE (
       t.json_column,
       '$[*]'
       COLUMNS (
        ...
       )) tj;

Regards,
Doug

2

Adding a WHERE clause is a bad hint, since a JSON join is only joining the JSON from the row in which it is contained to that specific row.

hint
hint803×171 45 KB

3

Any comments from the Toad team? Have been waiting 3 weeks.

1 Like
4

Sorry this one belongs in my camp, didn't notice it at first.
Yes you're right, that hint is meaningless indeed.
Will be fixed in next (or next next) beta. (QP-3740)

Thanks,
Andre