What's turning star rating into a string?⭐

[Fred_K]

Our MySQL database has a stars column with type int(1). (for users giving 1 to 5 stars)
I query my DB with this selected column in my builder:

Dev tool gives me this:

Is AVG calculation or avgRating alias naming turning my int(1) into a string? How to remedy that so i can use ceil() and round()?

[Teodor]

You seem to be trying to apply formatters expecting a number to a string value.
Apply the toNumber formatter to the value first and then to the ceil/round.

[Fred_K]

Thanks! So I take it that the AVG calculator (in aggregate) in the query builder turns my int(1) into a string, which is surprising.

[Teodor]

Please check my reply here:

AC Formatter reading numbers as text (therefore formatting options do not appear or fail)

Yes it is the expected behavior. The decimal values do not fit the JavaScript number type so it becomes a string. You need to convert them to number if you want to apply numeric formatters to them or do any calculations.