测试testAInsertProductSellDaily() 出现错误

org.springframework.jdbc.BadSqlGrammarException: 

### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'o2o.tb_user_product_map.shop_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

### The error may involve com.fushan.o2o.dao.ProductSellDailyDao.insertProductSellDaily-Inline

### The error occurred while setting parameters

### SQL: INSERT     INTO     tb_product_sell_daily(product_id,shop_id,create_time,total)     (     SELECT     product_id,shop_id,date_format(create_time,'%Y-%m-%d'),count(product_id)     AS total FROM     tb_user_product_map     WHERE     date_format(create_time,'%Y-%m-%d') =     date_sub(curdate(),interval 1     day) GROUP BY product_id)

### Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'o2o.tb_user_product_map.shop_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'o2o.tb_user_product_map.shop_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

<insert id="insertProductSellDaily" parameterType="com.fushan.o2o.entity.ProductSellDaily">
   INSERT
   INTO
   tb_product_sell_daily(product_id,shop_id,create_time,total)
   (
   SELECT
   product_id,shop_id,date_format(create_time,'%Y-%m-%d'),count(product_id)
   AS total FROM
   tb_user_product_map
   WHERE
   date_format(create_time,'%Y-%m-%d') =
   date_sub(curdate(),interval 1
   day) GROUP BY product_id)
</insert>
   <insert id="insertDefaultProductSellDaily">
   INSERT
   INTO
   tb_product_sell_daily(product_id,shop_id,create_time,total)
   (
   SELECT
   p.product_id,p.shop_id,date_sub(curdate(),interval 1 day),0 AS
   total
   FROM
   tb_product p
   WHERE
   p.product_id not in (select product_id from
   tb_product_sell_daily where date_format(create_time,'%Y-%m-%d') =
   date_sub(curdate(),interval 1 day))
   )
</insert>