Maksim Zhuravkov created IGNITE-22929:
-----------------------------------------
Summary: Sql. REGEX_REPLACE. Unable to compile expression
Key: IGNITE-22929
URL: https://issues.apache.org/jira/browse/IGNITE-22929
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Maksim Zhuravkov
{noformat}
SELECT regexp_replace('ANA', 'ana', 'banana', 'i')
{noformat}
Expected: banana
But got an error:
{noformat}
Caused by: org.apache.ignite.sql.SqlException: IGN-CMN-65535
TraceId:c9b560ec-bcff-4afb-94d9-bcb8c03eaa52 Unable to compile expression
at
java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710)
at
org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:789)
at
org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:723)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:658)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476)
at
org.apache.ignite.internal.sql.api.IgniteSqlImpl.execute(IgniteSqlImpl.java:210)
at
org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.lambda$execute$1(PublicApiThreadingIgniteSql.java:65)
at
org.apache.ignite.internal.thread.PublicApiThreading.executeWithRole(PublicApiThreading.java:144)
at
org.apache.ignite.internal.thread.PublicApiThreading.execUserSyncOperation(PublicApiThreading.java:102)
at
org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.execute(PublicApiThreadingIgniteSql.java:65)
at
org.apache.ignite.internal.sql.sqllogic.ScriptContext.executeQuery(ScriptContext.java:85)
at org.apache.ignite.internal.sql.sqllogic.Query.execute(Query.java:263)
at
org.apache.ignite.internal.sql.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:70)
... 4 more
Caused by: java.util.concurrent.CompletionException:
org.apache.ignite.sql.SqlException: IGN-CMN-65535
TraceId:c9b560ec-bcff-4afb-94d9-bcb8c03eaa52 Unable to compile expression
at
org.apache.ignite.internal.sql.api.IgniteSqlImpl.lambda$executeAsyncInternal$5(IgniteSqlImpl.java:379)
at
java.base/java.util.concurrent.CompletableFuture.uniExceptionally(CompletableFuture.java:986)
at
java.base/java.util.concurrent.CompletableFuture$UniExceptionally.tryFire(CompletableFuture.java:970)
at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
at
java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)
at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.lambda$closeAsync$4(TxAwareAsyncCursor.java:84)
at
java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
at
java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
at
java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.lambda$close$23(ExecutionServiceImpl.java:1261)
at
java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
at
java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
at
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1705)
at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:83)
... 3 more
Caused by: org.apache.ignite.sql.SqlException: IGN-CMN-65535
TraceId:c9b560ec-bcff-4afb-94d9-bcb8c03eaa52 Unable to compile expression
at
org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:61)
at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.wrapIfNecessary(TxAwareAsyncCursor.java:131)
at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.handleError(TxAwareAsyncCursor.java:108)
at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.lambda$requestNextAsync$2(TxAwareAsyncCursor.java:60)
at
java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:930)
at
java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:907)
at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
at
java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.acknowledgeFragment(ExecutionServiceImpl.java:852)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.onMessage(ExecutionServiceImpl.java:532)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.lambda$start$2(ExecutionServiceImpl.java:278)
at
org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:151)
at
org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.lambda$onMessage$1(MessageServiceImpl.java:117)
... 4 more
Caused by: org.apache.ignite.lang.IgniteException: IGN-CMN-65535
TraceId:c9b560ec-bcff-4afb-94d9-bcb8c03eaa52 Unable to compile expression
at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.lambda$mapToPublicException$2(IgniteExceptionMapperUtil.java:88)
at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapCheckingResultIsPublic(IgniteExceptionMapperUtil.java:141)
at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:137)
at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:88)
at
org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:51)
... 16 more
Caused by: org.apache.ignite.internal.lang.IgniteInternalException:
IGN-CMN-65535 TraceId:c9b560ec-bcff-4afb-94d9-bcb8c03eaa52 Unable to compile
expression
at
org.apache.ignite.internal.sql.engine.util.Commons.compile(Commons.java:369)
at
org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl.compile(ExpressionFactoryImpl.java:643)
at
org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl.lambda$scalar$3(ExpressionFactoryImpl.java:557)
at
com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$13(BoundedLocalCache.java:2457)
at
java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1908)
at
com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2455)
at
com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2438)
at
com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:107)
at
org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl.scalar(ExpressionFactoryImpl.java:556)
at
org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl.project(ExpressionFactoryImpl.java:274)
at
org.apache.ignite.internal.sql.engine.exec.LogicalRelImplementor.visit(LogicalRelImplementor.java:243)
at
org.apache.ignite.internal.sql.engine.exec.LogicalRelImplementor.visit(LogicalRelImplementor.java:136)
at
org.apache.ignite.internal.sql.engine.rel.IgniteProject.accept(IgniteProject.java:95)
at
org.apache.ignite.internal.sql.engine.exec.LogicalRelImplementor.visit(LogicalRelImplementor.java:908)
at
org.apache.ignite.internal.sql.engine.exec.LogicalRelImplementor.go(LogicalRelImplementor.java:935)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.executeFragment(ExecutionServiceImpl.java:882)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.lambda$submitFragment$10(ExecutionServiceImpl.java:950)
at
java.base/java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1072)
at
java.base/java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:478)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionContext.lambda$execute$0(ExecutionContext.java:332)
... 4 more
Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 78:
No applicable constructor/method found for actual parameters "java.lang.String,
java.lang.String, java.lang.String, long"; candidates are: "public
java.lang.String
org.apache.calcite.runtime.SqlFunctions$RegexFunction.regexpReplace(java.lang.String,
java.lang.String, java.lang.String)", "public java.lang.String
org.apache.calcite.runtime.SqlFunctions$RegexFunction.regexpReplace(java.lang.String,
java.lang.String, java.lang.String, int, int)", "public java.lang.String
org.apache.calcite.runtime.SqlFunctions$RegexFunction.regexpReplace(java.lang.String,
java.lang.String, java.lang.String, int, int, java.lang.String)", "public
java.lang.String
org.apache.calcite.runtime.SqlFunctions$RegexFunction.regexpReplace(java.lang.String,
java.lang.String, java.lang.String, int)"
at
org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13228)
at
org.codehaus.janino.UnitCompiler.findMostSpecificIInvocable(UnitCompiler.java:9794)
at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9654)
at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9570)
at org.codehaus.janino.UnitCompiler.getType2(UnitCompiler.java:7663)
at org.codehaus.janino.UnitCompiler.access$16200(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$25.visitMethodInvocation(UnitCompiler.java:6923)
at
org.codehaus.janino.UnitCompiler$25.visitMethodInvocation(UnitCompiler.java:6909)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:5470)
at org.codehaus.janino.UnitCompiler.getType(UnitCompiler.java:6909)
at
org.codehaus.janino.UnitCompiler.findMostSpecificIInvocable(UnitCompiler.java:9769)
at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9654)
at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9570)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:5322)
at org.codehaus.janino.UnitCompiler.access$9300(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$16.visitMethodInvocation(UnitCompiler.java:4824)
at
org.codehaus.janino.UnitCompiler$16.visitMethodInvocation(UnitCompiler.java:4800)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:5470)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:4800)
at
org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:5945)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:4177)
at org.codehaus.janino.UnitCompiler.access$6100(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$13.visitMethodInvocation(UnitCompiler.java:4151)
at
org.codehaus.janino.UnitCompiler$13.visitMethodInvocation(UnitCompiler.java:4126)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:5470)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:4126)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2572)
at org.codehaus.janino.UnitCompiler.access$1800(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$6.visitExpressionStatement(UnitCompiler.java:1584)
at
org.codehaus.janino.UnitCompiler$6.visitExpressionStatement(UnitCompiler.java:1579)
at org.codehaus.janino.Java$ExpressionStatement.accept(Java.java:3209)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1579)
at
org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1665)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1650)
at org.codehaus.janino.UnitCompiler.access$1700(UnitCompiler.java:240)
at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1583)
at org.codehaus.janino.UnitCompiler$6.visitBlock(UnitCompiler.java:1579)
at org.codehaus.janino.Java$Block.accept(Java.java:3115)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1579)
at org.codehaus.janino.UnitCompiler.access$4000(UnitCompiler.java:240)
at org.codehaus.janino.UnitCompiler$8.compile(UnitCompiler.java:3004)
at
org.codehaus.janino.UnitCompiler.compileTryCatch(UnitCompiler.java:3302)
at
org.codehaus.janino.UnitCompiler.compileTryCatchFinally(UnitCompiler.java:3197)
at
org.codehaus.janino.UnitCompiler.compileTryCatchFinallyWithResources(UnitCompiler.java:3025)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2998)
at org.codehaus.janino.UnitCompiler.access$2300(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$6.visitTryStatement(UnitCompiler.java:1589)
at
org.codehaus.janino.UnitCompiler$6.visitTryStatement(UnitCompiler.java:1579)
at org.codehaus.janino.Java$TryStatement.accept(Java.java:3577)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:1579)
at
org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:1665)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:3713)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:3378)
at
org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:1451)
at
org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:1424)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:833)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:446)
at org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$3.visitPackageMemberClassDeclaration(UnitCompiler.java:426)
at
org.codehaus.janino.UnitCompiler$3.visitPackageMemberClassDeclaration(UnitCompiler.java:422)
at
org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1688)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:422)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:396)
at org.codehaus.janino.UnitCompiler.access$000(UnitCompiler.java:240)
at
org.codehaus.janino.UnitCompiler$2.visitCompilationUnit(UnitCompiler.java:367)
at
org.codehaus.janino.UnitCompiler$2.visitCompilationUnit(UnitCompiler.java:365)
at org.codehaus.janino.Java$CompilationUnit.accept(Java.java:371)
at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:365)
at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:273)
at
org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:303)
at
org.codehaus.janino.ClassBodyEvaluator.cook2(ClassBodyEvaluator.java:297)
at
org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:273)
at
org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:267)
at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:52)
at
org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:413)
at
org.apache.ignite.internal.sql.engine.util.Commons.compile(Commons.java:367)
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
