[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||2478 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431
--- Comment #19 from Robert Großkopf ---
Another hint: Seems to be a problem with more than on the field type "text".
'0' appears also in field type array if table has been created new.
Created a array in this way through Tools → SQL
CREATE TABLE "public"."Table_Ar" ("ID" int4 NOT NULL,"Surname"
varchar(100),"Forename" varchar(200)[], PRIMARY KEY ("ID"));
I'm not able to enter data in the array in the fresh table. It will produce '0'
and this won't be accepted by an array, because it needs {…}.
When inserting through Tools → SQL
INSERT INTO "public"."Table_Ar" ("ID", "Surname", "Forename") VALUES (1,
'Müller', '{Liese, Gerd}');
The row will be inserted and the next row could be created in GUI without any
problem.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 --- Comment #18 from Robert Großkopf --- 1. Table has to be created with 2 fields, "ID" INTEGER[int 4] "Memotext" MEMO[Text] "ID" should be primary key 2. Try to input in GUI: "ID" → 1, "MemoText" → 'New Text' 3. Go to next row. 'New Text' will be set as '0'. All this only happens after creating a new table here. Doesn't happen after closing the connection and reopening the connection. All this happens only if there are other tables in schema "public". If there is no table in schema "public" the first table won't show this bug here. Tested with PostgreSQL 14.7 on OpenSUSE 15.4 64bit rpm Linux. Bug appears in LO 7.0.5.2, also in LO 7.5.1.2 and all other versions installed here. Think this isn't a regression, has never worked and was never detected … -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Stéphane Guillou (stragu) changed: What|Removed |Added Keywords|bibisectRequest, regression | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 --- Comment #17 from Stéphane Guillou (stragu) --- tried to bibisect but couldn't reproduce in the bibisect repo, then tried again to reproduce in 7.3.7.2 where I reproduced before, and couldn't reproduce either. I used a new table every time, and made sure a primary int4 ID was before the memo[text]var, no luck. I think I need more precise steps... -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Stéphane Guillou (stragu) changed: What|Removed |Added Version|7.5.0.3 release |7.3.7.2 release Blocks||104790 --- Comment #16 from Stéphane Guillou (stragu) --- I get "permission denied" errors when creating the table in LO 6.0 or 6.4. Making sure the primary key was Integer[int4] before the Memo[text] var, I could reproduce with PG13.10 and: Version: 7.3.7.2 / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded For people not reproducing with PG10, maybe double-check that you had it setup as Robert described in Comment 13. Works as expected in: Version: 7.2.7.2 / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded So regression. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=104790 [Bug 104790] [META] Database connectivity interfaces (ODBC, JDBC..) and external databases -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 --- Comment #15 from Alex Thurgood --- @Stephane - probably because I couldn't reproduce the buggy behaviour against a pg10 instance, cf. comment 5. It was only when I tried against a pg13 instance and later that I saw the problem. I thought that it might possibly be down to a change introduced in the TEXT datatype in pg13, but couldn't see anything in the release notes that might be indicative of such a change. I can't test any 6.x on macOS Arm, they refuse to run. Ideally, someone should test with a 6.x against at least a pg13 instance on Linux. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org --- Comment #14 from Stéphane Guillou (stragu) --- Alex, you marked as a regression, but Michael in Comment 1 reproduced in 7.3. Any evidence that this is actually a regression? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 QA Administrators changed: What|Removed |Added Keywords||bibisectRequest -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 --- Comment #13 from Robert Großkopf --- Have tested this a little bit more. Bug will only appear if primary key is a numeric field (int 4). If primary key is varchar(100) text content is saved in field for Meme[text] as text. Bug will only appear directly after creating the table. If you close the database file, close and reopen LO and connect again to PostgreSQL with direct connection text content will be saved. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 --- Comment #12 from Julien Nabet --- (In reply to Alex Thurgood from comment #9) > > Could this be a difference between PG10 and PG13 ? > ... > @lionel, @julien : would you happen to know which version of postgres our > SDBC driver is built against ? taking a look at download.lst, I see: 464 POSTGRESQL_TARBALL := postgresql-13.8.tar.bz2 (see https://opengrok.libreoffice.org/xref/core/download.lst?r=3c988ef4#464) so I'd say Postgresql 13.8 It migrated from 9.2 to 13.1 with 234833f7823a1424b62c93e145f0cfe2c6b6efd5 (see https://cgit.freedesktop.org/libreoffice/core/commit/?id=234833f7823a1424b62c93e145f0cfe2c6b6efd5) you can see the migrations to 13.5 and 13.8 with https://cgit.freedesktop.org/libreoffice/core/log/?qt=grep=postgresql -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 --- Comment #11 from Alex Thurgood --- It turns out that postgres 10 was EOL in November 2022: https://endoflife.date/postgresql if we haven't done so, I guess the driver should be updated to something current and not nearing EOL, as even v11 is EOL in 8 months time. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Alex Thurgood changed: What|Removed |Added Priority|medium |high Severity|normal |major -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Alex Thurgood changed: What|Removed |Added Keywords||dataLoss -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Alex Thurgood changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153431] PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13
https://bugs.documentfoundation.org/show_bug.cgi?id=153431 Alex Thurgood changed: What|Removed |Added Summary|PostgreSQL native |PostgreSQL native |connector: Field Memo |connector: Field Memo |[Text] is filled with 0 |[Text] is filled with 0 |instead of character|instead of character |content where postgres |content where postgres |server version is greater |server version is greater |than 13 |than or equal to 13 -- You are receiving this mail because: You are the assignee for the bug.
