SQL mixed datatypes when using GROUP BY and ORDER BY

Question

question

Przemyslaw Pasich asked May 21, '24 Jeanette F answered May 24, '24

SQL mixed datatypes when using GROUP BY and ORDER BY

When running a SQL query that aggregates over a field using GROUP BY and that field features a mix of datatypes (string and numerical), the results of the query are unexpected:

On the right there is only one datatype (string) in 'type' column and the query results are fine; however, on the left where there is a mix (string + num), the resulting query overwrites the value 'a' with a 0.

Is this a bug or am I misunderstanding how SQL works?

The model that recreates this behavior is attached:

SQL_mixed_datatypes_with_GROUPBY.fsm

Software Version:

FlexSim 24.1.0

sql calculated table flexql

sql-mixed-datatypes-with-groupby.png (134.2 KiB)

sql-mixed-datatypes-with-groupby.fsm (32.7 KiB)

Answer 1 · 2024-05-24T22:45:37Z

Jeanette F answered May 24, '24

Hello @Przemyslaw Pasich,

The columns need to be the same data type. If the column is all strings then the query works as expected.

question