Concatenation of character literasl fails.org.apache.calcite.sql2rel.ReflectiveConvertletTable$1.convertCall

Dremio server 14.0.0-202103011714040666-9a0c2e10
Deremio JDBC driver 14.0.0-202103011714040666-9a0c2e10

select rnum, ‘๛’ || c1 from cert.tlth where rnum = 47

PLAN ERROR: while converting ‘๛’ || tlth.c1

SQL Query select rnum, ‘๛’ || c1 from cert.tlth where rnum = 47

[Error Id: 1a3c097c-0da2-4f10-b440-76c87a8f0888 on 172.31.61.147:31010]

(java.lang.RuntimeException) while converting ‘๛’ || tlth.c1
org.apache.calcite.sql2rel.ReflectiveConvertletTable$1.convertCall():90
org.apache.calcite.sql2rel.SqlNodeToRexConverterImpl.convertCall():63
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit():4667
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit():4005
org.apache.calcite.sql.SqlCall.accept():138
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.convertExpression():4569
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList():3848
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl():663
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect():620
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive():3073
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery():556
com.dremio.exec.planner.sql.SqlConverter.toConvertibleRelRoot():325
com.dremio.exec.planner.sql.SqlConverter.toConvertibleRelRoot():308
com.dremio.exec.planner.sql.handlers.PrelTransformer.toConvertibleRelRoot():921
com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRelRoot():1006
com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRel():1035
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():186
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():176
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():47
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():59
com.dremio.exec.work.foreman.AttemptManager.plan():457
com.dremio.exec.work.foreman.AttemptManager.lambda$run$1():361
com.dremio.service.commandpool.CommandWrapper.run():62
com.dremio.context.RequestContext.run():95
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():180
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (java.lang.reflect.InvocationTargetException) null
sun.reflect.GeneratedMethodAccessor315.invoke():-1

Caused By (org.apache.calcite.runtime.CalciteException) Failed to encode ‘๛’ in character set ‘ISO-8859-1’
sun.reflect.GeneratedConstructorAccessor292.newInstance():-1
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45

@dqmdev

We are targeting a fix for this later this month

This only fixes the case that we have utf8 or utf16 encoded strings as literals in the SQL statement. As for the actual data, Dremio only supports utf8 encoded varchar columns. Anything other than utf-8 is not supported