NVlabs / FPSci

Aim Training Experiments
Other
67 stars 23 forks source link

Issue with `'` character in experiment configuration #383

Open bboudaoud-nv opened 2 years ago

bboudaoud-nv commented 2 years ago

When a ' character is present in the experiment configuration, it breaks the SQL query to insert a new row into the Experiments table by ending the string being used for the experiment description in the query.

For now I recommend avoiding use of the ' character (the primary challenge case would be its use in string such as "We'll"). In the future we should come up w/ a strategy that will reduce the need for this. I believe the easiest solution is "doubling" the ' character to '' to escape it in SQL.