Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15357

Wrong result with join_cache_level=4, BNLH join

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.2.12, 10.2.13
    • Fix Version/s: 10.2, 10.3, 10.4
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      CentOS release 6.5 x86_64, MariaDB 10.2.12, 10.2.13
    • Sprint:
      10.2.14

      Description

      the following query:

      SELECT DISTINCT T3.ZEBWD_SYS_ID,
                      T4.ZEBWD_SYS_IDT,
                      T3.ZEBWD_SYS_AV
      FROM            T_ZEBWDT1040 T1,   /* A001/A002 */
                      T_ZEBWDT1050 T2,
                      T_ZEBWDT1000 T3,
                      T_ZEBWDT1000T T4
      WHERE           T1.ZEBWD_ROLE_ID = T2.ZEBWD_ROLE_ID
      AND             T2.ZEBWD_MENU_ID = T3.ZEBWD_SYS_ID
      AND             T3.ZEBWD_SYS_DEL = 'N'
      AND             T3.ZEBWD_SYS_UP  = '0000000000'
      AND             T3.ZEBWD_SYS_ID  = T4.ZEBWD_SYS_ID
      AND             T1.ZEBWD_USER_ID = 'test'
      ORDER BY        T3.ZEBWD_SYS_AV ASC;
      

      Test Case 1: SET SESSION join_cache_level=8;

      +------+-------------+-------+--------+---------------+---------+---------+----------------------------+------+-----------------------------------------------------------+
      | id   | select_type | table | type   | possible_keys | key     | key_len | ref                        | rows | Extra                                                     |
      +------+-------------+-------+--------+---------------+---------+---------+----------------------------+------+-----------------------------------------------------------+
      |    1 | SIMPLE      | T1    | index  | PRIMARY       | PRIMARY | 154     | NULL                       |    1 | Using where; Using index; Using temporary; Using filesort |
      |    1 | SIMPLE      | T2    | ref    | PRIMARY       | PRIMARY | 62      | bnlh_test.T1.ZEBWD_ROLE_ID |    4 | Using index                                               |
      |    1 | SIMPLE      | T3    | eq_ref | PRIMARY       | PRIMARY | 92      | bnlh_test.T2.ZEBWD_MENU_ID |    1 | Using where                                               |
      |    1 | SIMPLE      | T4    | ref    | PRIMARY       | PRIMARY | 92      | bnlh_test.T2.ZEBWD_MENU_ID |    1 |                                                           |
      +------+-------------+-------+--------+---------------+---------+---------+----------------------------+------+-----------------------------------------------------------+
      4 rows in set (0.00 sec)
       
      MariaDB [bnlh_test]> 
       
      +--------------+---------------+--------------+
      | ZEBWD_SYS_ID | ZEBWD_SYS_IDT | ZEBWD_SYS_AV |
      +--------------+---------------+--------------+
      | ZSBILL1000   | MENU1         | 1            |
      | ZSBILL3000   | MENU3         | 2            |
      | ZSBILL2000   | MENU2         | 3            |
      | ZSBILL7000   | MENU7         | 4            |
      | ZSBILL4000   | MENU4         | 5            |
      | ZSBILL5000   | MENU5         | 6            |
      | ZSBILL8000   | MENU8         | 7            |
      | ZSBILL6000   | MENU6         | 8            |
      | ZSBILL9000   | MENU9         | 9            |
      +--------------+---------------+--------------+
      9 rows in set (0.00 sec)
      

      Test Case 2: SET SESSION join_cache_level=4;

      +------+-------------+-------+------------+---------------+-----------------------+---------+----------------------------+------+-----------------------------------------------------------+
      | id   | select_type | table | type       | possible_keys | key                   | key_len | ref                        | rows | Extra                                                     |
      +------+-------------+-------+------------+---------------+-----------------------+---------+----------------------------+------+-----------------------------------------------------------+
      |    1 | SIMPLE      | T1    | index      | PRIMARY       | PRIMARY               | 154     | NULL                       |    1 | Using where; Using index; Using temporary; Using filesort |
      |    1 | SIMPLE      | T2    | hash_index | PRIMARY       | #hash#PRIMARY:PRIMARY | 62:154  | bnlh_test.T1.ZEBWD_ROLE_ID |    9 | Using index; Using join buffer (flat, BNLH join)          |
      |    1 | SIMPLE      | T3    | hash_ALL   | PRIMARY       | #hash#PRIMARY         | 92      | bnlh_test.T2.ZEBWD_MENU_ID |   42 | Using where                                               |
      |    1 | SIMPLE      | T4    | hash_ALL   | PRIMARY       | #hash#PRIMARY         | 92      | bnlh_test.T2.ZEBWD_MENU_ID |   42 |                                                           |
      +------+-------------+-------+------------+---------------+-----------------------+---------+----------------------------+------+-----------------------------------------------------------+
      4 rows in set (0.00 sec)
       
      MariaDB [bnlh_test]> SELECT DISTINCT T3.ZEBWD_SYS_ID,
          ->                 T4.ZEBWD_SYS_IDT,
          ->                 T3.ZEBWD_SYS_AV
          -> FROM            T_ZEBWDT1040 T1,   /* A001/A002 */
          ->                 T_ZEBWDT1050 T2,
          ->                 T_ZEBWDT1000 T3,
          ->                 T_ZEBWDT1000T T4
          -> WHERE           T1.ZEBWD_ROLE_ID = T2.ZEBWD_ROLE_ID
          -> AND             T2.ZEBWD_MENU_ID = T3.ZEBWD_SYS_ID
          -> AND             T3.ZEBWD_SYS_DEL = 'N'
          -> AND             T3.ZEBWD_SYS_UP  = '0000000000'
          -> AND             T3.ZEBWD_SYS_ID  = T4.ZEBWD_SYS_ID
          -> AND             T1.ZEBWD_USER_ID = 'test'
          -> ORDER BY        T3.ZEBWD_SYS_AV ASC;
      +--------------+---------------+--------------+
      | ZEBWD_SYS_ID | ZEBWD_SYS_IDT | ZEBWD_SYS_AV |
      +--------------+---------------+--------------+
      | ZSBILL1000   | MENU4 - SUB1  | 1            |
      | ZSBILL1000   | MENU3         | 1            |
      | ZSBILL1000   | MENU9 - SUB5  | 1            |
      | ZSBILL1000   | MENU1 - SUB3  | 1            |
      | ZSBILL1000   | MENU9         | 1            |
      | ZSBILL1000   | MENU6 - SUB3  | 1            |
      | ZSBILL1000   | MENU5 - SUB3  | 1            |
      | ZSBILL1000   | MENU4 - SUB8  | 1            |
      | ZSBILL1000   | MENU4 - SUB3  | 1            |
      | ZSBILL1000   | MENU3 - SUB2  | 1            |
      | ZSBILL1000   | MENU2 - SUB1  | 1            |
      | ZSBILL1000   | MENU9 - SUB2  | 1            |
      | ZSBILL1000   | MENU1         | 1            |
      | ZSBILL1000   | MENU6 - SUB5  | 1            |
      | ZSBILL1000   | MENU6         | 1            |
      | ZSBILL1000   | MENU5         | 1            |
      | ZSBILL1000   | MENU4 - SUB5  | 1            |
      | ZSBILL1000   | MENU4         | 1            |
      | ZSBILL1000   | MENU2 - SUB3  | 1            |
      | ZSBILL1000   | MENU9 - SUB4  | 1            |
      | ZSBILL1000   | MENU1 - SUB2  | 1            |
      | ZSBILL1000   | MENU8         | 1            |
      | ZSBILL1000   | MENU6 - SUB2  | 1            |
      | ZSBILL1000   | MENU5 - SUB2  | 1            |
      | ZSBILL1000   | MENU4 - SUB7  | 1            |
      | ZSBILL1000   | MENU4 - SUB2  | 1            |
      | ZSBILL1000   | MENU3 - SUB1  | 1            |
      | ZSBILL1000   | MENU9 - SUB6  | 1            |
      | ZSBILL1000   | MENU2         | 1            |
      | ZSBILL1000   | MENU9 - SUB1  | 1            |
      | ZSBILL1000   | MENU6 - SUB4  | 1            |
      | ZSBILL1000   | MENU5 - SUB4  | 1            |
      | ZSBILL1000   | MENU4 - SUB9  | 1            |
      | ZSBILL1000   | MENU4 - SUB4  | 1            |
      | ZSBILL1000   | MENU3 - SUB3  | 1            |
      | ZSBILL1000   | MENU2 - SUB2  | 1            |
      | ZSBILL1000   | MENU9 - SUB3  | 1            |
      | ZSBILL1000   | MENU1 - SUB1  | 1            |
      | ZSBILL1000   | MENU7         | 1            |
      | ZSBILL1000   | MENU6 - SUB1  | 1            |
      | ZSBILL1000   | MENU5 - SUB1  | 1            |
      | ZSBILL1000   | MENU4 - SUB6  | 1            |
      | ZSBILL3000   | MENU5 - SUB3  | 2            |
      | ZSBILL3000   | MENU4 - SUB8  | 2            |
      | ZSBILL3000   | MENU4 - SUB3  | 2            |
      | ZSBILL3000   | MENU3 - SUB2  | 2            |
      | ZSBILL3000   | MENU2 - SUB1  | 2            |
      | ZSBILL3000   | MENU9 - SUB2  | 2            |
      | ZSBILL3000   | MENU1         | 2            |
      | ZSBILL3000   | MENU6 - SUB5  | 2            |
      | ZSBILL3000   | MENU6         | 2            |
      | ZSBILL3000   | MENU5         | 2            |
      | ZSBILL3000   | MENU4 - SUB5  | 2            |
      | ZSBILL3000   | MENU4         | 2            |
      | ZSBILL3000   | MENU2 - SUB3  | 2            |
      | ZSBILL3000   | MENU9 - SUB4  | 2            |
      | ZSBILL3000   | MENU1 - SUB2  | 2            |
      | ZSBILL3000   | MENU8         | 2            |
      | ZSBILL3000   | MENU6 - SUB2  | 2            |
      | ZSBILL3000   | MENU5 - SUB2  | 2            |
      | ZSBILL3000   | MENU4 - SUB7  | 2            |
      | ZSBILL3000   | MENU4 - SUB2  | 2            |
      | ZSBILL3000   | MENU3 - SUB1  | 2            |
      | ZSBILL3000   | MENU9 - SUB6  | 2            |
      | ZSBILL3000   | MENU2         | 2            |
      | ZSBILL3000   | MENU9 - SUB1  | 2            |
      | ZSBILL3000   | MENU6 - SUB4  | 2            |
      | ZSBILL3000   | MENU5 - SUB4  | 2            |
      | ZSBILL3000   | MENU4 - SUB9  | 2            |
      | ZSBILL3000   | MENU4 - SUB4  | 2            |
      | ZSBILL3000   | MENU3 - SUB3  | 2            |
      | ZSBILL3000   | MENU2 - SUB2  | 2            |
      | ZSBILL3000   | MENU9 - SUB3  | 2            |
      | ZSBILL3000   | MENU1 - SUB1  | 2            |
      | ZSBILL3000   | MENU7         | 2            |
      | ZSBILL3000   | MENU6 - SUB1  | 2            |
      | ZSBILL3000   | MENU5 - SUB1  | 2            |
      | ZSBILL3000   | MENU4 - SUB6  | 2            |
      | ZSBILL3000   | MENU4 - SUB1  | 2            |
      | ZSBILL3000   | MENU3         | 2            |
      | ZSBILL3000   | MENU9 - SUB5  | 2            |
      | ZSBILL3000   | MENU1 - SUB3  | 2            |
      | ZSBILL3000   | MENU9         | 2            |
      | ZSBILL3000   | MENU6 - SUB3  | 2            |
      | ZSBILL2000   | MENU1 - SUB3  | 3            |
      | ZSBILL2000   | MENU9         | 3            |
      | ZSBILL2000   | MENU6 - SUB3  | 3            |
      | ZSBILL2000   | MENU5 - SUB3  | 3            |
      | ZSBILL2000   | MENU4 - SUB8  | 3            |
      | ZSBILL2000   | MENU4 - SUB3  | 3            |
      | ZSBILL2000   | MENU3 - SUB2  | 3            |
      | ZSBILL2000   | MENU2 - SUB1  | 3            |
      | ZSBILL2000   | MENU9 - SUB2  | 3            |
      | ZSBILL2000   | MENU1         | 3            |
      | ZSBILL2000   | MENU6 - SUB5  | 3            |
      | ZSBILL2000   | MENU6         | 3            |
      | ZSBILL2000   | MENU5         | 3            |
      | ZSBILL2000   | MENU4 - SUB5  | 3            |
      | ZSBILL2000   | MENU4         | 3            |
      | ZSBILL2000   | MENU2 - SUB3  | 3            |
      | ZSBILL2000   | MENU9 - SUB4  | 3            |
      | ZSBILL2000   | MENU1 - SUB2  | 3            |
      | ZSBILL2000   | MENU8         | 3            |
      | ZSBILL2000   | MENU6 - SUB2  | 3            |
      | ZSBILL2000   | MENU5 - SUB2  | 3            |
      | ZSBILL2000   | MENU4 - SUB7  | 3            |
      | ZSBILL2000   | MENU4 - SUB2  | 3            |
      | ZSBILL2000   | MENU3 - SUB1  | 3            |
      | ZSBILL2000   | MENU9 - SUB6  | 3            |
      | ZSBILL2000   | MENU2         | 3            |
      | ZSBILL2000   | MENU9 - SUB1  | 3            |
      | ZSBILL2000   | MENU6 - SUB4  | 3            |
      | ZSBILL2000   | MENU5 - SUB4  | 3            |
      | ZSBILL2000   | MENU4 - SUB9  | 3            |
      | ZSBILL2000   | MENU4 - SUB4  | 3            |
      | ZSBILL2000   | MENU3 - SUB3  | 3            |
      | ZSBILL2000   | MENU2 - SUB2  | 3            |
      | ZSBILL2000   | MENU9 - SUB3  | 3            |
      | ZSBILL2000   | MENU1 - SUB1  | 3            |
      | ZSBILL2000   | MENU7         | 3            |
      | ZSBILL2000   | MENU6 - SUB1  | 3            |
      | ZSBILL2000   | MENU5 - SUB1  | 3            |
      | ZSBILL2000   | MENU4 - SUB6  | 3            |
      | ZSBILL2000   | MENU4 - SUB1  | 3            |
      | ZSBILL2000   | MENU3         | 3            |
      | ZSBILL2000   | MENU9 - SUB5  | 3            |
      | ZSBILL7000   | MENU4 - SUB5  | 4            |
      | ZSBILL7000   | MENU4         | 4            |
      | ZSBILL7000   | MENU2 - SUB3  | 4            |
      | ZSBILL7000   | MENU9 - SUB4  | 4            |
      | ZSBILL7000   | MENU1 - SUB2  | 4            |
      | ZSBILL7000   | MENU8         | 4            |
      | ZSBILL7000   | MENU6 - SUB2  | 4            |
      | ZSBILL7000   | MENU5 - SUB2  | 4            |
      | ZSBILL7000   | MENU4 - SUB7  | 4            |
      | ZSBILL7000   | MENU4 - SUB2  | 4            |
      | ZSBILL7000   | MENU3 - SUB1  | 4            |
      | ZSBILL7000   | MENU9 - SUB6  | 4            |
      | ZSBILL7000   | MENU2         | 4            |
      | ZSBILL7000   | MENU9 - SUB1  | 4            |
      | ZSBILL7000   | MENU6 - SUB4  | 4            |
      | ZSBILL7000   | MENU5 - SUB4  | 4            |
      | ZSBILL7000   | MENU4 - SUB9  | 4            |
      | ZSBILL7000   | MENU4 - SUB4  | 4            |
      | ZSBILL7000   | MENU3 - SUB3  | 4            |
      | ZSBILL7000   | MENU2 - SUB2  | 4            |
      | ZSBILL7000   | MENU9 - SUB3  | 4            |
      | ZSBILL7000   | MENU1 - SUB1  | 4            |
      | ZSBILL7000   | MENU7         | 4            |
      | ZSBILL7000   | MENU6 - SUB1  | 4            |
      | ZSBILL7000   | MENU5 - SUB1  | 4            |
      | ZSBILL7000   | MENU4 - SUB6  | 4            |
      | ZSBILL7000   | MENU4 - SUB1  | 4            |
      | ZSBILL7000   | MENU3         | 4            |
      | ZSBILL7000   | MENU9 - SUB5  | 4            |
      | ZSBILL7000   | MENU1 - SUB3  | 4            |
      | ZSBILL7000   | MENU9         | 4            |
      | ZSBILL7000   | MENU6 - SUB3  | 4            |
      | ZSBILL7000   | MENU5 - SUB3  | 4            |
      | ZSBILL7000   | MENU4 - SUB8  | 4            |
      | ZSBILL7000   | MENU4 - SUB3  | 4            |
      | ZSBILL7000   | MENU3 - SUB2  | 4            |
      | ZSBILL7000   | MENU2 - SUB1  | 4            |
      | ZSBILL7000   | MENU9 - SUB2  | 4            |
      | ZSBILL7000   | MENU1         | 4            |
      | ZSBILL7000   | MENU6 - SUB5  | 4            |
      | ZSBILL7000   | MENU6         | 4            |
      | ZSBILL7000   | MENU5         | 4            |
      | ZSBILL4000   | MENU4 - SUB3  | 5            |
      | ZSBILL4000   | MENU3 - SUB2  | 5            |
      | ZSBILL4000   | MENU2 - SUB1  | 5            |
      | ZSBILL4000   | MENU9 - SUB2  | 5            |
      | ZSBILL4000   | MENU1         | 5            |
      | ZSBILL4000   | MENU6 - SUB5  | 5            |
      | ZSBILL4000   | MENU6         | 5            |
      | ZSBILL4000   | MENU5         | 5            |
      | ZSBILL4000   | MENU4 - SUB5  | 5            |
      | ZSBILL4000   | MENU4         | 5            |
      | ZSBILL4000   | MENU2 - SUB3  | 5            |
      | ZSBILL4000   | MENU9 - SUB4  | 5            |
      | ZSBILL4000   | MENU1 - SUB2  | 5            |
      | ZSBILL4000   | MENU8         | 5            |
      | ZSBILL4000   | MENU6 - SUB2  | 5            |
      | ZSBILL4000   | MENU5 - SUB2  | 5            |
      | ZSBILL4000   | MENU4 - SUB7  | 5            |
      | ZSBILL4000   | MENU4 - SUB2  | 5            |
      | ZSBILL4000   | MENU3 - SUB1  | 5            |
      | ZSBILL4000   | MENU9 - SUB6  | 5            |
      | ZSBILL4000   | MENU2         | 5            |
      | ZSBILL4000   | MENU9 - SUB1  | 5            |
      | ZSBILL4000   | MENU6 - SUB4  | 5            |
      | ZSBILL4000   | MENU5 - SUB4  | 5            |
      | ZSBILL4000   | MENU4 - SUB9  | 5            |
      | ZSBILL4000   | MENU4 - SUB4  | 5            |
      | ZSBILL4000   | MENU3 - SUB3  | 5            |
      | ZSBILL4000   | MENU2 - SUB2  | 5            |
      | ZSBILL4000   | MENU9 - SUB3  | 5            |
      | ZSBILL4000   | MENU1 - SUB1  | 5            |
      | ZSBILL4000   | MENU7         | 5            |
      | ZSBILL4000   | MENU6 - SUB1  | 5            |
      | ZSBILL4000   | MENU5 - SUB1  | 5            |
      | ZSBILL4000   | MENU4 - SUB6  | 5            |
      | ZSBILL4000   | MENU4 - SUB1  | 5            |
      | ZSBILL4000   | MENU3         | 5            |
      | ZSBILL4000   | MENU9 - SUB5  | 5            |
      | ZSBILL4000   | MENU1 - SUB3  | 5            |
      | ZSBILL4000   | MENU9         | 5            |
      | ZSBILL4000   | MENU6 - SUB3  | 5            |
      | ZSBILL4000   | MENU5 - SUB3  | 5            |
      | ZSBILL4000   | MENU4 - SUB8  | 5            |
      | ZSBILL5000   | MENU2 - SUB1  | 6            |
      | ZSBILL5000   | MENU9 - SUB2  | 6            |
      | ZSBILL5000   | MENU1         | 6            |
      | ZSBILL5000   | MENU6 - SUB5  | 6            |
      | ZSBILL5000   | MENU6         | 6            |
      | ZSBILL5000   | MENU5         | 6            |
      | ZSBILL5000   | MENU4 - SUB5  | 6            |
      | ZSBILL5000   | MENU4         | 6            |
      | ZSBILL5000   | MENU2 - SUB3  | 6            |
      | ZSBILL5000   | MENU9 - SUB4  | 6            |
      | ZSBILL5000   | MENU1 - SUB2  | 6            |
      | ZSBILL5000   | MENU8         | 6            |
      | ZSBILL5000   | MENU6 - SUB2  | 6            |
      | ZSBILL5000   | MENU5 - SUB2  | 6            |
      | ZSBILL5000   | MENU4 - SUB7  | 6            |
      | ZSBILL5000   | MENU4 - SUB2  | 6            |
      | ZSBILL5000   | MENU3 - SUB1  | 6            |
      | ZSBILL5000   | MENU9 - SUB6  | 6            |
      | ZSBILL5000   | MENU2         | 6            |
      | ZSBILL5000   | MENU9 - SUB1  | 6            |
      | ZSBILL5000   | MENU6 - SUB4  | 6            |
      | ZSBILL5000   | MENU5 - SUB4  | 6            |
      | ZSBILL5000   | MENU4 - SUB9  | 6            |
      | ZSBILL5000   | MENU4 - SUB4  | 6            |
      | ZSBILL5000   | MENU3 - SUB3  | 6            |
      | ZSBILL5000   | MENU2 - SUB2  | 6            |
      | ZSBILL5000   | MENU9 - SUB3  | 6            |
      | ZSBILL5000   | MENU1 - SUB1  | 6            |
      | ZSBILL5000   | MENU7         | 6            |
      | ZSBILL5000   | MENU6 - SUB1  | 6            |
      | ZSBILL5000   | MENU5 - SUB1  | 6            |
      | ZSBILL5000   | MENU4 - SUB6  | 6            |
      | ZSBILL5000   | MENU4 - SUB1  | 6            |
      | ZSBILL5000   | MENU3         | 6            |
      | ZSBILL5000   | MENU9 - SUB5  | 6            |
      | ZSBILL5000   | MENU1 - SUB3  | 6            |
      | ZSBILL5000   | MENU9         | 6            |
      | ZSBILL5000   | MENU6 - SUB3  | 6            |
      | ZSBILL5000   | MENU5 - SUB3  | 6            |
      | ZSBILL5000   | MENU4 - SUB8  | 6            |
      | ZSBILL5000   | MENU4 - SUB3  | 6            |
      | ZSBILL5000   | MENU3 - SUB2  | 6            |
      | ZSBILL8000   | MENU9 - SUB4  | 7            |
      | ZSBILL8000   | MENU2 - SUB3  | 7            |
      | ZSBILL8000   | MENU1 - SUB2  | 7            |
      | ZSBILL8000   | MENU8         | 7            |
      | ZSBILL8000   | MENU6 - SUB2  | 7            |
      | ZSBILL8000   | MENU5 - SUB2  | 7            |
      | ZSBILL8000   | MENU4 - SUB7  | 7            |
      | ZSBILL8000   | MENU4 - SUB2  | 7            |
      | ZSBILL8000   | MENU9 - SUB6  | 7            |
      | ZSBILL8000   | MENU3 - SUB1  | 7            |
      | ZSBILL8000   | MENU9 - SUB1  | 7            |
      | ZSBILL8000   | MENU2         | 7            |
      | ZSBILL8000   | MENU6 - SUB4  | 7            |
      | ZSBILL8000   | MENU5 - SUB4  | 7            |
      | ZSBILL8000   | MENU4 - SUB9  | 7            |
      | ZSBILL8000   | MENU4 - SUB4  | 7            |
      | ZSBILL8000   | MENU3 - SUB3  | 7            |
      | ZSBILL8000   | MENU9 - SUB3  | 7            |
      | ZSBILL8000   | MENU2 - SUB2  | 7            |
      | ZSBILL8000   | MENU1 - SUB1  | 7            |
      | ZSBILL8000   | MENU7         | 7            |
      | ZSBILL8000   | MENU6 - SUB1  | 7            |
      | ZSBILL8000   | MENU5 - SUB1  | 7            |
      | ZSBILL8000   | MENU4 - SUB6  | 7            |
      | ZSBILL8000   | MENU4 - SUB1  | 7            |
      | ZSBILL8000   | MENU9 - SUB5  | 7            |
      | ZSBILL8000   | MENU3         | 7            |
      | ZSBILL8000   | MENU1 - SUB3  | 7            |
      | ZSBILL8000   | MENU9         | 7            |
      | ZSBILL8000   | MENU6 - SUB3  | 7            |
      | ZSBILL8000   | MENU5 - SUB3  | 7            |
      | ZSBILL8000   | MENU4 - SUB8  | 7            |
      | ZSBILL8000   | MENU4 - SUB3  | 7            |
      | ZSBILL8000   | MENU3 - SUB2  | 7            |
      | ZSBILL8000   | MENU9 - SUB2  | 7            |
      | ZSBILL8000   | MENU2 - SUB1  | 7            |
      | ZSBILL8000   | MENU1         | 7            |
      | ZSBILL8000   | MENU6 - SUB5  | 7            |
      | ZSBILL8000   | MENU6         | 7            |
      | ZSBILL8000   | MENU5         | 7            |
      | ZSBILL8000   | MENU4 - SUB5  | 7            |
      | ZSBILL8000   | MENU4         | 7            |
      | ZSBILL6000   | MENU6         | 8            |
      | ZSBILL6000   | MENU5         | 8            |
      | ZSBILL6000   | MENU4 - SUB5  | 8            |
      | ZSBILL6000   | MENU4         | 8            |
      | ZSBILL6000   | MENU9 - SUB4  | 8            |
      | ZSBILL6000   | MENU2 - SUB3  | 8            |
      | ZSBILL6000   | MENU8         | 8            |
      | ZSBILL6000   | MENU1 - SUB2  | 8            |
      | ZSBILL6000   | MENU6 - SUB2  | 8            |
      | ZSBILL6000   | MENU5 - SUB2  | 8            |
      | ZSBILL6000   | MENU4 - SUB7  | 8            |
      | ZSBILL6000   | MENU4 - SUB2  | 8            |
      | ZSBILL6000   | MENU9 - SUB6  | 8            |
      | ZSBILL6000   | MENU3 - SUB1  | 8            |
      | ZSBILL6000   | MENU9 - SUB1  | 8            |
      | ZSBILL6000   | MENU2         | 8            |
      | ZSBILL6000   | MENU6 - SUB4  | 8            |
      | ZSBILL6000   | MENU5 - SUB4  | 8            |
      | ZSBILL6000   | MENU4 - SUB9  | 8            |
      | ZSBILL6000   | MENU4 - SUB4  | 8            |
      | ZSBILL6000   | MENU3 - SUB3  | 8            |
      | ZSBILL6000   | MENU9 - SUB3  | 8            |
      | ZSBILL6000   | MENU2 - SUB2  | 8            |
      | ZSBILL6000   | MENU1 - SUB1  | 8            |
      | ZSBILL6000   | MENU7         | 8            |
      | ZSBILL6000   | MENU6 - SUB1  | 8            |
      | ZSBILL6000   | MENU5 - SUB1  | 8            |
      | ZSBILL6000   | MENU4 - SUB6  | 8            |
      | ZSBILL6000   | MENU4 - SUB1  | 8            |
      | ZSBILL6000   | MENU9 - SUB5  | 8            |
      | ZSBILL6000   | MENU3         | 8            |
      | ZSBILL6000   | MENU9         | 8            |
      | ZSBILL6000   | MENU1 - SUB3  | 8            |
      | ZSBILL6000   | MENU6 - SUB3  | 8            |
      | ZSBILL6000   | MENU5 - SUB3  | 8            |
      | ZSBILL6000   | MENU4 - SUB8  | 8            |
      | ZSBILL6000   | MENU4 - SUB3  | 8            |
      | ZSBILL6000   | MENU3 - SUB2  | 8            |
      | ZSBILL6000   | MENU9 - SUB2  | 8            |
      | ZSBILL6000   | MENU2 - SUB1  | 8            |
      | ZSBILL6000   | MENU1         | 8            |
      | ZSBILL6000   | MENU6 - SUB5  | 8            |
      | ZSBILL9000   | MENU6 - SUB2  | 9            |
      | ZSBILL9000   | MENU5 - SUB2  | 9            |
      | ZSBILL9000   | MENU4 - SUB7  | 9            |
      | ZSBILL9000   | MENU4 - SUB2  | 9            |
      | ZSBILL9000   | MENU3 - SUB1  | 9            |
      | ZSBILL9000   | MENU9 - SUB6  | 9            |
      | ZSBILL9000   | MENU2         | 9            |
      | ZSBILL9000   | MENU9 - SUB1  | 9            |
      | ZSBILL9000   | MENU6 - SUB4  | 9            |
      | ZSBILL9000   | MENU5 - SUB4  | 9            |
      | ZSBILL9000   | MENU4 - SUB9  | 9            |
      | ZSBILL9000   | MENU4 - SUB4  | 9            |
      | ZSBILL9000   | MENU3 - SUB3  | 9            |
      | ZSBILL9000   | MENU2 - SUB2  | 9            |
      | ZSBILL9000   | MENU9 - SUB3  | 9            |
      | ZSBILL9000   | MENU1 - SUB1  | 9            |
      | ZSBILL9000   | MENU7         | 9            |
      | ZSBILL9000   | MENU6 - SUB1  | 9            |
      | ZSBILL9000   | MENU5 - SUB1  | 9            |
      | ZSBILL9000   | MENU4 - SUB6  | 9            |
      | ZSBILL9000   | MENU4 - SUB1  | 9            |
      | ZSBILL9000   | MENU3         | 9            |
      | ZSBILL9000   | MENU9 - SUB5  | 9            |
      | ZSBILL9000   | MENU1 - SUB3  | 9            |
      | ZSBILL9000   | MENU9         | 9            |
      | ZSBILL9000   | MENU6 - SUB3  | 9            |
      | ZSBILL9000   | MENU5 - SUB3  | 9            |
      | ZSBILL9000   | MENU4 - SUB8  | 9            |
      | ZSBILL9000   | MENU4 - SUB3  | 9            |
      | ZSBILL9000   | MENU3 - SUB2  | 9            |
      | ZSBILL9000   | MENU2 - SUB1  | 9            |
      | ZSBILL9000   | MENU9 - SUB2  | 9            |
      | ZSBILL9000   | MENU1         | 9            |
      | ZSBILL9000   | MENU6 - SUB5  | 9            |
      | ZSBILL9000   | MENU6         | 9            |
      | ZSBILL9000   | MENU5         | 9            |
      | ZSBILL9000   | MENU4 - SUB5  | 9            |
      | ZSBILL9000   | MENU4         | 9            |
      | ZSBILL9000   | MENU2 - SUB3  | 9            |
      | ZSBILL9000   | MENU9 - SUB4  | 9            |
      | ZSBILL9000   | MENU1 - SUB2  | 9            |
      | ZSBILL9000   | MENU8         | 9            |
      +--------------+---------------+--------------+
      378 rows in set (0.01 sec)
      

        Attachments

          Activity

            People

            Assignee:
            igor Igor Babaev
            Reporter:
            sanedl NAMHEE KIM
            Votes:
            3 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated: