[Libreoffice-bugs] [Bug 116253] 'NULL' appears as default text in text and combo boxes when editing a newly inserted record in a form's table control

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Howard Johnson <BridgeportContractor at gmail.com> ---
--------------------------------------------------------------
1) It also does this in LO version 5.4.4.2


--------------------------------------------------------------
2) This bug is in a Table control when you insert a NEW record


--------------------------------------------------------------
3) MySQL fields defined with:

        Allow NULL = true     and 
        Default    = NULL


--------------------------------------------------------------
4) Database connection used:

Menu to: Tools | Options: LibreOffice > Advanced 

  In the 'Options - LibreOffice - Advanced' dialog:
     X Use a Java runtime environment:
        Oracle Corporation v 1.8.0_171

  Then click 'Class Path...'

  In the 'Class Path' dialog:
      Assigned folders and archives:
         mariadb-java-client-1.5.7.jar


Menu to: Edit | Database | Properties... | Additional Settings tab:
   Connection Settings
      Host name:  localhost
      Port number: 3306
      MySQL JDBC driver class:  org.mariadb.jdbc.Driver

   Data Conversion
      Character set:  System


Menu to: Edit | Database | Connection type...
    Database type:  MySQL (JDBC)


Menu to: Edit | Database | Advanced Settings...
    Special settings:
        x  Use keyword AS before table alias names
        x  Ignore the privileges from the database driver
        _  Display version columns (when available)
        _  End text lines with CR+LF
        x  Ignore currency field information
        Comparison of Boolean values:   Default



--------------------------------------------------------------------------------------
5) It only happens if I don't enter a value in a field:

   i)    in a VARCHAR  field it shows 'NULL'                                   
 (bug)
            (rather than quietly showing nothing which is what I would expect)
         the SQL record gets a (NULL) as verified by HeidiSQL (as expected)

   ii)   in a DATETIME field it shows '1/1/13'                                 
 (bug)
            (rather than quietly showing nothing which is what I would expect)
         the SQL record gets a (NULL) as verified by HeidiSQL (as expected)

   iii)  in a DECIMAL  field it shows '$0.00'  (when formatted to USD)         
 (bug)
            (rather than quietly showing nothing which is what I would expect)
         the SQL record gets a (NULL) as verified by HeidiSQL (as expected)


   iv)   in a INTEGER   field it shows nothing  (when looked up with a listbox)
 (ok)
         the SQL record gets a (NULL) as verified by HeidiSQL (as expected)

   v)    in a TINYINT  fields it shows nothing  (as expected)                  
 (ok)
         the SQL record gets a 0      as verified by HeidiSQL                  
 (bug)
             (rather than getting (NULL) which is what I would expect) 

         This happens both if settings are:

                 Input required: Yes
                       Tristate: Yes

               or are:

                 Input required: No
                       Tristate: No


--------------------------------------------------------------
6) This occurs if you set at least one field in the new record, 
   and then either hit up-arrow,  down-arrow or enter to insert
   the new record.


--------------------------------------------------------------
7) A secondary bug then occurs if you had hit up-arrow.
   If you then down arrow back into the newly created record,
   and especially into a VARCHAR field, the 'NULL' remains
   from before and now acts like it's actual text data!


==============================================================
Partial workarounds:
   First, except for TINYINT's and for with #7 above, the data actually 
   in the SQL is correct.  For #7 delete the 'NULL' text and you're ok.
   Clicking the refresh icon ('Refreshes the display data.') seems to 
   repaint the screen correctly.  (Simply scrolling up and down doesn't fix
it.)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180603/9db2eade/attachment-0001.html>