Examples with Index org.h2.index.Index used on opensource projects

Example 96 with Index

use of org.h2.index.Index in project h2database by h2database.

the class RegularTable method addRowsToIndex.

private static void addRowsToIndex(Session session, ArrayList<Row> list, Index index) {
    final Index idx = index;
    Collections.sort(list, new Comparator<Row>() {

        @Override
        public int compare(Row r1, Row r2) {
            return idx.compareRows(r1, r2);
        }
    });
    for (Row row : list) {
        index.add(session, row);
    }
    list.clear();
}

Example 97 with Index

use of org.h2.index.Index in project h2database by h2database.

the class RegularTable method removeRow.

@Override
public void removeRow(Session session, Row row) {
    if (database.isMultiVersion()) {
        if (row.isDeleted()) {
            throw DbException.get(ErrorCode.CONCURRENT_UPDATE_1, getName());
        }
        int old = row.getSessionId();
        int newId = session.getId();
        if (old == 0) {
            row.setSessionId(newId);
        } else if (old != newId) {
            throw DbException.get(ErrorCode.CONCURRENT_UPDATE_1, getName());
        }
    }
    lastModificationId = database.getNextModificationDataId();
    int i = indexes.size() - 1;
    try {
        for (; i >= 0; i--) {
            Index index = indexes.get(i);
            index.remove(session, row);
            checkRowCount(session, index, -1);
        }
        rowCount--;
    } catch (Throwable e) {
        try {
            while (++i < indexes.size()) {
                Index index = indexes.get(i);
                index.add(session, row);
                checkRowCount(session, index, 0);
            }
        } catch (DbException e2) {
            // this could happen, for example on failure in the storage
            // but if that is not the case it means there is something wrong
            // with the database
            trace.error(e2, "could not undo operation");
            throw e2;
        }
        throw DbException.convert(e);
    }
    analyzeIfRequired(session);
}

Example 98 with Index

use of org.h2.index.Index in project h2database by h2database.

the class Table method getChildren.

@Override
public ArrayList<DbObject> getChildren() {
    ArrayList<DbObject> children = New.arrayList();
    ArrayList<Index> indexes = getIndexes();
    if (indexes != null) {
        children.addAll(indexes);
    }
    if (constraints != null) {
        children.addAll(constraints);
    }
    if (triggers != null) {
        children.addAll(triggers);
    }
    if (sequences != null) {
        children.addAll(sequences);
    }
    children.addAll(dependentViews);
    if (synonyms != null) {
        children.addAll(synonyms);
    }
    ArrayList<Right> rights = database.getAllRights();
    for (Right right : rights) {
        if (right.getGrantedObject() == this) {
            children.add(right);
        }
    }
    return children;
}

Example 99 with Index

use of org.h2.index.Index in project h2database by h2database.

the class JoinBatch method start.

private void start() {
    // initialize current row
    current = new JoinRow(new Object[filters.length]);
    // initialize top cursor
    Cursor cursor;
    if (batchedSubQuery) {
        assert viewTopFutureCursor != null;
        cursor = get(viewTopFutureCursor);
    } else {
        // setup usual index cursor
        TableFilter f = top.filter;
        IndexCursor indexCursor = f.getIndexCursor();
        indexCursor.find(f.getSession(), f.getIndexConditions());
        cursor = indexCursor;
    }
    current.updateRow(top.id, cursor, JoinRow.S_NULL, JoinRow.S_CURSOR);
    // we need fake first row because batchedNext always will move to the
    // next row
    JoinRow fake = new JoinRow(null);
    fake.next = current;
    current = fake;
}

Example 100 with Index

use of org.h2.index.Index in project h2database by h2database.

the class JoinBatch method createViewIndexLookupBatch.

/**
 * Create index lookup batch for a view index.
 *
 * @param viewIndex view index
 * @return index lookup batch or {@code null} if batching is not supported
 *         for this query
 */
public static IndexLookupBatch createViewIndexLookupBatch(ViewIndex viewIndex) {
    Query query = viewIndex.getQuery();
    if (query.isUnion()) {
        ViewIndexLookupBatchUnion unionBatch = new ViewIndexLookupBatchUnion(viewIndex);
        return unionBatch.initialize() ? unionBatch : null;
    }
    JoinBatch jb = ((Select) query).getJoinBatch();
    if (jb == null || jb.getLookupBatch(0) == null) {
        // our sub-query is not batched or is top batched sub-query
        return null;
    }
    assert !jb.batchedSubQuery;
    jb.batchedSubQuery = true;
    return jb.viewIndexLookupBatch(viewIndex);
}