Package com.foundationdb.ais.model

Examples of com.foundationdb.ais.model.TableIndex

1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
        List<TableIndex> indexes = new ArrayList<>();
        for(TableIndex index : oldTable.getIndexesIncludingInternal()) {
            String oldName = index.getIndexName().getName();
            String preserveName = desc.getPreserveIndexes().get(oldName);
            if(preserveName == null) {
                TableIndex newIndex = newTable.getIndexIncludingInternal(oldName);
                if(newIndex != null) {
                    indexes.add(newIndex);
                }
            }
        }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
            if (join.getParent().getPrimaryKey() == null) {
                output.reportFailure(new AISValidationFailure(
                        new JoinParentNoExplicitPK (join.getParent().getName())));
                continue;
            }
            TableIndex parentPK= join.getParent().getPrimaryKey().getIndex();
            if (parentPK.getKeyColumns().size() != join.getJoinColumns().size()) {
                output.reportFailure(new AISValidationFailure(
                        new JoinColumnMismatchException (join.getJoinColumns().size(),
                                join.getChild().getName(),
                                join.getParent().getName(),
                                parentPK.getKeyColumns().size())));

                continue;
            }
            Iterator<JoinColumn>  joinColumns = join.getJoinColumns().iterator();
            for (IndexColumn parentPKColumn : parentPK.getKeyColumns()) {
                JoinColumn joinColumn = joinColumns.next();
                if (parentPKColumn.getColumn() != joinColumn.getParent()) {
                    output.reportFailure(new AISValidationFailure (
                            new JoinToWrongColumnsException (
                                    join.getChild().getName(),
                                    joinColumn.getParent().getName(),
                                    parentPK.getTable().getName(), parentPKColumn.getColumn().getName())));
                }
            }
        }
    }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
            if(index.containsTableColumn(tableName, oldColName)) {
                tableCopy.removeIndexes(Collections.singleton(index));
                if (index.getConstraintName() != null) {
                    aisCopy.removeConstraint(index.getConstraintName());
                }
                TableIndex indexCopy = TableIndex.create(tableCopy, index);
                for(IndexColumn iCol : index.getKeyColumns()) {
                    IndexColumn.create(indexCopy, (iCol.getColumn() == oldColumn) ? newColumn : iCol.getColumn(), iCol, iCol.getPosition());
                }
            }
        }
View Full Code Here
704
705
706
707
708
709
710
711
712
713
714
                throw new NoSuchColumnException(referencedColumnNames[i]);
            }
            referencedColumns.add(referencedColumn);
        }
        // Pick an index.
        TableIndex referencedIndex = ForeignKey.findReferencedIndex(referencedTable,
                                                                    referencedColumns);
        if (referencedIndex == null) {
            throw new ForeignKeyIndexRequiredException(constraintName, referencedName,
                                                       Arrays.toString(referencedColumnNames));
        }
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
209
210
211
            key.getReferencedIndex().isPrimaryKey()) {

            // Check the child table FK columns are the child table PK as well.
            // TODO: We may be able to relax this with further testing.
            List<Column> fkColumns = key.getReferencingColumns();
            TableIndex childPKIndex = key.getReferencingTable().getIndex(Index.PRIMARY);
            // this can occur if the child table has no declared primary key.
            if (childPKIndex == null) { return false; }
            List<IndexColumn> pkColumns = childPKIndex.getKeyColumns();
            if (fkColumns.size() != pkColumns.size()) return false;
            for (int i = 0; i < fkColumns.size(); i++) {
                if (!fkColumns.get(i).equals(pkColumns.get(i).getColumn())) {
                    return false;
                }
View Full Code Here
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
        for(TableIndex origIndex : origTable.getIndexesIncludingInternal()) {
            ChangeType indexChange = findOldName(indexChanges, origIndex.getIndexName().getName());
            if(indexChange == ChangeType.DROP) {
                continue;
            }
            TableIndex indexCopy = TableIndex.create(tableCopy, origIndex);
            int pos = 0;
            for(IndexColumn indexColumn : origIndex.getKeyColumns()) {
                String newName = findNewName(columnChanges, indexColumn.getColumn().getName());
                if(newName != null) {
                    IndexColumn.create(indexCopy, tableCopy.getColumn(newName), indexColumn, pos++);
                }
            }
            // DROP and MODIFY detection for indexes handled downstream
            if(indexCopy.getKeyColumns().isEmpty()) {
                tableCopy.removeIndexes(Collections.singleton(indexCopy));
            }
        }
    }
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
        // Look for incompatible spatial changes
        for(TableIndex oldIndex : oldTable.getIndexesIncludingInternal()) {
            String oldName = oldIndex.getIndexName().getName();
            String newName = findNewName(state.tableIndexChanges, oldName);
            TableIndex newIndex = (newName != null) ? newTable.getIndexIncludingInternal(newName) : null;
            if((newIndex != null) && oldIndex.isSpatial() && !Index.isSpatialCompatible(newIndex)) {
                newTable.removeIndexes(Collections.singleton(newIndex));

                // Remove any entry that already exists (e.g. MODIFY from compareColumns())
                Iterator<TableChange> it = state.tableIndexChanges.iterator();
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
204
                if(hKeyColumnTable != table) {
                    // HKey column from row of parent table
                    if (parentStoreData == null) {
                        // Initialize parent metadata and state
                        RowDef parentRowDef = rowDef.table().getParentTable().rowDef();
                        TableIndex parentPkIndex = parentRowDef.getPKIndex();
                        indexToHKey = parentPkIndex.indexToHKey();
                        parentStoreData = createStoreData(session, parentPkIndex);
                        parentPKIndexRow = readIndexRow(session, parentPkIndex, parentStoreData, rowDef, rowData);
                        i2hPosition = hKeyColumn.positionInHKey();
                    }
                    if(indexToHKey.isOrdinal(i2hPosition)) {
View Full Code Here
242
243
244
245
246
247
248
249
250
251
252
253
254
        BitSet tablesRequiringHKeyMaintenance;
        assert oldRow.getRowDefId() == newRow.getRowDefId();
        int fields = oldRowDef.getFieldCount();
        // Find the PK and FK fields
        BitSet keyField = new BitSet(fields);
        TableIndex pkIndex = oldRowDef.getPKIndex();
        int nkeys = pkIndex.getKeyColumns().size();
        IndexRowComposition indexRowComposition = pkIndex.indexRowComposition();
        for (int i = 0; i < nkeys; i++) {
            int pkFieldPosition = indexRowComposition.getFieldPosition(i);
            keyField.set(pkFieldPosition, true);
        }
        for (int fkFieldPosition : oldRowDef.getParentJoinFields()) {
View Full Code Here
36
37
38
39
40
41
42
43
44
                row(tid, "43.5435", "156.989"),
                row(tid, "32.456", "99.543"),
                row(tid, "53.00", "80.00")
        );
        createIndex(SCHEMA, TABLE, INDEX_NAME, "z_order_lat_lon(c1, c2)");
        TableIndex index = getTable(tid).getIndex("idx1");
        assertNotNull("Found index", index);
        assertEquals("Is spatial", true, index.isSpatial());
    }
View Full Code Here
TOP

Related Classes of com.foundationdb.ais.model.TableIndex

  • com.foundationdb.ais.model.validation.JoinToParentPK
  • com.foundationdb.ais.util.TableChangeValidator
  • com.foundationdb.server.service.dxl.BasicDDLFunctions
  • com.foundationdb.server.store.AbstractStore
  • com.foundationdb.server.store.OnlineHelper
  • com.foundationdb.server.test.it.bugs.bug1047046.AlterColumnInSpatialIndexIT
  • com.foundationdb.server.test.it.dxl.AlterTableITBase
  • com.foundationdb.server.test.it.dxl.CreateIndexesIT
  • com.foundationdb.sql.aisddl.AlterTableDDL
  • com.foundationdb.sql.aisddl.IndexDDLIT
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.