[Koha-bugs] [Bug 24148] black magic in Circulation/Returns.t

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

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

--- Comment #2 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Recreated from the MariaDB CLI.

MariaDB [koha_kohadev]> SELECT itemnumber, `type`, borrowernumber from
statistics WHERE ( `itemnumber` = 1087 AND `type` = 'return' );
+------------+--------+----------------+
| itemnumber | type   | borrowernumber |
+------------+--------+----------------+
|       1087 | return |            122 |
+------------+--------+----------------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT itemnumber, borrowernumber, datetime from
statistics WHERE ( `itemnumber` = 1087 AND `type` = 'return' ) ORDER BY
`datetime` ASC;
+------------+----------------+---------------------+
| itemnumber | borrowernumber | datetime            |
+------------+----------------+---------------------+
|       1087 |            122 | 2019-12-10 13:35:55 |
+------------+----------------+---------------------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT itemnumber, borrowernumber, datetime, type from
statistics WHERE ( `itemnumber` = 1087 AND `type` = 'return' ) ORDER BY
`datetime` ASC;
+------------+----------------+---------------------+--------+
| itemnumber | borrowernumber | datetime            | type   |
+------------+----------------+---------------------+--------+
|       1087 |            122 | 2019-12-10 13:35:55 | return |
+------------+----------------+---------------------+--------+
1 row in set (0.00 sec)


MariaDB [koha_kohadev]> SELECT * from statistics WHERE ( `itemnumber` = 1087
AND `type` = 'return' ) ORDER BY `datetime` ASC;
Empty set (0.00 sec)

MariaDB [koha_kohadev]> SELECT * from statistics WHERE ( `itemnumber` = 1087
AND `type` = 'return' ) ORDER BY `itemnumber` ASC;
+---------------------+-----------+--------+--------+-------+------------+----------+----------+----------------+----------------------------------------------------------------------------------+
| datetime            | branch    | value  | type   | other | itemnumber |
itemtype | location | borrowernumber | ccode                                   
                                        |
+---------------------+-----------+--------+--------+-------+------------+----------+----------+----------------+----------------------------------------------------------------------------------+
| 2019-12-10 13:35:55 | iObbbKovf | 0.0000 | return |       |       1087 |
SgqzzzD  | NULL     |            122 |
vghO1ljHGphe13fp_LDxGDhsYFQqTSEMJ3S2aQXYyK2gMVlo1Q3b3rpn_FQCEPKqlIgCv0iSHpc1tRdy
|
+---------------------+-----------+--------+--------+-------+------------+----------+----------+----------------+----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT * from statistics WHERE ( `itemnumber` = 1087
AND `type` = 'return' ) ORDER BY `datetime` ASC;
Empty set (0.00 sec)

MariaDB [koha_kohadev]> SELECT itemnumber, borrowernumber from statistics WHERE
( `itemnumber` = 1087 AND `type` = 'return' ) ORDER BY `datetime` ASC;
+------------+----------------+
| itemnumber | borrowernumber |
+------------+----------------+
|       1087 |            122 |
+------------+----------------+
1 row in set (0.00 sec)

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