[Shlomo Priymak]

peterlaursen wrote on Mar 18 2008, 11:43 AM:

Not reproducable for me on Vista SP1 RC, Nvidia graphics, resolution 1440*900.

Do you have the Vista 'sidebar' turned ON?

(this position is default for sidebar).

Vista SP1 final/public is expected in days/weeks. I think that might solve?!

Negative. I do not use the Vista sidebar.

Regardless, SP1 for Vista is still not available for my computer – Lenovo T60 with ATI graphics (Microsoft are delaying it for computers with certain drivers, till some problems are solved).

[Shlomo Priymak]

peterlaursen wrote on Mar 2 2008, 02:24 PM:

I 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 NULL

No 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?

I can't seem to reproduce it in 6.16 (i noticed this when I was using a previous version, perhaps this was fixed?). If I run into it again, I'll report in.

Sorry for the trouble 🙂

—

Shlomo

[Shlomo Priymak]

I'll try to explain myself better… In windows a “busy” window shows an “hourglass”. In SQLYog, it shows an hourglass but it flickers between an hourglass icon and the regular arrow when you pass between objects. This gives the idea that the program is “stuck”. Maybe the solution here is to use some other indication of “busy” instead of changing the cursor, so that the program does not appear stuck/non-responsive.

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

I read that one now, but it still doesn't provide a “real time” status of a query's progress. I end up checking “show full processlist” on another window to know how the query is doing. A once a second timer would be really good.

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?

I wasn't specific enough, you're right. Latest SQLYog, when performing “alter” or “create” table. The column definition window defines a “DEFAULT ''” for each column that is added. If I remove the the single quotes manually, they come back after clicking “alter table”.

[Shlomo Priymak]

If I may, I'd also like to propose few features 🙂

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.

2. Don't hang the front whole window while a long query is executing. Maybe use separate thread?

3. Show running execution time during, when running a regular query. This is also relevant for aforementioned DDL operations from the GUI.

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 hope I have not included anything that was obvious or old…

Thanks,

—

Shlomo

http://blog.shlomoid.com

[Author]

Posts