<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>OGR SQL problems</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I think there might be a bug with the OGR_DS_ExecuteSQL call in gdal 1.8, this worked fine with 1.7 and I see you`ve rebuilt the SQL part.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I've tried a select on a CANVEC layer which looks something like this:</FONT>
</P>
<P> <FONT SIZE=2 FACE="Arial">ogrinfo CanVec/031/h/031h05/031h05_6_0_BS_2010009_2.shp -sql "SELECT * FROM 031h05_6_0_BS_2010009_2"</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">And I get</FONT>
</P>
<P> <FONT SIZE=2 FACE="Arial">ERROR 1: SQL Expression Parsing Error: syntax error</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I've tried many other layers and it woks fine for all of them but not for any CANVEC layer.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I'm beginning to think the underscores in the layer name might cause a problem cause it`s the only differrence I can see</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Has anybody seen this behavior has well ?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Note the it does the same thing with the C API where I first stumbled on the problem</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"> Thanks.</FONT>
</P>
<P><SPAN LANG="fr-ca"><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">================================================================</FONT></SPAN>
<BR><SPAN LANG="fr-ca"><B><FONT SIZE=2 FACE="Arial">Jean-Philippe Gauthier Bilodeau </FONT><FONT COLOR="#999999" SIZE=2 FACE="Arial">Direction des opérations</FONT></B></SPAN>
<BR><SPAN LANG="fr-ca"><B><FONT SIZE=2 FACE="Arial">Spécialiste principal, </FONT><FONT COLOR="#999999" SIZE=2 FACE="Arial">Centre Météorologique Canadien</FONT></B></SPAN>
<BR><SPAN LANG="fr-ca"><B><FONT SIZE=2 FACE="Arial">programmation scientifique et infographie </FONT><FONT COLOR="#999999" SIZE=2 FACE="Arial">2121 Route Transcanadienne</FONT></B></SPAN>
<BR><SPAN LANG="fr-ca"><B><FONT SIZE=2 FACE="Arial">Tel : (514) 421-4642 </FONT><FONT COLOR="#999999" SIZE=2 FACE="Arial">Dorval,Québec</FONT></B></SPAN>
<BR><SPAN LANG="fr-ca"><B><FONT SIZE=2 FACE="Arial">Fax: (514) 421-4679 </FONT><FONT COLOR="#999999" SIZE=2 FACE="Arial">H9P 1J3</FONT></B></SPAN>
<BR><SPAN LANG="fr-ca"><B><FONT SIZE=2 FACE="Arial">Email: </FONT></B></SPAN><A HREF="mailto:Jean-Philippe.Gauthier@ec.gc.ca"><SPAN LANG="fr-ca"><B><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Jean-Philippe.Gauthier@ec.gc.ca</FONT></U></B></SPAN></A><SPAN LANG="fr-ca"><B> </B></SPAN>
</P>
<BR>
<BR>
</BODY>
</HTML>