https://bugs.documentfoundation.org/show_bug.cgi?id=92322

Alex Thurgood <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW
            Summary|Not changing a text field   |EDITING - MEMO (TEXT)
                   |with MySQL                  |fields refuse data entry
                   |                            |with MySQL and JDBC
                   |                            |connector

--- Comment #2 from Alex Thurgood <[email protected]> ---
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)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to