https://bugs.documentfoundation.org/show_bug.cgi?id=153431
--- Comment #22 from Terrence Enger <[email protected]> --- Created attachment 200307 --> https://bugs.documentfoundation.org/attachment.cgi?id=200307&action=edit SQL script to delete and initialize the database Attached file dbdump is sql script to delete and initialize the database. STR, short version - Create database. - Create .odb file. - Enter a row in existing table. The memo is saved as entered. - Create a table. - Enter a row in new table. The memo is zeroed. STR, longer version. Note that for ease of reading, I am introducing whitespace in strings to be typed; where a space is required, I say "<space>". ( 1) Create a database and schema as per attached sql script dbdump. ( 2) Create and open a .odb connecting to that database. ( 3) At database window, type "<alt>+A" to display list of tables. Lower right pane shows schemas bug_153431, information_schema, and pg_catalog; bug_153431 is expanded showing table c00_empty. ( 4) Double-click table c00_empty. Program presents window Table Data View with no data; caret is in first row in column id. ( 5) Type "1 <tab> abcde <space> fghij <tab>". Caret moves to second row. the_memo in first row shows "abcde fghij"; this is good. ( 6) Type "<ctrl>+W". Program closes Data View and returns focus to database window. ( 7) In database window, in pane Tasks (upper right), click <Create Table in Design View>. Program presents window Table Design. ( 8) Type "<tab>". Caret is in column Field Name in first row. ( 9) Type "id <tab> int <tab> <tab>". Caret moves to second row. (10) Type "the_memo <tab> m <tab> <tab>". Caret moves to third row. The window now shows Field Name | Field Type ------------+------------------ id | Integer [ int4 ] the_memo | Memo [ text ] (11) Right-click row header for id and from the drop-down menu select Primary Key. The row header for id now shows a key-icon. (12) Type "<ctrl>+W". Program presents dialog "Do you want to save the changes?". (13) Type "<alt>+Y". Program presents dialog "Save As"; focus is on Table Name, which shows value Table1. (14) Type "<shift>+<tab> <shift>+<tab>". Focus moves to Schema, which shows value public. (15) Type "b". Program supplies value bug_153431. (16) Type "<Enter>". Program closes "Save As" dialog and returns focus to database window; lower right pane now shows that bug_153431 contains Table1. (17) In database window, in lower right pane, double-click <Table1>. Program displays Table Data View; caret is in first row in column id. (18) Type "1 <tab> klmno <space> pqrst". Caret is in first row in column the_memo at the end of the string you just typed. So far, so good. (19) Type "<tab>". Caret moves to second row column id. The value in first row column the_memo is zero. This is bad. I see this behaviour most recently in a localbuild of commit af3f54e7, 2025-04-09, configured ... --with-vendor=Terrence Enger --with-jdk-home=/usr/lib/jvm/default-java --enable-split-debug --enable-gdb-index --enable-ld=gold --enable-option-checking=fatal --enable-dbgutil --enable-debug --without-system-postgresql --without-myspell-dicts --with-extra-buildid --without-doxygen --with-external-tar=/home/terry/lo_hacking/git/src --without-package-format --enable-odk --disable-ldap --disable-skia --enable-python=fully-internal --disable-pdfium and running on debian-sid. I have seen it in other versions of LibreOffice, but all running on debian. The STR tolerate a little bit of fat-fingering, but all this is the way I have been able to provoke the bug consistently. Obviously there is no good reason for entry of a row into c00_empty to change the result in Table1. I am setting bug status back to NEW. -- You are receiving this mail because: You are the assignee for the bug.
