Raymond Wong created DRILL-6395: ----------------------------------- Summary: Value Window Function - LEAD and LAG on VarChar result in "No applicable constructor/method found" error Key: DRILL-6395 URL: https://issues.apache.org/jira/browse/DRILL-6395 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Affects Versions: 1.13.0 Environment: windows 10, apacheĀ drill 1.13.0, 32GB Ram Reporter: Raymond Wong
{code:java} SELECT col2, LEAD(col1, 1) OVER (ORDER BY col2) AS nxtCol1 FROM ( SELECT 'A' AS col1, 1 AS col2 UNION SELECT 'B' AS col1, 2 AS col2 UNION SELECT 'C' AS col1, 3 AS col2 ) AS A; {code} Causes errorĀ {code:java} SQL Error: SYSTEM ERROR: CompileException: Line 37, Column 40: No applicable constructor/method found for actual parameters "int, int, int, io.netty.buffer.DrillBuf"; candidates are: "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, org.apache.drill.exec.expr.holders.VarCharHolder)", "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, org.apache.drill.exec.expr.holders.NullableVarCharHolder)", "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, byte[], int, int)", "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, java.nio.ByteBuffer, int, int)", "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, int, int, int, io.netty.buffer.DrillBuf)" {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)