Hi Rick,
I took 10.10 branch code and able to resolve all issues related with group
by.
I have some doubts could you please help me on these things.
1. I can see FromList and Groupbylist but can not find OrderByList node.
2. When I provide any function then the node tree will be like this.
Ex:
expression:
org.apache.derby.impl.sql.compile.JavaToSQLValueNode@6460029d
dataTypeServices: null
javaNode:
org.apache.derby.impl.sql.compile.StaticMethodCallNode@5b4bc4e6
javaClassName: null
methodName: TO_CHAR
methodParms[0] :
org.apache.derby.impl.sql.compile.SQLToJavaValueNode@4b6c06dd
value:
org.apache.derby.impl.sql.compile.ColumnReference@2136bdda
columnName: TIME
tableNumber: -1
columnNumber: 0
replacesAggregate: false
replacesWindowFunctionCall:
false
tableName: null
nestingLevel: -1
sourceLevel: -1
dataTypeServices: null
Here I want to get value node of SQLToJavaValueNode object. But, there is no
such method for getting sub node or value node SQLToJavaValueNode.
3. How can I get having clause from the select node.
Thanks,
Venu.
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Using-ASTParser-and-TreeWalker-for-parsing-SQL-query-tp131219p131603.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
