.from("foo") .where(in("a", 2, 4)) .perPartitionLimit(2) .limit(3) .toString()) .from("foo") .where(eq("a", bindMarker())) .perPartitionLimit(bindMarker()) .limit(3) .toString())
/** * Generate a SELECT ... FROM ... WHERE ... <strong>PER PARTITION LIMIT :perPartitionLimit</strong> */ public final EntityWithSASIIndices_Select.E_TM perPartitionLimit(final Integer perPartitionLimit) { where.perPartitionLimit(QueryBuilder.bindMarker("perPartitionLimit")); boundValues.add(perPartitionLimit); encodedValues.add(perPartitionLimit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>PER PARTITION LIMIT :perPartitionLimit</strong> */ public final EntityWithSASIIndices_Select.E_J perPartitionLimit(final Integer perPartitionLimit) { where.perPartitionLimit(QueryBuilder.bindMarker("perPartitionLimit")); boundValues.add(perPartitionLimit); encodedValues.add(perPartitionLimit); return this; }
.execute(select().all().from("test_ppl").where(in("a", 2, 3)).perPartitionLimit(2))) .contains(row(2, 0, 0), row(2, 1, 1), row(3, 0, 0), row(3, 1, 1)); assertThat( .from("test_ppl") .where(in("a", 2, 3)) .perPartitionLimit(bindMarker()) .limit(3) .getQueryString(), .from("test_ppl") .where(in("a", 1, 2, 3)) .perPartitionLimit(bindMarker()) .limit(3) .getQueryString(), .from("test_ppl") .where(eq("a", bindMarker())) .perPartitionLimit(bindMarker()) .getQueryString(), 2, .where(eq("a", bindMarker())) .and(gt("b", bindMarker())) .perPartitionLimit(bindMarker()) .allowFiltering() .getQueryString(),
.from("foo") .where(in("a", 2, 4)) .perPartitionLimit(2) .limit(3) .toString()) .from("foo") .where(eq("a", bindMarker())) .perPartitionLimit(bindMarker()) .limit(3) .toString())
/** * Generate a SELECT ... FROM ... WHERE ... <strong>PER PARTITION LIMIT :perPartitionLimit</strong> */ public final EntityWithSASIIndices_Select.E perPartitionLimit(final Integer perPartitionLimit) { where.perPartitionLimit(QueryBuilder.bindMarker("perPartitionLimit")); boundValues.add(perPartitionLimit); encodedValues.add(perPartitionLimit); return this; }
.execute(select().all().from("test_ppl").where(in("a", 2, 3)).perPartitionLimit(2))) .contains(row(2, 0, 0), row(2, 1, 1), row(3, 0, 0), row(3, 1, 1)); assertThat( .from("test_ppl") .where(in("a", 2, 3)) .perPartitionLimit(bindMarker()) .limit(3) .getQueryString(), .from("test_ppl") .where(in("a", 1, 2, 3)) .perPartitionLimit(bindMarker()) .limit(3) .getQueryString(), .from("test_ppl") .where(eq("a", bindMarker())) .perPartitionLimit(bindMarker()) .getQueryString(), 2, .where(eq("a", bindMarker())) .and(gt("b", bindMarker())) .perPartitionLimit(bindMarker()) .allowFiltering() .getQueryString(),