Created attachment 81818 [details] Sample linked table query. In the example (to be attached), running Query1 on all 3.n versions of LO I have used produces a result set where the text fields can be edited. This is true of this example using the embedded database, and of my main system using MySQl (Native and JDBC). On LO 4,1,0.1 RC the data cannot be edited. For me this a blocker and I'll have to give up on using 4.1 (I couldn't use 4.0 due to other faults). I had previously migrated to 4.1 since most problems were manageable.
I can confirm this bug. A query could be edited in nearly all LO-Versions, when there are the Primary-Keys of all tables included. Works with LO 3.5.7.2, LO 3.6.6.2, LO 4.0.3.3. Doesn't work with LO 3.3.4 and - new - with LO 4.1.0.1rc. I have tested it with openSUSE 12.3 64bit rpm.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=369e2d3e007fd9177c3500813feee22fc3a8a823 fdo#66464 initialise static join info at construct time The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a571129c94318ce5667f89cb6489561b8c161ee2&h=libreoffice-4-1 fdo#66464 initialise static join info at construct time It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Confirm fixed on my 32-bit linux mint debian system. Thanks.
Should have said - in 4.1.0.2 (RC2)
Setting to VERIFIED (FIXED) as per Tim's comment.