Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
-
None
Description
Notes:
On some reason, select from INFORMATION_SCHEMA.TABLE_CONSTRAINTS is important here.
have_innodb.inc is not particularly important, it's just there to avoid warnings upon select from the information schema. The failure happens regardless whether the test runs with InnoDB or not.
--source include/have_innodb.inc
|
|
INSTALL SONAME 'ha_federatedx'; |
|
eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT); |
|
CREATE TABLE t1 (a INT); |
CREATE TABLE t1_fed ENGINE=FEDERATED CONNECTION = 's/t1'; |
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS; |
CREATE TABLE t2 (a INT); |
CREATE TABLE t2_fed ENGINE=FEDERATED CONNECTION = 's/t2'; |
OPTIMIZE TABLE t2_fed; |
SELECT * FROM t2_fed; |
|
# Cleanup
|
DROP TABLE t2_fed, t2, t1_fed, t1; |
DROP SERVER s; |
UNINSTALL SONAME 'ha_federatedx'; |
10.4 f5dceafd |
OPTIMIZE TABLE t2_fed; |
Table Op Msg_type Msg_text |
test.t2_fed optimize status OK
|
SELECT * FROM t2_fed; |
bug.t 'innodb' [ fail ] |
Test ended at 2023-06-17 01:23:12 |
|
CURRENT_TEST: bug.t
|
mysqltest: At line 13: query 'SELECT * FROM t2_fed' failed: 2014: Received error: 2014 : Commands out of sync; you can't run this command now |
Reproducible on all existing versions, debug- and non-debug alike.
Debug builds further abort with
mysqld: /data/src/10.4/sql/sql_class.cc:1735: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed
|
but I assume it's just an aftermath of the problem above.