regression: CSV Export: pgAdmin4 starts quoting bigint column after some lines (RM #7272)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7272
Originally created by Frank Limpert at 2022-03-27 19:41:03 UTC.

Version: pgAdmin4 6.7 Desktop from https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal
Version: pgAdmin4 6.7 - docker image

Settings:
CSV field separator ;
CSV quote character "
CSV quoting Strings
Replace null values with nothing

Bug: An bigint column is quoted starting with line number 2002. Header line is line number 1. (i.e. record number 2001)

Expected behavior: Using the settings from above, data in numeric columns should never be quoted.

To reproduce: I've got the following types as output of my query:

smallint, smallint, bigint, character varying(32), character varying(40), date, date, smallint, integer, date, date
                    ^ this is the column showing that weird behavior

The column in question contains rather small values between 1 and 30.

[dpage]

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6695
Originally created by Nikhil Mohite at 2022-03-28 06:38:01 UTC.

Filename: Screenshot_2022-03-28_at_12.07.16_PM.png

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7272#note-2
Originally created by Nikhil Mohite at 2022-03-28 06:59:57 UTC.

Hi Frank,

I am unable to reproduce the issue.
Tried scenario:

Created Table with the following SQL

CREATE TABLE IF NOT EXISTS public.test_csv
(
    id integer NOT NULL DEFAULT nextval('test_csv_id_seq'::regclass),
    num1 smallint,
    num2 smallint,
    num3 bigint,
    name character varying(32) COLLATE pg_catalog."default",
    last_name character varying(40) COLLATE pg_catalog."default",
    "DOB" date,
    "DOJ" date,
    num4 smallint,
    int_num integer,
    "DOP" date,
    "DOS" date,
    CONSTRAINT test_csv_pkey PRIMARY KEY (id)
)

# Inserted 100000 records. (Also tried with small set of recods 5000)

# Updated the preferences settings as mentioned in the issue.

!Screenshot%202022-03-28%20at%2012.07.16%20PM.png!

4. Executed the following query and downloaded the CSV from Query Tool

SELECT * FROM public.test_csv
ORDER BY id ASC

Now checked the downloaded CSV not found any record in bigint columns in string quotes. (Also tried with few rows as empty in bigint column but got the same result.)

Regards,
Nikhil Mohite.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed		Frank Limpert
Attachment added		Screenshot 2022-03-28 at 12.07.16 PM.png

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7272#note-3
Originally created by Frank Limpert at 2022-03-29 17:46:45 UTC.

I assume, you tested with a fresh installation. I'm using both installations mentioned at the start for years already and updated them with every release. Maybe, there is something leftover in my settings disturbing current code. Can you please tell me, which settings (in sqlite) I should look for, so that I can post them here?

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7272#note-4
Originally created by Yogesh Mahajan at 2022-04-01 11:07:07 UTC.

Hi,

1.Is this issue observed in 6.7 version only?
2.Does the query result set show same output?(quotes biting values).

Thanks

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7272#note-5
Originally created by Frank Limpert at 2022-04-02 18:11:16 UTC.

1.) I've seen this behavior in 6.7 for the first time. I often execute the same query on different databases (over time) and compare the downloaded files. That's why I find the added quotes annoying. They have not been there in the previous releases.

2.) The result of the query is correct. There is no data corruption. The bug only makes it hard to compare different downloaded results over time using simple tools like diff.

Personal notice: It makes me always really nervous seeing such a kind of bug in one of my own programs, since it reeks of a fundamental misunderstanding between me and my computer ;-)

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7272#note-6
Originally created by Khushboo Vashi at 2022-04-08 11:33:36 UTC.

Hi,

Can you please provide the sample dump to reproduce this issue?

Thanks,
Khushboo

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7272#note-7
Originally created by Akshay Joshi at 2022-04-22 11:59:31 UTC.

No response from the author, hence rejecting it.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	New	Rejected

[dpage]

Issue closed on Redmine.