[IGNITE-13184] ALTER USER SET PASSWORD is valid syntax but does not find user

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.8.1
• Component/s: security, sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Ilya Kasnacheev
• Created: 25/Jun/20 10:55
• Updated: 25/Jun/20 10:57

Description

I have noticed the following:

1: jdbc:ignite:thin://localhost> ALTER USER "ignite" set password 'abcdefg' ;    
Error: Failed to parse query. Пользователь "ignite" не найден
User "ignite" not found; SQL statement:
ALTER USER "ignite" set password 'abcdefg'  [90032-197] (state=42000,code=1001)

The correct syntax is "WITH PASSWORD" but using "SET PASSWORD" does not cause parse error (like LIMIT PASSWORD or WHERE PASSWORD) would. It will report that user does not exist, which is false, and can probably throw an user off.