catena icon indicating copy to clipboard operation
catena copied to clipboard
verified publisher icon pixelspark

Specify (and check) SQL edge cases

Open pixelspark opened this issue 8 years ago • 1 comments

  • [x] What happens when selecting a column that does not exist? (SQLite: interpret the column name as string??). Suggestion: disallow completely.

  • [ ] How are bare columns dealt with? (SQLite: see here, especially the part on 'special processing for min/max'). Suggestion: disallow completely.

pixelspark avatar Nov 04 '17 12:11 pixelspark

Column names are now checked. As we do not yet support aggregations, bare columns are not yet an issue (leaving this open until then)

pixelspark avatar Nov 05 '17 09:11 pixelspark