apple

Finished

Test Name	Status
test_conflicting_aliases_during_combine (queries.tests.QuerySetBitwiseOperationTests)	Pass
test_ticket14729 (queries.tests.RawQueriesTests)	Pass
test_datetimes_invalid_field (queries.tests.Queries3Tests)	Pass
test_ticket22023 (queries.tests.Queries3Tests)	Pass
test_ticket7107 (queries.tests.Queries3Tests)	Pass
test_21001 (queries.tests.EmptyStringsAsNullTest)	Pass
test_direct_exclude (queries.tests.EmptyStringsAsNullTest)	Pass
test_joined_exclude (queries.tests.EmptyStringsAsNullTest)	Pass
test_reverse_trimming (queries.tests.ReverseJoinTrimmingTest)	Pass
Can create an instance of a model with only the PK field (#17056)."	Pass
test_ticket7371 (queries.tests.CustomPkTests)	Pass
test_invalid_values (queries.tests.TestInvalidValuesRelation)	Pass
test_ticket_21879 (queries.tests.ReverseM2MCustomPkTests)	Pass
test_invalid_order_by (queries.tests.QuerySetExceptionTests)	Pass
test_invalid_order_by_raw_column_alias (queries.tests.QuerySetExceptionTests)	Pass
test_invalid_queryset_model (queries.tests.QuerySetExceptionTests)	Pass
test_iter_exceptions (queries.tests.QuerySetExceptionTests)	Pass
test_ticket8597 (queries.tests.ComparisonTests)	Pass
test_annotated_default_ordering (queries.tests.QuerysetOrderedTests)	Pass
test_annotated_ordering (queries.tests.QuerysetOrderedTests)	Pass
test_annotated_values_default_ordering (queries.tests.QuerysetOrderedTests)	Pass
test_cleared_default_ordering (queries.tests.QuerysetOrderedTests)	Pass
test_empty_queryset (queries.tests.QuerysetOrderedTests)	Pass
test_explicit_ordering (queries.tests.QuerysetOrderedTests)	Pass
test_no_default_or_explicit_ordering (queries.tests.QuerysetOrderedTests)	Pass
test_order_by_extra (queries.tests.QuerysetOrderedTests)	Pass
test_empty_full_handling_conjunction (queries.tests.WhereNodeTest)	Pass
test_empty_full_handling_disjunction (queries.tests.WhereNodeTest)	Pass
test_empty_nodes (queries.tests.WhereNodeTest)	Pass
test_emptyqueryset_values (queries.tests.EmptyQuerySetTests)	Pass
test_ticket_19151 (queries.tests.EmptyQuerySetTests)	Pass
test_values_subquery (queries.tests.EmptyQuerySetTests)	Pass
Generating the query string doesn't alter the query's state	Pass
#13227 -- If a queryset is already evaluated, it can still be used as a query arg	Pass
Cloning a queryset does not get out of hand. While complete	Pass
test_ticket_20788 (queries.tests.Ticket20788Tests)	Pass
test_ticket_7302 (queries.tests.EscapingTests)	Pass
test_ticket_24278 (queries.tests.TestTicket24279)	Pass
test_tickets_3045_3288 (queries.tests.SelectRelatedTests)	Pass
test_ticket10432 (queries.tests.GeneratorExpressionTests)	Pass
test_double_subquery_in (queries.tests.DoubleInSubqueryTests)	Pass
test_values_in_subquery (queries.tests.ValuesSubqueryTests)	Pass
test_primary_key (queries.tests.IsNullTests)	Pass
test_to_field (queries.tests.IsNullTests)	Pass
test_ticket_14056 (queries.tests.Ticket14056Tests)	Pass
test_ticket_21787 (queries.tests.ForeignKeyToBaseExcludeTests)	Pass
test_empty_string_promotion (queries.tests.EmptyStringPromotionTests)	Pass
test_exists (queries.tests.ExistsSql)	Pass
test_ticket_18414 (queries.tests.ExistsSql)	Pass
test_ticket_19964 (queries.tests.RelabelCloneTest)	Pass
test_join_already_in_query (queries.tests.NullableRelOrderingTests)	Pass
test_ticket10028 (queries.tests.NullableRelOrderingTests)	Pass
test_ticket_18785 (queries.tests.Ticket18785Tests)	Pass
test_in_list_limit (queries.tests.ConditionalTests)	Pass
test_infinite_loop (queries.tests.ConditionalTests)	Pass
test_ticket_22429 (queries.tests.Ticket22429Tests)	Pass
test_ticket15786 (queries.tests.Exclude15786)	Pass
test_ticket_21203 (queries.tests.Ticket21203Tests)	Pass
test_ticket7778 (queries.tests.SubclassFKTests)	Pass
Subquery table names should be quoted.	Pass
test_ticket_12807 (queries.tests.Ticket12807Tests)	Pass
Tests QuerySet ORed combining in exclude subquery case.	Pass
test_double_exclude (queries.tests.NullInExcludeTest)	Pass
test_null_in_exclude_qs (queries.tests.NullInExcludeTest)	Pass
test_non_nullable_fk_not_promoted (queries.tests.ValuesJoinPromotionTests)	Pass
test_ticket_21376 (queries.tests.ValuesJoinPromotionTests)	Pass
test_values_no_promotion_for_existing (queries.tests.ValuesJoinPromotionTests)	Pass
test_ticket7872 (queries.tests.DisjunctiveFilterTests)	Pass
test_ticket8283 (queries.tests.DisjunctiveFilterTests)	Pass
When passing proxy model objects, child objects, or parent objects,	Pass
#23396 - Ensure ValueQuerySets are not checked for compatibility with the lookup field	Pass
A ValueError is raised when the incorrect object type is passed to a	Pass
test_can_combine_queries_using_and_and_or_operators (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_can_get_items_using_index_and_slice_notation (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_can_get_number_of_items_in_queryset_using_standard_len (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_invalid_index (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_slicing_can_slice_again_after_slicing (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_slicing_cannot_combine_queries_once_sliced (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_slicing_cannot_filter_queryset_once_sliced (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_slicing_cannot_reorder_queryset_once_sliced (queries.tests.QuerySetSupportsPythonIdioms)	Pass
hint: inverting your ordering might do what you need	Pass
test_slicing_with_steps_can_be_used (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_slicing_with_tests_is_not_lazy (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_slicing_without_step_is_lazy (queries.tests.QuerySetSupportsPythonIdioms)	Pass
test_ticket_20955 (queries.tests.Ticket20955Tests)	Pass
test_col_alias_quoted (queries.tests.Queries6Tests)	Pass
test_distinct_ordered_sliced_subquery_aggregation (queries.tests.Queries6Tests)	Pass
test_multiple_columns_with_the_same_name_slice (queries.tests.Queries6Tests)	Pass
test_nested_queries_sql (queries.tests.Queries6Tests)	Pass
test_parallel_iterators (queries.tests.Queries6Tests)	Pass
test_ticket3739 (queries.tests.Queries6Tests)	Pass
test_ticket_11320 (queries.tests.Queries6Tests)	Pass
test_tickets_8921_9188 (queries.tests.Queries6Tests)	Pass
test_fk_reuse (queries.tests.JoinReuseTest)	Pass
test_fk_reuse_annotation (queries.tests.JoinReuseTest)	Pass
test_fk_reuse_disjunction (queries.tests.JoinReuseTest)	Pass
test_fk_reuse_order_by (queries.tests.JoinReuseTest)	Pass
test_fk_reuse_select_related (queries.tests.JoinReuseTest)	Pass
When a trimmable join is specified in the query (here school__), the	Pass
test_revfk_noreuse (queries.tests.JoinReuseTest)	Pass
test_revo2o_reuse (queries.tests.JoinReuseTest)	Pass
test_ticket_23605 (queries.tests.Ticket23605Tests)	Pass
test_exclude_many_to_many (queries.tests.ManyToManyExcludeTest)	Pass
test_ticket_12823 (queries.tests.ManyToManyExcludeTest)	Pass
test_ticket12239 (queries.tests.Queries2Tests)	Pass
test_ticket4289 (queries.tests.Queries2Tests)	Pass
test_ticket7759 (queries.tests.Queries2Tests)	Pass
test_empty_resultset_sql (queries.tests.WeirdQuerysetSlicingTests)	Pass
test_empty_sliced_subquery (queries.tests.WeirdQuerysetSlicingTests)	Pass
test_empty_sliced_subquery_exclude (queries.tests.WeirdQuerysetSlicingTests)	Pass
test_tickets_7698_10202 (queries.tests.WeirdQuerysetSlicingTests)	Pass
test_zero_length_values_slicing (queries.tests.WeirdQuerysetSlicingTests)	Pass
test_extra_multiple_select_params_values_order_by (queries.tests.ValuesQuerysetTests)	Pass
test_extra_select_params_values_order_in_extra (queries.tests.ValuesQuerysetTests)	Pass
test_extra_values (queries.tests.ValuesQuerysetTests)	Pass
test_extra_values_list (queries.tests.ValuesQuerysetTests)	Pass
test_extra_values_order_in_extra (queries.tests.ValuesQuerysetTests)	Pass
test_extra_values_order_multiple (queries.tests.ValuesQuerysetTests)	Pass
test_extra_values_order_twice (queries.tests.ValuesQuerysetTests)	Pass
test_field_error_values_list (queries.tests.ValuesQuerysetTests)	Pass
test_flat_extra_values_list (queries.tests.ValuesQuerysetTests)	Pass
test_flat_values_list (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_list_bad_field_name (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_list_expression (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_list_expression_with_default_alias (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_list_flat (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_list_with_fields (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_list_without_fields (queries.tests.ValuesQuerysetTests)	Pass
test_named_values_pickle (queries.tests.ValuesQuerysetTests)	Pass
test_in_query (queries.tests.ToFieldTests)	Pass
test_in_subquery (queries.tests.ToFieldTests)	Pass
test_nested_in_subquery (queries.tests.ToFieldTests)	Pass
test_recursive_fk (queries.tests.ToFieldTests)	Pass
test_recursive_fk_reverse (queries.tests.ToFieldTests)	Pass
test_reverse_in (queries.tests.ToFieldTests)	Pass
test_single_object (queries.tests.ToFieldTests)	Pass
test_single_object_reverse (queries.tests.ToFieldTests)	Pass
This should exclude Orders which have some items with status 1	Pass
Using exclude(condition) and exclude(Q(condition)) should	Pass
test_AB_ACB (queries.tests.UnionTests)	Pass
test_A_AB (queries.tests.UnionTests)	Pass
test_A_AB2 (queries.tests.UnionTests)	Pass
test_BAB_BAC (queries.tests.UnionTests)	Pass
test_BAB_BACB (queries.tests.UnionTests)	Pass
test_BA_BCA__BAB_BAC_BCA (queries.tests.UnionTests)	Pass
test_or_with_both_slice (queries.tests.QuerySetBitwiseOperationTests)	Pass
test_or_with_both_slice_and_ordering (queries.tests.QuerySetBitwiseOperationTests)	Pass
test_or_with_lhs_slice (queries.tests.QuerySetBitwiseOperationTests)	Pass
test_or_with_rhs_slice (queries.tests.QuerySetBitwiseOperationTests)	Pass
test_subquery_aliases (queries.tests.QuerySetBitwiseOperationTests)	Pass
test_distinct_ordered_sliced_subquery (queries.tests.SubqueryTests)	Pass
Subselects honor any manual ordering	Pass
Related objects constraints can safely contain sliced subqueries.	Pass
Slice a query that has a sliced subquery	Pass
Delete queries can safely contain sliced subqueries	Pass
test_isnull_filter_promotion (queries.tests.NullJoinPromotionOrTest)	Pass
test_null_join_demotion (queries.tests.NullJoinPromotionOrTest)	Pass
test_ticket_17886 (queries.tests.NullJoinPromotionOrTest)	Pass
test_ticket_21366 (queries.tests.NullJoinPromotionOrTest)	Pass
test_ticket_21748 (queries.tests.NullJoinPromotionOrTest)	Pass
test_ticket_21748_complex_filter (queries.tests.NullJoinPromotionOrTest)	Pass
test_ticket_21748_double_negated_and (queries.tests.NullJoinPromotionOrTest)	Pass
test_ticket_21748_double_negated_or (queries.tests.NullJoinPromotionOrTest)	Pass
test_disjunction_promotion1 (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion2 (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion3 (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion3_demote (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion4 (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion4_demote (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion5_demote (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion6 (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion7 (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion_fexpression (queries.tests.DisjunctionPromotionTests)	Pass
test_disjunction_promotion_select_related (queries.tests.DisjunctionPromotionTests)	Pass
test_extra_select_literal_percent_s (queries.tests.Queries5Tests)	Pass
test_ordering (queries.tests.Queries5Tests)	Pass
test_queryset_reuse (queries.tests.Queries5Tests)	Pass
test_ticket5261 (queries.tests.Queries5Tests)	Pass
test_ticket7045 (queries.tests.Queries5Tests)	Pass
test_ticket7256 (queries.tests.Queries5Tests)	Pass
test_ticket9848 (queries.tests.Queries5Tests)	Pass
test_exclude_multivalued_exists (queries.tests.ExcludeTests)	Pass
test_exclude_nullable_fields (queries.tests.ExcludeTests)	Pass
test_exclude_reverse_fk_field_ref (queries.tests.ExcludeTests)	Pass
test_exclude_subquery (queries.tests.ExcludeTests)	Pass
test_exclude_unsaved_o2o_object (queries.tests.ExcludeTests)	Pass
test_exclude_with_circular_fk_relation (queries.tests.ExcludeTests)	Pass
test_subquery_exclude_outerref (queries.tests.ExcludeTests)	Pass
test_ticket14511 (queries.tests.ExcludeTests)	Pass
test_to_field (queries.tests.ExcludeTests)	Pass
test_combine_join_reuse (queries.tests.Queries4Tests)	Pass
test_combine_or_filter_reuse (queries.tests.Queries4Tests)	Pass
test_filter_reverse_non_integer_pk (queries.tests.Queries4Tests)	Pass
test_join_reuse_order (queries.tests.Queries4Tests)	Pass
test_order_by_resetting (queries.tests.Queries4Tests)	Pass
test_order_by_reverse_fk (queries.tests.Queries4Tests)	Pass
test_ticket10181 (queries.tests.Queries4Tests)	Pass
test_ticket11811 (queries.tests.Queries4Tests)	Pass
test_ticket14876 (queries.tests.Queries4Tests)	Pass
test_ticket15316_exclude_false (queries.tests.Queries4Tests)	Pass
test_ticket15316_exclude_true (queries.tests.Queries4Tests)	Pass
test_ticket15316_filter_false (queries.tests.Queries4Tests)	Pass
test_ticket15316_filter_true (queries.tests.Queries4Tests)	Pass
test_ticket15316_one2one_exclude_false (queries.tests.Queries4Tests)	Pass
test_ticket15316_one2one_exclude_true (queries.tests.Queries4Tests)	Pass
test_ticket15316_one2one_filter_false (queries.tests.Queries4Tests)	Pass
test_ticket15316_one2one_filter_true (queries.tests.Queries4Tests)	Pass
test_ticket24525 (queries.tests.Queries4Tests)	Pass
test_ticket7095 (queries.tests.Queries4Tests)	Pass
test_avoid_infinite_loop_on_too_many_subqueries (queries.tests.Queries1Tests)	Pass
Valid query should be generated when fields fetched from joined tables	Pass
test_deferred_load_qs_pickling (queries.tests.Queries1Tests)	Pass
test_double_exclude (queries.tests.Queries1Tests)	Pass
test_error_raised_on_filter_with_dictionary (queries.tests.Queries1Tests)	Pass
test_exclude (queries.tests.Queries1Tests)	Pass
test_exclude_in (queries.tests.Queries1Tests)	Pass
test_excluded_intermediary_m2m_table_joined (queries.tests.Queries1Tests)	Pass
test_field_with_filterable (queries.tests.Queries1Tests)	Pass
get() should clear ordering for optimization purposes.	Pass
test_heterogeneous_qs_combination (queries.tests.Queries1Tests)	Pass
test_lookup_constraint_fielderror (queries.tests.Queries1Tests)	Pass
test_negate_field (queries.tests.Queries1Tests)	Pass
test_nested_exclude (queries.tests.Queries1Tests)	Pass
This test is related to the above one, testing that there aren't	Pass
test_order_by_rawsql (queries.tests.Queries1Tests)	Pass
test_order_by_tables (queries.tests.Queries1Tests)	Pass
test_reasonable_number_of_subq_aliases (queries.tests.Queries1Tests)	Pass
test_subquery_condition (queries.tests.Queries1Tests)	Pass
test_ticket10205 (queries.tests.Queries1Tests)	Pass
test_ticket10432 (queries.tests.Queries1Tests)	Pass
test_ticket1050 (queries.tests.Queries1Tests)	Pass
test_ticket10742 (queries.tests.Queries1Tests)	Pass
Meta.ordering=None works the same as Meta.ordering=[]	Pass
test_ticket1801 (queries.tests.Queries1Tests)	Pass
test_ticket19672 (queries.tests.Queries1Tests)	Pass
test_ticket2091 (queries.tests.Queries1Tests)	Pass
test_ticket2253 (queries.tests.Queries1Tests)	Pass
test_ticket2306 (queries.tests.Queries1Tests)	Pass
test_ticket2400 (queries.tests.Queries1Tests)	Pass
test_ticket2496 (queries.tests.Queries1Tests)	Pass
test_ticket3037 (queries.tests.Queries1Tests)	Pass
test_ticket3141 (queries.tests.Queries1Tests)	Pass
test_ticket4358 (queries.tests.Queries1Tests)	Pass
test_ticket4464 (queries.tests.Queries1Tests)	Pass
test_ticket4510 (queries.tests.Queries1Tests)	Pass
test_ticket6074 (queries.tests.Queries1Tests)	Pass
test_ticket6154 (queries.tests.Queries1Tests)	Pass
test_ticket6981 (queries.tests.Queries1Tests)	Pass
test_ticket7076 (queries.tests.Queries1Tests)	Pass
test_ticket7096 (queries.tests.Queries1Tests)	Pass
test_ticket7155 (queries.tests.Queries1Tests)	Pass
test_ticket7181 (queries.tests.Queries1Tests)	Pass
test_ticket7235 (queries.tests.Queries1Tests)	Pass
test_ticket7277 (queries.tests.Queries1Tests)	Pass
test_ticket7323 (queries.tests.Queries1Tests)	Pass
test_ticket7378 (queries.tests.Queries1Tests)	Pass
test_ticket7791 (queries.tests.Queries1Tests)	Pass
test_ticket7813 (queries.tests.Queries1Tests)	Pass
test_ticket8439 (queries.tests.Queries1Tests)	Pass
test_ticket9926 (queries.tests.Queries1Tests)	Pass
test_ticket9985 (queries.tests.Queries1Tests)	Pass
test_ticket9997 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_1 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_2 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_3 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_4 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_5 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_6 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_7 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_8 (queries.tests.Queries1Tests)	Pass
test_ticket_10790_combine (queries.tests.Queries1Tests)	Pass
test_ticket_20250 (queries.tests.Queries1Tests)	Pass
test_tickets_1878_2939 (queries.tests.Queries1Tests)	Pass
test_tickets_2076_7256 (queries.tests.Queries1Tests)	Pass
test_tickets_2080_3592 (queries.tests.Queries1Tests)	Pass
test_tickets_2874_3002 (queries.tests.Queries1Tests)	Pass
test_tickets_4088_4306 (queries.tests.Queries1Tests)	Pass
test_tickets_5321_7070 (queries.tests.Queries1Tests)	Pass
test_tickets_5324_6704 (queries.tests.Queries1Tests)	Pass
test_tickets_6180_6203 (queries.tests.Queries1Tests)	Pass
test_tickets_7087_12242 (queries.tests.Queries1Tests)	Pass
test_tickets_7204_7506 (queries.tests.Queries1Tests)	Pass
test_tickets_7448_7707 (queries.tests.Queries1Tests)	Pass

Ridges.AI

             # If the left side of the join was already relabeled, use the
             # updated alias.
             join = join.relabeled_clone(change_map)
+            new_alias = self.join(join, reuse=reuse)
+            new_alias = self.join(join, reuse=reuse, avoid_aliases=set(change_map.values()))
             if join.join_type == INNER:
                 rhs_votes.add(new_alias)
             # We can't reuse the same join again in the query. If we have two
             for model, values in seen.items():
                 callback(target, model, values)
+    def table_alias(self, table_name, create=False, filtered_relation=None):
+    def table_alias(self, table_name, create=False, filtered_relation=None, avoid_aliases=None):
         """
         Return a table alias for the given table_name and whether this is a
         new alias or not.
         If 'create' is true, a new alias is always created. Otherwise, the
         most recently created alias for the table (if one exists) is reused.
+        If 'avoid_aliases' is provided, the new alias will not be any of the
+        values in this set.
         """
         alias_list = self.table_map.get(table_name)
         if not create and alias_list:
         # Create a new alias for this table.
         if alias_list:
+            alias = '%s%d' % (self.alias_prefix, len(self.alias_map) + 1)
+            # Start with the next available alias number
+            alias_num = len(self.alias_map) + 1
+            if avoid_aliases:
+                # Keep incrementing until we find an alias not in avoid_aliases
+                while True:
+                    alias = '%s%d' % (self.alias_prefix, alias_num)
+                    if alias not in avoid_aliases:
+                        break
+                    alias_num += 1
+            else:
+                alias = '%s%d' % (self.alias_prefix, alias_num)
             alias_list.append(alias)
         else:
             # The first occurrence of a table uses the table name directly.
         relabelling any references to them in select columns and the where
         clause.
         """
+        assert set(change_map).isdisjoint(change_map.values())
+        # Resolve any chained aliases to avoid intersecting keys and values
+        # For example, if change_map is {'T4': 'T5', 'T5': 'T6'}, we need to
+        # resolve it to {'T4': 'T6', 'T5': 'T6'} to prevent T5 from being
+        # renamed twice.
+        resolved_change_map = {}
+        for old_alias, new_alias in change_map.items():
+            # Follow the chain of aliases to find the final destination
+            final_alias = new_alias
+            seen_aliases = set()
+            while final_alias in change_map:
+                # Detect cycles to prevent infinite loops
+                if final_alias in seen_aliases:
+                    raise ValueError("Circular reference detected in change_map: %s" % change_map)
+                seen_aliases.add(final_alias)
+                final_alias = change_map[final_alias]
+            resolved_change_map[old_alias] = final_alias
+        # Now ensure no alias appears as both a key and a value
+        assert set(resolved_change_map).isdisjoint(resolved_change_map.values())
+        # Use the resolved change map for the actual changes
+        change_map = resolved_change_map
         # 1. Update references in "select" (normal columns plus aliases),
         # "group by" and "where".
         """
         return len([1 for count in self.alias_refcount.values() if count])
+    def join(self, join, reuse=None):
+    def join(self, join, reuse=None, avoid_aliases=None):
         """
         Return an alias for the 'join', either reusing an existing alias for
         that join or creating a new one. 'join' is either a base_table_class or
         The 'reuse' parameter can be either None which means all joins are
         reusable, or it can be a set containing the aliases that can be reused.
+        The 'avoid_aliases' parameter can be a set of aliases that should not
+        be used for new aliases.
         A join is always created as LOUTER if the lhs alias is LOUTER to make
         sure chains like t1 LOUTER t2 INNER t3 aren't generated. All new
             return reuse_alias
         # No reuse is possible, so we need a new alias.
+        alias, _ = self.table_alias(join.table_name, create=True, filtered_relation=join.filtered_relation)
+        alias, _ = self.table_alias(join.table_name, create=True, filtered_relation=join.filtered_relation, avoid_aliases=avoid_aliases)
         if join.join_type:
             if self.alias_map[join.parent_alias].join_type == LOUTER or join.nullable:
                 join_type = LOUTER

apple

Pending

Initializing Agent

Running Agent

Initializing Evaluation

Running Evaluation

Passed