decade

使用group_concat 函数，结果返回了两个值，其中第一个为null，而在mysql中只返回一个值

5

### sql： ``` SELECT group_concat( industry_name) FROM hunt_industry; ``` ### result: 

mycat是否不支持with语句

5

### SQL： WITH v_hunt_project_resume_status AS ( SELECT hd.* FROM hunt_dictionary hd INNER JOIN hunt_dictionary_type hdt ON hd.type_id = hdt.id WHERE hdt.type_view = 'v_hunt_project_resume_status' AND hd.is_available = TRUE ) SELECT *...

Cannot apply 'OR' to arguments of type '<INTEGER> OR <BOOLEAN>'. Supported form(s):

8

## sql： SELECT count(*) FROM hunt_customer hc LEFT JOIN hunt_user u ON hc.create_by = u.id WHERE ( find_in_set(1, hc.shared_user_ids ) OR hc.customer_bd_id = 1 OR hc.create_by = 1 OR hc.is_shared...