URGENT! Zoho Report cuts a digit from a number
I'm repeating the problem here, sorry.
=====================
Dear Zoho Reports Team,
We've just found a big problem:
1. We have a query which is created as SELECTs from many other queries and tables.
2. It has the first column 'code' which has Positive number format
There are, for example, two codes:
1242357
1242359
3. I have another query over this query, where i do:
SELECT concat('810',code) as "code"
where 'code' is the column 'code' from the first query.
4. In the second query i get CUT version of the code. I've just got:
810124235
810124235
while they must be
8101242357
8101242359
What's going on? That breaks everything and i can't find any reason Zoho does that.
Column 'code' in the second query has Plain text format.
Thank you.