Rejected compound SET silently changes the InnoDB FTS auxiliary-table target

set -eu

IMAGE='mariadb@sha256:dd9b303aed4f4890ed09f766d8ca9ddfd176c0c6f6267feff53b3192ec65a979'

C='mdev-ft-aux-partial-set'

OWNER="edbf-report-mcfg08-$$"

cleanup() {

  if docker inspect --format '{{ index .Config.Labels "io.encryptiondbfuzz.owner" }}' \

       "$C" 2>/dev/null | grep -Fqx "$OWNER"; then

    docker rm -f "$C" >/dev/null 2>&1 || true

  fi

}

trap cleanup EXIT

docker run --detach --name "$C" \

  --label "io.encryptiondbfuzz.owner=$OWNER" \

  --network none --read-only --cap-drop ALL \

  --security-opt no-new-privileges=true --pids-limit 160 \

  --memory 1g --cpus 1 --user 999:999 \

  --tmpfs /var/lib/mysql:rw,nosuid,nodev,size=512m,uid=999,gid=999 \

  --tmpfs /run/mysqld:rw,nosuid,nodev,size=16m,uid=999,gid=999 \

  --tmpfs /tmp:rw,nosuid,nodev,size=64m,uid=999,gid=999 \

  --env MARIADB_ALLOW_EMPTY_ROOT_PASSWORD=1 "$IMAGE"

READY=0

for I in $(seq 1 90); do

  if docker exec --user 999:999 "$C" mariadb --protocol=socket \

       --socket=/run/mysqld/mysqld.sock -uroot -NBe 'SELECT @@port' \

       2>/dev/null | grep -qx 3306; then

    READY=1

    break

  fi

  sleep 1

done

test "$READY" -eq 1

SQL="docker exec --user 999:999 $C mariadb --protocol=socket --socket=/run/mysqld/mysqld.sock -uroot --batch --skip-column-names"

$SQL -e "

  CREATE DATABASE edbf_cfg;

  CREATE TABLE edbf_cfg.a(

    id INT PRIMARY KEY AUTO_INCREMENT, body TEXT, FULLTEXT(body)

  ) ENGINE=InnoDB;

  CREATE TABLE edbf_cfg.b(

    id INT PRIMARY KEY AUTO_INCREMENT, body TEXT, FULLTEXT(body)

  ) ENGINE=InnoDB;

  INSERT INTO edbf_cfg.a(body) VALUES('alphaonly alphaonly');

  INSERT INTO edbf_cfg.b(body) VALUES('betaonly betaonly');

  SET GLOBAL innodb_ft_aux_table='edbf_cfg/a';"

echo 'before_variable:'

$SQL -e 'SELECT @@GLOBAL.innodb_ft_aux_table'

echo 'before_words:'

$SQL -e "SELECT GROUP_CONCAT(DISTINCT WORD ORDER BY WORD)

  FROM (SELECT WORD FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE

        UNION ALL

        SELECT WORD FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE) AS w"

set +e

$SQL -e "SET GLOBAL innodb_ft_aux_table='edbf_cfg/b', binlog_format='INVALID'"

RC=$?

set -e

echo "failed_compound_set_rc=$RC"

test "$RC" -ne 0

echo 'after_variable:'

$SQL -e 'SELECT @@GLOBAL.innodb_ft_aux_table'

echo 'after_words:'

$SQL -e "SELECT GROUP_CONCAT(DISTINCT WORD ORDER BY WORD)

  FROM (SELECT WORD FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE

        UNION ALL

        SELECT WORD FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE) AS w"

before_variable:

edbf_cfg/a

before_words:

alphaonly

ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'INVALID'

failed_compound_set_rc=1

after_variable:

edbf_cfg/a

after_words:

betaonly