Home
last modified time | relevance | path

Searched refs:autocommit (Results 1 – 21 of 21) sorted by relevance

/php-src/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_autocommit.phpt15 // autocommit should be on by default
20 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
26 printf("[003] Cannot turn off autocommit\n");
28 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
32 // PDO thinks autocommit is off, but its manually turned on...
33 if (!$db->query('SET autocommit = 1'))
40 if (!$db->query('SET autocommit = 0'))
44 printf("[008] Cannot turn on autocommit\n");
46 $row = $db->query('SELECT @@autocommit AS _autocommit')->fetch(PDO::FETCH_ASSOC);
67 // autocommit is on, no rollback possible
[all …]
H A Dpdo_mysql_begintransaction.phpt108 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit')))
113 … printf("[023] MySQL Server should indicate autocommit mode, expecting 1, got '%s', [%d] %s\n",
119 if (!($stmt = $db->query('SELECT @@autocommit as auto_commit')))
128 // Now we should be back to autocommit - we've issues a commit
130 … printf("[027] MySQL Server should indicate autocommit mode, expecting 1, got '%s', [%d] %s\n",
133 // Turn off autocommit using a server variable
134 $db->exec('SET @@autocommit = 0');
136 …printf("[028] I'm confused, how can autocommit be on? Didn't I say I want to manually control tran…
207 [028] I'm confused, how can autocommit be on? Didn't I say I want to manually control transactions?
H A Dpdo_mysql_commit.phpt39 … printf("[003] According to the manual we should be back to autocommit mode, got %s/%s\n",
/php-src/ext/mysqli/tests/
H A D074.phpt16 var_dump($mysqli->autocommit(false));
17 $result = $mysqli->query("SELECT @@autocommit");
20 var_dump($mysqli->autocommit(true));
21 $result = $mysqli->query("SELECT @@autocommit");
H A Dmysqli_autocommit_oo.phpt2 mysqli->autocommit()
22 if (!is_bool($tmp = $mysqli->autocommit(true)))
28 if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
34 printf("[005] Cannot turn off autocommit\n");
36 if (true !== ($tmp = $mysqli->autocommit( true)))
39 if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
44 printf("[008] Cannot turn on autocommit\n");
74 if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
80 printf("[018] Cannot turn on autocommit\n");
82 if (true !== ($tmp = $mysqli->autocommit( false)))
[all …]
H A Dmysqli_autocommit.phpt32 if (!$res = mysqli_query($link, 'SELECT @@autocommit as auto_commit'))
38 printf("[008] Cannot turn off autocommit\n");
43 if (!$res = mysqli_query($link, 'SELECT @@autocommit as auto_commit'))
48 printf("[011] Cannot turn on autocommit\n");
78 if (!$res = mysqli_query($link, 'SELECT @@autocommit as auto_commit'))
83 printf("[021] Cannot turn on autocommit\n");
H A Dmysqli_savepoint.phpt35 … printf("[009] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
37 /* overrule autocommit */
H A Dmysqli_commit_oo.phpt31 if (true !== ($tmp = $mysqli->autocommit(false))) {
32 … printf("[003] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
H A Dmysqli_begin_transaction.phpt26 printf("[010] Cannot turn on autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
28 /* overrule autocommit */
H A Dmysqli_rollback.phpt23 … printf("[005] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
H A Dmysqli_commit.phpt23 … printf("[005] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
H A Dmysqli_release_savepoint.phpt35 … printf("[009] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
H A Dmysqli_class_mysqli_interface.phpt23 'autocommit' => true,
/php-src/ext/pdo_odbc/tests/
H A Dautocommit_change_mode.phpt115 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
119 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
127 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
131 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
/php-src/ext/pdo_firebird/tests/
H A Dautocommit_change_mode.phpt115 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
119 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
127 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
131 SQLSTATE[HY000]: General error: Cannot change autocommit mode while a transaction is already open
/php-src/ext/odbc/tests/
H A Dodbc_setoption_001.phpt15 var_dump(odbc_setoption($conn, 1, 102 /* autocommit */, 0));
H A Dodbc_setoption_002.phpt15 var_dump(odbc_setoption($conn, 1, 102 /* autocommit */, 0));
/php-src/ext/mysqli/tests/bind_fetch/
H A Dsystem_variable.phpt18 $stmt = mysqli_prepare($link, "SELECT @@autocommit");
/php-src/ext/mysqli/tests/transactions/
H A D014.phpt2 mysqli autocommit/commit/rollback with innodb with CACHE
H A D015.phpt2 mysqli autocommit/commit/rollback with innodb with SQL_NO_CACHE
/php-src/ext/mysqli/
H A Dmysqli.stub.php735 public function autocommit(bool $enable): bool {} function in mysqli

Completed in 19 milliseconds