java.lang.Object
- org.apache.calcite.adapter.geode.rel.AbstractGeodeTest
- - org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest

public class GeodeBookstoreTest
extends AbstractGeodeTest

Tests using Bookshop schema.

Field Summary
- Fields inherited from class org.apache.calcite.adapter.geode.rel.AbstractGeodeTest
  POLICY

Constructor Summary

Constructors
Constructor Description

GeodeBookstoreTest()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`private CalciteAssert.AssertThat`	`calciteAssert()`
`private CalciteAssert.ConnectionFactory`	`newConnectionFactory()`
`static void`	`setUp()`
`void`	`testAddMissingGroupByColumnToProjectedFields()`	OQL Error: Query contains group by columns not present in projected fields Solution: Automatically expand the projections to include all missing GROUP By columns.
`void`	`testCount()`
`void`	`testCountInGroupBy()`
`void`	`testCountStar()`
`void`	`testFilterWithNestedField()`
`void`	`testGroupBy()`
`void`	`testInSetFilterWithNestedStringField()`
`void`	`testLimit()`
`void`	`testMaxMinSumAvg()`
`void`	`testMaxMinSumAvgInGroupBy()`
`void`	`testMissingProjectRelationOnGroupByColumnMatchingProjectedFields()`	When the group by columns match the projected fields, the optimizers removes the projected relation.
`void`	`testMissingProjectRelationOnGroupByColumnMatchingProjectedFields2()`	When the group by columns match the projected fields, the optimizers removes the projected relation.
`void`	`testProjectionsAndWhereGreatThan()`
`void`	`testSelect()`
`void`	`testSelectWithNestedPdx()`
`void`	`testSelectWithNestedPdx2()`
`void`	`testSelectWithNestedPdxFieldAccess()`
`void`	`testSelectWithNullFieldValue()`
`void`	`testSortBy2Columns()`
`void`	`testSortWithProjection()`
`void`	`testSortWithProjectionAndLimit()`
`void`	`testSqlBookMasterCount()`
`void`	`testSqlBookMasterWhere()`
`void`	`testSqlConjunction()`
`void`	`testSqlDisjunction()`
`void`	`testSqlDistinctSort()`
`void`	`testSqlDistinctSort2()`
`void`	`testSqlDistinctSort3()`
`void`	`testSqlLimit2()`
`void`	`testSqlSimple()`
`void`	`testSqlSingleNumberWhereFilter()`
`void`	`testWhereEqual()`
`void`	`testWhereWithAnd()`
`void`	`testWhereWithAndOr()`
`void`	`testWhereWithOr()`
`void`	`testWhereWithOrAnd()`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail
- GeodeBookstoreTest
```
public GeodeBookstoreTest()
```

Method Detail

setUp

public static void setUp()
                  throws java.lang.Exception

Throws:: java.lang.Exception

newConnectionFactory

private CalciteAssert.ConnectionFactory newConnectionFactory()

calciteAssert

private CalciteAssert.AssertThat calciteAssert()

testSelect
```
public void testSelect()
```

testWhereEqual
```
public void testWhereEqual()
```

testWhereWithAnd
```
public void testWhereWithAnd()
```

testWhereWithOr
```
public void testWhereWithOr()
```

testWhereWithAndOr
```
public void testWhereWithAndOr()
```

testWhereWithOrAnd
```
public void testWhereWithOrAnd()
```

testProjectionsAndWhereGreatThan

public void testProjectionsAndWhereGreatThan()

testLimit
```
public void testLimit()
```

testSortWithProjection
```
public void testSortWithProjection()
```

testSortWithProjectionAndLimit

public void testSortWithProjectionAndLimit()

testSortBy2Columns
```
public void testSortBy2Columns()
```

testAddMissingGroupByColumnToProjectedFields
```
public void testAddMissingGroupByColumnToProjectedFields()
```
OQL Error: Query contains group by columns not present in projected fields Solution: Automatically expand the projections to include all missing GROUP By columns.

testMissingProjectRelationOnGroupByColumnMatchingProjectedFields
```
public void testMissingProjectRelationOnGroupByColumnMatchingProjectedFields()
```
When the group by columns match the projected fields, the optimizers removes the projected relation.

testMissingProjectRelationOnGroupByColumnMatchingProjectedFields2
```
public void testMissingProjectRelationOnGroupByColumnMatchingProjectedFields2()
```
When the group by columns match the projected fields, the optimizers removes the projected relation.

testCount
```
public void testCount()
```

testCountStar
```
public void testCountStar()
```

testCountInGroupBy
```
public void testCountInGroupBy()
```

testMaxMinSumAvg
```
public void testMaxMinSumAvg()
```

testMaxMinSumAvgInGroupBy

public void testMaxMinSumAvgInGroupBy()

testGroupBy
```
public void testGroupBy()
```

testSelectWithNestedPdx
```
public void testSelectWithNestedPdx()
```

testSelectWithNestedPdx2

public void testSelectWithNestedPdx2()

testSelectWithNestedPdxFieldAccess

public void testSelectWithNestedPdxFieldAccess()

testSelectWithNullFieldValue

public void testSelectWithNullFieldValue()

testFilterWithNestedField

public void testFilterWithNestedField()

testSqlSimple
```
public void testSqlSimple()
```

testSqlSingleNumberWhereFilter

public void testSqlSingleNumberWhereFilter()

testSqlDistinctSort
```
public void testSqlDistinctSort()
```

testSqlDistinctSort2
```
public void testSqlDistinctSort2()
```

testSqlDistinctSort3
```
public void testSqlDistinctSort3()
```

testSqlLimit2
```
public void testSqlLimit2()
```

testSqlDisjunction
```
public void testSqlDisjunction()
```

testSqlConjunction
```
public void testSqlConjunction()
```

testSqlBookMasterWhere
```
public void testSqlBookMasterWhere()
```

testSqlBookMasterCount
```
public void testSqlBookMasterCount()
```

testInSetFilterWithNestedStringField

public void testInSetFilterWithNestedStringField()

Class GeodeBookstoreTest

Field Summary

Fields inherited from class org.apache.calcite.adapter.geode.rel.AbstractGeodeTest

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

GeodeBookstoreTest

Method Detail

setUp

newConnectionFactory

calciteAssert

testSelect

testWhereEqual

testWhereWithAnd

testWhereWithOr

testWhereWithAndOr

testWhereWithOrAnd

testProjectionsAndWhereGreatThan

testLimit

testSortWithProjection

testSortWithProjectionAndLimit

testSortBy2Columns

testAddMissingGroupByColumnToProjectedFields

testMissingProjectRelationOnGroupByColumnMatchingProjectedFields

testMissingProjectRelationOnGroupByColumnMatchingProjectedFields2

testCount

testCountStar

testCountInGroupBy

testMaxMinSumAvg

testMaxMinSumAvgInGroupBy

testGroupBy

testSelectWithNestedPdx

testSelectWithNestedPdx2

testSelectWithNestedPdxFieldAccess

testSelectWithNullFieldValue

testFilterWithNestedField

testSqlSimple

testSqlSingleNumberWhereFilter

testSqlDistinctSort

testSqlDistinctSort2

testSqlDistinctSort3

testSqlLimit2

testSqlDisjunction

testSqlConjunction

testSqlBookMasterWhere

testSqlBookMasterCount

testInSetFilterWithNestedStringField