Error: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: (conn=21) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-10, 10 ### The error may exist in mapper/contract_sql.xml ### The error may involve com.jsedc.contractweblib.ehojo.service.impl.ContractMapper.selectCostList-Inline ### The error occurred while setting parameters ### SQL: SELECT T.*, (select nvl(sum(f.pay_amt),0) as pay2 from V_TCM_BILLPAY_LINK f where f.CTRT_ACCT_BOOK_MNG_NO=T.CTRT_ACCT_BOOK_MNG_NO and f.pay_kind_fg='100') as pay2, (select nvl(sum(f.pay_amt) ,0) as pay3 from V_TCM_BILLPAY_LINK f where f.CTRT_ACCT_BOOK_MNG_NO=T.CTRT_ACCT_BOOK_MNG_NO and f.pay_kind_fg='300') as pay3, (select nvl(sum(f.pay_amt),0) as pay4 from V_TCM_BILLPAY_LINK f where f.CTRT_ACCT_BOOK_MNG_NO=T.CTRT_ACCT_BOOK_MNG_NO and f.pay_kind_fg='400') as pay4, (select nvl(sum(f.pay_amt),0) as pay7 from V_TCM_BILLPAY_LINK f where f.CTRT_ACCT_BOOK_MNG_NO=T.CTRT_ACCT_BOOK_MNG_NO and f.pay_kind_fg='700') as pay7 FROM ( SELECT '춘천시' AS GOV_NM, A.CTRT_ACCT_BOOK_MNG_NO, A.CTRT_GOV_CD, A.CTRT_GOV_NM, A.DEPT_CD, A.DEPT_NM, A.CTRT_KIND, A.CTRT_NM, Nvl(A.SCHD_AMT,0) AS SCHD_AMT, Nvl(A.FIRST_CTRT_AMT,0) AS FIRST_CTRT_AMT, Nvl(A.CTRT_AMT,0) AS CTRT_AMT, A.CTRT_RATE, A.CTRT_YMD, A.CTRT_START_YMD, A.CTRT_END_YMD, A.CTRT_METH, A.COMPLT_YMD, A.CTRT_FG_NM, A.CTRT_TYPE_NM, A.CTRT_RSN, A.CUST_NM, A.LOCAT_NM FROM tb_cost A WHERE 1=1 AND A.CTRT_KIND = ? order by A.CTRT_YMD desc, A.CTRT_ACCT_BOOK_MNG_NO desc LIMIT ?, 10 ) T, (SELECT @RNUM := 0) R ### Cause: java.sql.SQLSyntaxErrorException: (conn=21) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-10, 10