DROP TABLE t1,t2,... fails when table tf has a foreign key referencing t2

[chyujing]

Environment

• Platform: Android (arm64)
• Device: Android Studio emulator (emulator-5554)
• Binary: ./data/local/tmp/seekdb
• Startup Command: ./data/local/tmp/seekdb --nodaemon --base-dir /data/local/tmp/seekdb_data --port 5881
• Port: 5881

Description

When using mysqltest with the hint.win_magic hint, a DROP TABLE t1,t2,... statement fails if there exists a table tf that has a foreign key referencing one of the tables being dropped (specifically t2).

Steps to Reproduce

1. On the test machine, start the seekdb server with the provided command.
2. Execute a test case that involves:
   • Creating tables, including t1, t2, and tf.
   • Defining a foreign key constraint on table tf that references table t2.
   • Attempting to drop multiple tables in a single statement: DROP TABLE t1, t2, ....
3. The operation fails.

Impact

The failure prevents the successful execution of test cases that rely on dropping multiple tables with existing foreign key dependencies, affecting test automation and validation workflows.