Invalid syntax with STD() function when more than one field is used in select query

William Bronsema · *nix forums beginner Joined: 20 Jul 2006 Posts: 2

Hello,

I am encountering a strange issue when using the STD function. On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:

SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY

When I test this query on my hosted production machine (MYSQL version
4.19-standard) that query results in an invalid syntax error:

"#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(
`LAPSETIME` ) , UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY UKEY
LIM' at line 1"

The query will work if I remove the UKEY field in the select:

SELECT STD(`LAPSETIME`) FROM 4b3f91f64a19529a84dff4982c8a6bc5

Any ideas?

Cheers,
Bill

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

William Bronsema · *nix forums beginner Joined: 20 Jul 2006 Posts: 2

Oops, the version numbers were 4.1.18-nt and 4.1.19-standard. I have tried
it now on the latest 4.1.20 version and still have the same problem.

Does anyone have any ideas? Is this a bug?

Cheers,
Bill

Google