Skip to content

Conversation

@MatthiasKuehneEllerhold
Copy link

@MatthiasKuehneEllerhold MatthiasKuehneEllerhold commented Oct 9, 2017

Using bernardphp with the doctrine driver produces this invalid SELECT statement:

SELECT id, message FROM bernard_messages
WHERE queue = :queue AND visible = :visible
ORDER BY sentAt, id 
LIMIT 1FOR UPDATE

As you can see there is a space missing between "LIMIT 1" and "FOR UPDATE".

This error exists in 0.12.3 (latest stable) and the 0.x branch. It is fixed in the master though.

This error is thrown and silently ignored in the driver so it never makes it to the consumer. This makes it very hard to notice.

@MatthiasKuehneEllerhold MatthiasKuehneEllerhold changed the title DoctrineDriver: Fix "LIMIT 1FOR UPDATE" [0.x] DoctrineDriver: Fix "LIMIT 1FOR UPDATE" Oct 9, 2017
@acrobat
Copy link
Member

acrobat commented Nov 5, 2017

@sagikazarmark should we still merge this PR and release a new 0.x version? We are working towards 1.0 and this fix is already present in newer versions so a "upgrade" from 0.x to 1.0-alpha would fix this issue

@sagikazarmark
Copy link
Contributor

I have no problem with merging it and tagging as a 0.x patch release. Until 1.0 0.x is the "stable" release branch.

@sagikazarmark
Copy link
Contributor

@acrobat Do you want to merge it or should I?

@acrobat
Copy link
Member

acrobat commented Nov 5, 2017

Ok thanks for the feedback! I will merge and release!

@acrobat
Copy link
Member

acrobat commented Nov 5, 2017

Thanks @MatthiasKuehneEllerhold!

@acrobat acrobat merged commit c452caa into bernardphp:0.x Nov 5, 2017
@acrobat
Copy link
Member

acrobat commented Nov 5, 2017

@MatthiasKuehneEllerhold a new version was tagged, see 0.12.4

@MatthiasKuehneEllerhold
Copy link
Author

Happy to help.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants