Toad World® Forums

Typing short query [1 Attachment]


#1

[ Attachment(s) from Matt Sprygada included below]

<> Was typing this simple
query:

SELECT *
FROM MercuryGate.dbo.AllMgLoads AS a
WHERE a.Status

And when I went to type a “=” for the where clause, it crashed.


#2

Unfortunately we could not reproduce it on our side. I see that query like this works fine. Is it possible for you to send us backup of your database?

Thanks
Anastasia


#3

No. It is several gig in size. Not sure what the database has to do with the
error I got.


#4

Hi Matt,

Can you reproduce this on other server connection or other database or it is
actual only on this one?

Regards,

Alexander


#5

Matt, I believe the issue I reported on Friday 10-Dec is the same as you are
reporting, so I support you submission. It failed for me on a XP workstation but
will not fail on a Windows 7 workstation. Hopefully this little tidbit is
helpful to Alexander.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#6

Matt, I believe the issue I reported on Friday 10-Dec is the same as you are
reporting, so I support you submission. It failed for me on a XP workstation but
will not fail on a Windows 7 workstation. Hopefully this little tidbit is
helpful to Alexander.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg