Bugzilla – Attachment 141618 Details for
Bug 31727
Orphan records in circulation_rules and false positives after attempt to fix values to be empty or zeroes instead of missing
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Bug 31727 - Database query results from testing
Bug 31727 - Database query results.txt (text/plain), 17.83 KB, created by
David Nind
on 2022-10-11 20:25:05 UTC
(
hide
)
Description:
Bug 31727 - Database query results from testing
Filename:
MIME Type:
Creator:
David Nind
Created:
2022-10-11 20:25:05 UTC
Size:
17.83 KB
patch
obsolete
>Bug 31727 - Database query results >================================== > >Step 3 results = 47 rows/rules > >+----+------------+--------------+----------+----------------------------------+-----------------------+ >| id | branchcode | categorycode | itemtype | rule_name | rule_value | >+----+------------+--------------+----------+----------------------------------+-----------------------+ >| 1 | NULL | NULL | NULL | norenewalbefore | | >| 2 | NULL | NULL | NULL | rentaldiscount | 0 | >| 3 | NULL | NULL | NULL | holds_per_record | 2 | >| 4 | NULL | NULL | NULL | issuelength | 5 | >| 5 | NULL | NULL | NULL | opacitemholds | Y | >| 6 | NULL | NULL | NULL | article_requests | no | >| 7 | NULL | NULL | NULL | hardduedate | | >| 8 | NULL | NULL | NULL | maxonsiteissueqty | 5 | >| 9 | NULL | NULL | NULL | firstremind | 0 | >| 10 | NULL | NULL | NULL | maxissueqty | 5 | >| 11 | NULL | NULL | NULL | maxsuspensiondays | 5 | >| 12 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | >| 13 | NULL | NULL | NULL | holds_per_day | | >| 14 | NULL | NULL | NULL | cap_fine_to_replacement_price | | >| 15 | NULL | NULL | NULL | no_auto_renewal_after | | >| 16 | NULL | NULL | NULL | fine | 0 | >| 17 | NULL | NULL | NULL | finedays | 2 | >| 18 | NULL | NULL | NULL | hardduedatecompare | -1 | >| 19 | NULL | NULL | NULL | renewalperiod | 5 | >| 20 | NULL | NULL | NULL | overduefinescap | 0.00 | >| 21 | NULL | NULL | NULL | onshelfholds | 1 | >| 22 | NULL | NULL | NULL | auto_renew | 0 | >| 23 | NULL | NULL | NULL | lengthunit | days | >| 24 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | >| 25 | NULL | NULL | NULL | renewalsallowed | 5 | >| 26 | NULL | NULL | NULL | reservesallowed | | >| 27 | NULL | NULL | NULL | chargeperiod | | >| 28 | NULL | NULL | NULL | daysmode | | >| 29 | NULL | NULL | NULL | unseen_renewals_allowed | | >| 30 | NULL | NULL | NULL | suspension_chargeperiod | 1 | >| 31 | NULL | NULL | NULL | note | | >| 32 | NULL | NULL | NULL | decreaseloanholds | | >| 33 | NULL | NULL | NULL | holdallowed | from_any_library | >| 34 | NULL | NULL | NULL | patron_maxissueqty | 20 | >| 35 | NULL | NULL | NULL | patron_maxonsiteissueqty | 20 | >| 36 | NULL | NULL | NULL | max_holds | 25 | >| 37 | FRL | NULL | NULL | patron_maxissueqty | 10 | >| 38 | FRL | NULL | NULL | patron_maxonsiteissueqty | 5 | >| 39 | FRL | NULL | NULL | max_holds | 15 | >| 40 | MPL | NULL | NULL | holdallowed | from_local_hold_group | >| 41 | MPL | NULL | NULL | patron_maxonsiteissueqty | 5 | >| 42 | MPL | NULL | NULL | patron_maxissueqty | 5 | >| 43 | MPL | NULL | NULL | max_holds | 10 | >| 44 | SPL | NULL | NULL | holdallowed | from_home_library | >| 45 | SPL | NULL | NULL | patron_maxissueqty | 16 | >| 46 | SPL | NULL | NULL | patron_maxonsiteissueqty | 8 | >| 47 | SPL | NULL | NULL | max_holds | 5 | >+----+------------+--------------+----------+----------------------------------+-----------------------+ >47 rows in set (0.000 sec) > >Step 5 result = now have 63 rows/rules: 47 + 15 (3 libraries x 5 extra rules) + 1 (extra rule for unseenrenewalsallowed for NULL - see row 51) > >+----+------------+--------------+----------+----------------------------------+-----------------------+ >| id | branchcode | categorycode | itemtype | rule_name | rule_value | >+----+------------+--------------+----------+----------------------------------+-----------------------+ >| 1 | NULL | NULL | NULL | norenewalbefore | | >| 2 | NULL | NULL | NULL | rentaldiscount | 0 | >| 3 | NULL | NULL | NULL | holds_per_record | 2 | >| 4 | NULL | NULL | NULL | issuelength | 5 | >| 5 | NULL | NULL | NULL | opacitemholds | Y | >| 6 | NULL | NULL | NULL | article_requests | no | >| 7 | NULL | NULL | NULL | hardduedate | | >| 8 | NULL | NULL | NULL | maxonsiteissueqty | 5 | >| 9 | NULL | NULL | NULL | firstremind | 0 | >| 10 | NULL | NULL | NULL | maxissueqty | 5 | >| 11 | NULL | NULL | NULL | maxsuspensiondays | 5 | >| 12 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | >| 13 | NULL | NULL | NULL | holds_per_day | | >| 14 | NULL | NULL | NULL | cap_fine_to_replacement_price | | >| 15 | NULL | NULL | NULL | no_auto_renewal_after | | >| 16 | NULL | NULL | NULL | fine | 0 | >| 17 | NULL | NULL | NULL | finedays | 2 | >| 18 | NULL | NULL | NULL | hardduedatecompare | -1 | >| 19 | NULL | NULL | NULL | renewalperiod | 5 | >| 20 | NULL | NULL | NULL | overduefinescap | 0.00 | >| 21 | NULL | NULL | NULL | onshelfholds | 1 | >| 22 | NULL | NULL | NULL | auto_renew | 0 | >| 23 | NULL | NULL | NULL | lengthunit | days | >| 24 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | >| 25 | NULL | NULL | NULL | renewalsallowed | 5 | >| 26 | NULL | NULL | NULL | reservesallowed | | >| 27 | NULL | NULL | NULL | chargeperiod | | >| 28 | NULL | NULL | NULL | daysmode | | >| 29 | NULL | NULL | NULL | unseen_renewals_allowed | | >| 30 | NULL | NULL | NULL | suspension_chargeperiod | 1 | >| 31 | NULL | NULL | NULL | note | | >| 32 | NULL | NULL | NULL | decreaseloanholds | | >| 33 | NULL | NULL | NULL | holdallowed | from_any_library | >| 34 | NULL | NULL | NULL | patron_maxissueqty | 20 | >| 35 | NULL | NULL | NULL | patron_maxonsiteissueqty | 20 | >| 36 | NULL | NULL | NULL | max_holds | 25 | >| 37 | FRL | NULL | NULL | patron_maxissueqty | 10 | >| 38 | FRL | NULL | NULL | patron_maxonsiteissueqty | 5 | >| 39 | FRL | NULL | NULL | max_holds | 15 | >| 40 | MPL | NULL | NULL | holdallowed | from_local_hold_group | >| 41 | MPL | NULL | NULL | patron_maxonsiteissueqty | 5 | >| 42 | MPL | NULL | NULL | patron_maxissueqty | 5 | >| 43 | MPL | NULL | NULL | max_holds | 10 | >| 44 | SPL | NULL | NULL | holdallowed | from_home_library | >| 45 | SPL | NULL | NULL | patron_maxissueqty | 16 | >| 46 | SPL | NULL | NULL | patron_maxonsiteissueqty | 8 | >| 47 | SPL | NULL | NULL | max_holds | 5 | >| 48 | FRL | NULL | NULL | rentaldiscount | 0 | >| 49 | MPL | NULL | NULL | rentaldiscount | 0 | >| 50 | SPL | NULL | NULL | rentaldiscount | 0 | >| 51 | NULL | NULL | NULL | unseenrenewalsallowed | | >| 52 | FRL | NULL | NULL | unseenrenewalsallowed | | >| 53 | MPL | NULL | NULL | unseenrenewalsallowed | | >| 54 | SPL | NULL | NULL | unseenrenewalsallowed | | >| 58 | FRL | NULL | NULL | decreaseloanholds | | >| 59 | MPL | NULL | NULL | decreaseloanholds | | >| 60 | SPL | NULL | NULL | decreaseloanholds | | >| 61 | FRL | NULL | NULL | hardduedate | | >| 62 | MPL | NULL | NULL | hardduedate | | >| 63 | SPL | NULL | NULL | hardduedate | | >| 64 | FRL | NULL | NULL | issuelength | 0 | >| 65 | MPL | NULL | NULL | issuelength | 0 | >| 66 | SPL | NULL | NULL | issuelength | 0 | >+----+------------+--------------+----------+----------------------------------+-----------------------+ >63 rows in set (0.000 sec) > >Step 9 result = now have 48 row/rules: still have one extra rule - row 51 > >+----+------------+--------------+----------+----------------------------------+-----------------------+ >| id | branchcode | categorycode | itemtype | rule_name | rule_value | >+----+------------+--------------+----------+----------------------------------+-----------------------+ >| 1 | NULL | NULL | NULL | norenewalbefore | | >| 2 | NULL | NULL | NULL | rentaldiscount | 0 | >| 3 | NULL | NULL | NULL | holds_per_record | 2 | >| 4 | NULL | NULL | NULL | issuelength | 5 | >| 5 | NULL | NULL | NULL | opacitemholds | Y | >| 6 | NULL | NULL | NULL | article_requests | no | >| 7 | NULL | NULL | NULL | hardduedate | | >| 8 | NULL | NULL | NULL | maxonsiteissueqty | 5 | >| 9 | NULL | NULL | NULL | firstremind | 0 | >| 10 | NULL | NULL | NULL | maxissueqty | 5 | >| 11 | NULL | NULL | NULL | maxsuspensiondays | 5 | >| 12 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | >| 13 | NULL | NULL | NULL | holds_per_day | | >| 14 | NULL | NULL | NULL | cap_fine_to_replacement_price | | >| 15 | NULL | NULL | NULL | no_auto_renewal_after | | >| 16 | NULL | NULL | NULL | fine | 0 | >| 17 | NULL | NULL | NULL | finedays | 2 | >| 18 | NULL | NULL | NULL | hardduedatecompare | -1 | >| 19 | NULL | NULL | NULL | renewalperiod | 5 | >| 20 | NULL | NULL | NULL | overduefinescap | 0.00 | >| 21 | NULL | NULL | NULL | onshelfholds | 1 | >| 22 | NULL | NULL | NULL | auto_renew | 0 | >| 23 | NULL | NULL | NULL | lengthunit | days | >| 24 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | >| 25 | NULL | NULL | NULL | renewalsallowed | 5 | >| 26 | NULL | NULL | NULL | reservesallowed | | >| 27 | NULL | NULL | NULL | chargeperiod | | >| 28 | NULL | NULL | NULL | daysmode | | >| 29 | NULL | NULL | NULL | unseen_renewals_allowed | | >| 30 | NULL | NULL | NULL | suspension_chargeperiod | 1 | >| 31 | NULL | NULL | NULL | note | | >| 32 | NULL | NULL | NULL | decreaseloanholds | | >| 33 | NULL | NULL | NULL | holdallowed | from_any_library | >| 34 | NULL | NULL | NULL | patron_maxissueqty | 20 | >| 35 | NULL | NULL | NULL | patron_maxonsiteissueqty | 20 | >| 36 | NULL | NULL | NULL | max_holds | 25 | >| 37 | FRL | NULL | NULL | patron_maxissueqty | 10 | >| 38 | FRL | NULL | NULL | patron_maxonsiteissueqty | 5 | >| 39 | FRL | NULL | NULL | max_holds | 15 | >| 40 | MPL | NULL | NULL | holdallowed | from_local_hold_group | >| 41 | MPL | NULL | NULL | patron_maxonsiteissueqty | 5 | >| 42 | MPL | NULL | NULL | patron_maxissueqty | 5 | >| 43 | MPL | NULL | NULL | max_holds | 10 | >| 44 | SPL | NULL | NULL | holdallowed | from_home_library | >| 45 | SPL | NULL | NULL | patron_maxissueqty | 16 | >| 46 | SPL | NULL | NULL | patron_maxonsiteissueqty | 8 | >| 47 | SPL | NULL | NULL | max_holds | 5 | >| 51 | NULL | NULL | NULL | unseen_renewals_allowed | | >+----+------------+--------------+----------+----------------------------------+-----------------------+ >48 rows in set (0.001 sec) > >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=141618">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 31727
:
141595
|
141600
|
141601
| 141618 |
141725