Forum Replies Created
-
AuthorPosts
-
MitchParticipant
It happens every time I run that particular query. Here is another dump.
Gnome = yes.
Reboot = tried it.
MitchParticipantHere is the dump file.
MitchParticipantA query that returns a row with picture = null does not crash.
MitchParticipantI 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.
MitchParticipantBut there seems to be some queries where the refresh button is enabled. See attached screen shot.
MitchParticipantRelated: the “Column Name” column is also to narrow – does not show the full name of some columns.
MitchParticipantUbuntu 10.10 64 bit
Gnome
Wine 1.2.2
MitchParticipantIt is working great. Thanks!
MitchParticipantI see it now. It was a bit difficult to find that option, but now that I see it I will never forget!
MitchParticipantI 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.
MitchParticipantI 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.
MitchParticipantIt 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.
MitchParticipantI am running version 8.81 under Wine.
MitchParticipantIf I take the failing SQL (from history tab) and double the quote myself, it works fine.
MitchParticipantI have permission to allow you into our VPN for debugging. Are you still interested in doing this?
-
AuthorPosts