Devart Forums

The following query raises a stupid 'list index out of bounds' error:
'SELECT * FROM Table ORDER BY COL_NAME LIMIT 0,1'
when the lower limit is 0 and order by is included (can be solved by just including the upper limit, but it is still a bug, right?).

Anyway it took me 2 hours to track it down, so it would be great if someone fixed it to save time for people who have funnier things to do with their time.

Unfortunately we couldn't reproduce the problem.
Please send us (EvgeniyD*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.
Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor