[
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.cursorn...@19fdbcb
name: null
updateMode: UNSPECIFIED (0)
statementType: SELECT
resultSet:
org.apache.derby.impl.sql.compile.selectn...@16fdac
isDistinct: false
groupByList: null
orderByList: null
resultSetNumber: 0
referencedTableMap: null
statementResultSet: false
resultColumns:
org.apache.derby.impl.sql.compile.resultcol...@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.columnrefere...@1b2d7df
columnName: A
tableNumber: -1
columnNumber: 0
replacesAggregate: false
tableName: null
nestingLevel: -1
sourceLevel: -1
dataTypeServices: null
fromList:
org.apache.derby.impl.sql.compile.froml...@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.frombaseta...@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.frombaseta...@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.binaryrelationaloperatorn...@158015a
operator: =
methodName: equals
dataTypeServices: null
leftOperand:
org.apache.derby.impl.sql.compile.columnrefere...@c0c8b5
columnName: A
tableNumber: -1
columnNumber: 0
replacesAggregate: false
tableName: T
nestingLevel: -1
sourceLevel: -1
dataTypeServices: null
rightOperand:
org.apache.derby.impl.sql.compile.columnrefere...@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.
