alibaba / alibaba/nquery

doesn't support upsert-ish behaviour

Open
#11 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
385
Forks
117
PR merge metrics
No merged PRs in 30d

Description

the following query fails in test, but passes in mysql.

```
INSERT INTO `user_lauer_testing`
SET `user_id` = '123',
`username` = 'mike'
ON duplicate KEY
UPDATE `user_id` = '123',
`username` = 'bob'
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Begin by reproducing the SQL query shown in issue #11 through the failing test, then trace how nquery parses INSERT with ON DUPLICATE KEY UPDATE. Compare the result with MySQL; done means this query no longer fails and its upsert behavior is compatible with the stated MySQL result.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.