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 ?
_______________________________________________
Bug-gnubg mailing list
[email protected]
https://lists.gnu.org/mailman/listinfo/bug-gnubg
