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.