Annotation of embedaddon/php/ext/mysqli/tests/mysqli_insert_id_variation.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: Checking last_insert_id after different operations
! 3: --SKIPIF--
! 4: <?php
! 5: require_once('skipif.inc');
! 6: require_once('skipifconnectfailure.inc');
! 7: ?>
! 8: --FILE--
! 9: <?php
! 10: require_once("connect.inc");
! 11:
! 12: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
! 13: printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
! 14: $host, $user, $db, $port, $socket);
! 15:
! 16: $link->query("DROP TABLE IF EXISTS test_insert_id_var");
! 17: $link->query("CREATE TABLE test_insert_id_var (id INT auto_increment, PRIMARY KEY (id))");
! 18: $link->query("INSERT INTO test_insert_id_var VALUES (null)");
! 19: $i = $link->insert_id;
! 20:
! 21: if (!$i) {
! 22: printf("[001] Got no valid insert id: %s", var_export($i, true));
! 23: die();
! 24: }
! 25:
! 26:
! 27: $link->options(MYSQLI_OPT_LOCAL_INFILE, false);
! 28: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 29: printf("[002] mysqli_option changes insert_id: %s", var_export($link->insert_id, true));
! 30: die();
! 31: }
! 32:
! 33: /*
! 34: $link->dump_debug_info();
! 35: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 36: printf("[003] mysqli_debug_info changes insert_id: %s", var_export($link->insert_id, true));
! 37: die();
! 38: }
! 39: */
! 40:
! 41: $link->stat();
! 42: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 43: printf("[004] mysqli_stat changes insert_id: %s", var_export($link->insert_id, true));
! 44: die();
! 45: }
! 46:
! 47: /*$link->kill($link->thread_id);
! 48: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 49: printf("[005] mysqli_kill changes insert_id: %s", var_export($link->insert_id, true));
! 50: die();
! 51: }*/
! 52:
! 53: $link->ping();
! 54: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 55: printf("[006] mysqli_ping changes insert_id: %s", var_export($link->insert_id, true));
! 56: die();
! 57: }
! 58:
! 59: /*
! 60: mysqlnd resets the IDE to 0
! 61: libmysql doesn't
! 62:
! 63: $link->change_user ($user, $passwd, $db);
! 64: if (0 != $link->insert_id || 0 != mysqli_insert_id($link)) {
! 65: printf("[007] mysqli_change_user changes insert_id: %s", var_export($link->insert_id, true));
! 66: die();
! 67: }
! 68: */
! 69:
! 70: $stmt = $link->prepare("SELECT 1");
! 71: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 72: printf("[008a] mysqli_prepare changes insert_id: %s", var_export($link->insert_id, true));
! 73: die();
! 74: }
! 75: echo mysqli_error($link);
! 76: if (0 != $stmt->insert_id || 0 != mysqli_stmt_insert_id($stmt)) {
! 77: printf("[008b] mysqli_stmt doesn't initialise insert_id: %s", var_export($stmt->insert_id, true));
! 78: die();
! 79: }
! 80:
! 81: unset($stmt);
! 82: if ($i != $link->insert_id || $i != mysqli_insert_id($link)) {
! 83: printf("[009] stmt free changes insert_id: %s", var_export($link->insert_id, true));
! 84: die();
! 85: }
! 86:
! 87: $link->query("DROP TABLE IF EXISTS test_insert_id_var");
! 88:
! 89: echo "DONE";
! 90: ?>
! 91: --CLEAN--
! 92: <?php
! 93: require_once("connect.inc");
! 94: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
! 95: printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
! 96:
! 97: if (!mysqli_query($link, "DROP TABLE IF EXISTS test_insert_id_var"))
! 98: printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 99:
! 100: mysqli_close($link);
! 101: ?>
! 102: --EXPECTF--
! 103: DONE
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>