When opening
Configuration => Subsystems => Configuration => Security (Elytron) => Security Realms => JDBC Realm => Principal Query
the field "Attribute Mapping" shows only the first attribute
via cli this looks correct
/subsystem=elytron/jdbc-realm=MySqlJDBCRealm:read-resource
{
"outcome" => "success",
"result" => {"principal-query" => [{
"sql" => "SELECT u.password, r.role FROM users u, roles r WHERE u.userna
me =? AND u.username = r.username",
"data-source" => "MySQLTestDS",
"attribute-mapping" => [{
"to" => "groups",
"index" => 2
}],
"clear-password-mapper" => {"password-index" => 1}
}]}
}