Comment 14 for bug 1546396

This due to we use regex filter for name: https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L2286

We should convert the '|' to '\\|', then the sql like this 'select * from instances where instances.display_name REGEXP "\\|"' will works