Toad World® Forums

CRUD for sub-select

For this SQL Statement:
SELECT dummy
FROM (SELECT * FROM DUAL) ddd

If you pull up the CRUD Matrix, you get this:
–±--------------------------------±–±--±–±--±–±---------------------+
–| OBJECT SEL INS UPD DEL CRE OTHER |
–±--------------------------------±–±--±–±--±–±---------------------+
–| X |
–±--------------------------------±–±--±–±--±–±---------------------+

I would think the table DUAL should show up in the CRUD Matrix.

Thanks.
-Charlie

thanks Charlie

I have raised PT50489449
I think you are right, we will fix this soon.

Lidia

Hi Charlie,

This issue has been fixed and applied in our latest beta 2962.

You can download and have a check from:

www.toadworld.com/…/19982.aspx

Any issue please let us know, thanks.

Thanks,

Shirly

This is not fixed. I still get for that sample query.