# Enforce LIKE to be case sensitive, just like MySQL
$this->query( 'PRAGMA case_sensitive_like = 1' );
+ $sync = $this->sessionVars['synchronous'] ?? null;
+ if ( in_array( $sync, [ 'EXTRA', 'FULL', 'NORMAL' ], true ) ) {
+ $this->query( "PRAGMA synchronous = $sync" );
+ }
+
return $this->conn;
}
$this->startAtomic( $fname, self::ATOMIC_CANCELABLE );
foreach ( $a as $v ) {
parent::insert( $table, $v, "$fname/multi-row", $options );
+ $affectedRowCount += $this->affectedRows();
}
$this->endAtomic( $fname );
} catch ( Exception $e ) {
}
}
- $res = $this->query( $sql, $fname );
+ $res = $this->query( $sql, $fname, self::QUERY_PSEUDO_PERMANENT );
// Take over indexes
$indexList = $this->query( 'PRAGMA INDEX_LIST(' . $this->addQuotes( $oldName ) . ')' );