Specify (and check) SQL edge cases

pixelspark / catena

Catena is a distributed database based on a blockchain, accessible using SQL.

MIT License

302 stars 23 forks source link

Open pixelspark opened 7 years ago

pixelspark commented 7 years ago

[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 commented 7 years ago

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