I was doing some tests on a query using something like this... =========== start transaction; SELECT ... insert into .... select row_count(); select ... ...
Some things to know: 1. Check to see that auto-commit is off for the session you ran the commands in. 2. Are you using InnoDB or some other engine that...
I would like a menu choice to issue the command InnoDB Status and give me some nicely formatted output. Running this command in an editor means I have to copy...
I am using InnoDB. Turning off *Toad's* autocommit setting works, but that is *very* unintuitive since MySQL says: "To disable autocommit mode for a single ...
Henrik are you still out there? Didn't we work on this and get it fixed back in version 2? It seems to me we worked out that the user of TOAD should have...
Thanks. Just for clarification if anyone else wants to update the keywords for START and TRANSACTION, the file is "...\Quest Software\Toad for MySQL Beta...
I've been seeing this lately. I haven't been able to pin it down, but it may be after editing tables in Toad. When running Toad with Toad's Autocommit on,...
This happens with InnoDB b/c of the transactions and is related to the transaction isolation level . Here is a work-around I use, but it is not sound for...
This really really made me mad last night b/c I was attempting to get someone to give up phpMyAdmin in favor of TOAD: At work I am on a dual monitor setup...
Jim: I forgot to mention that the app is not the only thing blocked. If you notice the behavior try to write or read from the table elsewhere and you will see...
I hear you on that one. Screen resolution variations and dual monitors create quite a matrix of screen possibilities. Irregardless 1024 X 764 needs to be...
Oh, my! If TOAD holds open transactions under the covers, it should never, ever be used against production. Quest, can tell we configurat TOAD to avoid this?...
Thanks Debbie! How about Jim's locking issue. Can we come up with a plan to run that to ground? It is very serious. I do not remember TOAD for Oracle or SQL...
Lets me sure that we are clear for everyone lurking out there: This is an issue if you are using InnoDB tables in a DB. IT is _not_ and issue if you are using...
I am getting this error. The app hangs and I cannot send a support bundle. System.ArgumentOutOfRangeException Index was out of range. Must be non-negative and...
It also appears when I connect with the database pre-selected and attempt run the script. I cannot see anything wrong in the script. So, I started the app...
OK, it appears my use case was off: I now think this is a product of the syntax checker that is working in the background. I have noted that I have bad or...
Perhaps some more information on what you are actually doing to get these locks? I did find and fix an issue in regards to this when auto commit was enabled a...
Please relax people ;). I'm pretty sure this was a bug I fixed a few days ago so it should be fine in the next beta drop. Basically the problem was that in...
This was not fixed in 832, so I am assuming the "Open Transaction Blocking App" was not fixed either. Here's a more complete test case: drop table if exists...
I consistently get this when right-clicking on the Set N tab and clicking "Close all result sets" System.NullReferenceException Object reference not set to an...
Whats up Boyd? I checked in a change yesterday that fixes this issue (not sure if it made it in time for the beta drop though). Basically, at any time if the...
Yep, I saw that too. Should be fixed in the next Beta. ________________________________ On Behalf Of Jim Wallace Sent: Wednesday, June 20, 2007 4:55 AM To:...
I got this again in 283. I had Toad open and wasn't doing much of anything. It was just sitting on the schema tree. I had connected to a different server...
Hey David, glad to see your still around! I thought it was fixed actually b/c I never saw it again and I do a lot of docking/undocking. In any event, glad to...
Hi, do you mind answering a question on Toad/mySQL? I used the 'freeware' version, but it is a beta which expires in a month. Thanks in advance, Weilan ... ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
