On 05/08/15 15:33, Jim Starkey wrote: > Isn't it awfully confusing that a name that just happens to be all Ascii is > case insensitive but one with a non-ASCII character is case sensitive?
Telling true it's not more confusing than having Ascii name which is case insensitive and (full) non-ASCII name which is case sensitive. > If you know the character set and the upcasing rules, why not upcase all > non-quoted identifiers? The only place where we can have non-quoted non-ascii identifiers are various parameters blocks. I.e. the problem is wider than just logins and roles, for example table name may arrive in TPB. But we may talk first of all about logins cause they are used in DPB very often (at almost any connect to server) and therefore are specially interesting. Upcasing all non-quoted is very generic solution but one trouble exists - it's specially inconvenient for non-ascii logins. When adding new user with non-ascii symbols one has to use quoted form - non-quoted identifier with non-ascii symbol is rejected in CREATE USER and GRANT operators. And when placing that login into DPB from command line utility it's certainly possible to put it into quotes but definitely not too convenient. Users wish to be able at least to use in same way written login in both SQL operator and command line and always have it recognized. > Jim Starkey > > >> On May 7, 2015, at 6:47 AM, Alex Peshkoff <peshk...@mail.ru> wrote: >> >>> On 05/06/15 23:27, Jim Starkey wrote: >>> Non-ASCII, non-quoted names are a) illegal by SQL standard >> Yes, illegal, but logins and roles may arrive not in SQL context. They >> come to server in DPB. >> >>> and b) impossible to handle by Lex without both character set declaration >>> and explicit language support for that character set >> It's anyway required to transliterate identifier to metadata charset. >> >>> , and c) a really bad ideas (in my humble opinion). Otherwise, how can lex >>> even parse the identifier? Assume any character it doesn't recognize is a >>> letter? >> luckily lex need not parse DPB >> >> With Dmitry's suggestiion I see no problems with that identifiers - the >> only difference from exact SQL is that unquoted identifier with >> non-ascii symbols may exist. But we always treat it as quoted one i.e. >> leave case unchanged. Unquoted ascii-only logins/roles from DPB are >> uppercased. >> >>> If Firebird were UTF-8 only, which I think would be a good thing, maybe >>> rules could be relaxed. But trying to handle identifiers in random >>> character sets is untenable. >>> >>> >>> Jim Starkey >>> >>> >>>> On May 6, 2015, at 4:04 PM, Leyne, Sean <s...@broadviewsoftware.com> wrote: >>>> >>>> >>>> >>>>> I didn't follow all the details of this discussion, but this is how I see >>>>> the things: >>>>> >>>>> 1) I don't think non-ASCII user/role names ever worked reliably and we >>>>> never recommended using them. So if someone used them, they should be >>>>> prepared for troubles. And this is OK (more or less) during a major >>>>> version >>>>> upgrade. Life is cruel. >>>>> >>>>> 2) Unquoted ASCII user/role names should work the same way as before. I >>>>> believe we support the standard here by implicitly uppercasing them. >>>>> >>>>> 3) Quoted ASCII user/role names should work as declared in the standard, >>>>> i.e. be case-sensitive. If this causes compatibility issues for someone, >>>>> well, so >>>>> be it. I don't think there are many of such usage cases. >>>> I agree with everything that you have outlined, the question which is >>>> resolved by these answers is: >>>> >>>> How should unquoted non-ASCII characters in user/role names be handled >>>> (without the requiring ICU installed at client)? >>>> >>>> >>>> Sean >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> 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 >>> ------------------------------------------------------------------------------ >>> 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 >>> >> >> ------------------------------------------------------------------------------ >> 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 > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ 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
