Hmm, I don't have experience using MySQL tables for aliases. For Berkeley DB hashes, having multiple addresses separated by commas works fine. The
documentation indicates that this is the appropriate format no matter how the table is stored.
It could be that your address syntax is incorrect.
Another possibility is that MySQL tables operate differently. I notice that the MySQL query is capable of returning multiple results. You could try putting an extra entry into the table with the same alias but a different destination. If you were starting from scratch, something like this:
Code:
INSERT INTO `mailserver`.`virtual_aliases`
(`id`, `domain_id`, `source`, `destination`)
VALUES
('1', '1', 'alias@example.com', 'email1@example.com'),
('2', '1', 'alias@example.com', 'email2@example.com');
This way, the query for
'alias@example.com' would return two results. But this is pure speculation.