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

Table name autocomplete broken in SQL Lab #19008

Closed
3 tasks
villebro opened this issue Mar 3, 2022 · 1 comment · Fixed by #19152
Closed
3 tasks

Table name autocomplete broken in SQL Lab #19008

villebro opened this issue Mar 3, 2022 · 1 comment · Fixed by #19152
Assignees
Labels
#bug Bug report preset-io sqllab:editor sqllab Namespace | Anything related to the SQL Lab

Comments

@villebro
Copy link
Member

villebro commented Mar 3, 2022

Currently table names are not added to autocomplete in SQL Lab

How to reproduce the bug

  1. Go to SQL Lab
  2. Choose the Examples database and related schema (Pubic for Postgres)
  3. Check a name of a table ("Flights" should be present)
  4. Type "select * from Fli" in the Editor and notice that "Flights" doesn't appear in the dropdown

Expected results

All table names should be added to the autocomplete dropdown

Actual results

No tables are visible in the autocomplete dropdown

Screenshots

In the database, we see that the table "Flights" is present:
image

However, the table isn't available in the autocomplete dropdown:
image

Environment

(please complete the following information):

  • browser type and version:
  • superset version: master
  • python version: Python 3.8
  • node.js version: Node 16
  • any feature flags active:

Checklist

Make sure to follow these steps before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • I have reproduced the issue with at least the latest released version of superset.
  • I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

@villebro villebro added the #bug Bug report label Mar 3, 2022
@villebro villebro added sqllab Namespace | Anything related to the SQL Lab sqllab:editor labels Mar 3, 2022
@kamiljune
Copy link

Same problem on master branch, rollback to 1.4.1 solved this problem.
When you doing this, pls remember to downgrade database:
superset db downgrade 32646df09c64

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
#bug Bug report preset-io sqllab:editor sqllab Namespace | Anything related to the SQL Lab
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants