Re: [Firebird-devel] User name case
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
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
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
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
Re: [Firebird-devel] User name case
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). -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] User name case
On 1/18/22 19:23, Dimitry Sibiryakov wrote: Hello All. At which point user name is uppercased during attachDatabase() call? In ServerAuth::ServerAuth(). It calls fb_utils::dpbItemUpper(userName); Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] User name case
Hello All. At which point user name is uppercased during attachDatabase() call? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel