Bookworm-project / BookwormDB

Tools for text tokenization and encoding
MIT License
84 stars 12 forks source link

Variables cannot be named with MySQL reserved words #23

Closed bmschmidt closed 10 years ago

bmschmidt commented 12 years ago

We found that table creation fails if you have a variable named "to", because "TO" is a reserved keyword in SQL and cannot be used as a table/variable name. For this to work with real-world, user-submitted data, we might have to check to make sure their variables are named without overlapping on any SQL syntax.

bmschmidt commented 10 years ago

The list of words to check against is here

bmschmidt commented 10 years ago

Fixed so that it drops these fields and throws a warning: this warning is easy to miss, but that's a different issue.