Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-7687

Using camel-case aliases in queries with PosgreSQL

XMLWordPrintable

      There are some places in the frontend where we use camelCase aliases for columns in an SQL query, but PostgreSQL always returns results with lower-case keys. One of the problems it causes is that a template.get request in 2.2 returns unnecessary data:

      {
      "output": "refer",
      "parentTemplateids": 10050,
      "limit": 1
      }
      
      {
          "jsonrpc": "2.0",
          "result": [
              {
                  "parenttemplateid": "10050",
                  "templateid": "10001"
              }
          ],
          "id": 1
      }
      

      It may cause other problems too. We'll need to check all usages of aliases in the frontend and convert them to lower case. As far as I understood, the C side uses only lower-case aliases, so it shouldn't have any problems.

            Unassigned Unassigned
            jelisejev Pavels Jelisejevs (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: