Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-1447

remove late-project/basic-project and supply the functionality with the database.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 3.0.0
    • Component/s: None
    • Labels:
      None
    • Template:
    • Story Points:
      3
    • Sprint:
      PuppetDB 2015-05-06, PuppetDB 2015-05-20

      Description

      Currently when we query facts there is an implicit selection of the "type" column. We do this because on the database side we coalesce three columns of fact_values into a single string column "value". This creates issues with group-by queries like this:

      /v4/facts -d 'query=["extract",[["function","count"],"value"], ["=", "name","operatingsystem"], ["group_by", "value"]]
      

      since the selected fields must appear in the grouping. We should return a single column that includes both type and value information.

      A good test case for this is a count of fact values like operating system

      One way to do this would be to overload the existing value_json column with type information, and return that single column for all value queries (maybe even rename it.)

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            wyatt Wyatt Alt
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support