Skip to content

columnsWithAlias returns ".Column" for columns without tables #357

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
Closed
orivej opened this issue Jul 23, 2015 · 2 comments
Closed

columnsWithAlias returns ".Column" for columns without tables #357

orivej opened this issue Jul 23, 2015 · 2 comments
Labels
bug
Milestone
v1.3

Comments

@orivej
Copy link

orivej commented Jul 23, 2015

When columnsWithAlias is true, the call to Columns after a query like "select 1 as A" will describe the column as ".A". Is this intended? If yes, this should be documented in the README: ".A" as a column name is unexpected, in particular it can not be used in an "order by" clause.

(columnsWithAlias was introduced in #289.)
@arnehormann
Copy link
Member

I'm ignoring the issue for now (no time), but I'd still like to help you with the underlying problem:
you can use the column index in ORDER BY, e.g. ORDER BY 1 asc, 4 desc.

julienschmidt added a commit that referenced this issue Jul 24, 2015
@julienschmidt
columnsWithAlias: Only prepend table name if not empty
03a543a 
Fixes Issue #357
@julienschmidt julienschmidt mentioned this issue Jul 24, 2015
Merged
1 task
@julienschmidt
Copy link
Member

It's a bug. PR #359 should fix it.

@julienschmidt julienschmidt added this to the v1.3 milestone Jul 24, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
v1.3
Development

No branches or pull requests
3 participants
@orivej @julienschmidt @arnehormann