You will no longer receive e-mail notifications from this forum.
Log-In to post
Kudos to the folks making Toad World great!
Are there any release notes for the beta releases, it's tricky to know what to look for without any knowledge of what has changed.
A new beta for Toad for MySQL has been posted. V22.214.171.1240 is now available for immediate download. Just head over to the download section and get it right now!
This will hopefully be the final beta for the 7.0 release cycle.
I have Beta 7.0 installed and this is what I get when I view Release Notes:
Beta Version 6.0
Beta Release Notes
Released: January 14, 2011
In Toad 6.0.x if you positioned the cursor at the end of a statement immediately following the semi-colon and then selected the "Execute Current Statement" or pressed the F9 key, Toad, as expected, would execute that statement and only that statement.
In the most recent download of Toad Beta (126.96.36.1990) if I position the cursor after the final semicolon, and then select "Execute Current Statement" (or F9) , Toad 7 quite unexpectedly executes the NEXT STATEMENT instead of the current statement, even though that statement may be on another line or separated by several blank lines.
"Execute Current Statement" now only works if the cursor is positioned BEFORE the semicolon in a statement.
This is a really sneaky useability change because I was used to typing a statement including a semicolon then finishing off with the F9 key. NOT GOOD! I totally destroyed a database a couple of nights ago when Toad executed the statement following the one I was working on. PLEASE FIX!
In the following statements try positioning the cursor before and after the final semi colons and see what happens:
show variables like 'log%';select now();show variables like '%memory%';select hour(now());
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Toad Beta (188.8.131.520) installed on a clean system, no other instances of Toad present.Windows 7 Professional 64-Bit , SP1; Intel(R) Core(TM)2 Duo CPU P8700 @ 2.53 GHz ; 4.00 GB RAM
Request for enhancement to the editor: It would be really, really, REALLY nice to be able to triple-click anywhere on the current line to select to EOL. Then I could drag, copy, cut, and or paste it to my heart's content. This capability is pretty much ubiquitous in windows editing applications like Word, Wordpad, browser URL windows, even this "Description Field". Seems clumsy to always have to click and hold down the mouse button to grab an entire line, and then usually miss a character or two at the beginning or the end of the line.
Toad Beta 7 (184.108.40.2060), as well as all previous versions of Toad for MySQL, crash with a Java STACKTRACE when attempting to display data with microsecond (millisecond) precision.Versions of MySQL 5.6 and beyond support the concept of microseconds in the DATETIME and TIMESTAMP and all other time related function such as NOW(), etc.
Execute "SELECT NOW(6)" first in the mysql client and then in Toad for MySQL:
In the mysql client for MySQL 5.6.12 for Linux (x86_64):
mysql> SELECT NOW(6);+----------------------------+| NOW(6) |+----------------------------+| 2013-11-11 15:24:12.519015 |+----------------------------+1 row in set (0.00 sec)
Let's try this in Toad for MySQL 7:
System.FormatExceptionInput string was not in a correct format.Stack Trace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at MySql.Data.Types.MySqlDateTime.ParseMySql(String s) at MySql.Data.Types.MySqlDateTime.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal) at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject) at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms) at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlDataReader.Read() at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
When creating a connection in Conn Manager, if you use SSH in drop down, the Schema compare system can't handle that. It should just use all the information in the Conn Manager.. and the connection is already established.
This has never worked to my knowledge.
I have ver 7.0 1883.
I created a connection for 'root' and I happen to set a local IP and custom port because I run it through SSH.. but from Toad's perspective it's just a MySQL conn. And I've done it this way with Toad for years.
First minor thing, is that for years, when you Tab through the fields, it always skips over the Port field. Kind of silly.
But a new bug as of this version.. is that I do not set or save the password, but save the connection. So when I double-click on it later, it prompts me for the PW. Perfect.
However, if I use "Create-Like" when using this conn I made to create another one, same settings regarding the password, it thinks I'm sending NO PASSWORD and denies me. After deleting this new conn and re-creating it manually, it works fine. So something wrong with this "Create-Like" thing.
A new beta for Toad for MySQL has been posted. V220.127.116.113 is now available for immediate download. Just head over to the download section and get it right now!
I'm not sure which of the 3 outputs, but I have a situation where Toad could not output the EXPLAIN to me, even through running the SQL with EXPLAIN works fine.
I suspect it's because in this example the EXPLAIN had the first record with a NULL for the fields: KEY, KEY_LEN, and REF.
I am seeing some low volume here.
I posted several bugs to Toad for MySQL in the Beta community.. before that it was a while since anyone posted anything. Waiting to see if they will get read and addressed.
If you use code completion for simple queries as you type, things are OK.
But if you paste a more complicated query, and then you stick in there something like "and " expecting some table or alias names to come up, or even "and x." waiting for fields of the table/alias "x" to come, they don't. The system queries for something, but it seems to never finish. Then when you close Toad, it prompts you to cancel running queries.. and if you do, then also it kind of just sits there, requiring you to close Toad again.
Started popping this up every few seconds:
System.ArgumentNullExceptionValue cannot be null.Parameter name: inputStack Trace: at System.Text.RegularExpressions.Regex.Match(String input) at Quest.Toad.Trl.BaseSqlTrl.get_HasCount() at Quest.Toad.Trl.SqlTrl.GetTrlCount() at Quest.Toad.DatabaseBrowser.LeftListControl.ReadCount(Object obj)
- I have a few connections open, and have SessionMonitor going.- I also have the ObjectExplorer up, looking at Sessions.- In Options/Explorer/General I turned on "Automatically format generated SQL"- Then when I make another connection active, the above error keeps coming up. Then I turned off the "Automatically format generated SQL" and it would stop. If I turned back on, it would happen again.
Decimal type columns do not export when you use the Quick Export/Excel Instance/Excel Instance At Active Cell or Quick Export/Excel Instance/Excel Instance In New Sheet options.
For example, if you run this query, then use either of the Quick Exports mentioned above, the ExcelBug1 and ExcelBug4 columns will be blank in the spreadsheet. This does not happen in the current release version (18.104.22.1684).
, ROUND(500.9) AS ExcelBug1 , 501 AS ExcelBug2 , 500 + 1 AS ExcelBug3 , 500.9 AS ExcelBug4FROM information_schema.TABLES;
A new beta for Toad for MySQL has been posted. V22.214.171.1243 is now available for immediate download. Just head over to the download section and get it right now!
A new beta for Toad for MySQL has been posted. V126.96.36.1999 is now available for immediate download.
Just head over to the download section and get it right now!
A new beta for Toad for MySQL has officially started. V188.8.131.528 is now available for immediate download.
The new stable version of Toad for MySQL 184.108.40.2064 is now available for immediate download.