General SQL Parser Java version 1.9.5.5 released (2018-10-22)

• GSP Java version 1.9.5.5(2018-10-21)
  • [Oracle] able to recognize and parser noneditionable trigger
  • [Teradata] support at time zone clause of DATE datatype.
  • [Teradata] support with return only clause in declare cursor statement.
  • [SQL Server] support OBJECT:: in grant statement.
  • [SQL Server] support xmlnamespaces clause used together with CTE.
• GSP Java version 1.9.5.5(2018-10-19)
  • [Teradata] fix a bug can’t handle resignal statement with only RESIGNAL keyword.
  • [Snowflake] fix a bug can’t handle IDENTITY clause in create table statement.
  • [Snowflake] fully support create view statement.
  • [Netezza] support modify column in alter table statement.
  • [Oracle] fix a bug can’t handle with object IDENTIFIER in create view of object type.
• GSP Java version 1.9.5.5(2018-10-18)
  • [Netezza] support set privileges in alter table statement.
  • [Netezza] support if exists clause in drop table statement.
• GSP Java version 1.9.5.4(2018-10-17)
  • [SQL Server] Doesn’t treat [DATE] as a regular column name.
  • [demo/TTraceColumn] fix a out out memory bug when handling nested function call.
  • [Teradata] IS keyword can be used as AS keyword in COMMENT ON TABLE.
  • [SQL SERVER] support QUERYTRACEON query hint.
  • [API] add new enum: EQueryHint.E_QUERY_HINT_QUERYTRACEON
• GSP Java version 1.9.5.4(2018-10-16)
  • [Teradata] support collect statistics with a single index column name.
  • [Teradata] support qualify clause after group by clause.
  • [Teradata] support script clause in from clause.
  • [Teradata] able to recognize label statement.
• GSP Java version 1.9.5.4(2018-10-15)
  • [Teradata] support function call in index column of COLLECT STATS statement
  • [Teradata] able to handle qualify clause between having and group by clause.
  • [Teradata] fix a bug can’t handle index column name in COLLECT STATS statement.
  • [Teradata] support qualify clause after sample clause in select statement.
  • [Teradata] support percentile_cont and percentile_disc function.
  • [Teradata] support hash by random clause in insert statement.
  • [Hive] support over clause in case expression.
  • [Hive] fix a bug can’t handle ? in limit clause.
• GSP Java version 1.9.5.4(2018-10-12)
  • [Teradata] fix a bug can’t handle $var used after DATE keyword.
  • [Teradata] fix a bug can’t parse range_n clause in create table definition clause.
  • [Teradata] Able to recognize EXIT statement.
• GSP Java version 1.9.5.3(2018-10-08)
  • [Hive] support NOT LIKE predicate.
  • [Hive] fix a bug can’t handle DIV operator.
• GSP Java version 1.9.5.2(2018-10-03)
  • [Teradata] support where clause between group by and having clause in select statement.
  • [Teradata] collectStatistics statement bug fix.
  • [Teradata] support unique primary key clause in collectStatistics statement.
  • [Teradata] support multiple sample clause in collectStatistics statement.
  • [Teradata] support primary key clause before on in collectStatistics statement.
  • [Teradata] fix a bug can’t parse replace function.
• GSP Java version 1.9.5.2(2018-09-30)
  • [API/Oracle] add new class TPhysicalAttributesClause, TPhysicalAttributesItem, TPhysicalProperties, TSegmentAttributesClause, TSegmentAttributesItem
  • [API/Oracle] add new class TStorageClause to represent storage clause.
• GSP Java version 1.9.5.2(2018-09-29)
  • [API/Oracle] add new enum EFlashCacheType to flash cache.
  • [API/Oracle] add new enum EBufferPoolType to buffer pool.
  • [API/Oracle] add new class TSizeClause to represent size clause.
  • [API/Oracle] add new enum EStorageType to represent storage item type.
  • [API/Oracle] add new class TStorageItem to represent storage clause item.
  • [API/Oracle] add new class TCreateMaterializedViewLogSqlStatement represents Oracle create materalized view log statement.
  • [MySQL] able to pickup renamed table name in alter table rename to.
  • [MySQL] link new add column to table in alte table change column.
  • [demo/getTableColumn] Able to pickup table and column in create index statement.
• GSP Java version 1.9.5.1(2018-09-27)
  • [Netezza] support create database statement.
  • [Netezza] support comment on statement.
  • [Netezza] support lock table statement.
• GSP Java version 1.9.5.1(2018-09-26)
  • [API] rename EHiveLockMode to ELockMode
  • [API] move EHiveLockMode from gudusoft.gsqlparser.nodes.hive to gudusoft.gsqlparser.nodes
• GSP Java version 1.9.5.0(2018-09-18)
  • [API] Able to get characterSet and collationName from TCreateDatabaseSqlStatement.
  • [demo/toXML] support TIntoClause in xmlVisitor
• GSP Java version 1.9.4.9(2018-09-14)
  • [Teradata] support TD_UNPIVOT Table Operators function.
• GSP Java version 1.9.4.8(2018-09-13)
  • [Oracle] fix a bug can’t detect public keyword in create synonmy statement.
  • [Oracle] fix a bug can’t parse alter index inside stored procedure and not ended with a semicolon
• GSP Java version 1.9.4.7(2018-09-10)
  • [demo/getTableColumn] Able to get column name in primary/unique key constraint clause of create table statement.
  • [API] New method: TAlterTableOption.getReferencedTable() returns the referenced table in foreign key.
  • [demo/getTableColumn] Able to get column name in add foreign key constraint clause of alter table statement.
  • [demo/analyzescript, MySQL] fix a bug can’t detect add primary key constraint clause of alter table statement
  • [demo/getTableColumn] Able to get column name in add primary key constraint clause of alter table statement.
  • [demo/getTableColumn] Able to get column name in change column clause of alter table statement.
  • [demo/getTableColumn] Able to get column name in drop column clause of alter table statement.
• GSP Java version 1.9.4.7(2018-09-10)
  • [SQL Server] fix a null exception bug when process drop schema inside if statement.
  • [SQL Server] fix a null exception bug when process drop database inside if statement.
• GSP Java version 1.9.4.6(2018-09-06)
  • [SQL Server] support with option in drop constraint clause in alter table statement.
  • [SQL Server] fully support alter index statement.
• GSP Java version 1.9.4.5(2018-08-31)
  • [API] TFunctionCall.setExpr3 was replaced by setLengthExpression (substring function)
  • [API] TFunctionCall.setExpr2 was replaced by setStartExpression (substring function)
  • [API] TFunctionCall.setExpr1 was replaced by setDateExpression (extract function),setCastOperand (cast function) setTypeExpression (DB2 subtype-treatment: treat), setSourceExpression (substring function), setColumnNameOrListExpression (SQL Server contains predicate)
• GSP Java version 1.9.4.4(2018-08-30)
  • [Javadoc] Finished doc comments for TGSqlParser
• GSP Java version 1.9.4.4(2018-08-24)
  • [Javadoc] Finished doc comments for TSourceToken, TParseTreeNode class.
• GSP Java version 1.9.4.4(2018-08-24)
  • [Javadoc] Finished doc comments for TObjectName class.
• GSP Java version 1.9.4.4(2018-08-22)
  • [API] Add new method TSourceToken TSourceToken.nextSolidToken(boolean treatCommentAsSolidToken)
  • [API] Add new method TSourceToken TSourceToken.prevSolidToken(boolean treatCommentAsSolidToken)
• GSP Java version 1.9.4.4(2018-08-20)
  • [MySQL] support compressed keyword in alter table row_format clause.
  • [MySQL] support show index statement
  • [API] add new class TShowIndexStmt
• GSP Java version 1.9.4.3(2018-08-15)
  • [Teradata] support COMPILE WITH NO SPL clause in alter procedure statement.
  • [PostgreSQL] support rename table clause in alter table statement.
• GSP Java version 1.9.4.3(2018-08-13)
  • [getTableColumn] fix a bug can’t recognize the column derived from CTE.
• GSP Java version 1.9.4.2(2018-07-31)
  • [Oracle] fix a bug can’t parse plsql block not ended by a semicolon.
  • [getTableColumn] link column in add/modify clause to table in alter table statement.

Please more changelog, please check here.

Share Tweet LinkedIn Reddit