Fix various lib / test / examples typos (#7017)

* fix: lib/sqlalchemy/sql/lambdas.py

* fix: lib/sqlalchemy/sql/compiler.py

* fix: lib/sqlalchemy/sql/selectable.py

* fix: lib/sqlalchemy/orm/relationships.py

* fix: lib/sqlalchemy/dialects/mssql/base.py

* fix: lib/sql/test_compiler.py

* fix: lib/sqlalchemy/testing/requirements.py

* fix: lib/sqlalchemy/orm/path_registry.py

* fix: lib/sqlalchemy/dialects/postgresql/psycopg2.py

* fix: lib/sqlalchemy/cextension/immutabledict.c

* fix: lib/sqlalchemy/cextension/resultproxy.c

* fix: ./lib/sqlalchemy/dialects/oracle/cx_oracle.py

* fix: examples/versioned_rows/versioned_rows_w_versionid.py

* fix: examples/elementtree/optimized_al.py

* fix: test/orm/test_attribute.py

* fix: test/sql/test_compare.py

* fix: test/sql/test_type_expression.py

* fix: capitalization in test/dialect/mysql/test_compiler.py

* fix: typos in test/dialect/postgresql/test_reflection.py

* fix: typo in tox.ini comment

* fix: typo in /lib/sqlalchemy/orm/decl_api.py

* fix: typo in test/orm/test_update_delete.py

* fix: self-induced typo

* fix: typo in test/orm/test_query.py

* fix: typos in test/dialect/mssql/test_types.py

* fix: typo in test/sql/test_types.py

4 files changed, 8 insertions, 8 deletions

diff --git a/test/sql/test_compare.py b/test/sql/test_compare.py
index 371e68a8a..eaae0c448 100644
--- a/test/sql/test_compare.py
+++ b/test/sql/test_compare.py
@@ -860,7 +860,7 @@ class CoreFixtures(object):
             subq = select(l).subquery()
 
             # this creates a ColumnClause as a proxy to the Label() that has
-            # an anoymous name, so the column has one too.
+            # an anonymous name, so the column has one too.
             anon_col = subq.c[0]
 
             # then when BindParameter is created, it checks the label
@@ -876,7 +876,7 @@ class CoreFixtures(object):
             subq = select(l).subquery()
 
             # this creates a ColumnClause as a proxy to the Label() that has
-            # an anoymous name, so the column has one too.
+            # an anonymous name, so the column has one too.
             anon_col = subq.c[0]
 
             # then when BindParameter is created, it checks the label
diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py
index b150b9f64..15b13caaa 100644
--- a/test/sql/test_compiler.py
+++ b/test/sql/test_compiler.py
@@ -3682,7 +3682,7 @@ class BindParameterTest(AssertsCompiledSQL, fixtures.TestBase):
         subq = select(l).subquery()
 
         # this creates a ColumnClause as a proxy to the Label() that has
-        # an anoymous name, so the column has one too.
+        # an anonymous name, so the column has one too.
         anon_col = subq.c[0]
         assert isinstance(anon_col.name, elements._anonymous_label)
 
@@ -3896,7 +3896,7 @@ class BindParameterTest(AssertsCompiledSQL, fixtures.TestBase):
         # it's anonymous so unique=True
         is_true(original_bind.unique)
 
-        # cache key against hte original param
+        # cache key against the original param
         cache_key = stmt._generate_cache_key()
 
         # now adapt the statement
@@ -3971,7 +3971,7 @@ class BindParameterTest(AssertsCompiledSQL, fixtures.TestBase):
         # it's anonymous so unique=True
         is_true(original_bind.unique)
 
-        # cache key against hte original param
+        # cache key against the original param
         cache_key = stmt._generate_cache_key()
 
         # now adapt the statement and separately adapt the inner
@@ -5309,7 +5309,7 @@ class DDLTest(fixtures.TestBase, AssertsCompiledSQL):
         for kw in ("onupdate", "ondelete", "initially"):
             for phrase in (
                 "NOT SQL",
-                "INITALLY NOT SQL",
+                "INITIALLY NOT SQL",
                 "FOO RESTRICT",
                 "CASCADE WRONG",
                 "SET  NULL",
diff --git a/test/sql/test_type_expressions.py b/test/sql/test_type_expressions.py
index c4ed8121e..51ee0ae62 100644
--- a/test/sql/test_type_expressions.py
+++ b/test/sql/test_type_expressions.py
@@ -24,7 +24,7 @@ class _ExprFixture(object):
     def _fixture(self):
         class MyString(String):
 
-            # supercedes any processing that might be on
+            # supersedes any processing that might be on
             # String
             def bind_expression(self, bindvalue):
                 return func.lower(bindvalue)
diff --git a/test/sql/test_types.py b/test/sql/test_types.py
index 261c3ed10..01266d15b 100644
--- a/test/sql/test_types.py
+++ b/test/sql/test_types.py
@@ -1116,7 +1116,7 @@ class TypeCoerceCastTest(fixtures.TablesTest):
         MyType = self.MyType
 
         # test coerce from nulltype - e.g. use an object that
-        # does't match to a known type
+        # doesn't match to a known type
         class MyObj(object):
             def __str__(self):
                 return "THISISMYOBJ"