Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

[Doctrine][Messenger] Oracle sequences are suffixed with_seq#58557

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 ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
fabpot merged 1 commit intosymfony:6.4fromdevloop42:fix-oracle-sequence-name
Oct 18, 2024

Conversation

@devloop42
Copy link

@devloop42devloop42 commentedOct 14, 2024
edited
Loading

QA
Branch?6.4
Bug fix?yes
New feature?no
Deprecations?no
IssuesFix#58504
LicenseMIT

Generated sequences, by doctrine or in this case by the auto_setup of messenger, are suffixed with_seq.

@carsonbot
Copy link

Hey!

Thanks for your PR. You are targeting branch "6.4" but it seems your PR description refers to branch "6.4, and 7.1 for bug fixes".
Could you update the PR description or change target branch? This helps core maintainers a lot.

Cheers!

Carsonbot

@carsonbotcarsonbot changed the title[Messenger][Doctrine] Oracle sequences are suffixed with _seq[Doctrine][Messenger] Oracle sequences are suffixed with _seqOct 14, 2024
@devloop42devloop42 changed the title[Doctrine][Messenger] Oracle sequences are suffixed with _seq[Messenger][Doctrine] Oracle sequences are suffixed with _seqOct 14, 2024
Copy link
Member

@alexandre-dauboisalexandre-daubois left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Could this be covered by tests to avoid regressions?

// We need to create a sequence for Oracle and set the id column to get the correct nextval
if ($this->driverConnection->getDatabasePlatform()instanceof OraclePlatform) {
$idColumn->setDefault('seq_'.$this->configuration['table_name'].'.nextval');
$idColumn->setDefault($this->configuration['table_name'].'_seq'.'.nextval');

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Suggested change
$idColumn->setDefault($this->configuration['table_name'].'_seq'.'.nextval');
$idColumn->setDefault($this->configuration['table_name'].'_seq.nextval');

Copy link
Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

@alexandre-daubois : I updated that portion of code for consistency.
@rjd22 : Is this if block really needed as messenger in it's auto config process already create a sequence and trigger in case of id not specified ?

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Yes, for Oracle installations the default block is needed. Else the field won't use the sequence on some installations.

devloop42 reacted with thumbs up emoji
@OskarStarkOskarStark changed the title[Messenger][Doctrine] Oracle sequences are suffixed with _seq[Messenger][Doctrine] Oracle sequences are suffixed with_seqOct 14, 2024
@devloop42devloop42force-pushed thefix-oracle-sequence-name branch from882e17a to18eeb64CompareOctober 14, 2024 14:50
@rjd22
Copy link
Contributor

rjd22 commentedOct 17, 2024
edited
Loading

@xabbuh Since you looked at mine can you take a look at this one? It looks good to me. If we merge this before the next release we avoid a breaking change.

Copy link
Member

@xabbuhxabbuh left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

works for me

@carsonbotcarsonbot changed the title[Messenger][Doctrine] Oracle sequences are suffixed with_seq[Doctrine][Messenger] Oracle sequences are suffixed with_seqOct 17, 2024
@fabpotfabpotforce-pushed thefix-oracle-sequence-name branch from18eeb64 to6a17c04CompareOctober 18, 2024 07:50
@fabpot
Copy link
Member

Thank you@devloop42.

@fabpotfabpot merged commit5bc387b intosymfony:6.4Oct 18, 2024
7 of 9 checks passed
This was referencedOct 27, 2024
Sign up for freeto join this conversation on GitHub. Already have an account?Sign in to comment

Reviewers

@xabbuhxabbuhxabbuh approved these changes

@alexandre-dauboisalexandre-dauboisalexandre-daubois approved these changes

+1 more reviewer

@rjd22rjd22rjd22 left review comments

Reviewers whose approvals may not affect merge requirements

Assignees

No one assigned

Projects

None yet

Milestone

6.4

Development

Successfully merging this pull request may close these issues.

7 participants

@devloop42@carsonbot@rjd22@fabpot@xabbuh@alexandre-daubois@clem-rwan

[8]ページ先頭

©2009-2025 Movatter.jp