Hello,
I'm using the SqlDataSourceHelper from the Data Source Java Library
1.0.2 and it works fine, except for scalar functions.
This Google Vis. API query:
select xtime, page_views where year(xtime)=2010
gets translated to this SQL query:
SELECT xtime, page_views FROM pview_stats_compressed WHERE
(year_xtime=2010.0)
The year_xtime=2010.0 clause is incorrect MySQL syntax (the javadoc
for SqlDataSourceHelper says it is intended for MySQL). The problem is
in the buildWhereClauseRecursively method in the SqlDataSourceHelper.
Here is a test class to reproduce this behavior:
https://docs.google.com/leaf?id=0B8i_tyNGtZiKYzQ0ZWRkYzAtY2M5YS00ZDBiLWEyYWQtNDNiMTMzOWM1YTcw
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
