Bug 150738

Summary:	editing: when i select an id from a dropdown list null is populated if the same selection was made for the preceding row,
Product:	LibreOffice	Reporter:	graham jones <grahamleonardjones>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	normal	CC:	robert
Priority:	medium
Version:	7.3.4.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	entered G to select the id for G form dropdown list - next uom_name displayed force entry of 'G' from dropdown tab to header_id column - uom_id entry disapears enter an ingredient create new row and get error message sql definition for tablke components in source postgresql db table definition for uom in source postgresql database

Description graham jones 2022-09-01 09:05:26 UTC

Description:
when adding rows to my table components in a simple form; on columns that have a sql list dropdown defined such that i can select by uom_name and uom_id is returned then NULL is returned iof the same selection was made for this column on the previous row ( see error-base_bug_search_anomaly_06.png)

Steps to Reproduce:
1.create new row in table components
 a. table_components_base_structure.png
 b. table_components_postgres.sql.png
2. component_id auto populates
3.enter a number for units
4.select the same uom_name from the dropdown list 
 a. definition- base_bug_uom_id_control properties.png
 b. sql list- base_bug_uom_id_list contents.png
 c. base_bug_search_anomaly_03.png
5. tab to header_id and enter a header_id
 a. base_bug_search_anomaly_04.png
6. tab to ingredient_id and select and ingredient from the dropdown list
 a. base_bug_search_anomaly_05.png
7. create new row 
8. get error message
 a. base_bug_search_anomaly_06.png

Actual Results:
null is returned to the uom_id column

Expected Results:
the uom_id that matches the selected uom_name should be returned


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 8; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: en-NZ (en_NZ.UTF-8); UI: en-US
Calc: threaded

Comment 1 graham jones 2022-09-01 09:07:27 UTC

Created attachment 182141 [details]
entered G to select the id for G form dropdown list - next uom_name displayed

Comment 2 graham jones 2022-09-01 09:08:24 UTC

Created attachment 182142 [details]
force entry of 'G' from dropdown

Comment 3 graham jones 2022-09-01 09:09:31 UTC

Created attachment 182143 [details]
tab to header_id column - uom_id entry disapears

Comment 4 graham jones 2022-09-01 09:10:17 UTC

Created attachment 182144 [details]
enter an ingredient

Comment 5 graham jones 2022-09-01 09:11:06 UTC

Created attachment 182145 [details]
create new row and get error message

Comment 6 graham jones 2022-09-01 09:12:26 UTC

Created attachment 182146 [details]
sql definition for tablke components in source postgresql db

Comment 7 graham jones 2022-09-01 09:13:15 UTC

Created attachment 182147 [details]
table definition for uom in source postgresql database

Comment 8 graham jones 2022-09-01 09:15:16 UTC

context - base is acting a client db of the postgresql source database

Comment 9 Robert Großkopf 2023-03-16 14:29:30 UTC

Have tried this:
PostgreSQL with direct connection, 2 tables. Primary key from table2 is foreign key from table1.
Created some content in table2 for getting content for a listbox.
Created a form with table1 and a listbox, content from table 2.
Created it as tablecontrol, as I could see in the screenshots.

When adding new data in the form I could choose every value of the listbox. I could choose the same value as it is choosen the row before. There won't be added NULL instead of this value.

Might be it is a special bug together with gtk3…

System here:
Version: 7.4.6.2 / LibreOffice Community
Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded