HeavyMetal icon indicating copy to clipboard operation
HeavyMetal copied to clipboard

Filter disregards if database supports FEATURE_TABLE_ALIAS or not

Open jawngee opened this issue 14 years ago • 1 comments

Pretty minor, but I ran into this working with sqlite3 which of course supports it, though it does not support numeric ones, it must contain one letter.

jawngee avatar Aug 27 '10 04:08 jawngee

Do you have a testcase? I'm not sure if I understand what you encountered.

The heuristic for building table aliases is to take one letter from each word segment and append a unique random number. E.g. profiles.profile_view would be aliased something like ppv27, so you shouldn't ever see a numeric alias unless your table name is somehow numeric (which I think is verboten as well!)

peterdm avatar Aug 27 '10 13:08 peterdm