Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open.

2023-11-27 Thread Matteo Beccati
Hi Saki, Il 26/11/2023 03:30, Saki Takamachi ha scritto: The behavior in this case varies depending on the DB driver and is not unified. MySQL, OCI, ODBC, and Firebird currently support PDO autocommit mode. - MySQL always sets the new mode regardless of the state of the transaction,

Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open.

2023-11-27 Thread Saki Takamachi
Hi Matteo, > PDO's main goal was to make building db drivers easier, and it's not meant to > be a full DB abstraction layer. > > As such, it is not expected that all databases behave the same, especially > for exotic functionality, such as autocommit. As you say, such behavior varies from DB

Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open.

2023-11-27 Thread Matteo Beccati
Hi, Il 27/11/2023 10:23, Saki Takamachi ha scritto: As you say, such behavior varies from DB to DB. However, with the current implementation of PDO, we don't know how it will work until you actually try it, and each driver has different behavior, so it is important to describe how it works

[PHP-DEV] Callable arguments cannot have default value

2023-11-27 Thread Sergii Shymko
Hi, Wanted to bring up an inconsistent behavior of callable arguments compared to arguments of other types. Callable argument cannot have a default value (tested string or array types - both are not permitted). The same exact value works perfectly fine when passed dynamically, it just cannot

Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open.

2023-11-27 Thread Saki Takamachi
Hi, > In the latter case, I suppose they would expect the behaviour to be compliant > with the database standards. I may not have had this perspective. And this is a strong basis for explaining that different drivers behave differently. I will continue with the current implementation and

Re: [PHP-DEV] [PDO] I want to unify the behavior when changing the autocommit mode setting while a transaction is open.

2023-11-27 Thread Ayesh Karunaratne
> > Hi, > > > In the latter case, I suppose they would expect the behaviour to be > > compliant with the database standards. > > I may not have had this perspective. And this is a strong basis for > explaining that different drivers behave differently. > > I will continue with the current