1CREATE TABLE t_int (c1 TINYINT, 2c2 SMALLINT, 3c3 MEDIUMINT, 4c4 INT, 5c5 INTEGER, 6c6 SMALLINT UNSIGNED, 7c7 MEDIUMINT UNSIGNED, 8c8 INT UNSIGNED, 9c9 INTEGER); 10INSERT INTO t_int VALUES (91,92,93,94,95,96,97,98,99); 11INSERT INTO t_int VALUES (81,82,83,84,85,86,87,88,89); 12INSERT INTO t_int VALUES (71,72,73,74,75,76,77,78,79); 13SELECT * FROM t_int order by c1; 14c1 c2 c3 c4 c5 c6 c7 c8 c9 1571 72 73 74 75 76 77 78 79 1681 82 83 84 85 86 87 88 89 1791 92 93 94 95 96 97 98 99 18########################################## 19# Run plugin 20########################################## 21INSTALL PLUGIN test_session_detach SONAME 'TEST_SESSION_DETACH'; 22########################################## 23# Stop plugin 24########################################## 25UNINSTALL PLUGIN test_session_detach; 26########################################## 27# Plugin log 28########################################## 29========================================================================= 30Test in a server thread 31Opening Session 1 32========================================================================= 33 34Query 01: SELECT * FROM test.t_int ORDER BY c1 35num_cols : 9 36nb rows : 3 37c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 3871 72 73 74 75 76 77 78 79 3981 82 83 84 85 86 87 88 89 4091 92 93 94 95 96 97 98 99 41 42affected rows : 0 43server status : 34 44warn count : 0 45 46Detach Session 1 47 48Query 02: SELECT * FROM test.t_int ORDER BY c1 49num_cols : 9 50nb rows : 3 51c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 5271 72 73 74 75 76 77 78 79 5381 82 83 84 85 86 87 88 89 5491 92 93 94 95 96 97 98 99 55 56affected rows : 0 57server status : 34 58warn count : 0 59 60Detach Session 1 61 62Query 03: SELECT * FROM test.t_int ORDER BY c1 63num_cols : 9 64nb rows : 3 65c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 6671 72 73 74 75 76 77 78 79 6781 82 83 84 85 86 87 88 89 6891 92 93 94 95 96 97 98 99 69 70affected rows : 0 71server status : 34 72warn count : 0 73 74Detach Session 1 75 76Query 04: SELECT * FROM test.t_int ORDER BY c1 77num_cols : 9 78nb rows : 3 79c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 8071 72 73 74 75 76 77 78 79 8181 82 83 84 85 86 87 88 89 8291 92 93 94 95 96 97 98 99 83 84affected rows : 0 85server status : 34 86warn count : 0 87 88Detach Session 1 89 90Query 05: SELECT * FROM test.t_int ORDER BY c1 91num_cols : 9 92nb rows : 3 93c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 9471 72 73 74 75 76 77 78 79 9581 82 83 84 85 86 87 88 89 9691 92 93 94 95 96 97 98 99 97 98affected rows : 0 99server status : 34 100warn count : 0 101 102Detach Session 1 103========================================================================= 104Close Session 1 105Follows threaded run 106========================================================================= 107init thread 108Opening Session 1 109========================================================================= 110 111Query 01: SELECT * FROM test.t_int ORDER BY c1 112num_cols : 9 113nb rows : 3 114c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 11571 72 73 74 75 76 77 78 79 11681 82 83 84 85 86 87 88 89 11791 92 93 94 95 96 97 98 99 118 119affected rows : 0 120server status : 34 121warn count : 0 122 123Detach Session 1 124 125Query 02: SELECT * FROM test.t_int ORDER BY c1 126num_cols : 9 127nb rows : 3 128c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 12971 72 73 74 75 76 77 78 79 13081 82 83 84 85 86 87 88 89 13191 92 93 94 95 96 97 98 99 132 133affected rows : 0 134server status : 34 135warn count : 0 136 137Detach Session 1 138 139Query 03: SELECT * FROM test.t_int ORDER BY c1 140num_cols : 9 141nb rows : 3 142c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 14371 72 73 74 75 76 77 78 79 14481 82 83 84 85 86 87 88 89 14591 92 93 94 95 96 97 98 99 146 147affected rows : 0 148server status : 34 149warn count : 0 150 151Detach Session 1 152 153Query 04: SELECT * FROM test.t_int ORDER BY c1 154num_cols : 9 155nb rows : 3 156c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 15771 72 73 74 75 76 77 78 79 15881 82 83 84 85 86 87 88 89 15991 92 93 94 95 96 97 98 99 160 161affected rows : 0 162server status : 34 163warn count : 0 164 165Detach Session 1 166 167Query 05: SELECT * FROM test.t_int ORDER BY c1 168num_cols : 9 169nb rows : 3 170c1 TINY(1) c2 SHORT(2) c3 INT24(9) c4 LONG(3) c5 LONG(3) c6 SHORT(2) c7 INT24(9) c8 LONG(3) c9 LONG(3) 17171 72 73 74 75 76 77 78 79 17281 82 83 84 85 86 87 88 89 17391 92 93 94 95 96 97 98 99 174 175affected rows : 0 176server status : 34 177warn count : 0 178 179Detach Session 1 180========================================================================= 181Close Session 1 182deinit thread 183########################################## 184# Cleanup 185########################################## 186DROP TABLE IF EXISTS t_int; 187