db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From venu <VENUM...@GMAIL.COM>
Subject Re: Using ASTParser and TreeWalker for parsing SQL query
Date Wed, 19 Jun 2013 16:47:00 GMT
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.

Mime
View raw message