Select.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 | |
|---|---|---|
| LOOPS | Number of loops |  |
| CYCLOMATIC | Cyclomatic complexity | |
| COMPARISONS | Number of comparison operators | |
| RETURNS | Number of return points from functions | |
| SIZE | Size of the file in bytes | |
| BLOCKS | Number of blocks | |
| LOGICAL_LINES | Number of statements | |
| OPERATORS | Number of operators | |
| PROGRAM_LENGTH | Halstead program length | |
| LINES | Number of lines in the source file | |
| OPERANDS | Number of operands | |
| ELOC | Effective lines of code | |
| LOC | Lines of code | |
| INTERFACE_COMPLEXITY | Interface complexity | |
| LINE_COMMENT | Number of line comments | |
| WHITESPACE | Number of whitespace lines | |
| EXITS | Procedure exits | |
| UNIQUE_OPERANDS | Number of unique operands | |
| PROGRAM_VOCAB | Halstead program vocabulary | |
| JAVA0270 | JAVA0270 Use Java 5.0 enhanced for loop construct to iterate over all elements in an array | |
| JAVA0115 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| JAVA0108 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0116 | JAVA0116 Missing javadoc: field 'field' | |
| FUNCTIONS | Number of function declarations | |
| COMMENTS | Comment lines | |
| JAVA0081 | JAVA0081 Boolean literal in comparison | |
| JAVA0007 | JAVA0007 Should not declare public field | |
| BLOCK_COMMENT | Number of block comment lines | |
| JAVA0160 | JAVA0160 Method does not throw specified exception | |
| JAVA0049 | JAVA0049 Nested block at depth N (maximum: M) | |
| EXEC_COMMENTS | Comments in executable code | |
| JAVA0034 | JAVA0034 Missing braces in if statement | |
| PARAMS | Number of formal parameter declarations | |
| JAVA0110 | JAVA0110 Incorrect javadoc: no @return tag | |
| JAVA0177 | JAVA0177 Variable declaration missing initializer | |
| JAVA0032 | JAVA0032 Switch statement missing default | |
| JAVA0123 | JAVA0123 Use all three components of for loop | |
| DECL_COMMENTS | Comments in declarations | |
| JAVA0173 | JAVA0173 Unused method parameter | |
| JAVA0031 | JAVA0031 Case statement not properly closed | |
| NEST_DEPTH | Maximum nesting depth | |
| UNIQUE_OPERATORS | Number of unique operators | |
| PROGRAM_VOLUME | Halstead program volume | |
| JAVA0136 | JAVA0136 N methods defined in class (maximum: M) | |
| JAVA0126 | JAVA0126 Method declares unchecked exception in throws | |
| JAVA0179 | JAVA0179 Local variable hides visible field | |
| JAVA0117 | JAVA0117 Missing javadoc: method 'method' | |
| JAVA0171 | JAVA0171 Unused local variable | |
| JAVA0064 | JAVA0064 N variations of identifier name (maximum: M) | |
| JAVA0095 | JAVA0095 Uninitialized private field | |
| JAVA0029 | JAVA0029 Private method not used | |
| JAVA0100 | JAVA0100 Class contains N non-final fields (maximum: M) | |
| JAVA0145 | JAVA0145 Tab character used in source file | |
/* Copyright (c) 1995-2000, The Hypersonic SQL 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 Hypersonic SQL 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 THE HYPERSONIC SQL GROUP,
* 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.
*
* This software consists of voluntary contributions made by many individuals
* on behalf of the Hypersonic SQL Group.
*
*
* For work added by the HSQL Development Group:
*
* 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.RangeVariable.RangeIterator;
import org.hsqldb.lib.ArrayUtil;
import org.hsqldb.lib.HashMappedList;
import org.hsqldb.lib.HashSet;
import org.hsqldb.lib.HsqlArrayList;
import org.hsqldb.lib.OrderedHashSet;
import org.hsqldb.lib.Set;
import org.hsqldb.navigator.DataRowSetNavigator;
import org.hsqldb.navigator.RowSetNavigator;
import org.hsqldb.result.Result;
import org.hsqldb.result.ResultMetaData;
import org.hsqldb.types.Type;
// fredt@users - 1.9.0 - complete rewrite of column resolution and query processing
/**
* The compiled representation of an SQL SELECT.
*
* The query processing functionality of this class was inherited from Hypersonic.
* It was completely rewritten in successive versions of HSQLDB.
*
* @author Thomas Mueller (Hypersonic SQL Group)
* @author fredt@users
*
* @version 1.8.0
* @since Hypersonic SQL
*/
public class Select {
boolean isDistinctSelect;
public boolean isAggregated;
public boolean isAggregateSorted;
private boolean isGrouped;
private HashSet groupColumnNames;
RangeVariable[] rangeVariables;
HsqlArrayList rangeVariableList;
int[] rangeSequence;
Expression limitCondition;
Expression queryCondition; // null means no condition
Expression havingCondition; // null means none
Expression[] exprColumns; // 'result', 'group' and 'order' columns
HsqlArrayList exprColumnList;
public int visibleColumnCount; // columns in 'result'
int groupByColumnCount; // columns in 'group by'
int havingColumnCount; // columns in 'having' (0 or 1)
public int orderByColumnCount; // columns in 'order by'
public int orderByStart;
public int orderByLimitIndex; // index of first possible column beyond order by cols
public int[] sortOrder;
public int[] sortDirection;
boolean sortUnion; // if true, sort the result of the full union
HsqlName intoTableName; // null means not select..into
public int intoType;
//
boolean isMain; // has no union or is first in union chain
Select[] unionArray; // only set in the first Select in a union chain
int unionMaxDepth; // max unionDepth in chain
Select unionSelect; // next select in union chain or null
public int unionType; // type of union op with next select
int unionDepth;
public static final int NOUNION = 0,
UNION = 1,
UNIONALL = 2,
INTERSECT = 3,
EXCEPT = 4;
private boolean simpleLimit; // true if maxrows can be uses as is
ResultMetaData resultMetaData;
Expression[] aggregates;
//
OrderedHashSet unresolvedColumns;
//
CompileContext compileContext;
//
OrderedHashSet tempSet = new OrderedHashSet();
//
boolean isResolved;
private Select() {}
Select(CompileContext compileContext, boolean isMain) {
this.compileContext = compileContext;
this.isMain = isMain;
rangeVariableList = new HsqlArrayList();
exprColumnList = new HsqlArrayList();
}
void addRangeVariable(RangeVariable rangeVar) {
rangeVariableList.add(rangeVar);
}
void finaliseRangeVariables() {
if (rangeVariables == null
|| rangeVariables.length < rangeVariableList.size()) {
rangeVariables = new RangeVariable[rangeVariableList.size()];
rangeVariableList.toArray(rangeVariables);
/*
rangeSequence = new int[rangeVariables.length];
ArrayUtil.fillSequence(rangeSequence);
*/
}
}
void addSelectColumnExpression(Expression e) throws HsqlException {
if (e.exprType == Expression.ROW) {
// SQL error messsage
throw Trace.error(Trace.WRONG_DATA_TYPE, e.getDDL());
}
exprColumnList.add(e);
}
void addQueryCondition(Expression e) {
queryCondition = e;
}
void addGroupByColumnExpression(Expression e) throws HsqlException {
if (e.exprType == Expression.ROW) {
// SQL error messsage
throw Trace.error(Trace.UNRESOLVED_TYPE, e.getDDL());
}
exprColumnList.add(e);
isGrouped = true;
groupByColumnCount++;
}
void addHavingExpression(Expression e) {
exprColumnList.add(e);
havingCondition = e;
havingColumnCount = 1;
}
void addOrderByExpression(Expression e) throws HsqlException {
exprColumnList.add(e);
orderByColumnCount++;
}
void addUnionOrderByExpression(Expression e) throws HsqlException {
exprColumnList.add(e);
orderByColumnCount++;
}
public void checkUniqueColumnNameSet(OrderedHashSet columns)
throws HsqlException {
OrderedHashSet set = new OrderedHashSet();
for (int i = 0; i < rangeVariableList.size(); i++) {
RangeVariable range = (RangeVariable) rangeVariableList.get(i);
HashMappedList columnList = range.rangeTable.columnList;
for (int j = 0; j < columnList.size(); j++) {
String name = ((Column) columnList.get(j)).columnName.name;
if (range.namedJoinColumns != null
&& range.namedJoinColumns.contains(name)) {
continue;
}
if (columns.contains(name)) {
if (set.contains(name)) {
throw Trace.error(Trace.SQL_COLUMN_NAMES_NOT_UNIQUE);
}
set.add(name);
}
}
}
}
public OrderedHashSet getUniqueColumnNameSet() throws HsqlException {
OrderedHashSet set = new OrderedHashSet();
for (int i = 0; i < rangeVariableList.size(); i++) {
RangeVariable range = (RangeVariable) rangeVariableList.get(i);
HashMappedList columnList = range.rangeTable.columnList;
for (int j = 0; j < columnList.size(); j++) {
String name = ((Column) columnList.get(j)).columnName.name;
if (range.namedJoinColumns != null
&& range.namedJoinColumns.contains(name)) {
continue;
}
if (set.contains(name)) {
throw Trace.error(Trace.SQL_COLUMN_NAMES_NOT_UNIQUE);
}
set.add(name);
}
}
return set;
}
int addAllJoinedColumns(HsqlArrayList columnList, int position) {
HsqlArrayList currentColumnList = new HsqlArrayList();
for (int i = 0; i < rangeVariables.length; i++) {
rangeVariables[i].addTableColumns(currentColumnList);
}
for (int i = 0; i < currentColumnList.size(); i++) {
columnList.add(position, currentColumnList.get(i));
position++;
}
return position;
}
void finaliseAndResolve(boolean resolveAll) throws HsqlException {
finaliseColumns();
resolveNonSelectColumnRefernces();
if (resolveAll) {
checkColumnsResolved();
}
}
void finaliseColumns() {
exprColumns = new Expression[exprColumnList.size()];
exprColumnList.toArray(exprColumns);
orderByStart = visibleColumnCount + groupByColumnCount
+ havingColumnCount;
orderByLimitIndex = orderByStart + orderByColumnCount;
if (orderByColumnCount != 0) {
for (int i = 0; i < visibleColumnCount; i++) {
exprColumns[i].queryTableColumnIndex = i;
}
}
}
void checkColumnsResolved() throws HsqlException {
Expression.checkColumnsResolved(unresolvedColumns);
}
void finishPrepare(Session session) throws HsqlException {
if (isMain) {
prepareUnions();
}
if (areColumnsResolved()) {
resolveTypesAndPrepare();
}
}
/**
* Resolves all column expressions in the GROUP BY clause and beyond.
* Replaces any alias column expression in the ORDER BY cluase
* with the actual select column expression.
*
* @throws HsqlException
*/
void resolveNonSelectColumnRefernces() throws HsqlException {
for (int i = visibleColumnCount; i < orderByStart; i++) {
resolveColumnReferences(exprColumns[i]);
}
if (queryCondition != null) {
resolveColumnReferences(queryCondition);
}
// replace the aliases with expressions
// replace column names with expressions and resolve the table columns
for (int i = orderByStart; i < orderByLimitIndex; i++) {
Expression orderBy = exprColumns[i];
replaceColumnIndexInOrderBy(orderBy);
if (orderBy.eArg.queryTableColumnIndex != -1) {
continue;
}
orderBy.replaceAliasInOrderBy(exprColumns, visibleColumnCount,
null);
resolveColumnReferences(orderBy);
}
}
private void replaceColumnIndexInOrderBy(Expression orderBy)
throws HsqlException {
Expression e = orderBy.eArg;
if (e.getType() != Expression.VALUE) {
return;
}
// order by 1,2,3
if (e.getDataType().type == Types.SQL_INTEGER) {
int i = ((Integer) e.getValue(null)).intValue();
if (0 < i && i <= visibleColumnCount) {
orderBy.eArg = (Expression) exprColumnList.get(i - 1);
orderBy.setAggregateSpec();
}
return;
}
throw Trace.error(Trace.INVALID_ORDER_BY);
}
/**
* Uses SQL standard rules to determine the types of UNION columns
*/
private void resolveUnionColumnTypes() throws HsqlException {
for (int i = 0; i < visibleColumnCount; i++) {
Type type = null;
for (int j = 0; j < unionArray.length; j++) {
Type exprType = unionArray[j].exprColumns[i].dataType;
type = Type.getAggregatedType(exprType, type);
}
for (int j = 0; j < unionArray.length; j++) {
unionArray[j].exprColumns[i].setDataType(type);
}
}
}
public void collectAllBaseColumnExpressions(OrderedHashSet set) {
for (Select select = this; select != null;
select = select.unionSelect) {
for (int i = 0; i < orderByLimitIndex; i++) {
exprColumns[i].collectAllBaseColumnExpressions(set);
}
if (queryCondition != null) {
queryCondition.collectAllBaseColumnExpressions(set);
}
}
}
void collectRangeVariables(RangeVariable[] rangeVars, Set set) {
for (int i = 0; i < orderByLimitIndex; i++) {
exprColumns[i].collectRangeVariables(rangeVars, set);
}
if (queryCondition != null) {
queryCondition.collectRangeVariables(rangeVars, set);
}
}
void markRangeVariables(RangeVariable[] rangeVars, boolean[] flags) {
for (int i = 0; i < orderByLimitIndex; i++) {
exprColumns[i].markRangeVariables(rangeVars, flags);
}
if (queryCondition != null) {
queryCondition.markRangeVariables(rangeVars, flags);
}
}
boolean hasOuterReference(RangeVariable range) {
if (unresolvedColumns == null) {
return false;
}
for (int i = 0; i < unresolvedColumns.size(); i++) {
if (((Expression) unresolvedColumns.get(i)).hasReference(range)) {
return true;
}
}
return false;
}
/**
* Sets the types of all the expressions used in this Select.
*
* @throws HsqlException
*/
void resolveTypes() throws HsqlException {
for (int i = 0; i < orderByLimitIndex; i++) {
Expression e = exprColumns[i];
e.resolveTypes(null);
if (e.exprType == Expression.ROW) {
throw Trace.error(Trace.WRONG_DATA_TYPE);
}
}
for (int i = 0, len = rangeVariables.length; i < len; i++) {
Expression e = rangeVariables[i].nonIndexJoinCondition;
if (e != null) {
e.resolveTypes(null);
}
}
if (queryCondition != null) {
Expression e = queryCondition;
e.resolveTypes(null);
}
}
void resolveColumnReferences(Expression e) throws HsqlException {
finaliseRangeVariables();
unresolvedColumns = e.resolveColumnReferences(rangeVariables,
unresolvedColumns);
}
boolean areColumnsResolved() {
return unresolvedColumns == null || unresolvedColumns.isEmpty();
}
/**
* Attempts to resolve unresolved correlated column Expressions in this
* Select and assigns any still unresolved column to the given unresolved
* Expression set. Unresolved columns for union selects have already
* been added to this.
*/
OrderedHashSet resolveCorrelatedColumns(RangeVariable[] f,
OrderedHashSet unresolvedSet) throws HsqlException {
if (unresolvedColumns == null) {
return unresolvedSet;
}
for (int i = 0; i < unresolvedColumns.size(); i++) {
Expression e = (Expression) unresolvedColumns.get(i);
unresolvedSet = e.resolveColumnReferences(f, unresolvedSet);
}
return unresolvedSet;
}
private void setRangeVariableConditions() throws HsqlException {
RangeVariableResolver rangeResolver =
new RangeVariableResolver(rangeVariables, queryCondition,
compileContext);
rangeResolver.processConditions();
rangeVariables = rangeResolver.rangeVariables;
queryCondition = null;
}
/**
* Resolves expressions and pepares the metadata for the result.
* Called externally.
*/
void resolveTypesAndPrepare() throws HsqlException {
if (isResolved) {
return;
}
if (unionArray == null) {
resolveTypes();
setRangeVariableConditions();
checkConflicts();
setResultMetaData();
} else {
for (int i = 0; i < unionArray.length; i++) {
unionArray[i].resolveTypes();
unionArray[i].setRangeVariableConditions();
}
resolveUnionColumnTypes();
for (int i = 0; i < unionArray.length; i++) {
unionArray[i].checkConflicts();
unionArray[i].setResultMetaData();
}
}
isResolved = true;
}
private void checkConflicts() throws HsqlException {
// - 1.9.0 is standard compliant but has more extended support for
// referencing columns
// - check there is no direct aggregate expression in group by
// - check each expression in select list can be
// decomposed into the expressions in group by or any aggregates
// this allows direct function of group by expressions, but
// doesn't allow indirect functions. e.g.
// select 2*abs(cola) , sum(colb) from t group by abs(cola) // ok
// select 2*(cola + 10) , sum(colb) from t group by cola + 10 // ok
// select abs(cola) , sum(colb) from t group by cola // ok
// select 2*cola + 20 , sum(colb) from t group by cola + 10 // not allowed although correct
// select cola , sum(colb) from t group by abs(cola) // not allowed because incorrect
// - group by can introduce invisible, derived columns into the query table
// - check the having expression can be decomposed into
// select list expresions plus group by expressions
// - having cannot introduce additional, derived columns
// - having cannot reference columns not in the select or group by list
// - if there is any aggregate in select list but no group by, no
// non-aggregates is allowed
// - check order by columns
// - if distinct select, order by must be composed of the select list columns
// - if grouped by, then order by should be decomposed into the
// select list plus group by list
// - references to column aliases are allowed only in order by (Standard
// compliance) and take precendence over references to non-alias
// column names.
// - references to table / correlation and column list in correlation
// names are handles according to the Standard
// fredt@users
tempSet.clear();
for (int i = 0; i < visibleColumnCount; i++) {
if (exprColumns[i].dataType == null) {
throw Trace.error(Trace.UNRESOLVED_TYPE);
}
Expression.collectAllExpressions(tempSet, exprColumns[i],
Expression.aggregateFunctionSet,
Expression.subqueryExpressionSet);
if (!tempSet.isEmpty()) {
tempSet.clear();
isAggregated = true;
break;
}
}
if (havingColumnCount != 0) {
Expression.collectAllExpressions(
tempSet, exprColumns[visibleColumnCount + groupByColumnCount],
Expression.aggregateFunctionSet,
Expression.subqueryExpressionSet);
if (!tempSet.isEmpty()) {
tempSet.clear();
isAggregated = true;
}
}
if (isGrouped) {
for (int i = visibleColumnCount;
i < visibleColumnCount + groupByColumnCount; i++) {
Expression.collectAllExpressions(
tempSet, exprColumns[i], Expression.aggregateFunctionSet,
Expression.subqueryExpressionSet);
if (!tempSet.isEmpty()) {
throw Trace.error(Trace.INVALID_GROUP_BY,
((Expression) tempSet.get(0)).getDDL());
}
}
for (int i = 0; i < visibleColumnCount; i++) {
if (!exprColumns[i].isComposedOf(
exprColumns, visibleColumnCount,
visibleColumnCount + groupByColumnCount,
Expression.aggregateFunctionSet)) {
tempSet.add(exprColumns[i]);
}
}
if (!tempSet.isEmpty() && !resolveForGroupBy(tempSet)) {
throw Trace.error(Trace.NOT_IN_AGGREGATE_OR_GROUP_BY,
((Expression) tempSet.get(0)).getDDL());
}
} else if (isAggregated) {
for (int i = 0; i < visibleColumnCount; i++) {
Expression.collectAllExpressions(
tempSet, exprColumns[i], Expression.columnExpressionSet,
Expression.aggregateFunctionSet);
if (!tempSet.isEmpty()) {
throw Trace.error(Trace.NOT_IN_AGGREGATE_OR_GROUP_BY,
((Expression) tempSet.get(0)).getDDL());
}
}
}
if (havingColumnCount != 0) {
if (unresolvedColumns != null) {
tempSet.addAll(unresolvedColumns);
}
for (int i = 0; i < visibleColumnCount + groupByColumnCount; i++) {
tempSet.add(exprColumns[i]);
}
if (!exprColumns[visibleColumnCount + groupByColumnCount]
.isComposedOf(tempSet, Expression.aggregateFunctionSet)) {
int error = isAggregated || isGrouped
? Trace.NOT_IN_AGGREGATE_OR_GROUP_BY
: Trace.INVALID_HAVING;
throw Trace
.error(error,
exprColumns[visibleColumnCount + groupByColumnCount]
.getDDL());
}
tempSet.clear();
}
if (isDistinctSelect || unionSelect != null) {
for (int i = orderByStart; i < orderByLimitIndex; i++) {
if (exprColumns[i].queryTableColumnIndex != -1) {
continue;
}
if (!exprColumns[i].isComposedOf(
exprColumns, 0, visibleColumnCount,
Expression.emptyExpressionSet)) {
int error = Trace.INVALID_ORDER_BY_IN_DISTINCT_SELECT;
throw Trace.error(error, exprColumns[i].getDDL());
}
}
} else if (isGrouped) {
for (int i = orderByStart; i < orderByLimitIndex; i++) {
if (exprColumns[i].queryTableColumnIndex != -1) {
continue;
}
if (!exprColumns[i].isComposedOf(
exprColumns, 0,
visibleColumnCount + groupByColumnCount,
Expression.emptyExpressionSet)) {
int error = Trace.INVALID_ORDER_BY;
throw Trace.error(error, exprColumns[i].getDDL());
}
}
}
prepareSort();
simpleLimit = (isDistinctSelect == false && isGrouped == false
&& unionSelect == null && orderByColumnCount == 0);
}
boolean resolveForGroupBy(OrderedHashSet unresolvedSet) {
for (int i = visibleColumnCount;
i < visibleColumnCount + groupByColumnCount; i++) {
Expression e = exprColumns[i];
if (e.exprType == Expression.COLUMN) {
RangeVariable range = e.getRangeVariable();
int colIndex = e.getColumnIndex();
range.columnsInGroupBy[colIndex] = true;
}
}
for (int i = 0; i < rangeVariables.length; i++) {
RangeVariable range = rangeVariables[i];
range.hasKeyedColumnInGroupBy =
range.rangeTable.hasUniqueNotNullIndexForColumns(
range.columnsInGroupBy);
}
OrderedHashSet set = null;
for (int i = 0; i < unresolvedSet.size(); i++) {
Expression e = (Expression) unresolvedSet.get(i);
set = e.getUnkeyedColumns(set);
}
return set == null;
}
/**
* This is called only on the first Select in a UNION chain.
*/
private void prepareUnions() throws HsqlException {
int count = 0;
for (Select current = this; current != null;
current = current.unionSelect, count++) {}
if (count == 1) {
if (unionDepth != 0) {
throw Trace.error(Trace.MISSING_CLOSEBRACKET);
}
return;
}
unionArray = new Select[count];
count = 0;
for (Select current = this; current != null;
current = current.unionSelect, count++) {
unionArray[count] = current;
unionMaxDepth = current.unionDepth > unionMaxDepth
? current.unionDepth
: unionMaxDepth;
if (current != this && current.unresolvedColumns != null) {
unresolvedColumns.addAll(current.unresolvedColumns);
}
}
if (unionArray[unionArray.length - 1].unionDepth != 0) {
throw Trace.error(Trace.MISSING_CLOSEBRACKET);
}
}
private void setResultMetaData() throws HsqlException {
resultMetaData = ResultMetaData.newResultMetaData(orderByLimitIndex);
for (int i = 0; i < orderByLimitIndex; i++) {
Expression e = exprColumns[i];
resultMetaData.colTypes[i] = e.getDataType();
if (i < visibleColumnCount) {
String colname = e.getAlias();
if (colname == null || colname.length() == 0) {
colname = HsqlNameManager.getAutoColumnNameString(i);
e.setAlias(colname, false);
}
resultMetaData.colLabels[i] = e.getAlias();
resultMetaData.isLabelQuoted[i] = e.isAliasQuoted();
resultMetaData.schemaNames[i] = e.getTableSchemaName();
resultMetaData.tableNames[i] = e.getTableName();
resultMetaData.colNames[i] = e.getColumnName();
if (resultMetaData.isTableColumn(i)) {
resultMetaData.colNullable[i] = e.nullability;
resultMetaData.isIdentity[i] = e.isIdentity;
resultMetaData.isWritable[i] = e.isWritable;
}
resultMetaData.classNames[i] = e.getValueClassName();
}
}
}
private int getLimitStart(Session session) throws HsqlException {
if (limitCondition != null) {
Integer limit =
(Integer) limitCondition.getArg().getValue(session);
if (limit != null) {
return limit.intValue();
}
}
return 0;
}
/**
* For SELECT LIMIT n m ....
* finds cases where the result does not have to be fully built and
* returns an adjusted rowCount with LIMIT params.
*/
private int getLimitCount(Session session,
int rowCount) throws HsqlException {
int limitCount = 0;
if (limitCondition != null) {
Integer limit =
(Integer) limitCondition.getArg2().getValue(session);
if (limit != null) {
limitCount = limit.intValue();
}
}
if (rowCount != 0 && (limitCount == 0 || rowCount < limitCount)) {
limitCount = rowCount;
}
return limitCount;
}
/**
* translate the rowCount into total number of rows needed from query,
* including any rows skipped at the beginning
*/
private int getMaxRowCount(Session session,
int rowCount) throws HsqlException {
int limitStart = getLimitStart(session);
int limitCount = getLimitCount(session, rowCount);
if (!simpleLimit) {
rowCount = Integer.MAX_VALUE;
} else {
if (rowCount == 0) {
rowCount = limitCount;
}
if (rowCount == 0 || rowCount > Integer.MAX_VALUE - limitStart) {
rowCount = Integer.MAX_VALUE;
} else {
rowCount += limitStart;
}
}
return rowCount;
}
private void prepareSort() {
if (orderByColumnCount == 0) {
return;
}
sortOrder = new int[orderByColumnCount];
sortDirection = new int[orderByColumnCount];
for (int i = orderByStart, j = 0; i < orderByLimitIndex; i++, j++) {
int colindex = i;
if (exprColumns[i].eArg.queryTableColumnIndex != -1) {
colindex = exprColumns[i].eArg.queryTableColumnIndex;
}
sortOrder[j] = colindex;
sortDirection[j] = exprColumns[i].isDescending() ? -1
: 1;
}
}
/**
* Returns a single value result or throws if the result has more than
* one row with one value.
*
* @param session context
* @return the single valued result
* @throws HsqlException
*/
Object getValue(Session session) throws HsqlException {
Result r = getResult(session, 2); // 2 records are required for test
int size = r.getNavigator().getSize();
int len = r.getColumnCount();
if (size == 0) {
return null;
} else if (size == 1) {
r.initialiseNavigator();
Object o = r.getSingleRowData()[0];
return o;
} else {
throw Trace.error(Trace.CARDINALITY_VIOLATION_NO_SUBCLASS);
}
}
/**
* Returns a single row value result or throws if the result has more than
* one row.
*
* @param session context
* @return the single row result
* @throws HsqlException
*/
Object[] getValues(Session session) throws HsqlException {
Result r = getResult(session, 2); // 2 records are required for test
int size = r.getNavigator().getSize();
if (size == 0) {
return new Object[visibleColumnCount];
} else if (size == 1) {
return r.getSingleRowData();
} else {
throw Trace.error(Trace.CARDINALITY_VIOLATION_NO_SUBCLASS);
}
}
/**
* Returns the result of executing this Select.
*
* @param maxrows may be 0 to indicate no limit on the number of rows.
* Positive values limit the size of the result set.
* @return the result of executing this Select
* @throws HsqlException if a database access error occurs
*/
Result getResult(Session session, int maxrows) throws HsqlException {
Result r;
if (unionArray == null) {
r = getSingleResult(session, maxrows);
} else {
r = getResultMain(session, maxrows);
}
// fredt - now there is no need for the sort and group columns
r.setColumnCount(visibleColumnCount);
r.getNavigator().reset();
return r;
}
private Result getResultMain(Session session,
int rowCount) throws HsqlException {
Result[] unionResults = new Result[unionArray.length];
for (int i = 0; i < unionArray.length; i++) {
unionResults[i] = unionArray[i].getSingleResult(session,
Integer.MAX_VALUE);
}
for (int depth = unionMaxDepth; depth >= 0; depth--) {
for (int pass = 0; pass < 2; pass++) {
for (int i = 0; i < unionArray.length - 1; i++) {
if (unionResults[i] != null
&& unionArray[i].unionDepth >= depth) {
if (pass == 0
&& unionArray[i].unionType
!= Select.INTERSECT) {
continue;
}
if (pass == 1
&& unionArray[i].unionType
== Select.INTERSECT) {
continue;
}
int nextIndex = i + 1;
for (; nextIndex < unionArray.length; nextIndex++) {
if (unionResults[nextIndex] != null) {
break;
}
}
if (nextIndex == unionArray.length) {
break;
}
unionArray[i].mergeResults(session, unionResults[i],
unionResults[nextIndex]);
unionResults[nextIndex] = unionResults[i];
unionResults[i] = null;
}
}
}
}
Result result = unionResults[unionResults.length - 1];
if (sortUnion) {
DataRowSetNavigator nav =
(DataRowSetNavigator) result.getNavigator();
nav.sortOrder();
nav.trim(getLimitStart(session), getLimitCount(session, rowCount));
}
return result;
}
/**
* Merges the second result into the first using the unionMode
* set operation.
*/
private void mergeResults(Session session, Result first,
Result second) throws HsqlException {
DataRowSetNavigator navigator =
(DataRowSetNavigator) first.initialiseNavigator();
switch (unionType) {
case UNION :
navigator.union((DataRowSetNavigator) second.getNavigator());
break;
case UNIONALL :
navigator.unionAll(
(DataRowSetNavigator) second.getNavigator());
break;
case INTERSECT :
navigator.intersect(
(DataRowSetNavigator) second.getNavigator());
break;
case EXCEPT :
navigator.except((DataRowSetNavigator) second.getNavigator());
break;
}
}
private Result getSingleResult(Session session,
int rowCount) throws HsqlException {
Result r = buildResult(session, getMaxRowCount(session, rowCount));
DataRowSetNavigator nav = (DataRowSetNavigator) r.getNavigator();
if (isDistinctSelect) {
nav.removeDuplicates();
}
if (!sortUnion) {
nav.sortOrder();
nav.trim(getLimitStart(session), getLimitCount(session, rowCount));
}
return r;
}
private Result buildResult(Session session,
int limitcount) throws HsqlException {
int fullJoinIndex = 0;
GroupedResult gResult = new GroupedResult(session, this);
RangeIterator[] rangeIterators =
new RangeIterator[rangeVariables.length];
for (int i = 0; i < rangeVariables.length; i++) {
rangeIterators[i] = rangeVariables[i].getIterator(session);
}
for (int currentIndex = 0; ; ) {
if (currentIndex < fullJoinIndex) {
boolean end = true;
for (int i = fullJoinIndex + 1; i < rangeVariables.length;
i++) {
if (rangeVariables[i].isRightJoin) {
rangeIterators[i] = rangeVariables[i].getFullIterator(
session, rangeIterators[i]);
fullJoinIndex = i;
currentIndex = i;
end = false;
break;
}
}
if (end) {
break;
}
}
RangeIterator it = rangeIterators[currentIndex];
if (it.next()) {
if (currentIndex < rangeVariables.length - 1) {
currentIndex++;
continue;
}
} else {
it.reset();
currentIndex--;
continue;
}
Object[] row = new Object[exprColumns.length];
// gets the group by column values first.
for (int i = gResult.groupBegin; i < gResult.groupEnd; i++) {
row[i] = exprColumns[i].getValue(session);
}
row = gResult.getRow(row);
// Get all other values
for (int i = 0; i < gResult.groupBegin; i++) {
row[i] = isAggregated && exprColumns[i].isAggregate()
? exprColumns[i].updateAggregatingValue(session,
row[i])
: exprColumns[i].getValue(session);
}
for (int i = gResult.groupEnd; i < orderByLimitIndex; i++) {
row[i] = isAggregated && exprColumns[i].isAggregate()
? exprColumns[i].updateAggregatingValue(session,
row[i])
: exprColumns[i].getValue(session);
}
/*
// new aggregates
Object[] row = new Object[len + aggregates.length];
// gets the group by column values first.
for (int i = gResult.groupBegin; i < gResult.groupEnd; i++) {
row[i] = exprColumns[i].getValue(session);
}
row = gResult.getRow(row);
// Get all other values
for (int i = 0; i < gResult.groupBegin; i++) {
row[i] = isAggregated && exprColumns[i].isAggregate()
? row[i]
: exprColumns[i].getValue(session);
}
for (int i = gResult.groupEnd; i < len; i++) {
row[i] = isAggregated && exprColumns[i].isAggregate()
? row[i]
: exprColumns[i].getValue(session);
}
for (int i = 0; i < aggregates.length; i++) {
if (isAggregated && aggregates[i].isAggregate()) {
row[iPostOrderIndex + i] = aggregates[i].updateAggregatingValue(session,
row[iPostOrderIndex + i]);
} else {
throw Trace.runtimeError(
Trace.UNSUPPORTED_INTERNAL_OPERATION, "Select");
}
}
// end new aggregates
*/
gResult.addRow(row);
if (gResult.size() >= limitcount) {
break;
}
}
if (isAggregated && !isGrouped && gResult.size() == 0) {
Object[] row = new Object[exprColumns.length];
for (int i = 0; i < exprColumns.length; i++) {
row[i] = exprColumns[i].isAggregate() ? null
: exprColumns[i]
.getValue(session);
}
gResult.addRow(row);
}
Result result = gResult.getResult();
RowSetNavigator nav = result.getNavigator();
nav.reset();
if (havingColumnCount > 0) {
while (nav.hasNext()) {
Object[] row = (Object[]) nav.getNext();
if (!Boolean.TRUE.equals(
row[visibleColumnCount + groupByColumnCount])) {
nav.remove();
}
}
}
nav.reset();
return result;
}
/**
* Skeleton under development. Needs a lot of work.
*/
public StringBuffer getDDL() throws HsqlException {
StringBuffer sb = new StringBuffer();
sb.append(Token.T_SELECT).append(' ');
//limitStart;
//limitCount;
for (int i = 0; i < visibleColumnCount; i++) {
sb.append(exprColumns[i].getDDL());
if (i < visibleColumnCount - 1) {
sb.append(',');
}
}
sb.append(Token.T_FROM);
for (int i = 0; i < rangeVariables.length; i++) {
RangeVariable rangeVar = rangeVariables[i];
if (i != 0) {
if (rangeVar.isLeftJoin || rangeVariables[i].isRightJoin) {
sb.append(Token.T_OUTER).append(' ');
sb.append(Token.T_JOIN).append(' ');
}
// todo rangeVar conditions
}
// otherwise use a comma delimited table list
sb.append(',');
}
// if has GROUP BY
sb.append(' ').append(Token.T_GROUP).append(' ');
for (int i = visibleColumnCount;
i < visibleColumnCount + groupByColumnCount; i++) {
sb.append(exprColumns[i].getDDL());
if (i < visibleColumnCount + groupByColumnCount - 1) {
sb.append(',');
}
}
// if has HAVING
sb.append(' ').append(Token.T_HAVING).append(' ');
for (int i = visibleColumnCount + groupByColumnCount; i < orderByStart;
i++) {
sb.append(exprColumns[i].getDDL());
if (i < orderByStart - 1) {
sb.append(',');
}
}
if (unionSelect != null) {
switch (unionType) {
case EXCEPT :
sb.append(' ').append(Token.T_EXCEPT).append(' ');
break;
case INTERSECT :
sb.append(' ').append(Token.T_INTERSECT).append(' ');
break;
case UNION :
sb.append(' ').append(Token.T_UNION).append(' ');
break;
case UNIONALL :
sb.append(' ').append(Token.T_UNION).append(' ').append(
Token.T_ALL).append(' ');
break;
}
}
// if has ORDER BY
int groupByEnd = visibleColumnCount + groupByColumnCount;
int orderByStart = groupByEnd + havingColumnCount;
int orderByEnd = orderByStart + orderByColumnCount;
sb.append(' ').append(Token.T_ORDER).append(Token.T_BY).append(' ');
for (int i = orderByStart; i < orderByEnd; i++) {
sb.append(exprColumns[i].getDDL());
if (i < visibleColumnCount + groupByColumnCount - 1) {
sb.append(',');
}
}
return sb;
}
public ResultMetaData getMetaData() {
return resultMetaData;
}
public String describe(Session session) {
StringBuffer sb;
String temp;
/*
// temporary : it is currently unclear whether this may affect
// later attempts to retrieve an actual result (calls getResult(1)
// in preProcess mode). Thus, toString() probably should not be called
// on Select objects that will actually be used to retrieve results,
// only on Select objects used by EXPLAIN PLAN FOR
try {
getResult(session, 1);
} catch (HsqlException e) {}
*/
sb = new StringBuffer();
sb.append(super.toString()).append("[\n");
if (intoTableName != null) {
sb.append("into table=[").append(intoTableName.name).append("]\n");
}
if (limitCondition != null) {
sb.append("offset=[").append(
limitCondition.getArg().describe(session)).append("]\n");
sb.append("limit=[").append(
limitCondition.getArg2().describe(session)).append("]\n");
}
sb.append("isDistinctSelect=[").append(isDistinctSelect).append("]\n");
sb.append("isGrouped=[").append(isGrouped).append("]\n");
sb.append("isAggregated=[").append(isAggregated).append("]\n");
sb.append("columns=[");
int columns = visibleColumnCount + groupByColumnCount
+ havingColumnCount;
for (int i = 0; i < columns; i++) {
sb.append(exprColumns[i].describe(session));
}
sb.append("\n]\n");
sb.append("range variables=[\n");
for (int i = 0; i < rangeVariables.length; i++) {
sb.append("[\n");
sb.append(rangeVariables[i].describe(session));
sb.append("\n]");
}
sb.append("]\n");
temp = queryCondition == null ? "null"
: queryCondition.describe(session);
sb.append("queryCondition=[").append(temp).append("]\n");
temp = havingCondition == null ? "null"
: havingCondition.describe(session);
sb.append("havingCondition=[").append(temp).append("]\n");
sb.append("groupColumns=[").append(groupColumnNames).append("]\n");
if (unionSelect != null) {
switch (unionType) {
case EXCEPT :
sb.append(" EXCEPT ");
break;
case INTERSECT :
sb.append(" INTERSECT ");
break;
case UNION :
sb.append(" UNION ");
break;
case UNIONALL :
sb.append(" UNION ALL ");
break;
default :
sb.append(" UNKNOWN SET OPERATION ");
}
sb.append("[\n").append(unionSelect.describe(session)).append(
"]\n");
}
return sb.toString();
}
}
The table below shows all metrics for Select.java.
| Metric | Value | Description | |
|---|---|---|---|
| BLOCKS | 208.00 | Number of blocks | |
| BLOCK_COMMENT | 116.00 | Number of block comment lines | |
| COMMENTS | 246.00 | Comment lines | |
| COMMENT_DENSITY | 0.35 | Comment density | |
| COMPARISONS | 173.00 | Number of comparison operators | |
| CYCLOMATIC | 245.00 | Cyclomatic complexity | |
| DECL_COMMENTS | 21.00 | Comments in declarations | |
| DOC_COMMENT | 80.00 | Number of javadoc comment lines | |
| ELOC | 711.00 | Effective lines of code | |
| EXEC_COMMENTS | 17.00 | Comments in executable code | |
| EXITS | 114.00 | Procedure exits | |
| FUNCTIONS | 48.00 | Number of function declarations | |
| HALSTEAD_DIFFICULTY | 120.17 | Halstead difficulty | |
| HALSTEAD_EFFORT | 0.00 | Halstead effort | |
| INTERFACE_COMPLEXITY | 188.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 | 0.00 | JAVA0005 Imports not in specified order | |
| JAVA0006 | 0.00 | JAVA0006 Empty finally block | |
| JAVA0007 | 10.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 | 1.00 | JAVA0029 Private method not used | |
| JAVA0030 | 0.00 | JAVA0030 Private field not used | |
| JAVA0031 | 1.00 | JAVA0031 Case statement not properly closed | |
| JAVA0032 | 2.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 | 4.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 | 2.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 | 0.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 | 0.00 | JAVA0079 Use of instance to reference static member | |
| JAVA0080 | 1.00 | JAVA0080 Import declaration not used | |
| JAVA0081 | 2.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 | 1.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 | 10.00 | JAVA0108 Incorrect javadoc: no @param tag for 'parameter' | |
| JAVA0109 | 0.00 | JAVA0109 Incorrect javadoc: no parameter 'parameter' | |
| JAVA0110 | 4.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 | 8.00 | JAVA0115 Incorrect javadoc: no @throws or @exception tag for 'exception' | |
| JAVA0116 | 15.00 | JAVA0116 Missing javadoc: field 'field' | |
| JAVA0117 | 5.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 | 2.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 | 0.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 | 0.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 | 4.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 | 0.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 | 2.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 | 3.00 | JAVA0177 Variable declaration missing initializer | |
| JAVA0179 | 1.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 | 0.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 | 0.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 | 0.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 | 7.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 | 1482.00 | Number of lines in the source file | |
| LINE_COMMENT | 50.00 | Number of line comments | |
| LOC | 910.00 | Lines of code | |
| LOGICAL_LINES | 504.00 | Number of statements | |
| LOOPS | 56.00 | Number of loops | |
| NEST_DEPTH | 7.00 | Maximum nesting depth | |
| OPERANDS | 2123.00 | Number of operands | |
| OPERATORS | 3961.00 | Number of operators | |
| PARAMS | 44.00 | Number of formal parameter declarations | |
| PROGRAM_LENGTH | 6084.00 | Halstead program length | |
| PROGRAM_VOCAB | 531.00 | Halstead program vocabulary | |
| PROGRAM_VOLUME | 0.00 | Halstead program volume | |
| RETURNS | 144.00 | Number of return points from functions | |
| SIZE | 48377.00 | Size of the file in bytes | |
| UNIQUE_OPERANDS | 477.00 | Number of unique operands | |
| UNIQUE_OPERATORS | 54.00 | Number of unique operators | |
| WHITESPACE | 326.00 | Number of whitespace lines | |