distal-attribute
distal-attribute
distal-attribute
distal-attribute

Spaces instead of tabs not applying to create/alter code

User, date Message
Written by microUgly
2 years ago
Category: General
20 posts since Fri, 16 Apr 10
The setting for using spaces instead of tabs doesn't apply to the code generated for create and alter statements. Is it possible to change that?
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
That space-to-tab feature converts tabs which were typed via keyboard, not those which get prefilled by some automatic feature. These are two different things. But however, highly cosmetic if you ask me.
Written by microUgly
2 years ago
20 posts since Fri, 16 Apr 10
I use HeidiSQL to get create and alter statements from a master database which is then applied to other servers through the commandline.

Tab characters conflicts with MySQLs default rehashing feature.

This is one of the few situations that the "tab/spaces" argument has a functional side effect--spaces are always safe, tabs are not. It's not a personal preference (although I am a "space" man).

Currently we have to make a conscience effort to replace tabs with spaces before recording SQL in our documents to ensure they always work.
Written by microUgly
2 years ago
20 posts since Fri, 16 Apr 10
No chance then? I really thought that because tabs makes SQL statements less portable was good justification.
 

Please login to leave a reply, or register at first.