Re: SQL_BUFFER_RESULT and SQL_CALC_FOUND_ROWS in same SELECT broken

2002-03-05 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > *** against BK as of set 1.1144 *** > > It appears that putting SQL_BUFFER_RESULT and SQL_CALC_FOUND_ROWS > in the same SELECT statement is a really bad idea! > > SELECT FOUND_ROWS() after SELECT SQL_BUFFER_RESULT SQL_CALC_F

SQL_BUFFER_RESULT and SQL_CALC_FOUND_ROWS in same SELECT broken

2002-03-03 Thread mattj
>Description: *** against BK as of set 1.1144 *** It appears that putting SQL_BUFFER_RESULT and SQL_CALC_FOUND_ROWS in the same SELECT statement is a really bad idea! SELECT FOUND_ROWS() after SELECT SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS either returns a h