diff options
author | Stephen Finucane <sfinucan@redhat.com> | 2022-09-07 23:39:40 +0100 |
---|---|---|
committer | Stephen Finucane <sfinucan@redhat.com> | 2023-04-19 10:44:19 +0100 |
commit | 00aadf570b5468b62ad1d843dd5b88d7cf11baf1 (patch) | |
tree | 04c2569d98185001467f55a69c7d06f7dc4d34b2 /doc | |
parent | 8ef9db15704c0c2cb1342c7c1554bfa8d8a7a2e3 (diff) | |
download | ironic-00aadf570b5468b62ad1d843dd5b88d7cf11baf1.tar.gz |
db: Resolve SAWarning warnings
Resolve the following SAWarning warning:
SELECT statement has a cartesian product between FROM element(s)
"foo" and FROM element "bar". Apply join condition(s) between each
element to resolve.
This was happening because we were filtering instances of
ConductorHardwareInterfaces by the state of the Conductor referenced by
the 'conductor_id' field *without* joining the Conductor table. By
adding the join, we can avoid this cartesian product.
Change-Id: I2c20d7a7c1de41d4d0057fabc1d953b5bfb5b216
Signed-off-by: Stephen Finucane <sfinucan@redhat.com>
Diffstat (limited to 'doc')
0 files changed, 0 insertions, 0 deletions