Worked on stabilizing SQL semantics in the StarRocks/starrocks repository by addressing a bug related to window functions in VIEW definitions. Focused on ensuring that the IGNORE NULLS clause is correctly preserved when window functions use expressions, preventing silent omission and maintaining intended query behavior. The solution involved targeted changes in Java, with careful attention to SQL parsing and unit testing to validate correctness. This fix improves the reliability of analytics queries that depend on accurate NULL-handling in views. The work was delivered through a formally reviewed and signed-off commit, reflecting disciplined code review and traceability throughout the development process.