[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Bug-gnubg] Problem with example SQL query
From: |
Philippe Michel |
Subject: |
[Bug-gnubg] Problem with example SQL query |
Date: |
Sun, 11 Jun 2017 17:50:27 +0200 (CEST) |
User-agent: |
Alpine 2.21 (BSF 202 2017-01-01) |
In the Analyse/Show records/Query widget, there is an example of SQL query
on the gnubg match database.
Apparently it works as expected with sqlite, but fails if I use an
external mysql database. GNUbg's output isn't clear, but running the query
in a proper interface gives :
MariaDB [gnubg]> select s.session_id, s.length, p1.name, p2.name from player
p1, player p2 join session s on s.player_id0 = p1.player_id and s.player_id1 =
p2.player_id;
ERROR 1054 (42S22): Unknown column 'p1.player_id' in 'on clause'
Is the above statement somehow non-standard SQL that happens to work with
sqlite ?
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Bug-gnubg] Problem with example SQL query,
Philippe Michel <=