Distinct predicate using a row constructor

1

It appears that the parser will accept a distinct predicate. However, if a scenario uses a row constructor, it fails as shown. Presumably, row constructors are not supported, but unclear due to docs being limited.

select rnum, c1, c2, c3, c4 from cert.tolap where (c1, c3) is distinct from ( c2, c4 )

SYSTEM ERROR: AssertionError: todo: implement syntax SPECIAL(ROW($1, $3))

[Error Id: 849027e3-b979-4a82-80b4-d6efca158779 on 172.31.61.147:31010]

(com.dremio.exec.work.foreman.ForemanException) Unexpected exception during fragment initialization: java.lang.AssertionError: todo: implement syntax SPECIAL(ROW($1, $3))
com.dremio.exec.work.foreman.AttemptManager.run():407
com.dremio.context.RequestContext.run():95
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (java.util.concurrent.ExecutionException) java.lang.AssertionError: todo: implement syntax SPECIAL(ROW($1, $3))
java.util.concurrent.CompletableFuture.reportGet():357
java.util.concurrent.CompletableFuture.get():1908
com.dremio.exec.work.foreman.AttemptManager.run():366
com.dremio.context.RequestContext.run():95
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (java.lang.AssertionError) todo: implement syntax SPECIAL(ROW($1, $3))

2

@dqmdev

Thanks for the feedback, have created an internal ticket to either give a better message if not supported or fix the issue if it is reported