mariadb authorization fails with BadSqlGrammarException

[Yneth]

Describe the bug
Cannot authorize on existing registered client

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO oauth2_authorization (id, registered_client_id, principal_name, authorization_grant_type, attributes, state, authorization_code_value, authorization_code_issued_at, authorization_code_expires_at,authorization_code_metadata,access_token_value,access_token_issued_at,access_token_expires_at,access_token_metadata,access_token_type,access_token_scopes,oidc_id_token_value,oidc_id_token_issued_at,oidc_id_token_expires_at,oidc_id_token_metadata,refresh_token_value,refresh_token_issued_at,refresh_token_expires_at,refresh_token_metadata) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLSyntaxErrorException: (conn=4) Could not convert [{"@class":"java.util.Collections$UnmodifiableMap","java.security.Principal":

is thrown for attribute column on insertion.

To Reproduce
Attempt to authorize via existing registered client
example url
http://localhost:8080/oauth2/authorize?scope=client.read%20openid&response_type=code&client_id=client_id&redirect_uri=https://oauthdebugger.com/debug

Expected behavior
Should successfully authorize

Sample
I have the same issue as described in
#520

TO be exact BLOB int value for mariadb is equal to -4
which is set here

spring-authorization-server/oauth2-authorization-server/src/main/java/org/springframework/security/oauth2/server/authorization/JdbcOAuth2AuthorizationService.java

Line 663 in b991e1a

return rs.getInt("DATA_TYPE");

BUT it is later used

spring-authorization-server/oauth2-authorization-server/src/main/java/org/springframework/security/oauth2/server/authorization/JdbcOAuth2AuthorizationService.java

Line 681 in b991e1a

return Types.BLOB == columnMetadata.getDataType() && StringUtils.hasText(value) ?

failing to convert string to byte array as 2004 != -4

[jgrandja]

@Yneth Closing this as a duplicate of gh-550.

For additional details, please see this comment.