Examples of org.hsqldb.index.Index

org.hsqldb.index.Index
@author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0

            if (primaryTableIndex == null) {
                return;
            }
        }


        Index rangeIndex = select.rangeVariables[0].getSortIndex();


        if (rangeIndex == null) {


            // multi-index
            return;

View Full Code Here

        if (((ExpressionColumn) e).getRangeVariable()
                != select.rangeVariables[0]) {
            return false;
        }


        Index rangeIndex = select.rangeVariables[0].getSortIndex();


        if (rangeIndex == null) {
            return false;
        }


        if (select.rangeVariables[0].hasSingleIndexCondition()) {
            int[] colIndexes = rangeIndex.getColumns();


            if (colIndexes[0] != ((ExpressionColumn) e).getColumnIndex()) {
                return false;
            }


            if (opType == OpTypes.MAX) {
                select.rangeVariables[0].reverseOrder();
            }
        } else if (select.rangeVariables[0].hasAnyIndexCondition()) {
            return false;
        } else {
            Table table = select.rangeVariables[0].getTable();
            Index index = table.getIndexForColumn(
                session, ((ExpressionColumn) e).getColumnIndex());


            if (index == null) {
                return false;
            }

View Full Code Here

    }


    public Index getNewIndex(Session session, TableBase table) {


        if (hasOrder()) {
            Index orderIndex = table.createAndAddIndexStructure(session, null,
                sortOrder, sortDescending, sortNullsLast, false, false, false);


            if (collations != null) {
                for (int i = 0; i < columnCount; i++) {
                    if (collations[i] != null) {
                        Type type = orderIndex.getColumnTypes()[i];


                        type = Type.getType(type.typeCode,
                                            type.getCharacterSet(),
                                            collations[i], type.precision,
                                            type.scale);
                        orderIndex.getColumnTypes()[i] = type;
                    }
                }
            }


            return orderIndex;

View Full Code Here

        if (!check) {
            return;
        }


        if (!range.hasAnyIndexCondition()) {
            Index index = range.rangeTable.getIndexForColumns(colMap);


            if (index != null) {
                range.setSortIndex(index, false);
            }
        }

View Full Code Here

        }
    }


    public final RowIterator rowIterator() {


        Index index = indexList[0];


        for (int i = 0; i < indexList.length; i++) {
            if (indexList[i].isClustered()) {
                index = indexList[i];


                break;
            }
        }


        return index.firstRow(this);
    }

View Full Code Here

        return index.firstRow(this);
    }


    public void setAccessor(Index key, CachedObject accessor) {


        Index index = (Index) key;


        accessorList[index.getPosition()] = accessor;
    }

View Full Code Here

        return searchCost[index.getPosition()][count - 1];
    }


    public long elementCount() {


        Index index = this.indexList[0];


        if (elementCount.get() < 0) {
            elementCount.set(index.getNodeCount(null, this));
        }


        return elementCount.get();
    }

View Full Code Here

        return elementCount.get();
    }


    public long elementCount(Session session) {


        Index index = this.indexList[0];


        if (elementCount.get() < 0) {
            elementCount.set(index.getNodeCount(session, this));
        }


        if (session != null) {
            int txControl = session.database.txManager.getTransactionControl();


            if (txControl != TransactionManager.LOCKS) {
                switch (table.getTableType()) {


                    case TableBase.MEMORY_TABLE :
                    case TableBase.CACHED_TABLE :
                    case TableBase.TEXT_TABLE :
                        return index.getNodeCount(session, this);


                    default :
                }
            }
        }

View Full Code Here

                    return compileRenameObject(name, SchemaObject.INDEX);
                }


                readThis(Tokens.AS);


                Index index =
                    (Index) database.schemaManager.getSchemaObject(name);


                if (index == null) {
                    throw Error.error(ErrorCode.X_42501);
                }


                Table table = (Table) database.schemaManager.getSchemaObject(
                    index.getName().parent);
                int[]      indexColumns   = readColumnList(table, true);
                String     sql            = getLastPart();
                Object[]   args           = new Object[] {
                    table, indexColumns, index.getName()
                };
                HsqlName[] writeLockNames = new HsqlName[] {
                    database.getCatalogName(), table.getName()
                };

View Full Code Here

                    // create an autonamed index
                    indexName = session.database.nameManager.newAutoName("IDX",
                            c.getName().name, table.getSchemaName(),
                            table.getName(), SchemaObject.INDEX);


                    Index index = table.createAndAddIndexStructure(session,
                        indexName, c.core.mainCols, null, null, true, true,
                        false);
                    Constraint newconstraint = new Constraint(c.getName(),
                        table, index, SchemaObject.ConstraintTypes.UNIQUE);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.index.Index

org.hsqldb.Constraint

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.ExpressionLogical

org.hsqldb.ParserDDL

org.hsqldb.persist.RowStoreAVL

org.hsqldb.persist.RowStoreAVLDisk

org.hsqldb.persist.RowStoreAVLHybrid

org.hsqldb.persist.RowStoreAVLMemory

org.hsqldb.QuerySpecification

org.hsqldb.RangeVariable

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.