メモ(その3)
*文字数制限により出力結果を一部省略しています。
プロシージャの実行結果
mysql> call test_proc();
+--------+
| debug |
+--------+
+---------------------+
| 5.0.67-modified-log |
+---------------------+
+---------------+
| DEBUG block-1 |
+---------------+
+---------------+
| block-1 step1 |
+---------------+
+--------------------------------------------+
| DEBUG SQL exception BAD_NULL_ERROR block-1 |
+--------------------------------------------+
+---------------+
| DEBUG block-2 |
+---------------+
+---------------+
| block-2 step1 |
+---------------+
+--------------------------------------------+
| DEBUG SQL exception BAD_NULL_ERROR block-2 |
+--------------------------------------------+
+---------------+
| block-2 step2 |
+---------------+
+---------------+
| DEBUG block-3 |
+---------------+
+---------------+
| block-3 step1 |
+---------------+
+---------------+
| block-3 step2 |
+---------------+
+-------------------------------------+
| DEBUG SQL exception DUP_KEY block-3 |
+-------------------------------------+
+---------------+
| DEBUG block-4 |
+---------------+
+------------------+
| block-4(1) step1 |
+------------------+
+------------------+
| block-4(1) step2 |
+------------------+
+--------------------------------+
| DEBUG SQL exception block-4(1) |
+--------------------------------+
+------------------+
| block-4(1) step3 |
+------------------+
+-----------------------------+
| DEBUG block-4(1) exception! |
+-----------------------------+
+------------------+
| DEBUG block-4(2) |
+------------------+
+------------------+
| block-4(2) step1 |
+------------------+
+------------------+
| block-4(2) step2 |
+------------------+
+--------------------------------+
| DEBUG SQL exception block-4(2) |
+--------------------------------+
+------------------+
| DEBUG block-4(3) |
+------------------+
+---------------+
| DEBUG block-5 |
+---------------+
+---------------+
| block-5 step1 |
+---------------+
+------------------------------------+
| DEBUG handler on ORG_TOO_MANY_ROWS |
+------------------------------------+
+---------------+
| block-5 step2 |
+---------------+
+-------+
| 1 |
+-------+
+---------------+
| block-5 step3 |
+---------------+
+---------------+
| DEBUG block-6 |
+---------------+
+---------------+
| block-6 step1 |
+---------------+
+---------------+
| block-6 step2 |
+---------------+
+---------------------------------------+
| DEBUG handler on ORG_DUP_VAL_ON_INDEX |
+---------------------------------------+
+---------------+
| block-6 step3 |
+---------------+
+---------------+
| DEBUG block-7 |
+---------------+
+---------------+
| block-7 step1 |
+---------------+
+---------------+-------+
| outer loop : | 1 |
+---------------+-------+
+---------------+-------+-------+
| inner loop : | 1 | 1 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 1 | 2 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 1 | 3 |
+---------------+-------+-------+
+---------------------------------------+
| DEBUG handler on inner loop NOT FOUND |
+---------------------------------------+
+---------------+-------+
| outer loop : | 2 |
+---------------+-------+
+---------------+-------+-------+
| inner loop : | 2 | 1 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 2 | 2 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 2 | 3 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 2 | 4 |
+---------------+-------+-------+
+---------------------------------------+
| DEBUG handler on inner loop NOT FOUND |
+---------------------------------------+
+---------------+-------+
| outer loop : | 3 |
+---------------+-------+
+---------------+-------+-------+
| inner loop : | 3 | 1 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 3 | 2 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 3 | 3 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 3 | 4 |
+---------------+-------+-------+
+---------------+-------+-------+
| inner loop : | 3 | 5 |
+---------------+-------+-------+
+---------------------------------------+
| DEBUG handler on inner loop NOT FOUND |
+---------------------------------------+
+---------------+-------+
| outer loop : | 4 |
+---------------+-------+
+---------------+-------+-------+
| inner loop : | 4 | 1 |
+---------------+-------+-------+
+---------------------------------------+
| DEBUG handler on inner loop NOT FOUND |
+---------------------------------------+
+---------------------------------------+
| DEBUG handler on outer loop NOT FOUND |
+---------------------------------------+
+---------------+
| block-7 step2 |
+---------------+
Query OK, 0 rows affected (0.34 sec)