mirror of
https://github.com/MariaDB/server.git
synced 2025-07-05 19:08:12 +02:00
eaba4975c9
The GIS function st_collect can now be used with GROUP BY. Previously, such queries resulted in a crash because Item_func_stcollect did not specify quick_group = false and did not implement reset_field, update_field methods. With quick_group as false, an implementation of Item_sum tells the SQL layer that the aggregate can be computed with the TemporaryTableWithPartialSums algorithm. That is the case for st_collect. This is convenient because the SQL layer will rely on the Item_sum to produce the correct, updated aggregate value for a given result field. Otherwise, using reset_field and update_field implementations gives greater flexibility when computing the aggregate but requires more complexity.
9 lines
122 B
Text
9 lines
122 B
Text
[myisam]
|
|
default-storage-engine=myisam
|
|
|
|
[innodb]
|
|
innodb
|
|
default-storage-engine=innodb
|
|
|
|
[aria]
|
|
default-storage-engine=aria
|