Bug #85627 ERROR 1054 (42S22) at line 1: Unknown column 'knr' in 'from clause'
Submitted: 26 Mar 2017 9:57 Modified: 27 Apr 2017 8:04
Reporter: Kun Qiu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.67 OS:Ubuntu (14.04)
Assigned to: CPU Architecture:Any
Tags: Concurrency bug, flush tables with read lock, Rare event, UPDATE INNER JOIN

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[26 Mar 2017 10:04] Kun Qiu
this file will control all other three files to reproduce the error

Attachment: new_run.sh (application/octet-stream, text), 500 bytes.

[26 Mar 2017 10:05] Kun Qiu
this is the script1.sh file, suppose to be executed firstly

Attachment: bug38691_pre.sh (application/octet-stream, text), 720 bytes.

[26 Mar 2017 10:06] Kun Qiu
this is the script2.sh file I used

Attachment: bug38691_script1.sh (application/octet-stream, text), 378 bytes.

[26 Mar 2017 10:06] Kun Qiu
this is the script3.sh file I used.

Attachment: bug38691_script2.sh (application/octet-stream, text), 256 bytes.