Package org.hsqldb.index

Examples of org.hsqldb.index.RowIterator

2458
2459
2460
2461
2462
2463
2464
2465
2466
2467
2468
2469
2470
2471
2472
2473
2474
2475
2476
2477
2478
2479
2480
2481
2482
2483
2484
2485
2486
2487
2488
2489
2490
2491
2492
2493
2494
2495
2496
2497
2498
2499
2500
2501
2502
2503
2504
2505
2506
2507
2508
2509
2510
2511
2512
2513
2514
2515
2516
2517
2518
2519
2520
2521
2522
2523
2524
2525
2526
2527
2528
2529
2530
2531
2532
2533
2534
2535
2536
2537
2538
2539
2540
2541
2542
2543
2544
2545
2546
2547
2548
2549
  private Boolean getAnyAllValue(Session paramSession, Object paramObject, SubQuery paramSubQuery)
    throws HsqlException
  {
    boolean bool = paramSubQuery.table.isEmpty(paramSession);
    Index localIndex = paramSubQuery.table.getPrimaryIndex();
    RowIterator localRowIterator = localIndex.findFirstRowNotNull(paramSession);
    Row localRow1 = localRowIterator.next();
    int i;
    Row localRow2;
    Object localObject1;
    Object localObject2;
    int j;
    int k;
    switch (this.eArg2.exprType)
    {
    case 33:
      if (bool)
        return Boolean.FALSE;
      if (localRow1 == null)
        return null;
      i = Column.compareToTypeRange(paramObject, this.eArg2.eArg.getDataType());
      if (i != 0)
        switch (this.exprType)
        {
        case 21:
          return Boolean.FALSE;
        case 26:
          return Boolean.TRUE;
        case 22:
        case 23:
          return i > 0 ? Boolean.TRUE : Boolean.FALSE;
        case 24:
        case 25:
          return i < 0 ? Boolean.TRUE : Boolean.FALSE;
        }
      paramObject = Column.convertObject(paramObject, this.eArg2.eArg.getDataType());
      if (this.exprType == 21)
      {
        localRowIterator = localIndex.findFirstRow(paramSession, paramObject, 21);
        return localRowIterator.hasNext() ? Boolean.TRUE : Boolean.FALSE;
      }
      localRow2 = localIndex.lastRow(paramSession);
      localObject1 = localRow1.getData()[0];
      localObject2 = localRow2.getData()[0];
      j = Column.compare(paramSession.database.collation, paramObject, localObject1, this.eArg.getDataType());
      k = Column.compare(paramSession.database.collation, paramObject, localObject2, this.eArg.getDataType());
      switch (this.exprType)
      {
      case 26:
        return (j == 0) && (k == 0) ? Boolean.FALSE : Boolean.TRUE;
      case 23:
        return j > 0 ? Boolean.TRUE : Boolean.FALSE;
      case 22:
        return j >= 0 ? Boolean.TRUE : Boolean.FALSE;
      case 24:
        return k < 0 ? Boolean.TRUE : Boolean.FALSE;
      case 25:
        return k <= 0 ? Boolean.TRUE : Boolean.FALSE;
      }
      break;
    case 32:
      if (bool)
        return Boolean.TRUE;
      if (localRow1 == null)
        return null;
      i = Column.compareToTypeRange(paramObject, this.eArg2.eArg.getDataType());
      if (i != 0)
        switch (this.exprType)
        {
        case 21:
          return Boolean.FALSE;
        case 26:
          return Boolean.TRUE;
        case 22:
        case 23:
          return i > 0 ? Boolean.TRUE : Boolean.FALSE;
        case 24:
        case 25:
          return i < 0 ? Boolean.TRUE : Boolean.FALSE;
        }
      paramObject = Column.convertObject(paramObject, this.eArg2.eArg.getDataType());
      if ((this.exprType == 21) || (this.exprType == 26))
      {
        localRowIterator = localIndex.findFirstRow(paramSession, paramObject, 21);
        if (this.exprType == 21)
          return (localRowIterator.hasNext()) && (paramSubQuery.table.getRowCount(paramSession) == 1) ? Boolean.TRUE : Boolean.FALSE;
        return localRowIterator.hasNext() ? Boolean.FALSE : Boolean.TRUE;
      }
      localRow2 = localIndex.lastRow(paramSession);
      localObject1 = localRow1.getData()[0];
      localObject2 = localRow2.getData()[0];
      paramObject = Column.convertObject(paramObject, this.eArg2.eArg.getDataType());
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
    throws HsqlException
  {
    int i = 0;
    if (paramInt3 != paramInt2)
      i = Column.compareToTypeRange(paramObject, paramInt3);
    RowIterator localRowIterator;
    if (i == 0)
    {
      paramObject = Column.convertObject(paramObject, paramInt3);
      localRowIterator = paramIndex.findFirstRow(paramSession, paramObject, paramInt1);
    }
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
    int[] arrayOfInt = paramTable.getIndexRootsArray();
    long l = this.fileOffset;
    int i = 0;
    localDoubleIntIndex.setKeysSearchTarget();
    Trace.printSystemOut("lookup begins: " + this.stopw.elapsedTime());
    RowIterator localRowIterator = paramTable.rowIterator(localSession);
    Row localRow;
    while (localRowIterator.hasNext())
    {
      localRow = localRowIterator.next();
      localDoubleIntIndex.addUnsorted(localRow.getPos(), (int)(l / this.scale));
      if (i % 50000 == 0)
        Trace.printSystemOut("pointer pair for row " + i + " " + localRow.getPos() + " " + l);
      l += localRow.getStorageSize();
      i++;
    }
    Trace.printSystemOut(paramTable.getName().name + " list done ", this.stopw.elapsedTime());
    i = 0;
    localRowIterator = paramTable.rowIterator(localSession);
    while (localRowIterator.hasNext())
    {
      localRow = localRowIterator.next();
      localRowOutputBinary.reset();
      localRow.write(localRowOutputBinary, localDoubleIntIndex);
      this.fileStreamOut.write(localRowOutputBinary.getOutputStream().getBuffer(), 0, localRowOutputBinary.size());
      this.fileOffset += localRow.getStorageSize();
      if (i % 50000 == 0)
View Full Code Here
390
391
392
393
394
395
396
397
398
399
400
401
402
  void checkConvertColDataType(Column paramColumn1, Column paramColumn2)
    throws HsqlException
  {
    int i = this.table.getColumnNr(paramColumn1.columnName.name);
    RowIterator localRowIterator = this.table.getPrimaryIndex().firstRow(this.session);
    while (localRowIterator.hasNext())
    {
      Row localRow = localRowIterator.next();
      Object localObject = localRow.getData()[i];
      Column.convertObject(this.session, localObject, paramColumn2.getType(), paramColumn2.getSize(), paramColumn2.getScale());
    }
  }
View Full Code Here
411
412
413
414
415
416
417
418
419
420
421
422
423
424
        throw Trace.error(10);
      this.table.checkColumnInFKConstraint(i, 2);
    }
    else
    {
      RowIterator localRowIterator = this.table.getPrimaryIndex().firstRow(this.session);
      while (localRowIterator.hasNext())
      {
        Row localRow = localRowIterator.next();
        Object localObject = localRow.getData()[i];
        if (localObject != null)
          continue;
        throw Trace.error(10);
      }
View Full Code Here
286
287
288
289
290
291
292
293
294
295
296
297
298
299
  }

  static void checkReferencedRows(Session paramSession, Table paramTable, int[] paramArrayOfInt, Index paramIndex)
    throws HsqlException
  {
    RowIterator localRowIterator = paramTable.getPrimaryIndex().firstRow(paramSession);
    while (true)
    {
      Row localRow = localRowIterator.next();
      if (localRow == null)
        break;
      Object[] arrayOfObject = localRow.getData();
      if (hasReferencedRow(paramSession, arrayOfObject, paramArrayOfInt, paramIndex))
        continue;
View Full Code Here
TOP

Related Classes of org.hsqldb.index.RowIterator

  • org.hsqldb.Constraint
  • org.hsqldb.Expression
  • org.hsqldb.Index
  • org.hsqldb.persist.DataFileDefrag
  • org.hsqldb.scriptio.ScriptWriterBase
  • org.hsqldb.Table
  • org.hsqldb.TableFilter
  • org.hsqldb.TableWorks
    • 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.