Re: [Firebird-devel] User name case

2022-01-20 Thread Alex Peshkoff via Firebird-devel 

On 1/20/22 12:49, Dimitry Sibiryakov wrote:

Alex Peshkoff via Firebird-devel wrote 20.01.2022 10:43:

Are you sure?

fbs3 /usr/home/firebird/HEAD/gen/Debug/firebird/bin # ./isql -user 
РусLat -password abc localhost:employee

Database: localhost:employee, User: РусLat


  Try, for example, "test-user". The only special symbols allowed in 
SQL identifiers are "$" and "_" but the routine check only highest bit.




Nice catch. Please add an item and/or PR.




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User name case

2022-01-20 Thread Dimitry Sibiryakov 

Alex Peshkoff via Firebird-devel wrote 20.01.2022 10:43:

Are you sure?

fbs3 /usr/home/firebird/HEAD/gen/Debug/firebird/bin # ./isql -user РусLat 
-password abc localhost:employee

Database: localhost:employee, User: РусLat


  Try, for example, "test-user". The only special symbols allowed in SQL 
identifiers are "$" and "_" but the routine check only highest bit.


--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User name case

2022-01-20 Thread Alex Peshkoff via Firebird-devel 

On 1/19/22 18:46, Dimitry Sibiryakov wrote:

Alex Peshkoff via Firebird-devel wrote 18.01.2022 18:03:

 fb_utils::dpbItemUpper(userName);


  That's quite strange routine. It will uppercase the string even if 
it contains ASCII letters disallowed for not-delimited SQL identifier 
(which user name is).




Are you sure?

fbs3 /usr/home/firebird/HEAD/gen/Debug/firebird/bin # ./isql -user 
РусLat -password abc localhost:employee

Database: localhost:employee, User: РусLat
SQL> select current_user from rdb$database;

USER
===
РусLat

SQL>




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User name case

2022-01-20 Thread Mark Rotteveel 

On 2022-01-19 16:46, Dimitry Sibiryakov wrote:

Alex Peshkoff via Firebird-devel wrote 18.01.2022 18:03:

     fb_utils::dpbItemUpper(userName);


  That's quite strange routine. It will uppercase the string even if
it contains ASCII letters disallowed for not-delimited SQL identifier
(which user name is).


A user name is a delimited identifier since Firebird 3.0, but if it was 
delimited, it wouldn't be uppercased.


Mark


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel