#30099: Filter by Count annotated inside Subquery
-------------------------------------+-------------------------------------
Reporter: MrFus10n | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 2.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: subquery annotate | Triage Stage: Accepted
filter |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by MrFus10n):
I didn't change anything yet. Just cloned repo, setup virtualenv and
executed {{{tests/runtests.py}}}. I am using windows 7, python 3.5.3.
This is in the middle of testing:
{{{
Exception in thread Thread-805:
Traceback (most recent call last):
File "C:\Python\35x32\lib\threading.py", line 914, in _bootstrap_inner
self.run()
File "c:\dev\projects\django\django\test\testcases.py", line 1364, in
run
connections.close_all()
File "c:\dev\projects\django\django\db\utils.py", line 224, in close_all
connection.close()
File "c:\dev\projects\django\django\db\backends\sqlite3\base.py", line
237, in close
self.validate_thread_sharing()
File "c:\dev\projects\django\django\db\backends\base\base.py", line 531,
in validate_thread_sharing
% (self.alias, self._thread_ident, _thread.get_ident())
django.db.utils.DatabaseError: DatabaseWrapper objects created in a thread
can only be used in that same thread. The object with alias 'other' was
created in thread id 11452 and this is thread id 1148.
}}}
And this is after it's done:
{{{
======================================================================
ERROR: test_unicode_file_name (i18n.test_extraction.BasicExtractorTests)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\dev\projects\django\tests\i18n\test_extraction.py", line 216,
in test_unicode_file_name
management.call_command('makemessages', locale=[LOCALE], verbosity=0)
File "c:\dev\projects\django\django\core\management\__init__.py", line
148, in call_command
return command.execute(*args, **defaults)
File "c:\dev\projects\django\django\core\management\base.py", line 364,
in execute
output = self.handle(*args, **options)
File
"c:\dev\projects\django\django\core\management\commands\makemessages.py",
line 384, in handle
potfiles = self.build_potfiles()
File
"c:\dev\projects\django\django\core\management\commands\makemessages.py",
line 426, in build_potfiles
self.process_files(file_list)
File
"c:\dev\projects\django\django\core\management\commands\makemessages.py",
line 519, in process_files
self.process_locale_dir(locale_dir, files)
File
"c:\dev\projects\django\django\core\management\commands\makemessages.py",
line 583, in process_locale_dir
input_files_list.write(('\n'.join(input_files)))
File "C:\Python\35x32\lib\encodings\cp1251.py", line 19, in encode
return codecs.charmap_encode(input,self.errors,encoding_table)[0]
UnicodeEncodeError: 'charmap' codec can't encode character '\xe9' in
position 241: character maps to <undefined>
======================================================================
ERROR: test_strip_tags_files (utils_tests.test_html.TestUtilsHtml)
(filename='strip_tags1.html')
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\dev\projects\django\tests\utils_tests\test_html.py", line 103,
in test_strip_tags_files
content = fp.read()
File "C:\Python\35x32\lib\encodings\cp1251.py", line 23, in decode
return codecs.charmap_decode(input,self.errors,decoding_table)[0]
UnicodeDecodeError: 'charmap' codec can't decode byte 0x98 in position
33114: character maps to <undefined>
======================================================================
ERROR: test_content_saving (file_storage.tests.ContentFileStorageTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\dev\projects\django\tests\file_storage\tests.py", line 968, in
test_content_saving
self.storage.save('unicode.txt', ContentFile("espa\xf1ol"))
File "c:\dev\projects\django\django\core\files\storage.py", line 52, in
save
return self._save(name, content)
File "c:\dev\projects\django\django\core\files\storage.py", line 274, in
_save
_file.write(chunk)
File "C:\Python\35x32\lib\encodings\cp1251.py", line 19, in encode
return codecs.charmap_encode(input,self.errors,encoding_table)[0]
UnicodeEncodeError: 'charmap' codec can't encode character '\xf1' in
position 4: character maps to <undefined>
======================================================================
FAIL: test_all (admin_scripts.tests.DiffSettings)
The all option also shows settings with the default value.
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\dev\projects\django\tests\admin_scripts\tests.py", line 2247,
in test_all
self.assertNoOutput(err)
File "C:\dev\projects\django\tests\admin_scripts\tests.py", line 189, in
assertNoOutput
self.assertEqual(len(stream), 0, "Stream should be empty: actually
contains '%s'" % stream)
AssertionError: 1064 != 0 : Stream should be empty: actually contains
'Traceback (most recent call last):
File "./manage.py", line 21, in <module>
main()
File "./manage.py", line 17, in main
execute_from_command_line(sys.argv)
File "C:\dev\projects\django\django\core\management\__init__.py", line
381, in execute_from_command_line
utility.execute()
File "C:\dev\projects\django\django\core\management\__init__.py", line
375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\dev\projects\django\django\core\management\base.py", line 323,
in run_from_argv
self.execute(*args, **cmd_options)
File "C:\dev\projects\django\django\core\management\base.py", line 373,
in execute
self.stdout.write(output)
File "C:\dev\projects\django\django\core\management\base.py", line 145,
in write
self._out.write(style_func(msg))
File "C:\Python\35x32\lib\encodings\cp1251.py", line 19, in encode
return codecs.charmap_encode(input,self.errors,encoding_table)[0]
UnicodeEncodeError: 'charmap' codec can't encode character '\xe5' in
position 4960: character maps to <undefined>
'
======================================================================
FAIL: test_unified_all (admin_scripts.tests.DiffSettings)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\dev\projects\django\tests\admin_scripts\tests.py", line 2285,
in test_unified_all
self.assertNoOutput(err)
File "C:\dev\projects\django\tests\admin_scripts\tests.py", line 189, in
assertNoOutput
self.assertEqual(len(stream), 0, "Stream should be empty: actually
contains '%s'" % stream)
AssertionError: 1064 != 0 : Stream should be empty: actually contains
'Traceback (most recent call last):
File "./manage.py", line 21, in <module>
main()
File "./manage.py", line 17, in main
execute_from_command_line(sys.argv)
File "C:\dev\projects\django\django\core\management\__init__.py", line
381, in execute_from_command_line
utility.execute()
File "C:\dev\projects\django\django\core\management\__init__.py", line
375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\dev\projects\django\django\core\management\base.py", line 323,
in run_from_argv
self.execute(*args, **cmd_options)
File "C:\dev\projects\django\django\core\management\base.py", line 373,
in execute
self.stdout.write(output)
File "C:\dev\projects\django\django\core\management\base.py", line 145,
in write
self._out.write(style_func(msg))
File "C:\Python\35x32\lib\encodings\cp1251.py", line 19, in encode
return codecs.charmap_encode(input,self.errors,encoding_table)[0]
UnicodeEncodeError: 'charmap' codec can't encode character '\xe5' in
position 4888: character maps to <undefined>
'
======================================================================
FAIL: test_accent
(dbshell.test_postgresql_psycopg2.PostgreSqlDbshellCommandTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\dev\projects\django\tests\dbshell\test_postgresql_psycopg2.py",
line 100, in test_accent
pgpass_string,
AssertionError: Tuples differ: (['ps[32 chars]st', '-p', '444', 'dbname'],
None) != (['ps[32 chars]st', '-p', '444', 'dbname'],
'somehost:444:dbname:r\xf4le:s\xe9same')
First differing element 1:
None
'somehost:444:dbname:r\xf4le:s\xe9same'
- (['psql', '-U', 'r\xf4le', '-h', 'somehost', '-p', '444', 'dbname'],
None)
? ------
+ (['psql', '-U', 'r\xf4le', '-h', 'somehost', '-p', '444', 'dbname'],
+ 'somehost:444:dbname:r\xf4le:s\xe9same')
----------------------------------------------------------------------
Ran 12577 tests in 2925.839s
FAILED (failures=3, errors=3, skipped=948, expected failures=4)
Destroying test database for alias 'default'\u2026
Destroying test database for alias 'other'\u2026
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30099#comment:10>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/066.57568c084d569cbd63cde788f8394d6b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
