Vibe codingHardvc-g101

Subject Ai code reviewLevel Senior–Staff~18 minCommon in Algorithms & data structures interviewsIndustries Software development

Question

An AI agent was asked to rename the `users.fullname` column to `users.full_name` for consistency. It produced a single migration and a code change in the same PR. The PR merged; during the rolling deploy, production threw a burst of 500s before stabilizing.

sql

1-- migration2ALTER TABLE users RENAME COLUMN fullname TO full_name;

python

1# app code, same PR2user.full_name  # was user.fullname everywhere

Why did the rolling deploy break, and what's the safe sequence?

What a strong answer looks like

Treat the AI’s output as a draft to verify, not an answer to trust. Name the specific flaw and the input that triggers it, say how you’d catch it — tests, edge cases, reading critically — and how you’d re-prompt or decompose to get it right.

Learn the concepts

Describe your solution

Vibe coding: describe the solution in plain language (or narrate it) and the coach grades your approach. Generating runnable code from your description is coming next.

Run or narrate your approach, then ask the coach.