Forum Replies Created
-
AuthorPosts
-
Mitch
ParticipantIt happens every time I run that particular query. Here is another dump.
Gnome = yes.
Reboot = tried it.
Mitch
ParticipantHere is the dump file.
Mitch
ParticipantA query that returns a row with picture = null does not crash.
Mitch
ParticipantI understand the “Limit rows” being disabled when the query has a LIMIT, but it doesn't make sense to me for the Refresh button to be disabled simply because of a LIMIT.
Mitch
ParticipantBut there seems to be some queries where the refresh button is enabled. See attached screen shot.
Mitch
ParticipantRelated: the “Column Name” column is also to narrow – does not show the full name of some columns.
Mitch
ParticipantUbuntu 10.10 64 bit
Gnome
Wine 1.2.2
Mitch
ParticipantIt is working great. Thanks!
Mitch
ParticipantI see it now. It was a bit difficult to find that option, but now that I see it I will never forget!
Mitch
ParticipantI really did attach a screen recording in my first post. Not sure what happened to it.
I did some more research, and it seems that this is an oddity of mysql, not SQLyog. SQLyog is reflecting the status of the table after the index is added.
Mitch
ParticipantI suggest that there be an additional option that would control whether or not the auto-complete operated this way. Then, using the same example, if there was a “columnc” in tableb and the pattern was recognized, then the first column listed would be “colulmnc” with the new option in effect, or the normal column list if the new option was not in effect.
I recognize that this might take some work on the auto-complete parser, but I think that many users would find this a valuable feature. A large percentage of the queries that I write contain this particular pattern, or an explicit JOIN.
Mitch
ParticipantIt seems to suggest all of the columns in tableb, but I'd like it to (optionally) choose the matching column name as the first suggestion.
Mitch
ParticipantI am running version 8.81 under Wine.
Mitch
ParticipantIf I take the failing SQL (from history tab) and double the quote myself, it works fine.
Mitch
ParticipantI have permission to allow you into our VPN for debugging. Are you still interested in doing this?
-
AuthorPosts