org.apache.drill.jdbc.test

Class JdbcNullOrderingAndGroupingTest

java.lang.Object

org.apache.drill.test.BaseTest

org.apache.drill.test.DrillTest

org.apache.drill.exec.ExecTest

org.apache.drill.jdbc.JdbcTestBase

org.apache.drill.jdbc.test.JdbcTestQueryBase

org.apache.drill.jdbc.test.JdbcNullOrderingAndGroupingTest

public class JdbcNullOrderingAndGroupingTest
extends JdbcTestQueryBase

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.drill.jdbc.JdbcTestBase

JdbcTestBase.ModelAndSchema, JdbcTestBase.TestDataConnection

Nested classes/interfaces inherited from class org.apache.drill.test.DrillTest

DrillTest.MemWatcher

Field Summary

Fields inherited from class org.apache.drill.jdbc.test.JdbcTestQueryBase

TIMEOUT

Fields inherited from class org.apache.drill.jdbc.JdbcTestBase

watcher

Fields inherited from class org.apache.drill.exec.ExecTest

c, dirTestWatcher, optionManager

Fields inherited from class org.apache.drill.test.DrillTest

logOutcome, objectMapper, REPEAT_RULE, thrownException

Constructor Summary

Constructors

Constructor and Description
JdbcNullOrderingAndGroupingTest()

Method Summary

Modifier and Type	Method and Description
static void	resetDefaults()
static void	setUpClass()
void	testOrderBigIntAscNullsDefaultLast()
void	testOrderBigIntAscNullsFirst()
void	testOrderBigIntAscNullsLast()
void	testOrderBigIntDefaultedAscNullsDefaultLast()
void	testOrderBigIntDefaultedAscNullsFirst()
void	testOrderBigIntDefaultedAscNullsLast()
void	testOrderBigIntDescNullsDefaultFirst()
void	testOrderBigIntDescNullsFirst()
void	testOrderBigIntDescNullsLast()
void	testOrderDateAscNullsDefaultLast()
void	testOrderDateAscNullsFirst()
void	testOrderDateAscNullsLast()
void	testOrderDateDefaultedAscNullsDefaultLast()
void	testOrderDateDefaultedAscNullsFirst()
void	testOrderDateDefaultedAscNullsLast()
void	testOrderDateDescNullsDefaultFirst()
void	testOrderDateDescNullsFirst()
void	testOrderDateDescNullsLast()
void	testOrderDecimal35AscNullsDefaultLast()
void	testOrderDecimal35AscNullsFirst()
void	testOrderDecimal35AscNullsLast()
void	testOrderDecimal35DefaultedAscNullsDefaultLast()
void	testOrderDecimal35DefaultedAscNullsFirst()
void	testOrderDecimal35DefaultedAscNullsLast()
void	testOrderDecimal35DescNullsDefaultFirst()
void	testOrderDecimal35DescNullsFirst()
void	testOrderDecimal35DescNullsLast()
void	testOrderDecimal5AscNullsDefaultLast()
void	testOrderDecimal5AscNullsFirst()
void	testOrderDecimal5AscNullsLast()
void	testOrderDecimal5DefaultedAscNullsDefaultLast()
void	testOrderDecimal5DefaultedAscNullsFirst()
void	testOrderDecimal5DefaultedAscNullsLast()
void	testOrderDecimal5DescNullsDefaultFirst()
void	testOrderDecimal5DescNullsFirst()
void	testOrderDecimal5DescNullsLast()
void	testOrderDecimalAscNullsDefaultLast()
void	testOrderDecimalAscNullsFirst()
void	testOrderDecimalAscNullsLast()
void	testOrderDecimalDefaultedAscNullsDefaultLast()
void	testOrderDecimalDefaultedAscNullsFirst()
void	testOrderDecimalDefaultedAscNullsLast()
void	testOrderDecimalDescNullsDefaultFirst()
void	testOrderDecimalDescNullsFirst()
void	testOrderDecimalDescNullsLast()
void	testOrderDonutsTopping3AscNullsDefaultLast()
void	testOrderDonutsTopping3AscNullsFirst()
void	testOrderDonutsTopping3AscNullsLast()
void	testOrderDonutsTopping3DefaultedAscNullsDefaultLast()
void	testOrderDonutsTopping3DefaultedAscNullsFirst()
void	testOrderDonutsTopping3DefaultedAscNullsLast()
void	testOrderDonutsTopping3DescNullsDefaultFirst()
void	testOrderDonutsTopping3DescNullsFirst()
void	testOrderDonutsTopping3DescNullsLast()
void	testOrderFloatAscNullsDefaultLast()
void	testOrderFloatAscNullsFirst()
void	testOrderFloatAscNullsLast()
void	testOrderFloatDefaultedAscNullsDefaultLast()
void	testOrderFloatDefaultedAscNullsFirst()
void	testOrderFloatDefaultedAscNullsLast()
void	testOrderFloatDescNullsDefaultFirst()
void	testOrderFloatDescNullsFirst()
void	testOrderFloatDescNullsLast()
void	testOrderIntAscNullsDefaultLast()
void	testOrderIntAscNullsFirst()
void	testOrderIntAscNullsLast()
void	testOrderIntDefaultedAscNullsDefaultLast()
void	testOrderIntDefaultedAscNullsFirst()
void	testOrderIntDefaultedAscNullsLast()
void	testOrderIntDescNullsDefaultFirst()
void	testOrderIntDescNullsFirst()
void	testOrderIntDescNullsLast()
void	testOrderIntervalAscNullsDefaultLast()
void	testOrderIntervalAscNullsFirst()
void	testOrderIntervalAscNullsLast()
void	testOrderIntervalDefaultedAscNullsDefaultLast()
void	testOrderIntervalDefaultedAscNullsFirst()
void	testOrderIntervalDefaultedAscNullsLast()
void	testOrderIntervalDescNullsDefaultFirst()
void	testOrderIntervalDescNullsFirst()
void	testOrderIntervalDescNullsLast()
void	testOrderVarCharAscNullsDefaultLast()
void	testOrderVarCharAscNullsFirst()
void	testOrderVarCharAscNullsLast()
void	testOrderVarCharDefaultedAscNullsDefaultLast()
void	testOrderVarCharDefaultedAscNullsFirst()
void	testOrderVarCharDefaultedAscNullsLast()
void	testOrderVarCharDescNullsDefaultFirst()
void	testOrderVarCharDescNullsFirst()
void	testOrderVarCharDescNullsLast()

Methods inherited from class org.apache.drill.jdbc.test.JdbcTestQueryBase

testQuery

Methods inherited from class org.apache.drill.jdbc.JdbcTestBase

changeSchema, changeSchemaIfSupplied, connect, connect, connect, getDefaultProperties, reset, setUpTestCase, tearDownTestCase, testJdbcTestConnectionResettingCompatibility, toString, toString, withFull, withModel, withNoDefaultSchema

Methods inherited from class org.apache.drill.exec.ExecTest

clear, getLocalFileSystem, mockDrillbitContext, mockUsDateFormatSymbols, mockUtcDateTimeZone, parseExpr, setupOptionManager

Methods inherited from class org.apache.drill.test.DrillTest

escapeJsonString, finishDrillTest, initDrillTest

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcNullOrderingAndGroupingTest

public JdbcNullOrderingAndGroupingTest()

Method Detail

setUpClass

public static void setUpClass()
                       throws Exception

Throws:

Exception

resetDefaults

public static void resetDefaults()
                          throws Exception

Throws:

Exception

testOrderDonutsTopping3AscNullsFirst

public void testOrderDonutsTopping3AscNullsFirst()
                                          throws Exception

Throws:

Exception

testOrderDonutsTopping3AscNullsLast

public void testOrderDonutsTopping3AscNullsLast()
                                         throws Exception

Throws:

Exception

testOrderDonutsTopping3AscNullsDefaultLast

public void testOrderDonutsTopping3AscNullsDefaultLast()
                                                throws Exception

Throws:

Exception

testOrderDonutsTopping3DescNullsFirst

public void testOrderDonutsTopping3DescNullsFirst()
                                           throws Exception

Throws:

Exception

testOrderDonutsTopping3DescNullsLast

public void testOrderDonutsTopping3DescNullsLast()
                                          throws Exception

Throws:

Exception

testOrderDonutsTopping3DescNullsDefaultFirst

public void testOrderDonutsTopping3DescNullsDefaultFirst()
                                                  throws Exception

Throws:

Exception

testOrderDonutsTopping3DefaultedAscNullsFirst

public void testOrderDonutsTopping3DefaultedAscNullsFirst()
                                                   throws Exception

Throws:

Exception

testOrderDonutsTopping3DefaultedAscNullsLast

public void testOrderDonutsTopping3DefaultedAscNullsLast()
                                                  throws Exception

Throws:

Exception

testOrderDonutsTopping3DefaultedAscNullsDefaultLast

public void testOrderDonutsTopping3DefaultedAscNullsDefaultLast()
                                                         throws Exception

Throws:

Exception

testOrderVarCharAscNullsFirst

public void testOrderVarCharAscNullsFirst()
                                   throws Exception

Throws:

Exception

testOrderVarCharAscNullsLast

public void testOrderVarCharAscNullsLast()
                                  throws Exception

Throws:

Exception

testOrderVarCharAscNullsDefaultLast

public void testOrderVarCharAscNullsDefaultLast()
                                         throws Exception

Throws:

Exception

testOrderVarCharDescNullsFirst

public void testOrderVarCharDescNullsFirst()
                                    throws Exception

Throws:

Exception

testOrderVarCharDescNullsLast

public void testOrderVarCharDescNullsLast()
                                   throws Exception

Throws:

Exception

testOrderVarCharDescNullsDefaultFirst

public void testOrderVarCharDescNullsDefaultFirst()
                                           throws Exception

Throws:

Exception

testOrderVarCharDefaultedAscNullsFirst

public void testOrderVarCharDefaultedAscNullsFirst()
                                            throws Exception

Throws:

Exception

testOrderVarCharDefaultedAscNullsLast

public void testOrderVarCharDefaultedAscNullsLast()
                                           throws Exception

Throws:

Exception

testOrderVarCharDefaultedAscNullsDefaultLast

public void testOrderVarCharDefaultedAscNullsDefaultLast()
                                                  throws Exception

Throws:

Exception

testOrderIntAscNullsFirst

public void testOrderIntAscNullsFirst()
                               throws Exception

Throws:

Exception

testOrderIntAscNullsLast

public void testOrderIntAscNullsLast()
                              throws Exception

Throws:

Exception

testOrderIntAscNullsDefaultLast

public void testOrderIntAscNullsDefaultLast()
                                     throws Exception

Throws:

Exception

testOrderIntDescNullsFirst

public void testOrderIntDescNullsFirst()
                                throws Exception

Throws:

Exception

testOrderIntDescNullsLast

public void testOrderIntDescNullsLast()
                               throws Exception

Throws:

Exception

testOrderIntDescNullsDefaultFirst

public void testOrderIntDescNullsDefaultFirst()
                                       throws Exception

Throws:

Exception

testOrderIntDefaultedAscNullsFirst

public void testOrderIntDefaultedAscNullsFirst()
                                        throws Exception

Throws:

Exception

testOrderIntDefaultedAscNullsLast

public void testOrderIntDefaultedAscNullsLast()
                                       throws Exception

Throws:

Exception

testOrderIntDefaultedAscNullsDefaultLast

public void testOrderIntDefaultedAscNullsDefaultLast()
                                              throws Exception

Throws:

Exception

testOrderFloatAscNullsFirst

public void testOrderFloatAscNullsFirst()
                                 throws Exception

Throws:

Exception

testOrderFloatAscNullsLast

public void testOrderFloatAscNullsLast()
                                throws Exception

Throws:

Exception

testOrderFloatAscNullsDefaultLast

public void testOrderFloatAscNullsDefaultLast()
                                       throws Exception

Throws:

Exception

testOrderFloatDescNullsFirst

public void testOrderFloatDescNullsFirst()
                                  throws Exception

Throws:

Exception

testOrderFloatDescNullsLast

public void testOrderFloatDescNullsLast()
                                 throws Exception

Throws:

Exception

testOrderFloatDescNullsDefaultFirst

public void testOrderFloatDescNullsDefaultFirst()
                                         throws Exception

Throws:

Exception

testOrderFloatDefaultedAscNullsFirst

public void testOrderFloatDefaultedAscNullsFirst()
                                          throws Exception

Throws:

Exception

testOrderFloatDefaultedAscNullsLast

public void testOrderFloatDefaultedAscNullsLast()
                                         throws Exception

Throws:

Exception

testOrderFloatDefaultedAscNullsDefaultLast

public void testOrderFloatDefaultedAscNullsDefaultLast()
                                                throws Exception

Throws:

Exception

testOrderBigIntAscNullsFirst

public void testOrderBigIntAscNullsFirst()
                                  throws Exception

Throws:

Exception

testOrderBigIntAscNullsLast

public void testOrderBigIntAscNullsLast()
                                 throws Exception

Throws:

Exception

testOrderBigIntAscNullsDefaultLast

public void testOrderBigIntAscNullsDefaultLast()
                                        throws Exception

Throws:

Exception

testOrderBigIntDescNullsFirst

public void testOrderBigIntDescNullsFirst()
                                   throws Exception

Throws:

Exception

testOrderBigIntDescNullsLast

public void testOrderBigIntDescNullsLast()
                                  throws Exception

Throws:

Exception

testOrderBigIntDescNullsDefaultFirst

public void testOrderBigIntDescNullsDefaultFirst()
                                          throws Exception

Throws:

Exception

testOrderBigIntDefaultedAscNullsFirst

public void testOrderBigIntDefaultedAscNullsFirst()
                                           throws Exception

Throws:

Exception

testOrderBigIntDefaultedAscNullsLast

public void testOrderBigIntDefaultedAscNullsLast()
                                          throws Exception

Throws:

Exception

testOrderBigIntDefaultedAscNullsDefaultLast

public void testOrderBigIntDefaultedAscNullsDefaultLast()
                                                 throws Exception

Throws:

Exception

testOrderDateAscNullsFirst

public void testOrderDateAscNullsFirst()
                                throws Exception

Throws:

Exception

testOrderDateAscNullsLast

public void testOrderDateAscNullsLast()
                               throws Exception

Throws:

Exception

testOrderDateAscNullsDefaultLast

public void testOrderDateAscNullsDefaultLast()
                                      throws Exception

Throws:

Exception

testOrderDateDescNullsFirst

public void testOrderDateDescNullsFirst()
                                 throws Exception

Throws:

Exception

testOrderDateDescNullsLast

public void testOrderDateDescNullsLast()
                                throws Exception

Throws:

Exception

testOrderDateDescNullsDefaultFirst

public void testOrderDateDescNullsDefaultFirst()
                                        throws Exception

Throws:

Exception

testOrderDateDefaultedAscNullsFirst

public void testOrderDateDefaultedAscNullsFirst()
                                         throws Exception

Throws:

Exception

testOrderDateDefaultedAscNullsLast

public void testOrderDateDefaultedAscNullsLast()
                                        throws Exception

Throws:

Exception

testOrderDateDefaultedAscNullsDefaultLast

public void testOrderDateDefaultedAscNullsDefaultLast()
                                               throws Exception

Throws:

Exception

testOrderIntervalAscNullsFirst

public void testOrderIntervalAscNullsFirst()
                                    throws Exception

Throws:

Exception

testOrderIntervalAscNullsLast

public void testOrderIntervalAscNullsLast()
                                   throws Exception

Throws:

Exception

testOrderIntervalAscNullsDefaultLast

public void testOrderIntervalAscNullsDefaultLast()
                                          throws Exception

Throws:

Exception

testOrderIntervalDescNullsFirst

public void testOrderIntervalDescNullsFirst()
                                     throws Exception

Throws:

Exception

testOrderIntervalDescNullsLast

public void testOrderIntervalDescNullsLast()
                                    throws Exception

Throws:

Exception

testOrderIntervalDescNullsDefaultFirst

public void testOrderIntervalDescNullsDefaultFirst()
                                            throws Exception

Throws:

Exception

testOrderIntervalDefaultedAscNullsFirst

public void testOrderIntervalDefaultedAscNullsFirst()
                                             throws Exception

Throws:

Exception

testOrderIntervalDefaultedAscNullsLast

public void testOrderIntervalDefaultedAscNullsLast()
                                            throws Exception

Throws:

Exception

testOrderIntervalDefaultedAscNullsDefaultLast

public void testOrderIntervalDefaultedAscNullsDefaultLast()
                                                   throws Exception

Throws:

Exception

testOrderDecimalAscNullsFirst

public void testOrderDecimalAscNullsFirst()
                                   throws Exception

Throws:

Exception

testOrderDecimalAscNullsLast

public void testOrderDecimalAscNullsLast()
                                  throws Exception

Throws:

Exception

testOrderDecimalAscNullsDefaultLast

public void testOrderDecimalAscNullsDefaultLast()
                                         throws Exception

Throws:

Exception

testOrderDecimalDescNullsFirst

public void testOrderDecimalDescNullsFirst()
                                    throws Exception

Throws:

Exception

testOrderDecimalDescNullsLast

public void testOrderDecimalDescNullsLast()
                                   throws Exception

Throws:

Exception

testOrderDecimalDescNullsDefaultFirst

public void testOrderDecimalDescNullsDefaultFirst()
                                           throws Exception

Throws:

Exception

testOrderDecimalDefaultedAscNullsFirst

public void testOrderDecimalDefaultedAscNullsFirst()
                                            throws Exception

Throws:

Exception

testOrderDecimalDefaultedAscNullsLast

public void testOrderDecimalDefaultedAscNullsLast()
                                           throws Exception

Throws:

Exception

testOrderDecimalDefaultedAscNullsDefaultLast

public void testOrderDecimalDefaultedAscNullsDefaultLast()
                                                  throws Exception

Throws:

Exception

testOrderDecimal5AscNullsFirst

public void testOrderDecimal5AscNullsFirst()
                                    throws Exception

Throws:

Exception

testOrderDecimal5AscNullsLast

public void testOrderDecimal5AscNullsLast()
                                   throws Exception

Throws:

Exception

testOrderDecimal5AscNullsDefaultLast

public void testOrderDecimal5AscNullsDefaultLast()
                                          throws Exception

Throws:

Exception

testOrderDecimal5DescNullsFirst

public void testOrderDecimal5DescNullsFirst()
                                     throws Exception

Throws:

Exception

testOrderDecimal5DescNullsLast

public void testOrderDecimal5DescNullsLast()
                                    throws Exception

Throws:

Exception

testOrderDecimal5DescNullsDefaultFirst

public void testOrderDecimal5DescNullsDefaultFirst()
                                            throws Exception

Throws:

Exception

testOrderDecimal5DefaultedAscNullsFirst

public void testOrderDecimal5DefaultedAscNullsFirst()
                                             throws Exception

Throws:

Exception

testOrderDecimal5DefaultedAscNullsLast

public void testOrderDecimal5DefaultedAscNullsLast()
                                            throws Exception

Throws:

Exception

testOrderDecimal5DefaultedAscNullsDefaultLast

public void testOrderDecimal5DefaultedAscNullsDefaultLast()
                                                   throws Exception

Throws:

Exception

testOrderDecimal35AscNullsFirst

public void testOrderDecimal35AscNullsFirst()
                                     throws Exception

Throws:

Exception

testOrderDecimal35AscNullsLast

public void testOrderDecimal35AscNullsLast()
                                    throws Exception

Throws:

Exception

testOrderDecimal35AscNullsDefaultLast

public void testOrderDecimal35AscNullsDefaultLast()
                                           throws Exception

Throws:

Exception

testOrderDecimal35DescNullsFirst

public void testOrderDecimal35DescNullsFirst()
                                      throws Exception

Throws:

Exception

testOrderDecimal35DescNullsLast

public void testOrderDecimal35DescNullsLast()
                                     throws Exception

Throws:

Exception

testOrderDecimal35DescNullsDefaultFirst

public void testOrderDecimal35DescNullsDefaultFirst()
                                             throws Exception

Throws:

Exception

testOrderDecimal35DefaultedAscNullsFirst

public void testOrderDecimal35DefaultedAscNullsFirst()
                                              throws Exception

Throws:

Exception

testOrderDecimal35DefaultedAscNullsLast

public void testOrderDecimal35DefaultedAscNullsLast()
                                             throws Exception

Throws:

Exception

testOrderDecimal35DefaultedAscNullsDefaultLast

public void testOrderDecimal35DefaultedAscNullsDefaultLast()
                                                    throws Exception

Throws:

Exception