Return to mysqli_insert_packet_overflow.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests

Annotation of embedaddon/php/ext/mysqli/tests/mysqli_insert_packet_overflow.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: INSERT and packet overflow
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: 
                      8: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                      9:        die(sprintf("SKIP [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()));
                     10: 
                     11: $max_len = pow(2, 24);
                     12: if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
                     13:        die(sprintf("SKIP [%d] %s\n", mysqli_errno($link), mysqli_error($link)));
                     14: 
                     15: if (!mysqli_query($link, "SET NAMES 'latin1'"))
                     16:        die(sprintf("SKIP [%d] %s\n", mysqli_errno($link), mysqli_error($link)));
                     17: 
                     18: mysqli_close($link);
                     19: ?>
                     20: --INI--
                     21: memory_limit=256M
                     22: --FILE--
                     23: <?php
                     24:        require('connect.inc');
                     25:        if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     26:                printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
                     27: 
                     28:        if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
                     29:                printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     30: 
                     31:        if (!$row = mysqli_fetch_assoc($res))
                     32:                printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     33: 
                     34:        mysqli_free_result($res);
                     35: 
                     36:        if (0 === ($org_max_allowed_packet = (int)$row['Value']))
                     37:                printf("[004] Cannot determine max_allowed_packet size and/or bogus max_allowed_packet setting used.\n");
                     38: 
                     39:        $max_len = pow(2, 24);
                     40:        if ($org_max_allowed_packet < $max_len) {
                     41:                if (!mysqli_query($link, "SET GLOBAL max_allowed_packet = " . ($max_len + 100))) {
                     42:                        if (1227 == mysqli_errno($link)) {
                     43:                                /* [1227] Access denied; you need the SUPER privilege for this operation */
                     44:                                print "done!";
                     45:                                exit(0);
                     46:                        } else {
                     47:                                printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     48:                        }
                     49:                }
                     50:        }
                     51:        mysqli_close($link);
                     52:        if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     53:                printf("[006] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
                     54: 
                     55:        if (!mysqli_query($link, "SET NAMES 'latin1'"))
                     56:                printf("[007] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
                     57: 
                     58:        if (!$res = mysqli_query($link, "SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'"))
                     59:                printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     60: 
                     61:        if (!$row = mysqli_fetch_assoc($res))
                     62:                printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     63: 
                     64:        mysqli_free_result($res);
                     65: 
                     66:        if (0 === ($max_allowed_packet = (int)$row['Value']))
                     67:                printf("[010] Cannot determine max_allowed_packet size and/or bogus max_allowed_packet setting used.\n");
                     68: 
                     69:        $max_len = pow(2, 24);
                     70:        if ($max_allowed_packet < $max_len) {
                     71:                printf("[011] Failed to change max_allowed_packet");
                     72:        }
                     73: 
                     74:        if (!mysqli_query($link, "CREATE TABLE test(col_blob LONGBLOB) ENGINE=" . $engine))
                     75:                printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     76: 
                     77:        $query_prefix = "INSERT INTO test(col_blob) VALUES ('";
                     78:        $query_postfix = "')";
                     79:        $query_len = strlen($query_prefix) + strlen($query_postfix);
                     80:        $com_query_len = 2;
                     81: 
                     82: 
                     83:        $blob = str_repeat('a', $max_len - $com_query_len - $query_len);
                     84:        $query = sprintf("%s%s%s", $query_prefix, $blob, $query_postfix);
                     85: 
                     86:        if (!mysqli_query($link, $query))
                     87:                printf("[013] max_allowed_packet = %d, strlen(query) = %d, [%d] %s\n", $max_allowed_packet, strlen($query), mysqli_errno($link), mysqli_error($link));
                     88: 
                     89:        if (!$res = mysqli_query($link, "SELECT col_blob FROM test"))
                     90:                printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     91: 
                     92:        if (!$row = mysqli_fetch_assoc($res)) {
                     93:                printf("[015] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     94:        } else {
                     95:                if ($row['col_blob'] != $blob) {
                     96:                        printf("[016] Blob seems wrong, dumping data\n");
                     97:                        var_dump(strlen($row['col_blob']));
                     98:                        var_dump(strlen($blob));
                     99:                }
                    100:                mysqli_free_result($res);
                    101:        }
                    102: 
                    103:        if (!mysqli_query($link, "SET GLOBAL max_allowed_packet = " . $org_max_allowed_packet))
                    104:                if (1227 != mysqli_errno($link))
                    105:                        printf("[017] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                    106: 
                    107:        mysqli_close($link);
                    108: 
                    109:        print "done!";
                    110: ?>
                    111: --CLEAN--
                    112: <?php
                    113:        require_once("clean_table.inc");
                    114: ?>
                    115: --EXPECTF--
                    116: done!