Hi, I'm using Libre with Ubuntu 14.04:
Version: 5.0.5.2
Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3
Locale: en-US (en_US.UTF-8)
I have this query:
Code: Select all
SELECT DISTINCT "id", "player", "playdate", "score" FROM "bridge"."bdata" AS "bdata" WHERE "playdate" = '2017-01-02' ORDER BY "score" DESC LIMIT 6
Running the query works fine and I get 6 records out of 8 being displayed in DESC order.
When I run the report, supposedly using this query, I get all 8 records. If I use LIMIT 0,6 I get the following error:
SQL Status: HY000
Error code: 1000
Syntax error in SQL statement
Any clue as to why this happens and how to fix it?
Thanks R