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

--- Comment #18 from Matthew Charlesworth <[email protected]> 
---
Hi,

(In reply to Emmi Takkinen from comment #17)
> Hmm, they are indeed. This should also return empty:
> 
> SELECT COUNT(*) FROM aqbudgets WHERE budget_period_id IS NULL OR
> budget_period_id NOT IN(SELECT budget_period_id FROM aqbudgetperiods);

Well, 0...

MariaDB [...]> SELECT COUNT(*) FROM aqbudgets WHERE budget_period_id IS NULL OR
budget_period_id NOT IN(SELECT budget_period_id FROM aqbudgetperiods);
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.000 sec)

M.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to