mysqltest: dblink.sequence_for_dblink_mysql fails with error 1235 on DROP DATABASE LINK IF EXISTS
Open
Nobody has claimed this yet.
dima
type: bug
- Dominant language
- C++
- Stars
- 2.9k
- Forks
- 339
- Avg merge
- 1d 19h
- Merged PRs (30d)
- 52
Description
Environment
- Platform: Android (Android Studio emulator)
- Device: emulator-5554
- Architecture: arm64
- Binary:
./data/local/tmp/seekdb - Startup Command:
--nodaemon --base-dir /data/local/tmp/seekdb_data --port 5881 - Port: 5881
Description
In the dblink.sequence_for_dblink_mysql test, the DROP DATABASE LINK IF EXISTS statement is not supported and returns error code 1235.
Steps to Reproduce
- Start the server on the Android emulator using the provided command.
- Execute the
DROP DATABASE LINK IF EXISTSstatement. - Observe the error (code 1235).
Impact
The IF EXISTS syntax for dropping database links is not functional, which may affect scripts or applications that rely on this conditional drop feature.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the mysqltest case dblink.sequence_for_dblink_mysql and reproduce the DROP DATABASE LINK IF EXISTS statement on the provided Android emulator setup. Trace where the statement returns error 1235 and verify the test’s expected behavior. Done means the conditional drop executes successfully and the named test passes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, sql
- Domain
- database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100