You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL Beta Program great and have the most points for this month!
I downloaded the beta version to see if connections via SSH (to something like AWS) were better supported in the product. I didn't dig around in the details, but could not find that it was. Am I missing something?
I have installed Toad For MYSQL 22.214.171.1244 I was hoping that the datetime to milliseconds would be available, please advise
I am able to create a table with scripts using datetime(6). I can see the datetime with milliseconds in the Data import wizard in the defined columns window prior to updating the table, I do not receive any errors in the Import/Export report but once in the table the milliseconds are no longer displayed in my Timestamp column only yyyy-mm-dd hh:mm:ss AM. Then when exporting in the using the Data export Wizard in the Select columns window the datatype shows datetime(6) but in the exported excel file, the milliseconds are gone and can't be seen with even after setting the excel custom format to display milliseconds.
I have installed Toad For MYSQL 126.96.36.1994 and I am experiencing a problem with SQL formatting
Toad puts all my SQL into one line.
When I open a VIEW and go to the Script tab my SQL appears as in the sample below.
CREATE VIEW `database`.`table_v` AS select `field`.`id` AS `id`,`field`.`user_id` AS `user_id`,`ua`.`display_name` AS `display_name`,`field`.`user_type_id` AS `user_type_id`,`uta`.`name` AS `user_type`,`field`.`source_id` AS `source_id`,`tst`.`name` AS `source`,`field`.`author_id` AS `author_id`,(case when (`field`.`user_type_id` = 1) then `ua`.`display_name` when (`field`.`user_type_id` = 2) then `taa`.`name` else `ua`.`display_name` end) AS 'author'
When I use Notepad or NaviCat my SQL appears as
CREATE VIEW table_v AS
field.id,field.user_id,ua.display_name,field.user_type_id,uta.name AS user_type,field.source_id,tst.name AS source,field.author_id,CASE WHEN field.user_type_id = 1 THEN ua.display_name WHEN field.user_type_id = 2 THEN taa.name ELSE ua.display_nameEND AS author,
Toad has managed to convert SELECT, CASE, WHEN, THEN, ELSE and END to lower case. It has also added '' around object names and added AS
I would like Toad to display the SQL as it appears in Navicat and notepad.
I have altered Editor settings to no avail.
Can anybody shed any light on How to do this?
A new beta for Toad for MySQL has been posted. V188.8.131.5204 is now available for immediate download.
This will be the last beta before the 7.2 release.
Just head over to the download section and get it right now!
I just installed 184.108.40.20699 and the code completion threw an error I have never seen in Toad for MySQL before.
I was typing a CALL statement and there is an unterminated SELECT on the previous line, so the complete code that is in the editor is
select * from admin.tblOwners
After typing the "G" the code completion dialog popped up as normal, but it has red lines crossing it out and the error message dialog popped up (I have a screenshot if that's helpful). Here is the error message:
System.ArgumentOutOfRangeExceptionIndex and length must refer to a location within the string.Parameter name: lengthStack Trace: at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at System.String.Substring(Int32 startIndex, Int32 length) at Quest.Toad.Editor.CodeCompletionControl.treeList_CustomDrawNodeCell(Object sender, CustomDrawNodeCellEventArgs e) at DevExpress.XtraTreeList.TreeList.RaiseCustomDrawNodeCell(CustomDrawNodeCellEventArgs e) at DevExpress.XtraTreeList.Painter.TreeListPainter.DrawCell(CellInfo cell) at DevExpress.XtraTreeList.Painter.TreeListPainter.DrawCells(RowInfo ri) at DevExpress.XtraTreeList.Painter.TreeListPainter.DrawRow(TreeListDrawInfo e, RowInfo ri) at DevExpress.XtraTreeList.Painter.TreeListPainter.DrawRows() at DevExpress.XtraTreeList.Painter.TreeListPainter.DoDraw(TreeListViewInfo viewInfo, DXPaintEventArgs e) at DevExpress.XtraTreeList.TreeList.OnPaint(PaintEventArgs e) at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer) at System.Windows.Forms.Control.WmPaint(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m) at DevExpress.XtraTreeList.TreeList.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
A new beta for Toad for MySQL has been posted. V220.127.116.1131 is now available for immediate download. Just head over to the download section and get it right now!
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 (18.104.22.1680) 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 (22.214.171.1240) 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
A new beta for Toad for MySQL has been posted. V126.96.36.19999 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. V188.8.131.5259 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. V184.108.40.20618 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. V220.127.116.1165 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. V18.104.22.1685 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. V22.214.171.1248 is now available for immediate download. Just head over to the download section and get it right now!
Among other things this beta adds support for fractional second date times and fixes a long standing bug when debugging stored procedures or functions with cursors inside them.
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. V126.96.36.1990 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
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 (188.8.131.520), 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.