Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG]: RawValue no longer supports mysql functions #16037

Closed
ALameLlama opened this issue Aug 3, 2022 · 1 comment
Closed

[BUG]: RawValue no longer supports mysql functions #16037

ALameLlama opened this issue Aug 3, 2022 · 1 comment
Labels
5.0 The issues we want to solve in the 5.0 release bug A bug report status: medium Medium

Comments

@ALameLlama
Copy link
Contributor

ALameLlama commented Aug 3, 2022

Describe the bug
It looks like the change in this PR #15413 has broken how it handles MySQL functions

To Reproduce
This is taken from the function example Docblock.
$subscriber->createdAt = new \Phalcon\Db\RawValue("now()");
Or something like:
$subscriber->expiry = new \Phalcon\Db\RawValue("now() + INTERVAL 30 DAY");

PDOException #22007
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'now()' for column `database`.`table`.`created_at` at row 1
PDOException #22007
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'now() + INTERVAL 30 DAY' for column `database`.`table`.`expiry` at row 1

Details

  • Phalcon version: 5.0.0RC3
  • PHP Version: 7.4.30
  • Operating System: Ubuntu 20.04.4
  • Installation type: Any
  • Zephir version (if any): NA
  • Server: Apache
@ALameLlama ALameLlama added bug A bug report status: unverified Unverified labels Aug 3, 2022
@niden niden added status: medium Medium 5.0 The issues we want to solve in the 5.0 release and removed status: unverified Unverified labels Aug 5, 2022
@niden niden added this to Working on it in Phalcon Roadmap Aug 5, 2022
@niden
Copy link
Sponsor Member

niden commented Aug 8, 2022

Resolved in #16038

@niden niden closed this as completed Aug 8, 2022
Phalcon Roadmap automation moved this from Working on it to Implemented Aug 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
5.0 The issues we want to solve in the 5.0 release bug A bug report status: medium Medium
Projects
Archived in project
Phalcon Roadmap
  
Implemented
Development

No branches or pull requests

2 participants