Jira (PDB-5103) To_string function adds trailing spaces

[Andrei Filipovici (Jira)]

Andrei Filipovici created an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces Issue Type: Task Assignee: Unassigned Created: 2021/04/09 9:35 AM Labels: query-engine-improvements Priority: Normal Reporter: Andrei Filipovici When printing the month from a timestamp field using the to_string function, multiple spaces are added to the response. This happens for multiple format options, not just month. Example: For this query ["extract" [["function" "to_string" "producer_timestamp" "month"]]] the result is: "to_string": "april " Add Comment

This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)

[Andrei Filipovici (Jira)]

Andrei Filipovici updated an issue

PuppetDB / PDB-5103

To_string function adds trailing spaces

Change By: Andrei Filipovici

When printing the month from a timestamp field using the to_string function, multiple spaces are added to the response. This happens for multiple format options, not just month. Example: For this query ["extract" [["function" "to_string" "producer_timestamp" "month"]]] the result is:  "to_string": "april    "

There is a disable unit test with this particular issue. It has to be enabled once this is fixed.

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces

Change By: Andrei Filipovici Issue Type: Task Bug

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces

Change By: Andrei Filipovici Team: Ghost

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces Change By: Andrei Filipovici

When printing the month from a timestamp field using the to_string function, multiple spaces are added to the response. This happens for multiple format options, not just month. Example: For this query ["extract" [["function" "to_string" "producer_timestamp" "month"]]] the result is:  "to_string": "april    "

There is a disable disabled unit test with this particular issue ticket id . It has to be enabled once this is fixed.

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces Change By: Andrei Filipovici

When printing the month from a timestamp field using the to_string function, multiple spaces are added to the response. This happens for multiple format options, not just month. Example: For this query ["extract" [["function" "to_string" "producer_timestamp" "month"]]] the result is:  "to_string": "april    "

* There is a disabled unit test with this ticket id. It has to be enabled once this is fixed. *

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces

Change By: Bogdan Irimie Story Points: 2

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces

Change By: Bogdan Irimie Sprint: ghost-30.06.2021

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici assigned an issue to Andrei Filipovici

PuppetDB / PDB-5103 To_string function adds trailing spaces

Change By: Andrei Filipovici Assignee: Andrei Filipovici

Add Comment

[Andrei Filipovici (Jira)]

Andrei Filipovici commented on PDB-5103

Re: To_string function adds trailing spaces There is no problem because this is how PostgreSQL renders the response with the month formatting mask. The result is blank-padded to 9 chars. More info about the formatting mask can be found here: https://www.postgresql.org/docs/11/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE

Add Comment

[Rob Browning (Jira)]

Rob Browning updated an issue

PuppetDB / PDB-5103

To_string function adds trailing spaces

Change By: Rob Browning Fix Version/s: PDB 6.18.0 Fix Version/s: PDB 7.5.0

Add Comment

[Austin Blatt (Jira)]

Austin Blatt updated an issue

PuppetDB / PDB-5103 To_string function adds trailing spaces

Change By: Austin Blatt Release Notes: Not Needed

Add Comment