Feature Request: Support explicitly disabling PDO::ATTR_EMULATE_PREPARES at the connection level

[IMSoP]

Hi,

Some libraries which wrap PDO try to ensure emulated prepares are off on newly created connections, e.g. EasyDB.

this->pdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);

However, this driver defines that variable as "statement-level only" so gives an error:

PDOException: SQLSTATE[IMSSP]: The given attribute is only supported on the PDOStatement object. in /srv/app-service-auth/vendor/paragonie/easydb/src/EasyDB.php:50

As I understand it, the setting is off by default anyway, so this line would be a no-op if accepted. Would it be possible to accept the attribute, but only accept a value of false? That way, libraries wouldn't need driver-specific workarounds.

[yitam]

Hi @IMSoP, we will get back to you on this.

[yitam]

Yes @IMSoP we are looking into implementing this as a legitimate connection attribute but the emulate prepare option the users set for the prepared statements still overrides it.

[yitam]

5.10.0-beta 2 is just released. Please give it a try, @IMSoP

[yitam]

Closing this now please feel free to ask us to reopen.