Examples of org.apache.derby.iapi.store.access.ScanController.fetch()

Package org.apache.derby.iapi.store.access

Class org.apache.derby.iapi.store.access.ScanController

Examples of org.apache.derby.iapi.store.access.ScanController.fetch()

org.apache.derby.iapi.store.access.ScanController.fetch()
Fetch the (partial) row at the current position of the Scan. The value in the destRow storable row is replaced with the value of the row at the current scan position. The columns of the destRow row must be of the same type as the actual columns in the underlying conglomerate. The number of elements in fetch must be compatible with the number of scan columns requested at the openScan call time.
A fetch can return a sub-set of the scan columns reqested at scan open time by supplying a destRow will less elements than the number of requested columns. In this case the N leftmost of the requested columns are fetched, where N = destRow.length. In the case where all columns are rested and N = 2 then columns 0 and 1 are returned. In the case where the openScan FormatableBitSet requested columns 1, 4 and 7, then columns 1 and 4 would be fetched when N = 2.
The results of a fetch() performed on a scan after next() has returned false are undefined. A fetch() performed on a scan positioned on a deleted row will throw a StandardException with state = SQLState.AM_RECORD_NOT_FOUND. Note that this can happen even if next() has returned true (for instance the client can delete the row, or if using read uncommitted another thread can delete the row after the next() call but before the fetch). @param destRow The row into which the value of the current position in the scan is to be stored. @exception StandardException Standard exception policy. @see RowUtil

        int numrows = 0;
        while (scan.next())
        {
            numrows++;


            scan.fetch(index_row_from_base_row.getRow());


            try
            {
                scan.fetchLocation(null);
                return(FAIL("t_006: scan.fetchLocation() succeeded"));

View Full Code Here

                        null, ScanController.NA);


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(scan.next());


        scan.fetch(index_row.getRow());
        long key = ((SQLLongint)(index_row.getRow()[1])).getLong();


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(key == 3);

View Full Code Here

        base_cc.insertAndFetchLocation(base_row, row_loc);
        if (index_cc.insert(index_row.getRow()) != 0)
      throw T_Fail.testFailMsg("insert failed");


        // current position should not have changed
        scan.fetch(index_row.getRow());
        key = ((SQLLongint)(index_row.getRow()[1])).getLong();


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(key == 3);

View Full Code Here

            SanityManager.ASSERT(key == 3);


        // next position should be 5
        if (SanityManager.DEBUG)
            SanityManager.ASSERT(scan.next());
        scan.fetch(index_row.getRow());
        key = ((SQLLongint)(index_row.getRow()[1])).getLong();


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(key == 5);

View Full Code Here

                        null, ScanController.NA);


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(scan.next());


        scan.fetch(index_row.getRow());
        long key = ((SQLLongint)(index_row.getRow()[1])).getLong();


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(key == 1000);

View Full Code Here

            // About every 2nd split page, recheck the position
            
            if (i % 10 == 0)
            {
                // current position should not have changed
                scan.fetch(index_row.getRow());
                key = ((SQLLongint)(index_row.getRow()[1])).getLong();
                if (SanityManager.DEBUG)
                    SanityManager.ASSERT(key == 1000);
            }

View Full Code Here

        {
      throw T_Fail.testFailMsg("insert failed");
        }


        // current position should not have changed
        scan.fetch(index_row.getRow());
        key = ((SQLLongint)(index_row.getRow()[1])).getLong();


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(key == 1000);

View Full Code Here

            SanityManager.ASSERT(key == 1000);


        // next position should be 3000
        if (SanityManager.DEBUG)
            SanityManager.ASSERT(scan.next());
        scan.fetch(index_row.getRow());
        key = ((SQLLongint)(index_row.getRow()[1])).getLong();


        if (SanityManager.DEBUG)
            SanityManager.ASSERT(key == 3000);

View Full Code Here

    // Move to the 1st row in the heap
    heapScan.next();


    // Fetch the 1st row
    ExecRow firstRow = t_cc.getHeapRowOfNulls();
    heapScan.fetch(firstRow.getRowArray());
    heapScan.close();


    // Insert another copy of the 1st row into the heap
    ConglomerateController heapCC = t_cc.openHeapCC();
    heapCC.insert(firstRow.getRowArray());

View Full Code Here


    // Move to the 1st row in the index
    indexScan.next();


    // Fetch the 1st row
    indexScan.fetch(indexRow.getRowArray());
    indexScan.close();


    // Insert another copy of the 1st row into the index with a bad row location
    int keyLength = 
        t_cc.getIndexDescriptor().getIndexDescriptor().baseColumnPositions().length;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.