[Koha-bugs] [Bug 26940] debarred comment in borrowers table is lost on patron modifications in memberentry.pl page

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

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

Séverine Queune <severine.queune at bulac.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |severine.queune at bulac.fr

--- Comment #23 from Séverine Queune <severine.queune at bulac.fr> ---
Jonathan and Katrin, I don't know if you're waiting for a specific sign off
from Didier, but to me everything works fine.
Here are the results of the different requests, wich seem consistent to me :

mysql> SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment
FROM borrower_debarments d JOIN borrowers b ON
b.borrowernumber=d.borrowernumber WHERE (b.debarredcomment IS NULL OR
b.debarredcomment = '') AND ( expiration > CURRENT_DATE() OR expiration IS NULL
) GROUP BY d.borrowernumber;
+----------------+---------+
| borrowernumber | comment |
+----------------+---------+
|             70 | NULL    |
+----------------+---------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(*) FROM (SELECT 1 FROM borrower_debarments d JOIN borrowers
b ON b.borrowernumber=d.borrowernumber WHERE (b.debarredcomment IS NULL  ) AND
( expiration > CURRENT_DATE() OR expiration IS NULL ) GROUP BY
d.borrowernumber) as e;
+----------+
| COUNT(*) |
+----------+
|        1 |
+----------+
1 row in set (0.01 sec)

mysql> SELECT COUNT(*) FROM (SELECT 1 FROM borrower_debarments d JOIN borrowers
b ON b.borrowernumber=d.borrowernumber WHERE (b.debarredcomment IS NULL OR
b.debarredcomment = ''  ) AND ( expiration > CURRENT_DATE() OR expiration IS
NULL ) AND (comment IS NOT NULL OR comment <> '') GROUP BY d.borrowernumber) as
e;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)


Let me know if you need I sign it !

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