10000 40-csvql: Setting column Source to be the table name by djhworld · Pull Request #92 · campoy/justforfunc · GitHub
[go: up one dir, main page]
Skip to content

40-csvql: Setting column Source to be the table name #92

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.

Sign up for GitHub

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

Jump to bottom
Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

40-csvql: Setting column Source to be the table name #92

wants to merge 1 commit into from

Conversation

djhworld
Copy link
@djhworld djhworld commented Nov 10, 2018 •
edited
Loading

Just a small issue.

With the code in the video, if you try and apply a projection to a query, you get this error

mysql> select name from cities;
ERROR 1105 (HY000): unknown error: table "cities" does not have column "name"

This is because the Source attribute in the Column was being set as the path of the CSV file, rather than the table name.

This PR fixes issue #93

mysql> select name, country from cities where country <> 'USA';
+-----------+---------+
| name      | country |
+-----------+---------+
| Barcelona | Spain   |
| Paris     | France  |
| Shanghai  | China   |
+-----------+---------+
3 rows in set (0.00 sec)

@djhworld djhworld mentioned this pull request Nov 10, 2018
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
1 participant
@djhworld
0