- 
    Problem report 
- 
    Resolution: Fixed
- 
    Trivial 
- 
    6.2.6
- 
    None
- 
    Zabbix with ORACLE DB
- 
        Sprint 95 (Dec 2022)
- 
        0.125
Steps to reproduce:
Open host prototype on some template with existing host group prototypes.
There should be listed some host group prototypes which was added earlier. 
Query
SELECT gp.hostid,gp.name FROM group_prototype gp WHERE gp.hostid=82764 AND gp.name!='';
is not fetch result. i.e. current host group prototypes.
 
If you use this query it works for Oracle. 
SELECT gp.hostid,gp.name FROM ZABBIX.group_prototype gp WHERE gp.hostid=82764 AND gp.name IS NOT NULL
MySQL and PostgreSQL works fine with original query.
Expected:
So host group prototypes should be loaded. properly
- caused by
- 
                    ZBXNEXT-6959 Implement audit for frontend (Host prototypes) -         
- Closed
 
-         
