Toad World® Forums

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

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

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.

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

1 Like

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