class_docstr: run some compile tests, even though these are redundant.
class_docstr_tok: ["run","some","compile","tests",",","even","though","these","are","redundant","."]
code: def test_for_update_on_inner_w_joinedload_no_render_oracle(self):
      from sqlalchemy.dialects import oracle
  
      User = self.classes.User
      sess = fixture_session()
      self.assert_compile(
          sess.query(User)
          .options(joinedload(User.addresses))
          .with_for_update()
          .limit(1),
          "SELECT anon_1.users_id AS anon_1_users_id, "
          "anon_1.users_name AS anon_1_users_name, "
          "addresses_1.id AS addresses_1_id, "
          "addresses_1.user_id AS addresses_1_user_id, "
          "addresses_1.email_address AS addresses_1_email_address "
          "FROM (SELECT anon_2.users_id AS users_id, "
          "anon_2.users_name AS users_name FROM "
          "(SELECT users.id AS users_id, users.name AS users_name "
          "FROM users) anon_2 WHERE ROWNUM <= "
          "__[POSTCOMPILE_param_1]) anon_1 "
          "LEFT OUTER JOIN addresses addresses_1 "
          "ON anon_1.users_id = addresses_1.user_id FOR UPDATE",
          dialect=oracle.dialect(enable_offset_fetch=False),
      )
  
imports: from sqlalchemy import exc
  from sqlalchemy import testing
  from sqlalchemy.engine import default
  from sqlalchemy.orm import joinedload
  from sqlalchemy.orm import relationship
  from sqlalchemy.testing import assert_raises_message
  from sqlalchemy.testing import AssertsCompiledSQL
  from sqlalchemy.testing import eq_
  from sqlalchemy.testing.fixtures import fixture_session
  from test.orm import _fixtures
label_desc: Use image node_id 18 for calling the CompileTest obj's underlying member method code with example usage: obj.test_for_update_on_inner_w_joinedload_no_render_oracle() without return types