Post AQ46KIWNnGa8EwTS6a by xocolatl@mastodon.social
 (DIR) More posts by xocolatl@mastodon.social
 (DIR) Post #AQ414Gl05NTAMdqhU0 by djoerd@idf.social
       2022-11-28T13:28:10Z
       
       0 likes, 0 repeats
       
       Student's #SQL quiz solutions that will #DuckDB go all 'suicide':  1.  no join condition using four tables  2.  use an OR after some correct join conditions on four tables  (SQLite and PostgreSQL fail too: Don't underestimate our students!)
       
 (DIR) Post #AQ41ZUBUDJOmz87fua by proycon@social.anaproy.nl
       2022-11-28T13:33:43Z
       
       0 likes, 0 repeats
       
       @djoerd Don't forget to be extra vigilant if you have little Bobby Tables in your class!https://xkcd.com/327/
       
 (DIR) Post #AQ41lNkjx2VkVtHjgO by djoerd@idf.social
       2022-11-28T13:35:57Z
       
       0 likes, 0 repeats
       
       @proycon Ah, a classic: I show this in my last lecture :-) Actually, today's quizzes expect SQL, so students may input "DROP TABLE" directly, no injection needed.
       
 (DIR) Post #AQ46KIWNnGa8EwTS6a by xocolatl@mastodon.social
       2022-11-28T14:27:04Z
       
       0 likes, 0 repeats
       
       @djoerd What do you mean by “fail”?
       
 (DIR) Post #AQhhA67wIJeKNBTf1s by arjen@idf.social
       2022-12-17T16:53:31Z
       
       0 likes, 0 repeats
       
       @djoerd I guess it's more like don't overestimate our students 😉