Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantI do not understand the latest point. I edited a NULL-column and added a NOT NULL column (both varchars).
SQLyog sent this SQL (copied from HISTORY)
Code:alter table `test`.`aa` add column `dd` varchar(30) NOT NULL after `cc`,change `bb` `bb` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULLNo defaults specified in this statement. Are you sure it is not the server that does this?
Is what your refer to as 'latest version' 6.16?
peterlaursen
ParticipantI think it is possible to install the 'Microsoft Core Fonts' in darwine, excatly like in wine. This is undoubtedly an issue with fonts mapping between Wine and the underlying BSD-Unix kernel used by Mac OS-X.
Refer to:
http://webyog.com/faq/content/31/71/en/can…?highlight=wine
(link to download of those fonts as exe-installers is there)
peterlaursen
Participant1) Please tell the SQLyog version! Help .. about tells this.
2) Please specify that 'message of crash'. What exactly is it like. A screedump will be useful.
3) I also do not understand “I reload the dump file”. Do you simply execute that small code snippet from an external file with SQLyog? For me it works fine (even if I repeat several times) – see
[attachment=842:bonnie.jpg]
One problem however could be the file encoding. That is why you should use a recent SQLyog version.
peterlaursen
Participant1) agreed. This dialogue should (as well as others) be resizable and non-modal (means it should be possible to work in main window even if this is open
2) sorting. Not sure – one problem: You know that we plan to move 'code exectution' to 'manage indexes' dialogue (and not the 'subdialogue') to ensure that we execute a single ALTER TABLE only. Actually sorting indexes creates a new table definition!
3) multiselect. I think it will less important once we execute all changes in one ALTER TABLE only. But anyway let us discuss this.
4) All over the program we will check with the caption 'Cancel' that it only appears where 1) nothing has happened yet 2) performed actions can be reversed.
peterlaursen
ParticipantWe cannot tell in every detail. The ISP must have that information somewhere.
But please start reading:
1) The “getting started” paragraph in the help file
2) http://webyog.com/faq/content/16/66/en/wha…hlight=hostname
Further: when specifying a domain for the connection don't use “http://”. The domain is “myserver.ext” not “http://myserver.ext” (“http://” is a PROTOCOL and connection to MySQL does no use that protocol).
Probably you will need to start in CP to create a user for SQLyog/remote connection. Maybe also you will need to allow the ip/ip-range than you connect from. Besides that CP details are not relevant for SQLyog.
Note that if connections fail when experimenting there may be two very differerent reasons:
1) connection error like “can't connect …” . Then SQLyog finds no server where you specified. Details wrong, firewall etc.
2) authentication errors like “access denied ..”. Then the server is there, but user details are not correct.
peterlaursen
ParticipantI do not think that MySQL support will care much about an issue reported with SQLyog only. Advice: post a reproducable test case with cmd line, next refer to other clients (QB, SQLyog, PhpMyAdmin .. whatsoever)
peterlaursen
ParticipantIt is definitely the server that does!
I tried from command line client
Code:Enter password: ********
Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 6
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use test;
Database changed
mysql> DELIMITER $$
mysql>
mysql> DROP PROCEDURE IF EXISTS `test`.`MyTest`$$
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql>
mysql> CREATE DEFINER=`root`@`localhost` PROCEDURE `MyTest`(IN _inVar MEDIUMINT(
8) UNSIGNED)
-> BEGIN
->
-> SELECT 100 + _inVar;
->
-> END$$
Query OK, 0 rows affected (0.00 sec)mysql>
mysql> DELIMITER;
mysql> show create procedure mytest;
+———–+———-+——————————————————–
———————————————————————–+
| Procedure | sql_mode | Create Procedure
|
+———–+———-+——————————————————–
———————————————————————–+
| mytest | | CREATE DEFINER=`root`@`localhost` PROCEDURE `mytest`(IN
_inVar MEDIUMINT(8) UNSIGNED)
BEGIN
SELECT 100 + _inVar;END |
+———–+———-+——————————————————–
———————————————————————–+
1 row in set (0.00 sec)mysql>
note
Code:BEGIN
SELECT 100 + _inVar;END
|
I am not sure I understand which of your servers (5.0.54 and 5.0.45) that does correct and which does wrong!
If a recent version does 'worse' than an older one, I think you should report to bugs.mysql.com
peterlaursen
Participantbtw:
The short form “delimiter;” returns a syntax error for me on SQLyog 6.16/MySQL 5.0.51a.
I need to insert a SPACE like “delimiter ;”.
Does the short form work for you?
peterlaursen
ParticipantNo records of such change in server changelogs, I think (I searched). Probably considered too small a change to put there …
peterlaursen
ParticipantWe have no option to test with a server > 5.0.51a at the moment.
With 5.0.51a on my localhost it behaves like your 5.0.45 server.
I do not think it is a transmission issue. I think the server simply sometimes 'throws away' the empty lines.
But it looks like it has been (more or less) fixed in 5.0.54.
There have been lots of complaints in bugs.mysql.com and MySQL forums that the server did not preserve the original formatting for 'stored programs' and VIEWS (and I doubt it is fixed with VIEWs).
peterlaursen
Participant@shlomo
1. Option to display sql before executing and give an option to copy&paste it. This is relevant for automated SQL generations, such as Manage Indexes, and Alter Table. Since this operation hangs an entire GUI window, and the whole sqlyog is unusable during this time, I'd prefer to copy it and run in from the command line client. Also, seeing the SQL before running it seems very important, especially for production systems.
>> being a client SQLyog will have to wiat for the server's response. This is not a 'hang' – this is how a MySQL server and client communicate! You can have more connections or SQLyog instances running (as well as cmd line).
>> 'preview SQL'
2. Don't hang the front whole window while a long query is executing. Maybe use separate thread?
>> again you can have more connections or SQLyog instances running. What we do plan to improve is that some dialogues 'block acces' to main window even if no activity is there
3. Show running execution time during, when running a regular query. This is also relevant for aforementioned DDL operations from the GUI.
>> never thought about that. I think we could update every 1 or 5 seconds … but did you ever read:
http://webyog.com/faq/content/8/147/en/how…light=execution
4. Remove DEFAULT '' from each table column that is created. It is not always needed, but it's there anyway. It shouldn't be added unless specifically chosen. This is actually a bug maybe, and not a feature.
>> I do not understand! explain? program version? screenshot?
peterlaursen
Participant“On a VARCHAR NOT NULL column that has no DEFAULT value specified sqlyog should assume an empty string, not a NULL”
[attachment=840:notnullchar.jpg]
ok .. that makes sense! We will need some 'placeholder' for
in the grid then because we actually read from the grid when inserting/updating. peterlaursen
Participant1) we do have plans for the tabs (like rename, reorder), but not this …
You can add here yourself: http://code.google.com/p/sqlyog/issues/detail?id=29
2) That was considered allready when we released 5.0. I even think we considered to 'execute in virtual mode/simulate' for both SF's and SP's. (idea was that only stdout output and user variables should be affected, but not data stored on the server – whether user data or server variables).
Any idea on how to handle OUT and IN/OUT -parameters?
I think that was the main reason why we dropped the idea (+plus of course that codding such GUI functionality will take considerable time – and I think this was the first request of its kind).
peterlaursen
ParticipantPlease let us analyse what the possibilities are!
peterlaursen
ParticipantI am sorry, but there is not change in 6.16 FINAL.
To prevent overflow with BIGINT PKs we need to perform some conversions internally. We will analyse how this possibly could be optimized.
-
AuthorPosts