mondrian.test

Class OrderByAliasTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

mondrian.test.PropertyRestoringTestCase

mondrian.test.FoodMartTestCase

mondrian.rolap.BatchTestCase

mondrian.test.OrderByAliasTest

All Implemented Interfaces:

junit.framework.Test

public class OrderByAliasTest
extends BatchTestCase

Test cases to verify requiresOrderByAlias()=true for the MySQL 5.7+ MySQL 5.7+ sets SQL_MODE=ONLY_FULL_GROUP_BY, which makes it more strict about SQL with fields in the SELECT and ORDER BY clauses that aren't present in the GROUP BY. See Jira-case for background: http://jira.pentaho.com/browse/MONDRIAN-2451

Author:

Aleksandr Kozlov

Nested Class Summary

Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase

BatchTestCase.TestCase

Nested classes/interfaces inherited from class mondrian.test.FoodMartTestCase

FoodMartTestCase.QueryAndResult

Field Summary

Fields inherited from class mondrian.rolap.BatchTestCase

cubeNameSales, fieldGender, fieldProductDepartment, fieldProductFamily, fieldValueProductDepartment, fieldValuesGender, fieldValuesProductFamily, fieldValuesYear, fieldYear, measureUnitSales, tableCustomer, tableProductClass, tableTime

Fields inherited from class mondrian.test.PropertyRestoringTestCase

propSaver

Constructor Summary

Constructors

Constructor and Description
OrderByAliasTest()

Method Summary

Modifier and Type	Method and Description
protected void	setUp()
protected void	tearDown()
void	testNonEmptyCrossJoin()
void	testSqlInCaptionExpression()
void	testSqlInKeyExpression()
void	testSqlInMeasureExpression()
void	testSqlInNameExpression()
void	testSqlInOrdinalExpression()
void	testSqlInParentExpression()
void	testSqlInPropertyExpression()
void	testVirtualCube()

Methods inherited from class mondrian.rolap.BatchTestCase

assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, assertRequestSql, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure, mysqlPattern, sqlPattern

Methods inherited from class mondrian.test.FoodMartTestCase

allMember, assertAxisReturns, assertAxisThrows, assertBooleanExprReturns, assertExprReturns, assertExprThrows, assertQueriesReturnSimilarResults, assertQueryReturns, assertQueryThrows, assertSize, cubeByName, execute, executeExpr, executeQuery, executeSingletonAxis, genderMembersIncludingAll, getConnection, getDimensionWithName, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, verifySameNativeAndNot, warehouseMembersCanadaMexicoUsa

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runBare, runTest, setName, toString

Methods inherited from class junit.framework.Assert

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail

Methods inherited from class java.lang.Object

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

Constructor Detail

OrderByAliasTest

public OrderByAliasTest()

Method Detail

setUp

protected void setUp()
              throws Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

Exception

tearDown

protected void tearDown()
                 throws Exception

Overrides:

tearDown in class PropertyRestoringTestCase

Throws:

Exception

testSqlInKeyExpression

public void testSqlInKeyExpression()

testSqlInNameExpression

public void testSqlInNameExpression()

testSqlInCaptionExpression

public void testSqlInCaptionExpression()

testSqlInOrdinalExpression

public void testSqlInOrdinalExpression()

testSqlInParentExpression

public void testSqlInParentExpression()

testSqlInPropertyExpression

public void testSqlInPropertyExpression()

testSqlInMeasureExpression

public void testSqlInMeasureExpression()

testNonEmptyCrossJoin

public void testNonEmptyCrossJoin()

testVirtualCube

public void testVirtualCube()