#627 Quicksort does not calc correct the calculated fields (SQLite)

[MmVisual]

"FieldName1" and "FieldName2" are calculated fields.

Example:
TZQuery.SortedFields := 'FieldName1;FieldName2';
TZQuery.SortType := stAscending;

All rows from "FieldName1" are NULL and declared als Float field.
All rows from "FieldName2" are NULL and declared als Float field, but only one column has the value 20.0.
The sorting from "FieldName2" is wrong.

If the query has only one field:
TZQuery.SortedFields := 'FieldName2';
Then it works.

Used database: SQLite

[MmVisual]

Addition information:
This calculated field is type String. The String filled in the field. But Zeos cannot read it.

[MmVisual]

Additional information:
ColumnIndex: 5
FColumnTypes[5]: stString

[MmVisual]

Additional information:
The calculated field use Zeos as "stAsciiStream" and not with the configurated type (String or Double). Reading from this field as stAsciiStream fails.

I'm sorry, I have no idea where I can make the change to fix this bug.

[marsupilami79]

This might be related: https://zeoslib.sourceforge.io/viewtopic.php?p=317554#p317554