#1766 mod_storage_Archive summary API does not work with Postgres
Reporter
Zash
Owner
Zash
Created
Updated
Stars
★ (1)
Tags
Status-Fixed
Priority-Medium
Type-Defect
Milestone-0.12
Zash
on
What steps will reproduce the problem?
0. Configure Prosody to use Postgres for storage
1. Use the archive:summary() (e.g. via the community mod_map)
What is the expected output?
The API returns a table with summary data
What do you see instead?
Error preparing statement handle: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 5: ORDER BY "sort_id" ASC;
^
What version of the product are you using? On what operating system?
Prosody 0.12.1, also reproduced on trunk 494577d883ff
Debian testing (for LuaDBI compatible with Lua 5.4)
Postgres from the Docker image postgres:14-alpine
Please provide any additional information below.
Reported by Jack in the chat
What steps will reproduce the problem? 0. Configure Prosody to use Postgres for storage 1. Use the archive:summary() (e.g. via the community mod_map) What is the expected output? The API returns a table with summary data What do you see instead? Error preparing statement handle: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 5: ORDER BY "sort_id" ASC; ^ What version of the product are you using? On what operating system? Prosody 0.12.1, also reproduced on trunk 494577d883ff Debian testing (for LuaDBI compatible with Lua 5.4) Postgres from the Docker image postgres:14-alpine Please provide any additional information below. Reported by Jack in the chat
Fixed in https://hg.prosody.im/trunk/rev/5aafcf6a0730
Changes