On 06/05/2015 13:49, Alex Peshkoff wrote: > 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? > > So, that's not the only problem, as you pointed above. IMHO, if things is going to be incompatible and requires user attention anyway, I'd say it's better to do nothing automatically in the API nor in the command line, for users and roles. Everybody will have some initial problem, but then no one will be in real trouble entering names in case-sensitive form in non-SQL places. Adriano ------------------------------------------------------------------------------ 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
