Merge 4.9 into 4.10 #6324
GitHub Actions / Java CI / Test Report (21)
failed
Sep 9, 2024 in 0s
5708 tests run, 5446 passed, 140 skipped, 122 failed.
Annotations
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test cursored pageable list for sorting null
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{id, DESC)]}
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{name, ASC)]}
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{name, DESC)]}
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{age, ASC), SORT{name, ASC)]}
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age > ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age ASC,person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{age, DESC), SORT{name, ASC)]}
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.age < ?) OR (person_.age = ? AND person_.name > ?) OR (person_.age = ? AND person_.name = ? AND person_.id > ?)) ORDER BY person_.age DESC,person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test pageable list with row removal [sorting: null, elem1: AAAAA00, elem2: AAAAA01, elem10: BBBBB00, elem19: BBBBB09, #0]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test pageable list with row removal [sorting: DefaultSort{orderBy=[SORT{id, DESC)]}, elem1: ZZZZZ09, elem2: ZZZZZ08, elem10: YYYYY09, elem19: YYYYY00, #1]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id < ?)) ORDER BY person_.id DESC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test pageable list with row removal [sorting: DefaultSort{orderBy=[SORT{name, ASC)]}, elem1: AAAAA00, elem2: AAAAA00, elem10: AAAAA03, elem19: AAAAA06, #2]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test pageable list with row removal [sorting: DefaultSort{orderBy=[SORT{name, DESC)]}, elem1: ZZZZZ09, elem2: ZZZZZ09, elem10: ZZZZZ06, elem19: ZZZZZ03, #3]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test pageable list with row addition [sorting: DefaultSort{orderBy=[SORT{name, ASC)]}, elem1: AAAAA00, elem2: AAAAA00, elem3: AAAAA00, elem10: AAAAA03, elem19: AAAAA06, #0]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row addition(AbstractCursoredPageSpec.groovy:186)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name > ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name ASC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2CursoredPaginationSpec.test pageable list with row addition [sorting: DefaultSort{orderBy=[SORT{name, DESC)]}, elem1: ZZZZZ09, elem2: ZZZZZ09, elem3: ZZZZZ09, elem10: ZZZZZ06, elem19: ZZZZZ03, #1]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.withExistingConnectionInternal(AbstractConnectionOperations.java:128)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:92)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at app//io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at app//io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row addition(AbstractCursoredPageSpec.groovy:186)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.name < ?) OR (person_.name = ? AND person_.id > ?)) ORDER BY person_.name DESC,person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 12 more
github-actions / Java CI / Test Report (21)
H2ReactiveRepositorySpec.test pageable list [pageable: DefaultCursoredPageable{size=10, page=0, currentCursor=null, mode=CURSOR_NEXT, sort=DefaultSort{orderBy=[]}}, #1]
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
Raw output
io.micronaut.data.exceptions.DataAccessException: Unable to prepare query [SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10]: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:218)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:376)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at app//io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at app//io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at app//io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at app//io.micronaut.data.runtime.operations.ExecutorAsyncOperations.lambda$findAll$8(ExecutorAsyncOperations.java:131)
at [email protected]/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
at [email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at [email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at [email protected]/java.lang.Thread.run(Thread.java:1583)
Suppressed: java.lang.Exception: #block terminated with an error
at reactor.core.publisher.BlockingSingleSubscriber.blockingGet(BlockingSingleSubscriber.java:104)
at reactor.core.publisher.Mono.block(Mono.java:1779)
at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321)
at io.micronaut.data.tck.tests.AbstractReactiveRepositorySpec.$spock_feature_0_22(AbstractReactiveRepositorySpec.groovy:710)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.spockframework.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:187)
at org.spockframework.runtime.model.MethodInfo.lambda$new$0(MethodInfo.java:49)
at org.spockframework.runtime.model.MethodInfo.invoke(MethodInfo.java:156)
at org.spockframework.runtime.PlatformSpecRunner.invokeRaw(PlatformSpecRunner.java:407)
at org.spockframework.runtime.PlatformSpecRunner.invoke(PlatformSpecRunner.java:390)
at org.spockframework.runtime.PlatformSpecRunner.runFeatureMethod(PlatformSpecRunner.java:324)
at org.spockframework.runtime.IterationNode.execute(IterationNode.java:50)
at org.spockframework.runtime.IterationNode.execute(IterationNode.java:13)
at org.spockframework.runtime.SpockNode.sneakyInvoke(SpockNode.java:40)
at org.spockframework.runtime.IterationNode.lambda$around$0(IterationNode.java:67)
at org.spockframework.runtime.PlatformSpecRunner.lambda$createMethodInfoForDoRunIteration$5(PlatformSpecRunner.java:236)
at org.spockframework.runtime.model.MethodInfo.invoke(MethodInfo.java:156)
at org.spockframework.runtime.PlatformSpecRunner.invokeRaw(PlatformSpecRunner.java:407)
at org.spockframework.runtime.PlatformSpecRunner.invoke(PlatformSpecRunner.java:390)
at org.spockframework.runtime.PlatformSpecRunner.runIteration(PlatformSpecRunner.java:218)
at org.spockframework.runtime.IterationNode.around(IterationNode.java:67)
at org.spockframework.runtime.IterationNode.around(IterationNode.java:13)
at org.spockframework.runtime.ParameterizedFeatureChildExecutor.execute(ParameterizedFeatureChildExecutor.java:104)
at org.spockframework.runtime.PlatformParameterizedSpecRunner$1.runIteration(PlatformParameterizedSpecRunner.java:72)
at org.spockframework.runtime.extension.IDataDriver.lambda$static$0(IDataDriver.java:37)
at org.spockframework.runtime.PlatformParameterizedSpecRunner.runParameterizedFeature(PlatformParameterizedSpecRunner.java:47)
at org.spockframework.runtime.ParameterizedFeatureNode.execute(ParameterizedFeatureNode.java:40)
at org.spockframework.runtime.ParameterizedFeatureNode.execute(ParameterizedFeatureNode.java:16)
at org.spockframework.runtime.SpockNode.sneakyInvoke(SpockNode.java:40)
at org.spockframework.runtime.FeatureNode.lambda$around$0(FeatureNode.java:41)
at org.spockframework.runtime.PlatformSpecRunner.lambda$createMethodInfoForDoRunFeature$4(PlatformSpecRunner.java:199)
at org.spockframework.runtime.model.MethodInfo.invoke(MethodInfo.java:156)
at org.spockframework.runtime.PlatformSpecRunner.invokeRaw(PlatformSpecRunner.java:407)
at org.spockframework.runtime.PlatformSpecRunner.invoke(PlatformSpecRunner.java:390)
at org.spockframework.runtime.PlatformSpecRunner.runFeature(PlatformSpecRunner.java:192)
at org.spockframework.runtime.FeatureNode.around(FeatureNode.java:41)
at org.spockframework.runtime.FeatureNode.around(FeatureNode.java:12)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
at org.spockframework.runtime.SpockNode.sneakyInvoke(SpockNode.java:40)
at org.spockframework.runtime.SpecNode.lambda$around$0(SpecNode.java:63)
at org.spockframework.runtime.PlatformSpecRunner.lambda$createMethodInfoForDoRunSpec$0(PlatformSpecRunner.java:61)
at org.spockframework.runtime.model.MethodInfo.invoke(MethodInfo.java:156)
at org.spockframework.runtime.PlatformSpecRunner.invokeRaw(PlatformSpecRunner.java:407)
at org.spockframework.runtime.PlatformSpecRunner.invoke(PlatformSpecRunner.java:390)
at org.spockframework.runtime.PlatformSpecRunner.runSpec(PlatformSpecRunner.java:55)
at org.spockframework.runtime.SpecNode.around(SpecNode.java:63)
at org.spockframework.runtime.SpecNode.around(SpecNode.java:11)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ [*]AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10"; SQL statement:
SELECT person_.`id`,person_.`name`,person_.`age`,person_.`enabled`,person_.`income` FROM `person` person_ AND ((person_.id > ?)) ORDER BY person_.id ASC LIMIT 10 [42000-232]
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at app//org.h2.message.DbException.get(DbException.java:223)
at app//org.h2.message.DbException.get(DbException.java:199)
at app//org.h2.message.DbException.getSyntaxError(DbException.java:247)
at app//org.h2.command.ParserBase.getSyntaxError(ParserBase.java:760)
at app//org.h2.command.Parser.prepareCommand(Parser.java:487)
at app//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
at app//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
at app//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
at app//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at app//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:315)
at app//org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:89)
at app//org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at app//org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at app//io.micronaut.data.runtime.operations.internal.sql.AbstractSqlRepositoryOperations.prepareStatement(AbstractSqlRepositoryOperations.java:216)
... 13 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test cursored pageable list for sorting null
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.id > 10)) ORDER BY person_.id ASC LIMIT 10' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{id, DESC)]}
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.id < 1551)) ORDER BY person_.id DESC LIMIT 10' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{name, ASC)]}
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.name > 'AAAAA03') OR (person_.name = 'AAAAA03' AND person_.id > 15' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{name, DESC)]}
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.name < 'ZZZZZ06') OR (person_.name = 'ZZZZZ06' AND person_.id > 25' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{age, ASC), SORT{name, ASC)]}
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.age > 1) OR (person_.age = 1 AND person_.name > 'JJJJJ00') OR (per' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test cursored pageable list for sorting DefaultSort{orderBy=[SORT{age, DESC), SORT{name, ASC)]}
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test cursored pageable list for sorting #sorting(AbstractCursoredPageSpec.groovy:90)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.age < 30) OR (person_.age = 30 AND person_.name > 'JJJJJ09') OR (p' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test pageable list with row removal [sorting: null, elem1: AAAAA00, elem2: AAAAA01, elem10: BBBBB00, elem19: BBBBB09, #0]
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.id > 4690)) ORDER BY person_.id ASC LIMIT 10' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test pageable list with row removal [sorting: DefaultSort{orderBy=[SORT{id, DESC)]}, elem1: ZZZZZ09, elem2: ZZZZZ08, elem10: YYYYY09, elem19: YYYYY00, #1]
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.id < 6231)) ORDER BY person_.id DESC LIMIT 10' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test pageable list with row removal [sorting: DefaultSort{orderBy=[SORT{name, ASC)]}, elem1: AAAAA00, elem2: AAAAA00, elem10: AAAAA03, elem19: AAAAA06, #2]
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.name > 'AAAAA03') OR (person_.name = 'AAAAA03' AND person_.id > 62' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test pageable list with row removal [sorting: DefaultSort{orderBy=[SORT{name, DESC)]}, elem1: ZZZZZ09, elem2: ZZZZZ09, elem10: ZZZZZ06, elem19: ZZZZZ03, #3]
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row removal(AbstractCursoredPageSpec.groovy:137)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.name < 'ZZZZZ06') OR (person_.name = 'ZZZZZ06' AND person_.id > 72' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test pageable list with row addition [sorting: DefaultSort{orderBy=[SORT{name, ASC)]}, elem1: AAAAA00, elem2: AAAAA00, elem3: AAAAA00, elem10: AAAAA03, elem19: AAAAA06, #0]
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row addition(AbstractCursoredPageSpec.groovy:186)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.name > 'AAAAA03') OR (person_.name = 'AAAAA03' AND person_.id > 78' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
github-actions / Java CI / Test Report (21)
MysqlCursoredPaginationSpec.test pageable list with row addition [sorting: DefaultSort{orderBy=[SORT{name, DESC)]}, elem1: ZZZZZ09, elem2: ZZZZZ09, elem3: ZZZZZ09, elem10: ZZZZZ06, elem19: ZZZZZ03, #1]
java.lang.reflect.UndeclaredThrowableException
Raw output
java.lang.reflect.UndeclaredThrowableException
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:385)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:378)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$findAll$5(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.lambda$executeRead$23(DefaultJdbcRepositoryOperations.java:770)
at io.micronaut.data.connection.support.AbstractConnectionOperations.executeWithNewConnection(AbstractConnectionOperations.java:143)
at io.micronaut.data.connection.support.AbstractConnectionOperations.execute(AbstractConnectionOperations.java:90)
at io.micronaut.data.connection.ConnectionOperations.executeRead(ConnectionOperations.java:71)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.executeRead(DefaultJdbcRepositoryOperations.java:767)
at io.micronaut.data.jdbc.operations.DefaultJdbcRepositoryOperations.findAll(DefaultJdbcRepositoryOperations.java:530)
at io.micronaut.data.runtime.intercept.DefaultAbstractFindPageInterceptor.intercept(DefaultAbstractFindPageInterceptor.java:62)
at io.micronaut.data.runtime.intercept.DataIntroductionAdvice.intercept(DataIntroductionAdvice.java:83)
at io.micronaut.aop.chain.MethodInterceptorChain.proceed(MethodInterceptorChain.java:143)
at io.micronaut.data.tck.tests.AbstractCursoredPageSpec.test pageable list with row addition(AbstractCursoredPageSpec.groovy:186)
Caused by: java.lang.reflect.InvocationTargetException
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:130)
... 13 more
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ((person_.name < 'ZZZZZ06') OR (person_.name = 'ZZZZZ06' AND person_.id > 88' at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
... 14 more
Loading