Max function is not available

sangita · Post by **sangita** » Fri Feb 19, 2010 9:47 pm

Hi!
When I use the max function while querying the database, I get the error of "Function Testlink.Max does not exist -- Error # 1305". Is there a way to add this?
Thanks
Sangita

TurboPT · Post by **TurboPT** » Sat Feb 20, 2010 1:24 am

Need more details...

How/where are you trying to use this with a query?

sangita · Post by **sangita** » Sat Feb 20, 2010 4:30 pm

Hi!
We have MSSQL database for testlink and I am using MSSQL browser 1.2.14 for the query. I need to get the latest version number from tcversions table. I am using the following query, but it is giving me the listed error.

select max(version) from tcversions
where id = xxxxx

Thanks
Sangita

TurboPT · Post by **TurboPT** » Sat Feb 20, 2010 10:08 pm

Sounds like a possible mis-configuration. [but might not be]

Error 1305 is a MySQL [not MS-SQL] error# for "procedure doesn't exist", as it seems to be looking for a procedure named 'max'.

Since max is an SQL aggregate function [in both MySQL and MS-SQL], I'm not sure how it is getting this error. The query you posted seems to be ok.

What MS-SQL version do you have? [not the browser version being used]

Oh, even though the query appears to be ok, as posted, make sure that there is NOT a space between max and its opening ( . If I do this with MySQL it gives me the same error. I'm not sure if MS-SQL needs a space there though, so try it both ways.