## Test case reproducing issue described under Bug#31931873

--source include/count_sessions.inc
--source include/have_debug_sync.inc
--source include/xplugin_preamble.inc
--source include/xplugin_create_user.inc

## Test case description:
--echo ## I. Validate the fix for the bug. The issue occures between two
--echo ##    session, where one shows X Plugins status variables, second
--echo ##    triggers reauthentication
--echo #
--echo # 1. Create classic session (S2), show any X Plugins status variable
--echo # 2. Create X Protocol session (S1), which triggers reauthentication
--echo # 3. Synchronize S1 and S2, in a way that triggers the issue
--echo #
--echo


## Test starts here

# SQL FOR SYNCHRONIZATION OF TWO SESSIONS
--let $sql_synchronize_sessions= $MYSQL_TMP_DIR/mutexes1.xpl
--write_file $sql_synchronize_sessions
SET DEBUG_SYNC= 'now WAIT_FOR reached_is_handled_by_thd';
SET DEBUG_SYNC= 'now WAIT_FOR reached_create_session_locked';
SET DEBUG_SYNC= 'now SIGNAL continue_create_session_locked';
SET DEBUG_SYNC= 'now SIGNAL continue_is_handled_by_thd';
EOF

# SQL FOR TRIGGERING THE ISSUE ON S2
--let $sql_trigger_issue_S2= $MYSQL_TMP_DIR/mutexes2.xpl
--write_file $sql_trigger_issue_S2
SET DEBUG_SYNC= 'syncpoint_is_handled_by_thd SIGNAL reached_is_handled_by_thd WAIT_FOR continue_is_handled_by_thd';
show status like "Mysqlx_sessions"
EOF

# X PROTOCOL PART OF THE ISSUE (TRIGGER ON S1)
--let $xtest_file= $MYSQL_TMP_DIR/mutexes.xpl
--write_file $xtest_file

SET DEBUG_SYNC= 'syncpoint_create_session_locked SIGNAL reached_create_session_locked WAIT_FOR continue_create_session_locked';
env %MASTER_MYPORT% MASTER_MYPORT;
env %MYSQL% MYSQL;

echo;
echo #;
echo # I.1;
# Trigger issue on Session2 (S2)
system_in_background %MYSQL%
  -P %MASTER_MYPORT%
  --protocol tcp
  -u x_root
  -h localhost
  test < %SQL_FILE2%;

echo;
echo #;
echo # I.2;
# Trigger issue on Session1 (S1)
Mysqlx.Session.Close{
}

echo;
echo #;
echo # I.3;
system_in_background %MYSQL%
  -P %MASTER_MYPORT%
  --protocol tcp
  -u x_root
  -h localhost
   test < %SQL_FILE1%;

recv;
closesession abort;
EOF


exec $MYSQLXTEST
  -ux_root --password=''
  --file=$xtest_file
  -v%SQL_FILE1%=$sql_synchronize_sessions
  -v%SQL_FILE2%=$sql_trigger_issue_S2 2>&1;

## Cleanup
--source ../include/xplugin_cleanup.inc

# Wait till all disconnects are completed
--source include/wait_until_count_sessions.inc