[Top][All Lists]

[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 = 
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 ?

reply via email to

[Prev in Thread] Current Thread [Next in Thread]