Method test_bindparam_not_cached

test/sql/test_lambdas.py:1920–1959

test #12084

(self, user_address_fixture, testing_engine)

            )

    def test_bindparam_not_cached(self, user_address_fixture, testing_engine):
        """test #12084"""

        users, addresses = user_address_fixture

        engine = testing_engine(
            options={"query_cache_size": 0, "sqlite_share_pool": True}
        )
        with engine.begin() as conn:
            conn.execute(
                users.insert(),
                [{"id": 7, "name": "bar"}, {"id": 8, "name": "foo"}],
            )

        def make_query(stmt, *criteria):
            for crit in criteria:
                stmt += lambda s: s.where(crit)

            return stmt

        for i in range(2):
            with engine.connect() as conn:
                stmt = lambda_stmt(lambda: select(users))
                # create a filter criterion that will never match anything
                stmt1 = make_query(
                    stmt,
                    users.c.name == "bar",
                    users.c.name == "foo",
                )

                assert len(conn.scalars(stmt1).all()) == 0

                stmt2 = make_query(
                    stmt,
                    users.c.name == "bar",
                    users.c.name == "bar",
                    users.c.name == "foo",
                )

                assert len(conn.scalars(stmt2).all()) == 0


class DeferredLambdaElementTest(