Why is the QUERY partially executed?

Question

Google Sheets

The grouping of text through the query function is incorrect .
There is a source table with data

spoiler

Through the query, I group and sum the values

=query('Daily(cop)'!H:N;"Select N,I,J,K, sum(L) group by N,I,J,K LABEL sum(L) 'Σh'")

But at the same time, as a result of grouping, Text elements are not displayed, i.e. components are lost 10040-MIX 10040-BM-MEP, etc.

spoiler

Moreover, if they are replaced only by numbers, everything happens correctly, why is the text component not displayed?

Answer 1

there is such a bug in google but you can win through filter

Answer 2

I don't think there is any optimal algorithm for determining the type of values ​​in a range. Therefore, you must take care of it yourself.
An example of implicit type casting to a string ""&C5:C12

This is not a bug at all. These are the requirements of the SQL query language and its derivatives. All data must be converted to the desired type, fantasy is unnecessary.
Table Example