test: add logictest about ALTER USER ... WITH
@@ -40,6 +40,9 @@ CREATE USER 'test-i@localhost' IDENTIFIED WITH sha256_password BY 'password';
statement ok
ALTER USER 'test-i@localhost' IDENTIFIED WITH sha256_password BY 'new-password';
+statement ok
+ALTER USER 'test-i'@'localhost' WITH DEFAULT_ROLE = 'role1';
+
statement ok
DROP USER IF EXISTS 'test-e'@'localhost';
