Good idea, but it's not a driver issue. A small jdbc app executing the same query with the same version of the driver gives me a result set as expected.
On 12/1/10 3:03 PM, Rainer Noack wrote: > Hmm, sounds like a driver problem (jdbc vs. Native) , not an ant issue. > > -----Ursprüngliche Nachricht----- > Von: Laurence Mills-Gahl [mailto:elem...@gmail.com] > Gesendet: Mittwoch, 1. Dezember 2010 17:45 > An: user@ant.apache.org > Betreff: sql task output suppressing a column > > I am having difficulty with the results of a sql task not being the same as > the results from the sql query in the db environment and I am wondering if > anybody else has seen this behavior. > > I have a sql task executing the following query: > > SELECT > c.property_value, > center.name, > s.property_value > FROM center INNER JOIN center_property c ON center.centerKey = c.centerKey > AND c.property_type = '_CODE' > LEFT OUTER JOIN center_property s ON center.centerKey = s.centerKey AND > s.property_type = '_STATUS' > WHERE center.parentCenterFK = 147 > AND center.active = 1 > ORDER BY center.name ASC > > > The 'center' table is joined to the 'center_property' table twice using the > property_type _CODE and _STATUS in order to get the values for the _CODE and > _STATUS. This query gives me the expected results from within the mysql > commandline tool and gui manager. > From ant though, I get the code property value and the status property > value, but the center.name column is always blank. > > I have thought about the column 'name' being a reserved word but quoting the > column name or making it an alias works with the command line query, but > gives the same results via ant. > > I have tried moving the sql to an external resource file as well as directly > in the build file and the output is no different. > > I am stumped as to why the query would work, return the right number of > rows, but not show any result for the second column. All columns are string > types. (property_value is VARCHAR(255) and center.name is > VARCHAR(100)) > > Does anybody have any ideas on where to look for the missing names? > > Thank you. > > Larry Mills-Gahl > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@ant.apache.org For additional > commands, e-mail: user-h...@ant.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@ant.apache.org > For additional commands, e-mail: user-h...@ant.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@ant.apache.org For additional commands, e-mail: user-h...@ant.apache.org
