TOAD bug

From: Joe <balu422_at_yahoo.com>
Date: 1 Feb 2006 09:42:08 -0800
Message-ID: <1138815728.690052.252630_at_g43g2000cwa.googlegroups.com>



[Quoted] Hi Everyone -

I came across a Toad bug this morning in the SQL Editor that I wanted to pass on. It involves the MINUS query capability. Here is the text that I forwarded to Toad support.

Issue: When using a minus query without a where clause, Toad returns no rows found. When adding a where clause or even a comment Toad returns rows.

select * from stw_universe_estimate_at_dnstwpr minus
select * from stw_universe_estimate

Hit Shift F9 anywhere in the statement above - returns no rows

select * from stw_universe_estimate_at_dnstwpr -- minus
select * from stw_universe_estimate

Hit Shift F9 anywhere in the statement above with the dashdash comment - the correct rows are returned.

If I hightlight the three lights and hit the execute statement icon, the correct rows are returned with or without the dashdash comment. So, it appears to just be a problem with the Shift F9 feature.

Are there any known bug fixes for this? If so, can you please point me to those. If not, I consider this a very serious bug in that incorrect results are returned. Had I NOT known that there were differences, I would not even pursued this issue and would have assumed the tables were in sync. This could have been extremely bad. Note also that moving the _at_dnstwpr did NOT have any effects. It still did NOT work with Shift F9.

Thank you in advance for your help resolving this issue. Thanks,

Joe Received on Wed Feb 01 2006 - 18:42:08 CET

Original text of this message