Description:
Page: https://dev.mysql.com/doc/refman/9.5/en/server-system-variables.html#sysvar_session_track_...
The example:
====================================================================
mysql> SET @@SESSION.session_track_system_variables='statement_id'
mysql> SELECT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.0006 sec)
Statement ID: 603835
====================================================================
Issues
1. There is a missing `;` at the end of the `SET` statement.
2. With MySQL 9.5 client and server I don't get the `Statement ID:` line.
How to repeat:
mysql-9.5.0 [(none)]> SET @@SESSION.session_track_system_variables='statement_id';
Query OK, 0 rows affected (0.001 sec)
mysql-9.5.0 [(none)]> SELECT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.000 sec)
mysql-9.5.0 [(none)]>
Wireshark does show the `statement_id` being sent by the server:
Session tracking data
Session tracking data length: 18
Session Track
Session tracking type: SESSION_SYSVARS_TRACKER (0)
Session tracking length: 16
System variable change Length: 12
System variable change Name: statement_id
System variable change Length: 2
System variable change Value: 37
Note that MySQL Shell does show this information:
sql> SET @@SESSION.session_track_system_variables='statement_id';
Query OK, 0 rows affected (0.0005 sec)
sql> SELECT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.0006 sec)
Statement ID: 56
sql>
Suggested fix:
1. Add the same functionality to MySQL Client
2. Explicitly state that this example requires MySQL Shell. Either explicitly in the description or implicitly by using a recognizable prompt like `mysqlsh> `
Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders. It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.