On 05/05/15 17:01, James Starkey wrote: > The SQL standard, and Ann will correct me if I'm wrong, is both clear and > simple. Unquoted (and necessarily ASCII) identifiers are folded to upper > case and quoted identifiers are not. > > The SQL language character set is ASCII except for strings enclosed in > quotes. > > Other than folding ASCII lower case to ASCII upper case, no other > conversion is necessary.
OK, let's try to follow standard exactly regarding user names and roles. But some questions remain. First of all, usage of names in GRANT/REVOKE operators since interbase/firebird fork (at least since it, suppose even earlier) does not follow SQL standard. User name is always upper cased, even when it is double quoted. Who can see any problems (first of all backward compatibility one) if this behavior is changed? For me the worse is as follows. If someone is using quoted user names in scripts, and that names do have lower-case symbols, result will be not as expected. For example: grant select on ..... to "SomeOne" Expected to grant rights to SOMEONE, actually will be granted to SomeOne. I do not think it's a bug issue first of all cause I do not expect such scripts, but formal compatibility is broken. Second problem is what to do with names from DPB. There is Adriano's suggestion to use same logic as for roles (non-quoted names are uppercased), but here is one additional issue with non-ascii names. Unlike SQL such names may be entered without quotes. In versions pre-2.5 non-ascii symbols in role name are not uppercased, in 2.5 they are uppercased. What behavior is appropriate for roles and logins in FB3? ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
