Parser can't handle using some function names as column id

Question

Parser can't handle using some function names as column id

machow opened this issue 8 years ago · 4 comments

machow commented 8 years ago

cc @colinricardo

SELECT date FROM y chokes the parser, but SELECT date1 FROM y doesn't.

Answer 1 · 2017-06-08T17:59:49.000Z

@colinricardo how much of a priority is this? Do you know if/when it would block course development?

Answer 2 · 2017-06-08T18:11:14.000Z

@machow not a priority I don't think! A quick fix would be to change the data column in the database to something less offensive like timestamp. Thoughts?

Answer 3 · 2017-06-08T18:21:15.000Z

Ah, I spaced out and forgot that the column in the db is named date--I'll just fix it this week, since it will probably be an inconvenience throughout the sql courses!

Answer 4 · 2017-06-08T19:18:47.000Z

a bit easier than expected! Should be updated on sqlwhat-viewer also.