CompiledStatement.java
| Index Score | ||
|---|---|---|
 |
 |
org.hsqldb |
 |
|
HSQL Database Engine |
View: Reasons, Metrics, Source Code
These are the metrics that contribute to the Enerjy Score for this file, ranked by impact. So the metrics listed at the top influence the score to a greater extent that the metrics listed at the bottom.
| Metric | Description | |
|---|---|---|
| JAVA0108 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' |  |
| LINE_COMMENT | Number of line comments | |
| DECL_COMMENTS | Comments in declarations | |
| EXEC_COMMENTS | Comments in executable code | |
| RETURNS | Number of return points from functions | |
| INTERFACE_COMPLEXITY | Interface complexity | |
| LOGICAL_LINES | Number of statements | |
| SIZE | Size of the file in bytes | |
| LOOPS | Number of loops | |
| PARAMS | Number of formal parameter declarations | |
| JAVA0115 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| LINES | Number of lines in the source file | |
| ELOC | Effective lines of code | |
| OPERANDS | Number of operands | |
| PROGRAM_LENGTH | Halstead program length | |
| LOC | Lines of code | |
| OPERATORS | Number of operators | |
| JAVA0256 | JAVA0256 Assignment of external collection/array to field | |
| JAVA0031 | JAVA0031 Case statement not properly closed | |
| CYCLOMATIC | Cyclomatic complexity | |
| WHITESPACE | Number of whitespace lines | |
| JAVA0116 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0177 | JAVA0177 Variable declaration missing initializer | |
| UNIQUE_OPERANDS | Number of unique operands | |
| COMMENTS | Comment lines | |
| JAVA0270 | JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array | |
| JAVA0034 | JAVA0034 Missing braces in if statement | |
| PROGRAM_VOCAB | Halstead program vocabulary | |
| JAVA0032 | JAVA0032 Switch statement missing default | |
| BLOCKS | Number of blocks | |
| JAVA0110 | JAVA0110 Incorrect javadoc: no @return tag | |
| EXITS | Procedure exits | |
| JAVA0138 | JAVA0138 N parameters defined for method (maximum: M) | |
| FUNCTIONS | Number of function declarations | |
| JAVA0029 | JAVA0029 Private method not used | |
| DOC_COMMENT | Number of javadoc comment lines | |
| JAVA0075 | JAVA0075 Method parameter hides field | |
| JAVA0117 | JAVA0117 Missing javadoc: method 'method' | |
| PROGRAM_VOLUME | Halstead program volume | |
| JAVA0259 | JAVA0259 Return of collection/array field | |
| JAVA0136 | JAVA0136 N methods defined in class (maximum: M) | |
| JAVA0160 | JAVA0160 Method does not throw specified exception | |
| UNIQUE_OPERATORS | Number of unique operators | |
| JAVA0126 | JAVA0126 Method declares unchecked exception in throws | |
| JAVA0171 | JAVA0171 Unused local variable | |
| JAVA0265 | JAVA0265 Use of Throwable.printStackTrace() | |
| JAVA0100 | JAVA0100 Class contains N non-final fields (maximum: M) | |
| JAVA0130 | JAVA0130 Non-static method does not use instance fields | |
| COMPARISONS | Number of comparison operators | |
| JAVA0145 | JAVA0145 Tab character used in source file | |
/* Copyright (c) 2001-2007, The HSQL Development Group
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the HSQL Development Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
package org.hsqldb;
import org.hsqldb.HsqlNameManager.HsqlName;
import org.hsqldb.Parser.CompileContext;
import org.hsqldb.lib.HsqlArrayList;
import org.hsqldb.lib.OrderedHashSet;
import org.hsqldb.lib.Set;
import org.hsqldb.result.ResultConstants;
import org.hsqldb.result.ResultMetaData;
import org.hsqldb.types.Type;
import org.hsqldb.lib.ArrayUtil;
/**
* A simple structure class for holding the products of
* statement compilation for later execution.
*
* @author boucherb@users
* @version 1.9.0
* @since 1.7.2
*/
// fredt@users 20040404 - patch 1.7.2 - fixed type resolution for parameters
// boucherb@users 200404xx - patch 1.7.2 - changed parameter naming scheme for SQLCI client usability/support
// fredt@users 20050609 - 1.8.0 - fixed EXPLAIN PLAN by implementing describe(Session)
// fredt@users - 1.9.0 - support for generated column reporting
// fredt@users - 1.9.0 - support for multi-row inserts
public final class CompiledStatement {
public static final String PCOL_PREFIX = "@p";
static final String RETURN_COLUMN_NAME = "@p0";
// enumeration of allowable CompiledStatement types
public static final int UNKNOWN = 0;
public static final int INSERT_VALUES = 1;
public static final int INSERT_SELECT = 2;
public static final int UPDATE = 3;
public static final int DELETE = 4;
public static final int SELECT = 5;
public static final int SELECT_INTO = 6;
public static final int CALL = 7;
public static final int MERGE = 8;
public static final int SET = 9;
public static final int DDL = 10;
// resusables
static final Expression[] parameters0 = new Expression[0];
static final Type[] paramTypes0 = new Type[0];
static final SubQuery[] subqueries0 = new SubQuery[0];
/** id in CompiledStatementManager */
int id;
/** false when cleared */
boolean isValid = true;
/** target table for INSERT_XXX, UPDATE and DELETE and MERGE */
Table targetTable;
RangeVariable[] targetRangeVariables;
/** source table for MERGE */
Table sourceTable;
/** condition expression for UPDATE, MERGE and DELETE */
Expression condition;
/** column map for INSERT_XXX, UPDATE */
int[] columnMap;
/** column map for INSERT operation via MERGE */
int[] insertColumnMap;
/** column map for UPDATE operation via MERGE */
int[] updateColumnMap;
/** Column value Expressions for UPDATE and MERGE. */
Expression[] updateExpressions;
/** Column value Expressions for MERGE */
Expression[][] multiColumnValues;
/** INSERT_VALUES */
Expression insertExpression;
/**
* Flags indicating which columns' values will/will not be
* explicitly set.
*/
boolean[] insertCheckColumns;
boolean[] updateCheckColumns;
/** Expression to be evaluated when this is a CALL statement. */
Expression expression;
/**
* Select to be evaluated when this is an INSERT_SELECT or
* SELECT statement
*/
Select select;
/**
* Parse-order array of Expression objects, all of iType == PARAM ,
* involved in some way in any INSERT_XXX, UPDATE, DELETE, SELECT or
* CALL CompiledStatement
*/
Expression[] parameters;
/**
* Type[] contains type of each parameter
*/
Type[] paramTypes;
/**
* int[] contains column indexes for generated values
*/
int[] generatedIndexes;
/**
* ResultMetaData for generated values
*/
ResultMetaData generatedResultMetaData;
/**
* Subqueries inverse usage depth order
*/
SubQuery[] subqueries;
/**
* The type of this CompiledStatement. <p>
*
* One of: <p>
*
* <ol>
* <li>UNKNOWN
* <li>INSERT_VALUES
* <li>INSERT_SELECT
* <li>UPDATE
* <li>DELETE
* <li>SELECT
* <li>CALL
* <li>MERGE
* <li>DDL
* </ol>
*/
int type;
/**
* The SQL string that produced this compiled statement
*/
String sql;
/**
* The default schema name used to resolve names in the sql
*/
final HsqlName schemaHsqlName;
/**
* Total number of RangeIterator objects used
*/
int rangeIteratorCount;
/**
* Database objects used
*/
OrderedHashSet sequenceExpressions;
OrderedHashSet routineExpressions;
HsqlArrayList rangeVariables;
/**
* Creates a new instance of CompiledStatement for DDL
*
*/
CompiledStatement(HsqlName schema) {
parameters = parameters0;
paramTypes = paramTypes0;
subqueries = subqueries0;
type = DDL;
schemaHsqlName = schema;
}
/**
* Initializes this as a DELETE statement
*/
CompiledStatement(Session session, RangeVariable[] rangeVars,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.targetTable = rangeVars[0].rangeTable;
this.targetRangeVariables = rangeVars;
type = DELETE;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as an UPDATE statement.
*/
CompiledStatement(Session session, RangeVariable rangeVars[],
int[] updateColumnMap, Expression[] colExpressions,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.targetTable = rangeVars[0].rangeTable;
this.updateColumnMap = updateColumnMap;
this.updateExpressions = colExpressions;
this.updateCheckColumns =
targetTable.getColumnCheckList(updateColumnMap);
this.targetRangeVariables = rangeVars;
type = UPDATE;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as an INSERT_VALUES statement.
*/
CompiledStatement(Session session, Table targetTable, int[] columnMap,
Expression insertExpression, boolean[] checkColumns,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.targetTable = targetTable;
this.insertColumnMap = columnMap;
this.insertCheckColumns = checkColumns;
this.insertExpression = insertExpression;
type = INSERT_VALUES;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as an INSERT_SELECT statement.
*/
CompiledStatement(Session session, Table targetTable, int[] columnMap,
boolean[] checkColumns, Select select,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.targetTable = targetTable;
this.insertColumnMap = columnMap;
this.insertCheckColumns = checkColumns;
this.select = select;
type = INSERT_SELECT;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as a SELECT statement.
*/
CompiledStatement(Session session, Select select,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.select = select;
type = (select.intoTableName == null) ? SELECT
: SELECT_INTO;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as a CALL statement.
*/
CompiledStatement(Session session, Expression expression,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.expression = expression;
type = CALL;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as a MERGE statement.
*/
CompiledStatement(Session session, RangeVariable[] targetRangeVars,
int[] insertColMap, int[] updateColMap,
boolean[] checkColumns, Expression mergeCondition,
Expression insertExpr, Expression[] updateExpr,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.sourceTable = targetRangeVars[0].rangeTable;
this.targetTable = targetRangeVars[1].rangeTable;
this.insertCheckColumns = checkColumns;
this.insertColumnMap = insertColMap;
this.updateColumnMap = updateColMap;
this.insertExpression = insertExpr;
this.updateExpressions = updateExpr;
this.targetRangeVariables = targetRangeVars;
this.condition = mergeCondition;
type = MERGE;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* Instantiate this as a SET statement.
*/
CompiledStatement(Session session, Table table, RangeVariable rangeVars[],
int[] updateColumnMap, Expression[] colExpressions,
CompileContext compileContext) throws HsqlException {
this.schemaHsqlName = session.currentSchema;
this.targetTable = table;
this.updateColumnMap = updateColumnMap;
this.updateExpressions = colExpressions;
this.updateCheckColumns =
targetTable.getColumnCheckList(updateColumnMap);
this.targetRangeVariables = rangeVars;
type = SET;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
/**
* For the output of the statement
*/
public ResultMetaData getGeneratedColumnMetaData() {
return generatedResultMetaData;
}
/**
* For the creation of the statement
*/
public void setGeneratedColumnInfo(int generate, ResultMetaData meta) {
// can support INSERT_SELECT also
if (type != this.INSERT_VALUES) {
return;
}
int colIndex = targetTable.getIdentityColumn();
if (colIndex == -1) {
return;
}
switch (generate) {
case ResultConstants.RETURN_NO_GENERATED_KEYS :
return;
case ResultConstants.RETURN_GENERATED_KEYS_COL_INDEXES :
int[] columnIndexes = meta.getGeneratedColumnIndexes();
if (columnIndexes.length != 1) {
return;
}
if (columnIndexes[0] != colIndex) {
return;
}
// fall through
case ResultConstants.RETURN_GENERATED_KEYS :
generatedIndexes = new int[]{ colIndex };
break;
case ResultConstants.RETURN_GENERATED_KEYS_COL_NAMES :
String[] columnNames = meta.getGeneratedColumnNames();
if (columnNames.length != 1) {
return;
}
if (targetTable.findColumn(columnNames[0]) != colIndex) {
return;
}
generatedIndexes = new int[]{ colIndex };
break;
}
generatedResultMetaData =
ResultMetaData.newResultMetaData(generatedIndexes.length);
for (int i = 0; i < generatedIndexes.length; i++) {
Column.setMetaDataColumnInfo(
generatedResultMetaData, i, targetTable,
targetTable.getColumn(generatedIndexes[i]));
}
}
Object[] getGeneratedColumns(Object[] data) {
if (generatedIndexes == null) {
return null;
}
Object[] values = new Object[generatedIndexes.length];
for (int i = 0; i < generatedIndexes.length; i++) {
values[i] = data[generatedIndexes[i]];
}
return values;
}
boolean hasGeneratedColumns() {
return generatedIndexes != null;
}
boolean[] getInsertOrUpdateColumnCheckList() {
switch (type) {
case INSERT_SELECT :
case INSERT_VALUES :
return insertCheckColumns;
case UPDATE :
return updateCheckColumns;
case MERGE :
boolean[] check =
(boolean[]) ArrayUtil.duplicateArray(insertCheckColumns);
ArrayUtil.orBooleanArray(updateCheckColumns, check);
return check;
}
return null;
}
private void setParameters(Expression[] params) {
this.parameters = params;
Type[] types = new Type[parameters.length];
for (int i = 0; i < parameters.length; i++) {
parameters[i].parameterIndex = i;
types[i] = parameters[i].getDataType();
}
this.paramTypes = types;
}
void materializeSubQueries(Session session,
Set subqueryPopFlags) throws HsqlException {
for (int i = 0; i < subqueries.length; i++) {
SubQuery sq = subqueries[i];
// VIEW working tables may be reused in a single query but they are filled only once
if (!subqueryPopFlags.add(sq)) {
continue;
}
if (!sq.isCorrelated) {
sq.materialise(session);
}
}
}
void dematerializeSubQueries(Session session) {
if (subqueries == null) {
return;
}
for (int i = 0; i < subqueries.length; i++) {
subqueries[i].dematerialiseAll(session);
}
}
void clearVariables() {
isValid = false;
targetTable = null;
condition = null;
insertColumnMap = null;
updateColumnMap = null;
updateExpressions = null;
insertExpression = null;
insertCheckColumns = null;
expression = null;
select = null;
parameters = null;
paramTypes = null;
subqueries = null;
}
void setDatabseObjects(CompileContext compileContext)
throws HsqlException {
Expression[] params = compileContext.getParameters();
setParameters(params);
subqueries = compileContext.getSubqueries();
rangeIteratorCount = compileContext.getRangeVarCount();
rangeVariables = compileContext.rangeVariables;
sequenceExpressions = compileContext.usedSequences;
routineExpressions = compileContext.usedRoutineNames;
}
/**
* Determines if the authorizations are adequate
* to execute the compiled object. Completion requires the list of
* all database objects in a compiled statement.
*/
void checkAccessRights(Session session) throws HsqlException {
if (targetTable != null) {
targetTable.checkDataReadOnly();
}
if (session.isAdmin()) {
return;
}
if (sequenceExpressions != null) {
for (int i = 0; i < sequenceExpressions.size(); i++) {
NumberSequence s = (NumberSequence) sequenceExpressions.get(i);
session.getUser().checkAccess(s);
}
}
if (routineExpressions != null) {
for (int i = 0; i < routineExpressions.size(); i++) {
String s = (String) routineExpressions.get(i);
session.getUser().checkAccess(s);
}
}
if (rangeVariables != null) {
for (int i = 0; i < rangeVariables.size(); i++) {
RangeVariable range = (RangeVariable) rangeVariables.get(i);
if (range.rangeTable.getSchemaName()
== SchemaManager.SYSTEM_SCHEMA_HSQLNAME) {
continue;
}
session.getUser().checkSelect(range.rangeTable,
range.usedColumns);
}
}
switch (type) {
case CALL : {
break;
}
case INSERT_SELECT : {
session.checkReadWrite();
session.getUser().checkInsert(targetTable, insertCheckColumns);
targetTable.checkDataReadOnly();
// fall through
}
case SELECT :
break;
case DELETE : {
// session level user rights
session.checkReadWrite();
session.getUser().checkDelete(targetTable);
// object readonly
targetTable.checkDataReadOnly();
break;
}
case INSERT_VALUES : {
session.checkReadWrite();
session.getUser().checkInsert(targetTable, insertCheckColumns);
targetTable.checkDataReadOnly();
break;
}
case UPDATE : {
session.checkReadWrite();
session.getUser().checkUpdate(targetTable, updateCheckColumns);
targetTable.checkDataReadOnly();
break;
}
case MERGE : {
session.checkReadWrite();
session.getUser().checkInsert(targetTable, insertCheckColumns);
session.getUser().checkUpdate(targetTable, updateCheckColumns);
targetTable.checkDataReadOnly();
break;
}
case DDL : {
session.checkReadWrite();
}
}
}
/**
* Returns the metadata, which is empty if the CompiledStatement does not
* generate a Result.
*/
ResultMetaData getResultMetaData() {
switch (type) {
case CALL : {
// TODO:
//
// 1.) standard to register metadata for columns of
// the primary result set, if any, generated by call
//
// 2.) Represent the return value, if any (which is
// not, in truth, a result set), as an OUT parameter
//
// For now, I've reverted a bunch of code I had in place
// and instead simply reflect things as the are, describing
// a single column result set that communicates
// the return value. If the expression generating the
// return value has a void return type, a result set
// is described whose single column is of type NULL
ResultMetaData md = ResultMetaData.newResultMetaData(1);
md.colNames[0] = CompiledStatement.RETURN_COLUMN_NAME;
md.colTypes[0] = expression.getDataType();
md.classNames[0] = expression.getValueClassName();
// no more setup for r; all the defaults apply
return md;
}
case SELECT :
return select.getMetaData();
case SELECT_INTO :
case DELETE :
case INSERT_SELECT :
case INSERT_VALUES :
case UPDATE :
case DDL :
return ResultMetaData.emptyMetaData;
default :
throw Trace.runtimeError(
Trace.UNSUPPORTED_INTERNAL_OPERATION,
"CompiledStatement.getResultMetaData()");
}
}
/**
* Returns the metadata for the placeholder parameters.
*/
ResultMetaData getParametersMetaData() {
ResultMetaData metaData;
int offset;
int idx;
boolean hasReturnValue;
offset = 0;
// NO: Not yet
// hasReturnValue = (type == CALL && !expression.isProcedureCall());
//
// if (hasReturnValue) {
// outlen++;
// offset = 1;
// }
metaData = ResultMetaData.newParameterMetaData(parameters.length);
// NO: Not yet
// if (hasReturnValue) {
// e = expression;
// out.sName[0] = DIProcedureInfo.RETURN_COLUMN_NAME;
// out.sClassName[0] = e.getValueClassName();
// out.colType[0] = e.getDataType();
// out.colSize[0] = e.getColumnSize();
// out.colScale[0] = e.getColumnScale();
// out.nullability[0] = e.nullability;
// out.isIdentity[0] = false;
// out.paramMode[0] = expression.PARAM_OUT;
// }
for (int i = 0; i < parameters.length; i++) {
idx = i + offset;
// always i + 1. We currently use the convention of @p0 to name the
// return value OUT parameter
metaData.colNames[idx] = CompiledStatement.PCOL_PREFIX + (i + 1);
// sLabel is meaningless in this context.
metaData.classNames[idx] = parameters[i].getValueClassName();
metaData.colTypes[idx] = parameters[i].dataType;
// TODO: The rules should be: - always nullable unless:
//
// 1.) type of site is Java primitive,
// e.g. a SQL-invoked routine
// parameter that maps to a
// primitive Java method argument
//
// 2.) (future) the site is declared
// not null, e.g. a SQL language
// routine parameter explicitly
// declared not null.
metaData.colNullable[idx] = parameters[i].nullability;
metaData.isIdentity[idx] = parameters[i].isIdentity;
// currently will always be Expression.PARAM_IN
metaData.paramModes[idx] = parameters[i].paramMode;
}
return metaData;
}
/**
* Retrieves a String representation of this object.
*/
public String describe(Session session) {
try {
return describeImpl(session);
} catch (Exception e) {
e.printStackTrace();
return e.toString();
}
}
/**
* Provides the toString() implementation.
*/
private String describeImpl(Session session) throws Exception {
StringBuffer sb;
sb = new StringBuffer();
switch (type) {
case SELECT : {
sb.append(select.describe(session));
appendParms(sb).append('\n');
appendSubqueries(sb);
return sb.toString();
}
case INSERT_VALUES : {
sb.append("INSERT VALUES");
sb.append('[').append('\n');
appendMultiColumns(sb, insertColumnMap).append('\n');
appendTable(sb).append('\n');
appendParms(sb).append('\n');
appendSubqueries(sb).append(']');
return sb.toString();
}
case INSERT_SELECT : {
sb.append("INSERT SELECT");
sb.append('[').append('\n');
appendColumns(sb, insertColumnMap).append('\n');
appendTable(sb).append('\n');
sb.append(select.describe(session)).append('\n');
appendParms(sb).append('\n');
appendSubqueries(sb).append(']');
return sb.toString();
}
case UPDATE : {
sb.append("UPDATE");
sb.append('[').append('\n');
appendColumns(sb, updateColumnMap).append('\n');
appendTable(sb).append('\n');
appendCondition(session, sb);
sb.append(targetRangeVariables[0].describe(session)).append(
'\n');
sb.append(targetRangeVariables[1].describe(session)).append(
'\n');
appendParms(sb).append('\n');
appendSubqueries(sb).append(']');
return sb.toString();
}
case DELETE : {
sb.append("DELETE");
sb.append('[').append('\n');
appendTable(sb).append('\n');
appendCondition(session, sb);
sb.append(targetRangeVariables[0].describe(session)).append(
'\n');
sb.append(targetRangeVariables[1].describe(session)).append(
'\n');
appendParms(sb).append('\n');
appendSubqueries(sb).append(']');
return sb.toString();
}
case CALL : {
sb.append("CALL");
sb.append('[');
sb.append(expression.describe(session)).append('\n');
appendParms(sb).append('\n');
appendSubqueries(sb).append(']');
return sb.toString();
}
case MERGE : {
sb.append("MERGE");
sb.append('[').append('\n');
appendMultiColumns(sb, insertColumnMap).append('\n');
appendColumns(sb, updateColumnMap).append('\n');
appendTable(sb).append('\n');
appendCondition(session, sb);
sb.append(targetRangeVariables[0].describe(session)).append(
'\n');
sb.append(targetRangeVariables[1].describe(session)).append(
'\n');
sb.append(targetRangeVariables[2].describe(session)).append(
'\n');
appendParms(sb).append('\n');
appendSubqueries(sb).append(']');
return sb.toString();
}
default : {
return "UNKNOWN";
}
}
}
private StringBuffer appendSubqueries(StringBuffer sb) {
sb.append("SUBQUERIES[");
for (int i = 0; i < subqueries.length; i++) {
sb.append("\n[level=").append(subqueries[i].level).append('\n');
if (subqueries[i].select != null) {
sb.append("org.hsqldb.Select@").append(
Integer.toHexString(subqueries[i].select.hashCode()));
}
sb.append("]");
}
sb.append(']');
return sb;
}
private StringBuffer appendTable(StringBuffer sb) {
sb.append("TABLE[").append(targetTable.getName().name).append(']');
return sb;
}
private StringBuffer appendSourceTable(StringBuffer sb) {
sb.append("SOURCE TABLE[").append(sourceTable.getName().name).append(
']');
return sb;
}
private StringBuffer appendColumns(StringBuffer sb, int[] columnMap) {
if (columnMap == null || updateExpressions == null) {
return sb;
}
sb.append("COLUMNS=[");
for (int i = 0; i < columnMap.length; i++) {
sb.append('\n').append(columnMap[i]).append(':').append(
' ').append(
targetTable.getColumn(columnMap[i]).columnName.name).append(
'[').append(updateExpressions[i]).append(']');
}
sb.append(']');
return sb;
}
private StringBuffer appendColumns(StringBuffer sb) {
sb.append("COLUMNS=[");
/*
for (int i = 0; i < columnMap.length; i++) {
sb.append('\n').append(columnMap[i]).append(':');
.append(' ').append(
targetTable.getColumn(columnMap[i]).columnName.name).append(
'[').append(columnExpressions[i]).append(']');
}
*/
sb.append(']');
return sb;
}
private StringBuffer appendMultiColumns(StringBuffer sb, int[] columnMap) {
if (columnMap == null || multiColumnValues == null) {
return sb;
}
sb.append("COLUMNS=[");
for (int j = 0; j < multiColumnValues.length; j++) {
for (int i = 0; i < columnMap.length; i++) {
sb.append('\n').append(columnMap[i]).append(':').append(
' ').append(
targetTable.getColumn(
columnMap[i]).columnName.name).append('[').append(
multiColumnValues[j][i]).append(']');
}
}
sb.append(']');
return sb;
}
private StringBuffer appendParms(StringBuffer sb) {
sb.append("PARAMETERS=[");
for (int i = 0; i < parameters.length; i++) {
sb.append('\n').append('@').append(i).append('[').append(
parameters[i]).append(']');
}
sb.append(']');
return sb;
}
private StringBuffer appendCondition(Session session, StringBuffer sb) {
return condition == null ? sb.append("CONDITION[]\n")
: sb.append("CONDITION[").append(
condition.describe(session)).append(
"]\n");
}
}
The table below shows all metrics for CompiledStatement.java.
| Metric | Value | Description | |
|---|---|---|---|
| BLOCKS | 83.00 | Number of blocks | |
| BLOCK_COMMENT | 38.00 | Number of block comment lines | |
| COMMENTS | 226.00 | Comment lines | |
| COMMENT_DENSITY | 0.47 | Comment density | |
| COMPARISONS | 39.00 | Number of comparison operators | |
| CYCLOMATIC | 103.00 | Cyclomatic complexity | |
| DECL_COMMENTS | 49.00 | Comments in declarations | |
| DOC_COMMENT | 126.00 | Number of javadoc comment lines | |
| ELOC | 478.00 | Effective lines of code | |
| EXEC_COMMENTS | 32.00 | Comments in executable code | |
| EXITS | 59.00 | Procedure exits | |
| FUNCTIONS | 32.00 | Number of function declarations | |
| HALSTEAD_DIFFICULTY | 97.85 | Halstead difficulty | |
| HALSTEAD_EFFORT | 0.00 | Halstead effort | |
| INTERFACE_COMPLEXITY | 163.00 | Interface complexity | |
| JAVA0001 | 0.00 | JAVA0001 Package name does not contain only lower case letters | |
| JAVA0002 | 0.00 | JAVA0002 Package name does not begin with a top level domain name or country code | |
| JAVA0003 | 0.00 | JAVA0003 Minimize use of on-demand (.*) imports | |
| JAVA0004 | 0.00 | JAVA0004 Unnecessary import from java.lang | |
| JAVA0005 | 1.00 | JAVA0005 Imports not in specified order | |
| JAVA0006 | 0.00 | JAVA0006 Empty finally block | |
| JAVA0007 | 0.00 | JAVA0007 Should not declare public field | |
| JAVA0008 | 0.00 | JAVA0008 Empty catch block | |
| JAVA0009 | 0.00 | JAVA0009 Protected member in final class | |
| JAVA0010 | 0.00 | JAVA0010 Non-instantiable class does not contain a non-private static member | |
| JAVA0011 | 0.00 | JAVA0011 Abstract class does not contain an abstract method | |
| JAVA0012 | 0.00 | JAVA0012 Non-constructor method with same name as declaring class | |
| JAVA0013 | 0.00 | JAVA0013 Non-blank final field is not static | |
| JAVA0014 | 0.00 | JAVA0014 Class with only static members has non-private constructor | |
| JAVA0015 | 0.00 | JAVA0015 Package class contains public nested type | |
| JAVA0016 | 0.00 | JAVA0016 Abstract class contains public constructor | |
| JAVA0017 | 0.00 | JAVA0017 Class name does not have required form | |
| JAVA0018 | 0.00 | JAVA0018 Method name does not have required form | |
| JAVA0019 | 0.00 | JAVA0019 Interface name does not have required form | |
| JAVA0020 | 0.00 | JAVA0020 Field name does not have required form | |
| JAVA0021 | 0.00 | JAVA0021 Interface method name does not have required form | |
| JAVA0022 | 0.00 | JAVA0022 Static final field name does not have required form | |
| JAVA0023 | 0.00 | JAVA0023 Empty finalize method | |
| JAVA0024 | 0.00 | JAVA0024 Empty class | |
| JAVA0025 | 0.00 | JAVA0025 Method override is empty | |
| JAVA0026 | 0.00 | JAVA0026 Finalize method with parameters | |
| JAVA0029 | 2.00 | JAVA0029 Private method not used | |
| JAVA0030 | 0.00 | JAVA0030 Private field not used | |
| JAVA0031 | 3.00 | JAVA0031 Case statement not properly closed | |
| JAVA0032 | 3.00 | JAVA0032 Switch statement missing default | |
| JAVA0033 | 0.00 | JAVA0033 default: not last case in switch statement | |
| JAVA0034 | 0.00 | JAVA0034 Missing braces in if statement | |
| JAVA0035 | 0.00 | JAVA0035 Missing braces in for statement | |
| JAVA0036 | 0.00 | JAVA0036 Missing braces in while statement | |
| JAVA0038 | 0.00 | JAVA0038 Non-case label in switch statement | |
| JAVA0039 | 0.00 | JAVA0039 Break statement with label | |
| JAVA0040 | 0.00 | JAVA0040 Switch statement contains N cases (maximum: M) | |
| JAVA0041 | 0.00 | JAVA0041 Nested synchronized block | |
| JAVA0042 | 0.00 | JAVA0042 Empty synchronized statement | |
| JAVA0043 | 0.00 | JAVA0043 Inner class does not use outer class | |
| JAVA0044 | 0.00 | JAVA0044 Serializable class with no instance variables | |
| JAVA0045 | 0.00 | JAVA0045 Serializable class with only transient fields | |
| JAVA0046 | 0.00 | JAVA0046 Name of class not derived from Exception ends with 'Exception' | |
| JAVA0047 | 0.00 | JAVA0047 Serializable class derives from invalid base class | |
| JAVA0048 | 0.00 | JAVA0048 Name of class derived from Exception does not end with 'Exception' | |
| JAVA0049 | 0.00 | JAVA0049 Nested block at depth N (maximum: M) | |
| JAVA0050 | 0.00 | JAVA0050 Class derives from java.lang.Error | |
| JAVA0051 | 0.00 | JAVA0051 Class derives from java.lang.RuntimeException | |
| JAVA0052 | 0.00 | JAVA0052 Class derives from java.lang.Throwable | |
| JAVA0053 | 0.00 | JAVA0053 Unused label | |
| JAVA0054 | 0.00 | JAVA0054 Inheritance depth N exceeds maximum M | |
| JAVA0055 | 0.00 | JAVA0055 Class should be interface | |
| JAVA0056 | 0.00 | JAVA0056 Unnecessary abstract modifier for interface or annotation | |
| JAVA0057 | 0.00 | JAVA0057 Unnecessary default constructor | |
| JAVA0058 | 0.00 | JAVA0058 Constructor calls super() | |
| JAVA0059 | 0.00 | JAVA0059 Method override only calls super() | |
| JAVA0061 | 0.00 | JAVA0061 Inaccessible member in anonymous class | |
| JAVA0062 | 0.00 | JAVA0062 Public class missing public member or protected constructor | |
| JAVA0063 | 0.00 | JAVA0063 Identifier name should not contain '$' | |
| JAVA0064 | 1.00 | JAVA0064 N variations of identifier name (maximum: M) | |
| JAVA0065 | 0.00 | JAVA0065 Unnecessary final modifier for method in final class | |
| JAVA0066 | 0.00 | JAVA0066 Unnecessary modifier for interface nested type | |
| JAVA0067 | 0.00 | JAVA0067 Array descriptor on identifier name | |
| JAVA0068 | 0.00 | JAVA0068 Modifiers not declared in recommended order | |
| JAVA0071 | 0.00 | JAVA0071 Strings compared with == | |
| JAVA0073 | 0.00 | JAVA0073 Integer division in floating-point context | |
| JAVA0074 | 0.00 | JAVA0074 Use of Object.notify() | |
| JAVA0075 | 2.00 | JAVA0075 Method parameter hides field | |
| JAVA0076 | 0.00 | JAVA0076 Use of magic number | |
| JAVA0077 | 0.00 | JAVA0077 Private field not used in declaring class | |
| JAVA0078 | 0.00 | JAVA0078 Floating point values compared with == | |
| JAVA0079 | 1.00 | JAVA0079 Use of instance to reference static member | |
| JAVA0080 | 0.00 | JAVA0080 Import declaration not used | |
| JAVA0081 | 0.00 | JAVA0081 Boolean literal in comparison | |
| JAVA0082 | 0.00 | JAVA0082 Unnecessary widening cast | |
| JAVA0083 | 0.00 | JAVA0083 Unnecessary instanceof test | |
| JAVA0084 | 0.00 | JAVA0084 Should use compound assignment operator | |
| JAVA0085 | 0.00 | JAVA0085 Use of sun.* class | |
| JAVA0087 | 0.00 | JAVA0087 Use of Thread.sleep() | |
| JAVA0089 | 0.00 | JAVA0089 Use of restricted package | |
| JAVA0092 | 0.00 | JAVA0092 Use of restricted type | |
| JAVA0093 | 0.00 | JAVA0093 Redundant assignment | |
| JAVA0094 | 0.00 | JAVA0094 Field hides a superclass field | |
| JAVA0095 | 0.00 | JAVA0095 Uninitialized private field | |
| JAVA0096 | 0.00 | JAVA0096 Field in nested class hides outer field | |
| JAVA0098 | 0.00 | JAVA0098 Minimize use of implicit field initializers | |
| JAVA0100 | 1.00 | JAVA0100 Class contains N non-final fields (maximum: M) | |
| JAVA0101 | 0.00 | JAVA0101 Unnecessary modifier for field in interface | |
| JAVA0102 | 0.00 | JAVA0102 Last statement in finalize() not super.finalize() | |
| JAVA0103 | 0.00 | JAVA0103 Explicit call to finalize() | |
| JAVA0104 | 0.00 | JAVA0104 finalize() only calls super.finalize() | |
| JAVA0105 | 0.00 | JAVA0105 Duplicate import declaration | |
| JAVA0106 | 0.00 | JAVA0106 Unnecessary import from current package | |
| JAVA0108 | 47.00 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0109 | 0.00 | JAVA0109 Incorrect javadoc: no parameter 'parameter' | |
| JAVA0110 | 5.00 | JAVA0110 Incorrect javadoc: no @return tag | |
| JAVA0111 | 0.00 | JAVA0111 Incorrect javadoc: @return tag for void method | |
| JAVA0112 | 0.00 | JAVA0112 Incorrect javadoc: no exception 'exception' in throws | |
| JAVA0113 | 0.00 | JAVA0113 Incorrect javadoc: no @author tag | |
| JAVA0114 | 0.00 | JAVA0114 Incorrect javadoc: no @version tag | |
| JAVA0115 | 10.00 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| JAVA0116 | 12.00 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0117 | 0.00 | JAVA0117 Missing javadoc: method 'method' | |
| JAVA0118 | 0.00 | JAVA0118 Missing javadoc: type 'type' | |
| JAVA0119 | 0.00 | JAVA0119 Control variable changed within body of for loop | |
| JAVA0123 | 0.00 | JAVA0123 Use all three components of for loop | |
| JAVA0125 | 0.00 | JAVA0125 Continue statement with label | |
| JAVA0126 | 0.00 | JAVA0126 Method declares unchecked exception in throws | |
| JAVA0128 | 0.00 | JAVA0128 Public constructor in non-public class | |
| JAVA0130 | 1.00 | JAVA0130 Non-static method does not use instance fields | |
| JAVA0131 | 0.00 | JAVA0131 Compatible method does not override base | |
| JAVA0132 | 0.00 | JAVA0132 Method overload with compatible signature | |
| JAVA0133 | 0.00 | JAVA0133 Non-synchronized method overrides synchronized method | |
| JAVA0135 | 0.00 | JAVA0135 Only one of Object.equals and Object.hashCode defined: missing 'method' | |
| JAVA0136 | 1.00 | JAVA0136 N methods defined in class (maximum: M) | |
| JAVA0137 | 0.00 | JAVA0137 Non-abstract class missing constructor | |
| JAVA0138 | 4.00 | JAVA0138 N parameters defined for method (maximum: M) | |
| JAVA0139 | 0.00 | JAVA0139 Definition of main other than public static void main(java.lang.String[]) | |
| JAVA0141 | 0.00 | JAVA0141 Unnecessary modifier for method in interface | |
| JAVA0143 | 0.00 | JAVA0143 Synchronized method | |
| JAVA0144 | 0.00 | JAVA0144 Line exceeds maximum M characters | |
| JAVA0145 | 0.00 | JAVA0145 Tab character used in source file | |
| JAVA0150 | 0.00 | JAVA0150 java.lang.Error (or subclass) thrown | |
| JAVA0153 | 0.00 | JAVA0153 Inefficient conversion of integer to string | |
| JAVA0159 | 0.00 | JAVA0159 Inefficient conversion of string to integer | |
| JAVA0160 | 1.00 | JAVA0160 Method does not throw specified exception | |
| JAVA0161 | 0.00 | JAVA0161 Conditional wait() not in loop | |
| JAVA0163 | 0.00 | JAVA0163 Empty statement | |
| JAVA0165 | 0.00 | JAVA0165 Conflicting return statement in finally block | |
| JAVA0166 | 1.00 | JAVA0166 Generic exception caught | |
| JAVA0167 | 0.00 | JAVA0167 ThreadDeath not rethrown | |
| JAVA0169 | 0.00 | JAVA0169 Unnecessary catch block: exception 'exception' | |
| JAVA0170 | 0.00 | JAVA0170 Caught exception not derived from java.lang.Exception | |
| JAVA0171 | 1.00 | JAVA0171 Unused local variable | |
| JAVA0173 | 0.00 | JAVA0173 Unused method parameter | |
| JAVA0174 | 0.00 | JAVA0174 Assigned local variable never used | |
| JAVA0175 | 0.00 | JAVA0175 Successive assignment to variable | |
| JAVA0176 | 0.00 | JAVA0176 Local variable name does not have required form | |
| JAVA0177 | 5.00 | JAVA0177 Variable declaration missing initializer | |
| JAVA0179 | 0.00 | JAVA0179 Local variable hides visible field | |
| JAVA0233 | 0.00 | JAVA0233 Definition of serialVersionUID other than 'private static final long serialVersionUID' | |
| JAVA0234 | 0.00 | JAVA0234 Class is Serializable but does not define serialVersionUID | |
| JAVA0235 | 0.00 | JAVA0235 Class defines serialVersionUID but does not implement Serializable | |
| JAVA0236 | 0.00 | JAVA0236 Attempt to clone an object which does not implement Cloneable | |
| JAVA0237 | 0.00 | JAVA0237 Class implements Cloneable but does not have public clone method | |
| JAVA0238 | 0.00 | JAVA0238 Clone method does not call super.clone() | |
| JAVA0239 | 0.00 | JAVA0239 Class declares 'readObject' or 'writeObject' but does not implement Serializable | |
| JAVA0240 | 0.00 | JAVA0240 Serializable class which declares readObject or writeObject but not both | |
| JAVA0241 | 0.00 | JAVA0241 'readObject' or 'writeObject' should be declared private in Serializable class | |
| JAVA0242 | 0.00 | JAVA0242 Transient field in non-Serializable class | |
| JAVA0243 | 0.00 | JAVA0243 'readResolve' or 'writeReplace' should be declared private or protected | |
| JAVA0244 | 0.00 | JAVA0244 Field or method name in subclass differs only by case from inherited field or method | |
| JAVA0245 | 0.00 | JAVA0245 JUnit TestCase with non-trivial constructor | |
| JAVA0246 | 0.00 | JAVA0246 JUnit assertXXX statement missing message parameter | |
| JAVA0247 | 0.00 | JAVA0247 JUnit 'setUp()' and 'tearDown()' should call super method | |
| JAVA0248 | 0.00 | JAVA0248 JUnit method 'setUp' or 'tearDown' with incorrect signature | |
| JAVA0249 | 0.00 | JAVA0249 JUnit TestCase 'suite()' should be declared static | |
| JAVA0250 | 0.00 | JAVA0250 JUnit TestCase declares testXXX method with incorrect signature | |
| JAVA0251 | 0.00 | JAVA0251 Use '%n' for line breaks in printf/format for platform independence | |
| JAVA0252 | 0.00 | JAVA0252 'enum' is a Java 1.5 reserved word | |
| JAVA0253 | 0.00 | JAVA0253 Not all enum constants consumed in switch statement | |
| JAVA0254 | 0.00 | JAVA0254 Use enhanced for loop construct instead of Iterator | |
| JAVA0255 | 0.00 | JAVA0255 Result of method invocation not used | |
| JAVA0256 | 17.00 | JAVA0256 Assignment of external collection/array to field | |
| JAVA0257 | 0.00 | JAVA0257 Use of 'Constant Interface' anti-pattern | |
| JAVA0258 | 0.00 | JAVA0258 Implement Iterable for foreach compatibility | |
| JAVA0259 | 2.00 | JAVA0259 Return of collection/array field | |
| JAVA0260 | 0.00 | JAVA0260 Use 'enum' instead of Enumerated Type pattern | |
| JAVA0261 | 0.00 | JAVA0261 Use specialized Enum collection types | |
| JAVA0262 | 0.00 | JAVA0262 Use of char in integer context | |
| JAVA0263 | 0.00 | JAVA0263 Long literal ends with 'l' instead of 'L' | |
| JAVA0264 | 0.00 | JAVA0264 Integer math in long context - check for overflow | |
| JAVA0265 | 1.00 | JAVA0265 Use of Throwable.printStackTrace() | |
| JAVA0266 | 0.00 | JAVA0266 Use of System.out | |
| JAVA0267 | 0.00 | JAVA0267 Use of System.err | |
| JAVA0269 | 0.00 | JAVA0269 Contents of StringBuffer never used | |
| JAVA0270 | 4.00 | JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array | |
| JAVA0271 | 0.00 | JAVA0271 Minimize use of on-demand (.*) static imports | |
| JAVA0272 | 0.00 | JAVA0272 Thread.run() called | |
| JAVA0273 | 0.00 | JAVA0273 Non-final derivative of Thread calls start() in constructor | |
| JAVA0274 | 0.00 | JAVA0274 Serializable class has a synchronized readObject() | |
| JAVA0275 | 0.00 | JAVA0275 Serializable class has a synchronized writeObject() and no other synchronized methods | |
| JAVA0276 | 0.00 | JAVA0276 Unnecessary use of String constructor | |
| JAVA0277 | 0.00 | JAVA0277 Iterator.next() implementation does not throw NoSuchElementException | |
| JAVA0278 | 0.00 | JAVA0278 Unnecessary use of Boolean constructor | |
| JAVA0279 | 0.00 | JAVA0279 Serialization method readObject or readObjectNoData calls an overridable method | |
| JAVA0280 | 0.00 | JAVA0280 IllegalMonitorStateException caught | |
| JAVA0281 | 0.00 | JAVA0281 Iterator.next() not called in loop | |
| JAVA0282 | 0.00 | JAVA0282 Call to Iterator.next() in loop which does not test Iterator.hasNext() | |
| JAVA0283 | 0.00 | JAVA0283 Control variable not updated in loop body | |
| JAVA0284 | 0.00 | JAVA0284 Explicit garbage collection | |
| JAVA0285 | 0.00 | JAVA0285 Dereference of potentially null variable | |
| JAVA0286 | 0.00 | JAVA0286 Dereference of null variable | |
| JAVA0287 | 0.00 | JAVA0287 Unnecessary null check | |
| JAVA0288 | 0.00 | JAVA0288 Inconsistent null check | |
| LINES | 987.00 | Number of lines in the source file | |
| LINE_COMMENT | 62.00 | Number of line comments | |
| LOC | 566.00 | Lines of code | |
| LOGICAL_LINES | 352.00 | Number of statements | |
| LOOPS | 14.00 | Number of loops | |
| NEST_DEPTH | 4.00 | Maximum nesting depth | |
| OPERANDS | 1320.00 | Number of operands | |
| OPERATORS | 2343.00 | Number of operators | |
| PARAMS | 64.00 | Number of formal parameter declarations | |
| PROGRAM_LENGTH | 3663.00 | Halstead program length | |
| PROGRAM_VOCAB | 364.00 | Halstead program vocabulary | |
| PROGRAM_VOLUME | 0.00 | Halstead program volume | |
| RETURNS | 99.00 | Number of return points from functions | |
| SIZE | 31383.00 | Size of the file in bytes | |
| UNIQUE_OPERANDS | 317.00 | Number of unique operands | |
| UNIQUE_OPERATORS | 47.00 | Number of unique operators | |
| WHITESPACE | 195.00 | Number of whitespace lines | |