zxk1111

i has the same error,like select t.* from (select s.field_1,if(s.field_2 is null,1,2) as field_2 from sub s)t will display this error because of t.*, if like select t.field_1,t.field_2 will success,...