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

Query returns no data SQL Lab #8909

Closed
klazaj opened this issue Jan 2, 2020 · 1 comment
Closed

Query returns no data SQL Lab #8909

klazaj opened this issue Jan 2, 2020 · 1 comment
Labels

Comments

@klazaj
Copy link

@klazaj klazaj commented Jan 2, 2020

When I run the query select * from table where 'Column' = 'Value' in SQL Lab, the query returns no data, even though there are rows that satisfy that condition.

Is there something wrong with my where condition?

PS:
I have also tried select * from table where Column = 'Value', and I get the following Error message:

column "column" does not exist LINE 1: select * from table where Column = 'Value' ^ HINT: Perhaps you meant to reference the column "table.Column".

When I try select * from table where table.Column = 'Value' there's again a similar Error message:

column table.column does not exist LINE 1: select * from table where table.Column = 'Value' ^ HINT: Perhaps you meant to reference the column "table.Column".

I assume the problem is with the capital C in Column, hence why I put the single quotes in the query.

@issue-label-bot issue-label-bot bot added the #bug label Jan 2, 2020
@issue-label-bot

This comment has been minimized.

Copy link

@issue-label-bot issue-label-bot bot commented Jan 2, 2020

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.63. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

@dpgaspar dpgaspar added #question and removed #bug labels Jan 2, 2020
@klazaj klazaj closed this Jan 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.