Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Left Pane is not shown when database contains table that name has unicode characters (MSSQL) #1178

Closed
kitsuyui opened this issue Jul 11, 2016 · 0 comments

Comments

@kitsuyui
Copy link
Contributor

kitsuyui commented Jul 11, 2016

not shown

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1475, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1461, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 477, in wrapper
    resp = resource(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/flask_login.py", line 792, in decorated_view
    return func(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/flask/views.py", line 84, in view
    return self.dispatch_request(*args, **kwargs)
  File "/opt/redash/redash.0.11.0.b1903/redash/handlers/base.py", line 25, in dispatch_request
    return super(BaseResource, self).dispatch_request(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/flask_restful/__init__.py", line 587, in dispatch_request
    resp = meth(*args, **kwargs)
  File "/opt/redash/redash.0.11.0.b1903/redash/handlers/data_sources.py", line 105, in get
    schema = data_source.get_schema()
  File "/opt/redash/redash.0.11.0.b1903/redash/models.py", line 412, in get_schema
    schema = sorted(query_runner.get_schema(get_stats=refresh), key=lambda t: t['name'])
  File "/opt/redash/redash.0.11.0.b1903/redash/query_runner/__init__.py", line 117, in get_schema
    self._get_tables(schema_dict)
  File "/opt/redash/redash.0.11.0.b1903/redash/query_runner/mssql.py", line 95, in _get_tables
    table_name = '{}.{}'.format(row['table_schema'], row['table_name'])

Steps to Reproduce

Technical details:

Redash Version: v0.10.1.b1834, 0.11.0 - RC
Browser/OS: Google Chrome / OSX / Server: Ubuntu Linux 16.04 LTS
How did you install Redash: used setup/ubuntu/bootstrap.sh

@arikfr arikfr closed this as completed in 74021c2 Jul 11, 2016
simo7 pushed a commit to pubnative/redash that referenced this issue Sep 22, 2016
…le that name has unicode characters (MSSQL)

- Update table_name to be unicode (not str).
dairyo pushed a commit to KiiCorp/redash that referenced this issue Mar 1, 2019
…le that name has unicode characters (MSSQL)

- Update table_name to be unicode (not str).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant