Loading video...

Video Failed to Load

Go Home

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?

googledevs's profile picture

Google for Developers

2,573,576 subscribers

11,376 views • 6 months ago •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

This SQL query looks completely reasonable. It filters out banned and inactive users. Yet the result might catch you off guard. What does it actually return?
0:31

This SQL query looks completely reasonable. It filters out banned and inactive users. Yet the result might catch you off guard. What does it actually return?

Google for Developers

10,023 views • 7 months ago

🤯🤯 That's insane! Hugging Face just shipped Data Studio on dataset pages... Ask a question about any dataset, the agent writes and runs a SQL query... then share the result or download as CSV... check it out! 👀 ⤵️ Wow GG Caleb 👏
0:25

🤯🤯 That's insane! Hugging Face just shipped Data Studio on dataset pages... Ask a question about any dataset, the agent writes and runs a SQL query... then share the result or download as CSV... check it out! 👀 ⤵️ Wow GG Caleb 👏

Jeff Boudier 🤗

19,703 views • 1 year ago

This is a tool that used GPT that lets you connect to PostgresDB or MongoDB, lets users type in questions, and it generates the query code (even advanced table joins), runs the code and returns the answer instantly. Like a query co-pilot. Here are my thoughts 👇🏻
0:23

This is a tool that used GPT that lets you connect to PostgresDB or MongoDB, lets users type in questions, and it generates the query code (even advanced table joins), runs the code and returns the answer instantly. Like a query co-pilot. Here are my thoughts 👇🏻

Duy

68,809 views • 3 years ago

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results
5:48

Visualizing a SQL query in 5 mins SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results

Alex Xu

22,753 views • 13 days ago

It looks like she should take a shower immediately after doing this.
0:21

It looks like she should take a shower immediately after doing this.

Ayu D. Palupi

63,795 views • 10 months ago

If this is wrong, why doesn’t it feel wrong?
1:00

If this is wrong, why doesn’t it feel wrong?

Doctor jii…

46,786 views • 8 months ago

This is the most overvalued the stock market has been in modern history. And retail is still buying like nothing is wrong. We have seen this exact shape before: → Dot-com → Housing → AI Every one topped quietly while everyone was still bullish, then broke. The S&P is already tracing it, and SpaceX is the last liquidity event before it goes. When it breaks, the money does not vanish. It looks for the exit. Watch where it runs.
0:20

This is the most overvalued the stock market has been in modern history. And retail is still buying like nothing is wrong. We have seen this exact shape before: → Dot-com → Housing → AI Every one topped quietly while everyone was still bullish, then broke. The S&P is already tracing it, and SpaceX is the last liquidity event before it goes. When it breaks, the money does not vanish. It looks for the exit. Watch where it runs.

Mister Crypto

23,441 views • 1 month ago

Looks like it runs in the family 😎
0:20

Looks like it runs in the family 😎

MLBDevelops

103,417 views • 1 year ago

If Kyle was mad about the lesbian comment, she should have said something at the moment instead of laughing it off. This is why she comes across as so fake and a victim. Why complain about it at the reunion when she could have called Garcelle out? #RHOBH
0:44

If Kyle was mad about the lesbian comment, she should have said something at the moment instead of laughing it off. This is why she comes across as so fake and a victim. Why complain about it at the reunion when she could have called Garcelle out? #RHOBH

Reality Roast

110,895 views • 1 year ago

You can now access AI directly from your database! Here is a step-by-step demo that uses GPT-4 to classify customer reviews from a MySQL dataset. And I'm only writing SQL instructions! You have to see it! The model acts as another table in the database. I can query it and join it with other tables. It's awesome! This is all thanks to mindshub. Here is their GitHub repository: They are sponsoring this post. Watch the video.
6:49

You can now access AI directly from your database! Here is a step-by-step demo that uses GPT-4 to classify customer reviews from a MySQL dataset. And I'm only writing SQL instructions! You have to see it! The model acts as another table in the database. I can query it and join it with other tables. It's awesome! This is all thanks to mindshub. Here is their GitHub repository: They are sponsoring this post. Watch the video.

Santiago

209,454 views • 2 years ago

A DEVELOPER FOUND SEVEN WAYS TO TAKE DOWN A PRODUCTION DATABASE THAT ALL LOOK EXACTLY LIKE NORMAL, INNOCENT CODE AND ALMOST EVERY TEAM IS SHIPPING AT LEAST ONE OF THEM RIGHT NOW 17 minutes from Josh Berkus, one of the people who actually maintains PostgreSQL, walking through the quiet mistakes that turn a healthy database into a 3am outage. -> The moment it lands, you realize none of these are exotic attacks. They're ordinary-looking decisions -- a query that locks a table, a connection that never closes, a setting no one ever questioned -- that work perfectly until the day they don't, and then they take everything down with them. The scary part isn't that the database breaks. It's how normal the code looks right up until it does. A query that runs in 5ms on your laptop and 5 minutes on prod. A migration that silently locks the whole table. A connection pool that runs dry the moment real traffic shows up. Every one of them passed review. Writing SQL that runs was never the hard part -> writing SQL that survives production is. And now that an AI agent is generating and firing queries at your real database faster than anyone can read them, every one of those seven landmines is one autocomplete away -- and the only person who can stop it is the one who already knows where they're buried. Your database doesn't go down because someone attacked it. It goes down because something that looked completely normal finally caught up with it. Save and Watch it today. You'll see the next outage coming before it lands ↓
16:51

A DEVELOPER FOUND SEVEN WAYS TO TAKE DOWN A PRODUCTION DATABASE THAT ALL LOOK EXACTLY LIKE NORMAL, INNOCENT CODE AND ALMOST EVERY TEAM IS SHIPPING AT LEAST ONE OF THEM RIGHT NOW 17 minutes from Josh Berkus, one of the people who actually maintains PostgreSQL, walking through the quiet mistakes that turn a healthy database into a 3am outage. -> The moment it lands, you realize none of these are exotic attacks. They're ordinary-looking decisions -- a query that locks a table, a connection that never closes, a setting no one ever questioned -- that work perfectly until the day they don't, and then they take everything down with them. The scary part isn't that the database breaks. It's how normal the code looks right up until it does. A query that runs in 5ms on your laptop and 5 minutes on prod. A migration that silently locks the whole table. A connection pool that runs dry the moment real traffic shows up. Every one of them passed review. Writing SQL that runs was never the hard part -> writing SQL that survives production is. And now that an AI agent is generating and firing queries at your real database faster than anyone can read them, every one of those seven landmines is one autocomplete away -- and the only person who can stop it is the one who already knows where they're buried. Your database doesn't go down because someone attacked it. It goes down because something that looked completely normal finally caught up with it. Save and Watch it today. You'll see the next outage coming before it lands ↓

slash1s

22,268 views • 3 months ago

English Is The New SQL LLMs have made it easy for everyone to create on-the-fly dashboards and plots. You can connect to your database and then use a SOTA LLM like 4o, Opus, or Gemini to generate SQL and Python code to create on-the-fly dashboards and plots. ChatLLM makes it possible across all state-of-the-art LLMs -
0:27

English Is The New SQL LLMs have made it easy for everyone to create on-the-fly dashboards and plots. You can connect to your database and then use a SOTA LLM like 4o, Opus, or Gemini to generate SQL and Python code to create on-the-fly dashboards and plots. ChatLLM makes it possible across all state-of-the-art LLMs -

Bindu Reddy

50,569 views • 2 years ago

At first, it looks like Jinyoung is crying, but then it turns out that he changed into the wrong pants and wants to change back. Why is this man so funny?
0:33

At first, it looks like Jinyoung is crying, but then it turns out that he changed into the wrong pants and wants to change back. Why is this man so funny?

Lavina

57,577 views • 1 year ago

The Global American Cultural Victory doesn’t look like people wearing blue jeans and listening to rock and roll. It looks like this:
0:30

The Global American Cultural Victory doesn’t look like people wearing blue jeans and listening to rock and roll. It looks like this:

RAY

390,880 views • 3 months ago

this whole video ❤️‍🩹 jimin was talking to armys and as soon as he noticed something was wrong he immediately stopped the concert 🐥 it looks like someone has fallen over there 🐥 something's wrong over there 🐥 please take care of it quickly
0:42

this whole video ❤️‍🩹 jimin was talking to armys and as soon as he noticed something was wrong he immediately stopped the concert 🐥 it looks like someone has fallen over there 🐥 something's wrong over there 🐥 please take care of it quickly

j.mt

473,296 views • 2 months ago

The way to cut bangs like this looks so easy and the result is really good, so I want to try it 😍
0:40

The way to cut bangs like this looks so easy and the result is really good, so I want to try it 😍

monic

800,571 views • 2 months ago

During one of my runs, this song started playing in my YouTube mix—I fell in love with it, and the result was this dance. I hope you like it.
1:46

During one of my runs, this song started playing in my YouTube mix—I fell in love with it, and the result was this dance. I hope you like it.

ArianaRealTV

14,498 views • 5 months ago

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless
0:27

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless

Beaver 🦁

86,519 views • 8 months ago