Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SAWarning: SELECT statement has a cartesian product #72

Open
xsuchy opened this issue Jan 3, 2023 · 0 comments
Open

SAWarning: SELECT statement has a cartesian product #72

xsuchy opened this issue Jan 3, 2023 · 0 comments

Comments

@xsuchy
Copy link
Member

xsuchy commented Jan 3, 2023

When running python -m pytest -v test.py I get:


test.py::TestsWithApp::test_sqlalchemy_aliased
  /home/msuchy/projects/flask-whooshee/test.py:357: SAWarning: SELECT statement has a cartesian product between FROM element(s) "entry" and FROM element "user".  Apply join condition(s) between each element to resolve.
    self.assertEqual(len(self.User.query.join(alias).whooshee_search('chuck').all()), 3)

test.py::TestsWithInitApp::test_sqlalchemy_aliased
  /home/msuchy/projects/flask-whooshee/test.py:357: SAWarning: SELECT statement has a cartesian product between FROM element(s) "entry_1", "user" and FROM element "entry".  Apply join condition(s) between each element to resolve.
    self.assertEqual(len(self.User.query.join(alias).whooshee_search('chuck').all()), 3)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant