DataFrame/Series at set value test GH#30649

- [ ] closes #30649 (Replace xxxx with the GitHub issue number)
- [ ] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).

Hi @liang3zy22 thanks for the PR!

By running the example code in #30649 in the main branch, It seems we still get the errononous behavior, do you agree, i.e. this PR doesn't close that issue?  Oh, so 30649 is not fixed. My codes just tested what it behaves now. Yes :-). Want to search for how to fix it?  Yeah @topper-123 , please give me some info about how to fix this issue. I want to fix it. This may potentially not be so easy and it can take quite some time to for me also to figure out what need to be fixed here. So you need to either dig into this, or find some other issues you're interested in. Sorry. 

If you're interested in working on some other good starter issue, you can look into some of the issues at https://github.com/pandas-dev/pandas/issues?q=is%3Aopen+is%3Aissue+label%3A%22good+first+issue%22

If you decide you don't want to keep looking into this issue, can you close this PR. ok, I close my PR. Hope this issue can be fixed soon.