db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derby Ciu (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3946) Provide support for using the Derby parser to generate Abstract Syntax Trees
Date Mon, 22 Feb 2010 19:35:27 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12836846#action_12836846
] 

Derby Ciu commented on DERBY-3946:
----------------------------------

Hi Rick,

       I guess I am on the right track. Running the above query gives this - 

Parsing:
select a from t, s where t.a = s.a

org.apache.derby.impl.sql.compile.CursorNode@19fdbcb
name: null
updateMode: UNSPECIFIED (0)
statementType: SELECT
resultSet: 	
	org.apache.derby.impl.sql.compile.SelectNode@16fdac
	isDistinct: false
	groupByList: null
	orderByList: null
	resultSetNumber: 0
	referencedTableMap: null
	statementResultSet: false
	resultColumns: 	
	org.apache.derby.impl.sql.compile.ResultColumn@1682a53
	exposedName: A
	name: A
	tableName: null
	isDefaultColumn: false
	wasDefaultColumn: false
	isNameGenerated: false
	sourceTableName: null
	type: null
	columnDescriptor: null
	isGenerated: false
	isGeneratedForUnmatchedColumnInInsert: false
	isGroupingColumn: false
	isReferenced: false
	isRedundant: false
	virtualColumnId: 1
	resultSetNumber: -1
	dataTypeServices: null
	expression: 		
		org.apache.derby.impl.sql.compile.ColumnReference@1b2d7df
		columnName: A
		tableNumber: -1
		columnNumber: 0
		replacesAggregate: false
		tableName: null
		nestingLevel: -1
		sourceLevel: -1
		dataTypeServices: null
	fromList: 		
		org.apache.derby.impl.sql.compile.FromList@7a9224
		tableName: T
		tableDescriptor: null
		updateOrDelete: 0
		null
		existsBaseTable: false
		dependencyMap: null
		correlation Name: null
		null
		tableNumber -1
		level 0
		resultSetNumber: 0
		referencedTableMap: null
		statementResultSet: false
		; tableName: S
		tableDescriptor: null
		updateOrDelete: 0
		null
		existsBaseTable: false
		dependencyMap: null
		correlation Name: null
		null
		tableNumber -1
		level 0
		resultSetNumber: 0
		referencedTableMap: null
		statementResultSet: false
		; 			
			org.apache.derby.impl.sql.compile.FromBaseTable@110b640
			tableName: T
			tableDescriptor: null
			updateOrDelete: 0
			null
			existsBaseTable: false
			dependencyMap: null
			correlation Name: null
			null
			tableNumber -1
			level 0
			resultSetNumber: 0
			referencedTableMap: null
			statementResultSet: false
			
			org.apache.derby.impl.sql.compile.FromBaseTable@2d59a3
			tableName: S
			tableDescriptor: null
			updateOrDelete: 0
			null
			existsBaseTable: false
			dependencyMap: null
			correlation Name: null
			null
			tableNumber -1
			level 0
			resultSetNumber: 0
			referencedTableMap: null
			statementResultSet: false
	whereClause: 		
		org.apache.derby.impl.sql.compile.BinaryRelationalOperatorNode@158015a
		operator: =
		methodName: equals
		dataTypeServices: null
		leftOperand: 			
			org.apache.derby.impl.sql.compile.ColumnReference@c0c8b5
			columnName: A
			tableNumber: -1
			columnNumber: 0
			replacesAggregate: false
			tableName: T
			nestingLevel: -1
			sourceLevel: -1
			dataTypeServices: null
		rightOperand: 			
			org.apache.derby.impl.sql.compile.ColumnReference@b914b3
			columnName: A
			tableNumber: -1
			columnNumber: 0
			replacesAggregate: false
			tableName: S
			nestingLevel: -1
			sourceLevel: -1
			dataTypeServices: null
	preJoinFL: orderByList: 

I will get back to you. 
Thanks and regards,
Ciu

> Provide support for using the Derby parser to generate Abstract Syntax Trees
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-3946
>                 URL: https://issues.apache.org/jira/browse/DERBY-3946
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.5.1.1
>            Reporter: Rick Hillegas
>         Attachments: ASTParser.java, ASTParser.java, ASTParser.java, derby-3946-01-aa-standaloneParser.diff,
TreeWalker.java, TreeWalker.java
>
>
> Users would like to be able to use the Derby parser to produce query trees without actually
running the queries on Derby.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message