System : Yosemite 10.10.3 Java : 1.6.0-65 MySQL Connector : 5.1.35 MySQL Database : no possible to change a field in TEXT format. But, no problem with fields in VARCHAR(n) format. Regards, PJG51
@PJG51: please explain what exactly it is that you are trying to do : - change the definition of a field type to TEXT ? - change the data in a TEXT field type to something else (overwrite) ? Setting to NEDDINFO. Please set back to UNCONFIRMED once you have provided detailed steps of what you are attempting to do, what you expect to see, and what you actually experience. Thank you.
Confirmed on Version: 4.4.3.2 Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16 Locale : fr_ 1) Create an ODB file that connects to a mysql server db via the mysql JDBC connector. 2) Create a table within the ODB via the Table creation GUI with the following definitions : ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY text1 MEMO (TEXT) default length (65535) - NULL ALLOWED text2 VARCHAR default length (1° - NULL ALLOWED 3) Save the table and then open it for data entry Try entering data in the MEMO field : the data is preliminarily displayed, but when you press tab or enter, it disappears. Try entering data in the VARCHAR field - the data is accepted and the record created. If the table issetup to have just an ID field as above and a MEMO field, then no data entry at all is possible. Cross checking with a terminal connection to the same db, the table shows the following : mysql> select * from gibberish; +----+-----------+---------------+ | id | gibberish | moregibberish | +----+-----------+---------------+ | 1 | NULL | huytgfrdes | +----+-----------+---------------+ 1 row in set (0,01 sec)
The problem appears specific to use of the JDBC connector, as the direct native mysql connector allows me to enter data into the MEMO field.
Which, unless the problem is ubiquitous to all mysql JDBC drivers irrespective of OS, is naturally a problem on Mac, as there is no native connector extension provided ;-)
Well, having tested the same ODB on Version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 with connector 5.1.21 it works ok there ==> regression
On master build I get a magnificent abort : Application Specific Information: Assertion failed: (nShortenedLength >= 0), function rtl_ustr_shortenedCompare_WithLength, file /Volumes/BUILDHD/Shared/LO/core/sal/rtl/strtmpl.cxx, line 169. Apple trace enclosed.
Created attachment 116821 [details] Apple crash trace
So thanks Alex, I think you've been around the problem! But I don't think this bug is completely linked to MySQL Connector, because it works properly with NeoOffice…
(In reply to PJG51 from comment #8) > So thanks Alex, I think you've been around the problem! > But I don't think this bug is completely linked to MySQL Connector, because > it works properly with NeoOffice… As I mentioned in comment 5, it works with an older version of LibreOffice, so this is a regression.
Created attachment 116823 [details] bt for crash on master
On pc Debian x86-64 with master sources updated yesterday, I don't reproduce the crash when adding entry or the disappear symptom. But memo field is limited to 4 character whereas size field is 65535. I had a crash when viewing table structure then close window.
Created attachment 116859 [details] bt with debug symbols
I just noticed, I used MariaDb, not Mysql connector (here's an extract of my autogen.input: --without-system-mariadb --enable-ext-mariadb-connector --enable-bundle-mariadb ) With Mysql/jdbc, no crash neither when browsing data nor editing then closing table. Also, I can enter more than 4 characters in memo field.
*** Bug 92366 has been marked as a duplicate of this bug. ***
Julien Nabet committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dc1dd18d0650fb0e054791381062b33a5609c424 Related tdf#92322: fix crash with doCursor It will be available in 5.1.0. 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.
Tested with the steps described in Bug 92366 on Linux Mint. Crashing before the patch, working after. Thanks.
This bug is not about the crash. Reopening.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=57eb935945a76d587490e393954c06d1c8972471&h=libreoffice-5-0 Related tdf#92322: fix crash with doCursor It will be available in 5.0.0.3. 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.
Migrating Whiteboard tags to Keywords: (notBibisectable)
This is now WFM with Version: 5.3.4.2 Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3 Threads CPU : 4; Version de l'OS :Mac OS X 10.12.6; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR.UTF-8); Calc: group and mysql jdbc connector 5.1.43