====================================================================== ERROR: test_empty_result_set (postgres_tests.test_aggregates.TestGeneralAggregate.test_empty_result_set) [] (aggregation=(BitXor(F(integer_field)), None)) ---------------------------------------------------------------------- Traceback (most recent call last): File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 57, in testPartExecutor yield File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 538, in subTest yield File "C:\Users\smith\projects\django\tests\postgres_tests\test_aggregates.py", line 106, in test_empty_result_set values = AggregateTestModel.objects.none().aggregate( ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\models\query.py", line 571, in aggregate self._validate_values_are_expressions( ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\models\query.py", line 1945, in _validate_values_are_expressions raise TypeError( TypeError: QuerySet.aggregate() received non-expression(s): (BitXor(F(integer_field)), None). ====================================================================== ERROR: test_ops_class (indexes.tests.SchemaIndexesPostgreSQLTests.test_ops_class) ---------------------------------------------------------------------- Traceback (most recent call last): File "C:\Users\smith\projects\django\django\db\backends\utils.py", line 87, in _execute return self.cursor.execute(sql) ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\.venv\Lib\site-packages\psycopg\cursor.py", line 723, in execute raise ex.with_traceback(None) ^^^^^^^^^^^^^^^^^ psycopg.errors.DuplicateTable: relation "test_ops_class" already exists The above exception was the direct cause of the following exception: Traceback (most recent call last): File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 57, in testPartExecutor yield File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 623, in run self._callTestMethod(testMethod) ^^^^^^^^^^^^^^^^^ File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 579, in _callTestMethod if method() is not None: ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\tests\indexes\tests.py", line 191, in test_ops_class editor.add_index(IndexedArticle2, index) ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\backends\postgresql\schema.py", line 324, in add_index self.execute( File "C:\Users\smith\projects\django\django\db\backends\postgresql\schema.py", line 45, in execute return super().execute(sql, params) ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\backends\base\schema.py", line 201, in execute cursor.execute(sql, params) ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\backends\utils.py", line 67, in execute return self._execute_with_wrappers( ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\backends\utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\backends\utils.py", line 84, in _execute with self.db.wrap_database_errors: ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\django\db\backends\utils.py", line 87, in _execute return self.cursor.execute(sql) ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\.venv\Lib\site-packages\psycopg\cursor.py", line 723, in execute raise ex.with_traceback(None) ^^^^^^^^^^^^^^^^^ django.db.utils.ProgrammingError: relation "test_ops_class" already exists ====================================================================== FAIL: test_foreign_data_wrapper (inspectdb.tests.InspectDBTransactionalTests.test_foreign_data_wrapper) ---------------------------------------------------------------------- Traceback (most recent call last): File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 57, in testPartExecutor yield File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 623, in run self._callTestMethod(testMethod) ^^^^^^^^^^^^^^^^^ File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 579, in _callTestMethod if method() is not None: ^^^^^^^^^^^^^^^^^ File "C:\Users\smith\projects\django\tests\inspectdb\tests.py", line 615, in test_foreign_data_wrapper self.assertIn(foreign_table_model, output) ^^^^^^^^^^^^^^^^^ File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 1140, in assertIn self.fail(self._formatMessage(msg, standardMsg)) ^^^^^^^^^^^^^^^^^ File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.11_3.11.752.0_x64__qbz5n2kfra8p0\Lib\unittest\case.py", line 703, in fail raise self.failureException(msg) ^^^^^^^^^^^^^^^^^ AssertionError: 'class InspectdbIrisForeignTable(models.Model):' not found in '# This is an auto-generated Django model module.\n# You\'ll have to do the following manually to clean this up:\n# * Rearrange models\' order\n# * Make sure each model has one field with primary_key=True\n# * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior\n# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table\n# Feel free to rename the models, but don\'t rename db_table values or field names.\nfrom django.db import models\n\n\nclass InspectdbCharfielddbcollation(models.Model):\n char_field = models.CharField(max_length=10, db_collation=\'sv-x-icu\')\n\n class Meta:\n managed = False\n db_table = \'inspectdb_charfielddbcollation\'\n\n\nclass InspectdbCharfieldunlimited(models.Model):\n char_field = models.CharField()\n\n class Meta:\n managed = False\n db_table = \'inspectdb_charfieldunlimited\'\n\n\nclass InspectdbColumntypes(models.Model):\n big_int_field = models.BigIntegerField()\n bool_field = models.BooleanField()\n null_bool_field = models.BooleanField(blank=True, null=True)\n char_field = models.CharField(max_length=10)\n null_char_field = models.CharField(max_length=10, blank=True, null=True)\n date_field = models.DateField()\n date_time_field = models.DateTimeField()\n decimal_field = models.DecimalField(max_digits=6, decimal_places=1)\n email_field = models.CharField(max_length=254)\n file_field = models.CharField(max_length=100)\n file_path_field = models.CharField(max_length=100)\n float_field = models.FloatField()\n int_field = models.IntegerField()\n gen_ip_address_field = models.GenericIPAddressField()\n pos_big_int_field = models.BigIntegerField()\n pos_int_field = models.IntegerField()\n pos_small_int_field = models.SmallIntegerField()\n slug_field = models.CharField(max_length=50)\n small_int_field = models.SmallIntegerField()\n text_field = models.TextField()\n time_field = models.TimeField()\n url_field = models.CharField(max_length=200)\n uuid_field = models.UUIDField()\n\n class Meta:\n managed = False\n db_table = \'inspectdb_columntypes\'\n\n\nclass InspectdbDbcomment(models.Model):\n rank = models.IntegerField(db_comment="\'Rank\' column comment")\n\n class Meta:\n managed = False\n db_table = \'inspectdb_dbcomment\'\n db_table_comment = \'Custom table comment\'\n\n\nclass InspectdbDigitsincolumnname(models.Model):\n number_123 = models.CharField(db_column=\'123\', max_length=11) # Field renamed because it wasn\'t a valid Python identifier.\n number_4extra = models.CharField(db_column=\'4extra\', max_length=11) # Field renamed because it wasn\'t a valid Python identifier.\n number_45extra = models.CharField(db_column=\'45extra\', max_length=11) # Field renamed because it wasn\'t a valid Python identifier.\n\n class Meta:\n managed = False\n db_table = \'inspectdb_digitsincolumnname\'\n\n\nclass InspectdbForeignkeytofield(models.Model):\n to_field_fk = models.ForeignKey(\'InspectdbPeoplemoredata\', models.DO_NOTHING, to_field=\'people_unique_id\')\n\n class Meta:\n managed = False\n db_table = \'inspectdb_foreignkeytofield\'\n\n\nclass InspectdbFuncuniqueconstraint(models.Model):\n name = models.CharField(max_length=255)\n rank = models.IntegerField()\n\n # A unique constraint could not be introspected.\n class Meta:\n managed = False\n db_table = \'inspectdb_funcuniqueconstraint\'\n# Unable to inspect table \'inspectdb_iris_foreign_table\'\n# The error was: could not stat file "nul": Invalid argument\n\n\nclass InspectdbJsonfieldcolumntype(models.Model):\n json_field = models.JSONField()\n null_json_field = models.JSONField(blank=True, null=True)\n\n class Meta:\n managed = False\n db_table = \'inspectdb_jsonfieldcolumntype\'\n\n\nclass InspectdbMessage(models.Model):\n from_field = models.ForeignKey(\'InspectdbPeople\', models.DO_NOTHING, db_column=\'from_id\') # Field renamed because it was a Python reserved word.\n author = models.ForeignKey(\'InspectdbPeople\', models.DO_NOTHING, related_name=\'inspectdbmessage_author_set\')\n\n class Meta:\n managed = False\n db_table = \'inspectdb_message\'\n\n\nclass InspectdbPeople(models.Model):\n name = models.CharField(max_length=255)\n parent = models.ForeignKey(\'self\', models.DO_NOTHING)\n\n class Meta:\n managed = False\n db_table = \'inspectdb_people\'\n\n\nclass InspectdbPeopledata(models.Model):\n people_pk = models.OneToOneField(InspectdbPeople, models.DO_NOTHING, primary_key=True)\n ssn = models.CharField(max_length=11)\n\n class Meta:\n managed = False\n db_table = \'inspectdb_peopledata\'\n\n\nclass InspectdbPeoplemoredata(models.Model):\n people_unique = models.OneToOneField(InspectdbPeople, models.DO_NOTHING)\n message = models.ForeignKey(InspectdbMessage, models.DO_NOTHING, blank=True, null=True)\n license = models.CharField(max_length=255)\n\n class Meta:\n managed = False\n db_table = \'inspectdb_peoplemoredata\'\n\n\nclass InspectdbSpecialTableName(models.Model):\n field = models.IntegerField()\n field_field = models.IntegerField(db_column=\'Field_\') # Field name made lowercase. Field renamed because it ended with \'_\'.\n field_field_0 = models.IntegerField(db_column=\'Field__\') # Field name made lowercase. Field renamed because it contained more than one \'_\' in a row. Field renamed because it ended with \'_\'. Field renamed because of name conflict.\n field_field_1 = models.IntegerField(db_column=\'__field\') # Field renamed because it contained more than one \'_\' in a row. Field renamed because it started with \'_\'. Field renamed because of name conflict.\n prc_x = models.IntegerField(db_column=\'prc(%) x\') # Field renamed to remove unsuitable characters.\n tamaño = models.IntegerField()\n\n class Meta:\n managed = False\n db_table = \'inspectdb_special.table name\'\n\n\nclass InspectdbTextfielddbcollation(models.Model):\n text_field = models.TextField(db_collation=\'sv-x-icu\')\n\n class Meta:\n managed = False\n db_table = \'inspectdb_textfielddbcollation\'\n\n\nclass InspectdbUniquetogether(models.Model):\n field1 = models.IntegerField()\n field2 = models.CharField(max_length=10)\n from_field = models.IntegerField(db_column=\'from\') # Field renamed because it was a Python reserved word.\n non_unique_column = models.IntegerField(db_column=\'non__unique_column\') # Field renamed because it contained more than one \'_\' in a row.\n non_unique_column_0 = models.IntegerField(db_column=\'non_unique__column\') # Field renamed because it contained more than one \'_\' in a row. Field renamed because of name conflict.\n\n class Meta:\n managed = False\n db_table = \'inspectdb_uniquetogether\'\n unique_together = ((\'from_field\', \'field1\'), (\'non_unique_column\', \'non_unique_column_0\'), (\'field1\', \'field2\'),)\n'