manyuanrong / manyuanrong/sql-builder
Double-quotes don't work for MySQL with `ANSI_QUOTES`
Open
- Dominant language
- TypeScript
- Stars
- 55
- Forks
- 15
- PR merge metrics
- No merged PRs in 30d
Description
The sql-builder currently use double-quotes for string values, but with `ANSI_QUOTES` set in `sql_mode`, MySQL will treat double-quotes as identifiers instead of strings.
Related: https://github.com/denodrivers/mysql/issues/108
Contributor guide
No contributing guide indexed for this repository
Research direction
No files or tests are named. Start by locating how sql-builder quotes string values and how MySQL-specific behavior is tested; verify the behavior under ANSI_QUOTES and identify the expected string-literal syntax. Done means generated queries treat string values as strings when ANSI_QUOTES is enabled.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, typescript
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100