Error code: 1247 Reference ' startTime ' not supported (forward Reference in item list)

1. Error description

1 queries executed, 0 success, 1 errors, 0 warnings query: Select A.createuserid as TypeId, (select COUNT (c.id) from t_aps C WH ERE c. ' Status ' in (2, 5) and C.createtime >= start ... Error code: 1247Reference ' StartTime ' not supported (forward reference in item list) Time   : 0 sec transfer Time   : 0 sec Total time      : 0 Sec

2. Cause of error

As the parameter is passed in the stored procedure:

C.createtime >= startTime and C.createtime <= endTime

In order to detect the correctness of the query statement, I directly put the query statements with parameters in the stored procedure on the client side, resulting in an error

3. Solutions

(1) Comment out the statement segment with parameters

(2) Change the parameter to a specific value

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Error code: 1247 Reference ' startTime ' not supported (forward Reference in item list)