Bug: sql: concat instead of arithmatic operation | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Bug: sql: concat instead of arithmatic operation

Under sql > filtering > custom columns both 2/3 and 3/3 are on concatination. 3/3 should on arithmatic operations

26th May 2018, 4:00 AM
Manohar Reddy Poreddy
2 Answers
+ 1
if you have numbers stored as a string and you attempt mathematical operations, these are overloaded operator for concatenation on purpose. The strings probably need CAST to make them numbers in addition to the mathematical equation
29th May 2018, 8:04 AM
SQrL
SQrL - avatar
0
do you mean you agree, if so how to let author know to fix it?
29th May 2018, 1:42 PM
Manohar Reddy Poreddy