[DRILL-366] Casting to BigInt from Varchar produces wrong results

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: Mehant Baid
• Reporter: Mehant Baid
• Created: 12/Feb/14 00:18
• Updated: 29/Apr/15 21:37
• Resolved: 04/Mar/14 16:47

Description

Can be reproduced using the following plan:

{
head:{
type:"APACHE_DRILL_PHYSICAL",
version:"1",
generator:

{ type:"manual" }

},
graph:[
{
@id:1,
pop:"json-scan",
entries: [

{ path : "/tmp/scan4.json" }

],
storageengine:

{ "type": "json", "dfsName": "file:///" }

},
{
pop:"project",
@id:2,
child: 1,
exprs: [

{ ref: "int", expr: "cast(integer as bigint)" }

]
},

{ @id: 3, child: 2, pop: "screen" }

]
}

Input file, "/tmp/scan4.json":
{
"integer" : "2008"
}
{
"integer" : "2007"
}
{
"integer" : "2006"
}

Output:
2008
2008
2008

From the above output we notice that it always generates values corresponding to the first row. Looks like the buffer is not getting reset to the next row.