﻿id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33643	inspectdb crashes on Oracle databases with functional indexes.	Scott	Scott	"I'm getting the following error when using inspectdb with an Oracle database. The column in question  is a hidden column that's automatically created by the database, and doesn't need a model. The command runs fine if I add something to skip these columns. Here's a related issue in SQLAlchemy: https://github.com/sqlalchemy/sqlalchemy/issues/1513

{{{
Traceback (most recent call last):
  File ""xxxx\envs\django\Scripts\manage.py-script.py"", line 33, in <module>
    sys.exit(load_entry_point('hero', 'console_scripts', 'manage.py')())
  File ""xxxx\__init__.py"", line 17, in manage
    execute_from_command_line(sys.argv)
  File ""xxxx\envs\django\lib\site-packages\django\core\management\__init__.py"", line 446, in execute_from_command_line    utility.execute()
  File ""xxxx\envs\django\lib\site-packages\django\core\management\__init__.py"", line 440, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""xxxx\envs\django\lib\site-packages\django\core\management\base.py"", line 414, in run_from_argv
    self.execute(*args, **cmd_options)
  File ""xxxx\envs\django\lib\site-packages\django\core\management\base.py"", line 460, in execute
    output = self.handle(*args, **options)
  File ""xxxx\envs\django\lib\site-packages\django\core\management\commands\inspectdb.py"", line 46, in handle
    for line in self.handle_inspection(options):
  File ""xxxx\envs\django\lib\site-packages\django\core\management\commands\inspectdb.py"", line 226, in handle_inspection
    yield from self.get_meta(
  File ""xxxx\envs\django\lib\site-packages\django\core\management\commands\inspectdb.py"", line 348, in get_meta       
    str(tuple(column_to_field_name[c] for c in columns))
  File ""xxxx\envs\django\lib\site-packages\django\core\management\commands\inspectdb.py"", line 348, in <genexpr>      
    str(tuple(column_to_field_name[c] for c in columns))
KeyError: 'sys_nc00106$'
}}}
"	Bug	closed	Core (Management commands)	4.0	Normal	fixed	oracle inspectdb		Ready for checkin	1	0	0	0	0	0
