1--TEST-- 2mysqli_savepoint() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7 8require_once('connect.inc'); 9if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 10 die(sprintf("skip Cannot connect, [%d] %s", mysqli_connect_errno(), mysqli_connect_error())); 11 12if (!have_innodb($link)) 13 die(sprintf("skip Needs InnoDB support, [%d] %s", $link->errno, $link->error)); 14?> 15--FILE-- 16<?php 17 require_once("connect.inc"); 18 19 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 20 printf("[003] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 21 $host, $user, $db, $port, $socket); 22 23 try { 24 mysqli_savepoint($link, ''); 25 } catch (\ValueError $e) { 26 echo $e->getMessage() . \PHP_EOL; 27 } 28 29 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) 30 printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 32 if (!mysqli_query($link, 'CREATE TABLE test(id INT) ENGINE = InnoDB')) 33 printf("[008] Cannot create test table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 35 if (true !== ($tmp = mysqli_autocommit($link, false))) 36 printf("[009] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp); 37 38 /* overrule autocommit */ 39 if (true !== ($tmp = mysqli_savepoint($link, 'my'))) 40 printf("[010] Got %s - [%d] %s\n", var_dump($tmp, true), mysqli_errno($link), mysqli_error($link)); 41 42 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)')) 43 printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 44 45 $tmp = mysqli_rollback($link); 46 if ($tmp !== true) 47 printf("[012] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp); 48 49 print "done!"; 50?> 51--CLEAN-- 52<?php 53 require_once("clean_table.inc"); 54?> 55--EXPECT-- 56mysqli_savepoint(): Argument #2 ($name) cannot be empty 57done! 58