mysql - sql syntax or bug ?

[samoy]

Could someone help me out here?. I have just recently uploaded some geographic coordinates into mysql and using mysql to retrieve records based on geographic coordinate values.

mysql> select count(*) from VDR where (LATITUDE between -38 and -37)

mysql returns 0 records (which is wrong because all of the Latitude values is less than -37)

but

mysql> select count(*) from VDR where (LATITUDE between -38 and -3)

mysql returns 997913 records which is correct. Somehow, mysql does not like the double digit figures for the second negative number.

Could this be a mysql bug or just a sql syntax problem ?

Sam

 

[vcherubini]

Could it be because you do not have the values enclosed in single quotes (') because the negative sign would make them strings?

I am by no means a mySQL expert, but it is just something that you could try.

Hope this helps,

-Vic vic cherubini
malice365@hotmail.com

http://www.epicsoftware.com

====
Knows: Perl, HTML, JavScript, C/C++, PHP, Flash, Director
====

 

[BillPatterson]

I tried it and it appeared to work correctly. How exactly have you defined your columns?