[
https://issues.apache.org/jira/browse/FINERACT-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18065997#comment-18065997
]
VICTOR ROMERO commented on FINERACT-2535:
-----------------------------------------
It doesn't work, because the same query "SELECT * from m_client" works in
Postgresql. So then this is a defect for MariaDB.
The sentence is valid ANSI SQL (it conforms to the SQL standard syntax as
defined in ISO/IEC 9075).
El dom, 15 mar 2026 a las 19:47, Arnav Patil (Jira) (<[email protected]>)
> Data type 'BOOLEAN' is not supported in runreports endpoint
> -----------------------------------------------------------
>
> Key: FINERACT-2535
> URL: https://issues.apache.org/jira/browse/FINERACT-2535
> Project: Apache Fineract
> Issue Type: Task
> Reporter: Victor Romero
> Priority: Major
>
> Data type 'BOOLEAN' is not supported in runreports endpoints
>
> Database MariaDB version 12
> Step to reproduce
> 1. Create a Custom SQL Report
> SELECT * from m_client
> POST
> https://\{URL_BASE}/fineract-provider/api/v1/reports
> {"reportName":"TEST_REPORT","reportCategory":"","description":"","reportType":"Table","useReport":true,"reportSql":"select
> * from m_client","reportParameters":[]}
>
> Run it
> GET on https://\{BASE_URL}/fineract-provider/api/v1/runreports/LIST_CLIENTS
> Response
> {
> "developerMessage": "The server is currently unable to handle the request
> , please try after some time.",
> "httpStatusCode": "503",
> "defaultUserMessage": "The server is currently unable to handle the
> request , please try after some time.",
> "userMessageGlobalisationCode": "error.msg.platform.service.unavailable",
> "errors": [
> {
> "defaultUserMessage": "Data type 'BOOLEAN' is not supported ",
> "parameterName": "id",
> "developerMessage": "Data type 'BOOLEAN' is not supported ",
> "userMessageGlobalisationCode":
> "error.msg.database.type.not.supported",
> "args": []
> }
> ]
> }
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
