Hi Shigeki, This is critical functionality for ManifoldCF. Quite a lot of ManifoldCF stuff won't work on MySQL if this is broken - not just crawling using the JDBC connector. Are you successfully crawling with MySQL as the back-end? If you are, that means that there is a way to do this right but the JDBC connector is not using it.
I am testing with MySQL JDBC connector 5.1.18 here, which would indicate that that is the case. Could you open a ticket describing the problem, and I will look into this in some detail tonight? Thanks, Karl On Mon, Aug 20, 2012 at 4:21 AM, Shigeki Kobayashi <[email protected]> wrote: > Hi guys. > > > I am not sure if everyone has already noticed this, but this is to share an > experimental fact of using MySQL connectors to crawl MySQL data. > > Using "AS" in Select queries in SeedQuery and DataQuery causes error > depending on versions of MySQL connectors. > > Env: > - ManifoldCF0.5 > - Solr3.6 > - MySQL5.5 > > Example: > > SeedQuery：SELECT idfield AS $(IDCOLUMN) FROM documenttable > > Error Message: > Bad seed query; doesn't return $(IDCOLUMN) column. Try using quotes around > $(IDCOLUMN) variable, e.g. "$(IDCOLUMN)". > > Cause of Error: > MySQL connecors of over version 5.1 seem to have a bug that causes error > when you use "AS" in Select to put an alias for a column. > > Versions of MySQL Connector: > mysql-connector-java-5.0.8.jar -> OK > mysql-connector-java-5.1.18.jar -> No Good > mysql-connector-java-5.1.21.jar -> No Good > > Exception: > Using function (e.g. sysdate() as) or fixed strings (e.g. " fixed string" > as) followed by "as" does not cause error. > > Regards, > > Shigeki
