KB214155: In MicroStrategy 9.x and 10.x, “0” is added to column alias in the report SQL

In the SQL, a “0” is added to the 30 characters long column name to be the column alias; which makes it different from what is defined.

select a11.id_a  aa,
a11.id_b  bb,
a13.id_a  aa0,
a13.id_b  bb0,
a13.123456789012345678901234567890  1234567890123456789012345678900
from table1 a11
cross join table2 a13

 
CAUSE
This is working as designed. Strategy SQL engine adds the suffix ‘0’ to the column alias to distinguish multiple columns with the same column alias.
In the above example, there are two attribute forms with same column alias (a11.id_a, a13.id_a with column alias aa AND a11.id_b, a13.id_b with column alias bb). Therefore, the "0" gets added to distinguish the seconds instance. According to current logic, suffix ‘0’ will be added to ALL the forms of that attribute - therefore "0" is added to the column alias for the column "a13.123456789012345678901234567890" also. 
ACTION
There is no action needed as it is working as designed. Shorten the column alias if there is column name length restriction for specific database platforms.