What are you trying to achieve?
It seems you are trying to add an integer to a string column numerically.
Can you actually cast the name column to integers?
--Andries
> On Dec 15, 2016, at 10:05 AM, Sanjiv Kumar wrote:
>
> Hello
> I am using drill 1.9 version in embedded mode and in Wind
Hello
I am using drill 1.9 version in embedded mode and in Window 10.
My question is when i am adding two integer column, its working fine.
e.g:- select P.`costprice` + P.`initialprice` from
testplugin.dbo.testtable P;
NOTE:- both columns costprice and initialprice are integer.
B