[peterlaursen]

That is expected behaviour. But I think you request is reasonable! Give us a little time to discuss this.

[peterlaursen]

This comment issue is fixed in later versions. 5.17 I think.

http://webyog.com/faq/33_7_en.html

This works here on 5.2 b8:

Code:

/* = PROCEDURE tst2 ========================== */
DELIMITER $$ — or you may still use 'DELIMITER $$;'
CREATE PROCEDURE `test`.`tst2`()
BEGIN
— do nothing:
END$$

[peterlaursen]

OK it won't let you create subfolders to the 'favorites' folder and the existing ones don't show on your system for some reason.

We will need some time to discuss how this can happen!

[peterlaursen]

We do intend to support sql_modes better then today. I doubt whether it is possible to support STRICT_TRANS_TABLES and STRICT_ALL_TABLES. But most of the rest of the common ones should be possible.

The main problem is that an empty cell in the grids (DATA and RESULT tabs etc.) is ambiguous. It is 'nothing' but is 'nothing' the same as NULL or EMPTY?

A workaround for you could be setting the sql_mode from the SQL pane manually after connecting. You can store the SQL as a 'favorite'. But some operations on data might fail (with an error) then. It all depends on what your data are like, if columns are defined NULL or NOT NULL, whether columns have defaults (note that BLOBS cannot have defaults!) and what operations you are actually doing.

[peterlaursen]

Well – then it is not the CPU that is the 'bottleneck' her. And no connection issue either.

Did you try changing the server configuration? You find different 'templates' for the configuration file in the Server installation folder.

[peterlaursen]

please read: http://webyog.com/faq/27_114_en.html

You will need to build a jobfile! How else should SJA be able to tell what it shall do?

“it gives me an error” … what error? Any error message?

[peterlaursen]

http://code.google.com/p/sqlyog/ says:

Quote:

NB: Please respect these GUIDELINES:

====================================

You (anybody) are welcome to submit an issue here in case

1) that you are 'reasonable sure' that it is a bug.

2) and you are able to describe it a clear and reproducable way.

If neither is the case, please contact us – preferably through our Forums. We will then assist in clarifying, verifying and describing! Also please use the Forums for feature requests and similar things. We need to coordinate issues occurring here with our internal systems – and proposals and request may exist in some form in those systems allready. Thanks in advance!

[peterlaursen]

two chances …

* upgrade the server (or your resources on it)

* upgrade the connection

This is a single query and it is not SQLyog that is slow. SQLyog is patiently waiting for data to arrive! But try to include a “LIMIT 1000” for instance and measure the time. Your JOIN syntax could be wrong resulting in an astronomic rows returned.

Also Check Task Manager. How much CPU is used? What is the network transfer rate?

[peterlaursen]

we know that! And had it not been for those crash issues we would have done that allready!

Check Item 39 here: http://code.google.com/p/sqlyog/issues/list

[peterlaursen]

With the backup 'powertool' of the ENTERPRISE version you can deselect the UTF8 option.

[peterlaursen]

No one of us here have experienced this with much more complicated and 'deeper' folder structures.

Does not happen either with your favorites folder replacing ours.

Could I ask you to try Beta8 to get a better debug dump?

[peterlaursen]

oh …. 🙂

..yes that makes sense.

You request an option to display the CREATE STATEMENT. Right?

That makes sense because once you open the 'structure sync' tool you cannot work with the program main window. But I would prefer another solution where the windows opened in its own thread so that the main window could be used simutaneously.

[peterlaursen]

It is not a bug actually. We designed so that VIEWS, SP's and FUNCTIONS 'are linked to' ALL TABLES. It is not possible to sync VIEWS, SP's and FUNCTIONS if not all tables are selected and opposite. This is to avoid situations where one of those depend on some table. Syncing the object without syncing the table would damage the database. We do not parse the CREATE statement for those objects (only do a SHOW FULL FIELDS FROM ..) and cannot tell wchich objects depends on each other.

Also the tool is a DATABASE STRUCTURE SYNCHRONIZATION tool. Not a SP's synchronization tool for instance.

As the tool is now you will have to edit the sync script.

I understand that the GUI design can be a little confusing. We have not found a better solution with the software component (scintilla editor) that we use for drawing those objects. However we have ourselves also some wishes for future imporvements of this. But is is not priority of this moment.

[peterlaursen]

I am afraid I am not able to understand you very well.

What are the 'versions' that you are talking about?

MySQL version? Anything else?

Please explain more in depth!

[peterlaursen]

Are you perfectly sure that you did not mismatch two files? There was an issue with 5.18 but should not be in 5.2.

If you can reproduce with 5.2 then please create a simple testcase with a few rows of data. Create a screenshot from SQLyog DATA tab (or any other client where it displays correctly). Attach this screenshot with the corresponding dump here (or create a ticket if you want).

BTW: I think I remember that you are Czech? You have an option to use latin2 as well, I think? Is that the same issue?

[Author]

Posts