This isn't Randall's first rodeo. On his color survey, he mentioned this (http://blog.xkcd.com/2010/05/03/color-survey-results/):
"A couple dozen people embedded SQL ‘drop table’ statements in the color names. Nice try, kids."
The data gets collated in a Google sheet, so I think he'll be fine. Or at least if he finds a bug, it'll get fixed.
Yeah I suspect google sheets is not obviously vulnerable to sql injection at this point in the game.
It's not going to -stay- in a google spreadsheet, though. You have to assume it will get loaded into some other system. there are opportunities to exploit that system, potentially. Kind of a 'stored' injection vulnerability.
He is hip to sql injection.
https://xkcd.com/327/
That's the joke.
Re:The xkcd survey
by kenbellows on Wednesday September 02, 2015 @12:46PM
(#10160493)
yeah it's going into a docs spreadsheet rather than a db, at least directly, so I don't think he has much to worry about
I'll have to play with spreadsheet injection then
Re:The xkcd survey
by misingnoglic on Thursday September 03, 2015 @09:01PM
(#10168325)
I assume he'd use python for the parsing with the CSV library, so just including lots of quotes, commas, \t, and \n characters would probably mess something up.
Cantaloupe');DROP TABLE Food;--
ol' Randal is going to get (or some permutation thereof). Figuring that Randal is pretty smart, I bet he has a piece of code to parse out that. Still, anyone here have a good hack that can just nuke days of his time whilst completing this form? Only other one I can think of him using is (for Matlab):
Cantaloupe'); clear all; clc; close all;