Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Incomplete
 - 
    1.1.2
 - 
    None
 - 
    MariaDB-log Columnstore 1.1.2-1
1um,2pm 
Description
MariaDB [(none)]> SELECT w.withdraw_apply_no, w.state, ir.*  FROM holmes_analysis.risk_assess_flow_index_result ir LEFT JOIN nirvana.withdraw_apply w on w.withdraw_risk_assess_apply_id = ir.risk_asess_flow_state_id where ir.channel_code = 'qianzhan' and ir.risk_assess_flow_id = 103 and ir.`key1` REGEXP 'TSHATFR001|TSHATFR002|TSHATFR003|TSHATFR004|TSHATFR005' and ir.create_time >= '2017-11-03';
ERROR 1815 (HY000): Internal error: InetStreamSocket::readToMagic: Remote is closed
MariaDB [(none)]> 
MariaDB [(none)]> 
MariaDB [(none)]> SELECT w.withdraw_apply_no, w.state, ir.id  FROM holmes_analysis.risk_assess_flow_index_result ir LEFT JOIN nirvana.withdraw_apply w on w.withdraw_risk_assess_apply_id = ir.risk_asess_flow_state_id where ir.channel_code = 'qianzhan' and ir.risk_assess_flow_id = 103 and ir.`key1` REGEXP 'TSHATFR001|TSHATFR002|TSHATFR003|TSHATFR004|TSHATFR005' and ir.create_time >= '2017-11-03' limit 1;
----------------------------------
| withdraw_apply_no | state | id | 
----------------------------------
| 106171108303012930 | 4 | 258820079 | 
----------------------------------
1 row in set (6.93 sec)
select ir.* is crash!!!
select ir.id is no problem.