Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 1.2Mb


14.12.2.1 ERR Instead of EOF

EXPLAIN SELECT * FROM dual;

results in

01 00 00 01 0a 18 00 00    02 03 64 65 66 00 00 00    ..........def...
02 69 64 00 0c 3f 00 03    00 00 00 08 a1 00 00 00    .id..?..........
00 21 00 00 03 03 64 65    66 00 00 00 0b 73 65 6c    .!....def....sel
65 63 74 5f 74 79 70 65    00 0c 08 00 13 00 00 00    ect_type........
fd 01 00 1f 00 00 1b 00    00 04 03 64 65 66 00 00    ...........def..
00 05 74 61 62 6c 65 00    0c 08 00 40 00 00 00 fd    ..table....@....
00 00 1f 00 00 1a 00 00    05 03 64 65 66 00 00 00    ..........def...
04 74 79 70 65 00 0c 08    00 0a 00 00 00 fd 00 00    .type...........
1f 00 00 23 00 00 06 03    64 65 66 00 00 00 0d 70    ...#....def....p
6f 73 73 69 62 6c 65 5f    6b 65 79 73 00 0c 08 00    ossible_keys....
00 10 00 00 fd 00 00 1f    00 00 19 00 00 07 03 64    ...............d
65 66 00 00 00 03 6b 65    79 00 0c 08 00 40 00 00    ef....key....@..
00 fd 00 00 1f 00 00 1d    00 00 08 03 64 65 66 00    ............def.
00 00 07 6b 65 79 5f 6c    65 6e 00 0c 08 00 00 10    ...key_len......
00 00 fd 00 00 1f 00 00    19 00 00 09 03 64 65 66    .............def
00 00 00 03 72 65 66 00    0c 08 00 00 04 00 00 fd    ....ref.........
00 00 1f 00 00 1a 00 00    0a 03 64 65 66 00 00 00    ..........def...
04 72 6f 77 73 00 0c 3f    00 0a 00 00 00 08 a0 00    .rows..?........
00 00 00 1b 00 00 0b 03    64 65 66 00 00 00 05 45    ........def....E
78 74 72 61 00 0c 08 00    ff 00 00 00 fd 01 00 1f    xtra............
00 00 05 00 00 0c fe 00    00 02 00 17 00 00 0d ff    ................
48 04 23 48 59 30 30 30    4e 6f 20 74 61 62 6c 65    H.#HY000No table
73 20 75 73 65 64                                     s used

See how after the column definitions a ERR_Packet is sent:

                                    17 00 00 0d ff    ................
48 04 23 48 59 30 30 30    4e 6f 20 74 61 62 6c 65    H.#HY000No table
73 20 75 73 65 64                                     s used

User Comments
Sign Up Login You must be logged in to post a comment.