[Koha-bugs] [Bug 26539] New: Inconsistent case sensitivity around patron attribute code - potential data loss

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26539

            Bug ID: 26539
           Summary: Inconsistent case sensitivity around patron attribute
                    code - potential data loss
 Change sponsored?: ---
           Product: Koha
           Version: 19.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: andrew at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

To recreate:
1 - have a patron attribute with code "TEST"
2 - using import_borrowers.pl, import a patron with "test:1" in the
patron_attributes
field of your CSV
3 - load your patron, confirm the value of 1 shows on moremember.pl
4 - click to edit your patron, confirm the value of 1 does not show on
memberentry.pl
5 - query the database, SELECT * from borrower_attributes where
borrowernumber=[your borrower], see code="test"
6 - update the database, UPDATE borrower_attributes set code="TEST" where
id=[your attribute id]
7 - reload memberentry.pl, it now shows a 1

Back at step 4, if we'd saved our patron, that value would have been lost

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.