org.apache.calcite.test

类 SqlOperatorTest

java.lang.Object

org.apache.calcite.test.SqlOperatorTest

@TestInstance(value=PER_CLASS)
public class SqlOperatorTest
extends Object

Contains unit tests for all operators. Each of the methods is named after an operator.

To run, you also need an execution mechanism: parse, validate, and execute expressions on the operators. This is left to a SqlTester object which is obtained via the fixture() method. The default tester merely validates calls to operators, but CalciteSqlOperatorTest uses a tester that executes calls and checks that results are valid.

Different implementations of SqlTester are possible, such as:

• Execute against a JDBC database;
• Parse and validate but do not evaluate expressions;
• Generate a SQL script;
• Analyze which operators are adequately tested.

A typical method will be named after the operator it is testing (say testSubstringFunc). It first calls SqlOperatorFixture.setFor(SqlOperator, VmName...) to declare which operator it is testing.

 public void testSubstringFunc() {
     tester.setFor(SqlStdOperatorTable.substringFunc);
     tester.checkScalar("sin(0)", "0");
     tester.checkScalar("sin(1.5707)", "1");
 }

The rest of the method contains calls to the various checkXxx methods in the SqlTester interface. For an operator to be adequately tested, there need to be tests for:

• Parsing all of its the syntactic variants.
• Deriving the type of in all combinations of arguments.
  • Pay particular attention to nullability. For example, the result of the "+" operator is NOT NULL if and only if both of its arguments are NOT NULL.
  • Also pay attention to precision/scale/length. For example, the maximum length of the "||" operator is the sum of the maximum lengths of its arguments.
• Executing the function. Pay particular attention to corner cases such as null arguments or null results.

嵌套类概要

嵌套类

限定符和类型	类和说明
protected static class	SqlOperatorTest.TesterImpl Implementation of SqlTester based on a JDBC connection.

字段概要

字段

限定符和类型	字段和说明
protected static TimeZone	CURRENT_TZ
static Pattern	DATE_PATTERN Regular expression for a SQL DATE value.
static List<String>	DAY_VARIANTS
static boolean	DECIMAL Whether DECIMAL type is implemented.
static List<String>	HOUR_VARIANTS
protected static TimeZone	LOCAL_TZ
static List<String>	MICROSECOND_VARIANTS
static List<String>	MINUTE_VARIANTS
static List<String>	MONTH_VARIANTS
static List<String>	NANOSECOND_VARIANTS
static List<String>	QUARTER_VARIANTS
static List<String>	SECOND_VARIANTS
static SqlOperatorTest.TesterImpl	TESTER
static Pattern	TIME_PATTERN Regular expression for a SQL TIME(0) value.
static Pattern	TIMESTAMP_PATTERN Regular expression for a SQL TIMESTAMP(0) value.
static boolean	TODO
protected static TimeZone	UTC_TZ
static List<String>	WEEK_VARIANTS
static List<String>	YEAR_VARIANTS

构造器概要

构造器

构造器和说明
SqlOperatorTest()

方法概要

限定符和类型	方法和说明
protected static org.apache.calcite.util.Pair<String,org.apache.calcite.runtime.Hook.Closeable>	currentTimeString(TimeZone tz) Returns a time string, in GMT, that will be valid for at least 2 minutes.
protected SqlOperatorFixture	fixture() Sub-classes should override to run tests in a different environment.
protected static Calendar	getCalendarNotTooNear(int timeUnit) Returns a Calendar that is the current time, pausing if we are within 2 minutes of midnight or the top of the hour.
void	testConstantCast() Test case for Constant expression with nested casts causes a compiler crash.
void	testJsonInsert()
void	testJsonReplace()
void	testJsonSet()

从类继承的方法 java.lang.Object

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

字段详细资料

TESTER

public static final SqlOperatorTest.TesterImpl TESTER

TODO

public static final boolean TODO

另请参阅:

常量字段值

TIME_PATTERN

public static final Pattern TIME_PATTERN

Regular expression for a SQL TIME(0) value.

TIMESTAMP_PATTERN

public static final Pattern TIMESTAMP_PATTERN

Regular expression for a SQL TIMESTAMP(0) value.

DATE_PATTERN

public static final Pattern DATE_PATTERN

Regular expression for a SQL DATE value.

MICROSECOND_VARIANTS

public static final List<String> MICROSECOND_VARIANTS

NANOSECOND_VARIANTS

public static final List<String> NANOSECOND_VARIANTS

SECOND_VARIANTS

public static final List<String> SECOND_VARIANTS

MINUTE_VARIANTS

public static final List<String> MINUTE_VARIANTS

HOUR_VARIANTS

public static final List<String> HOUR_VARIANTS

DAY_VARIANTS

public static final List<String> DAY_VARIANTS

WEEK_VARIANTS

public static final List<String> WEEK_VARIANTS

MONTH_VARIANTS

public static final List<String> MONTH_VARIANTS

QUARTER_VARIANTS

public static final List<String> QUARTER_VARIANTS

YEAR_VARIANTS

public static final List<String> YEAR_VARIANTS

UTC_TZ

protected static final TimeZone UTC_TZ

LOCAL_TZ

protected static final TimeZone LOCAL_TZ

CURRENT_TZ

protected static final TimeZone CURRENT_TZ

DECIMAL

public static final boolean DECIMAL

Whether DECIMAL type is implemented.

另请参阅:

常量字段值

构造器详细资料

SqlOperatorTest

public SqlOperatorTest()

方法详细资料

fixture

protected SqlOperatorFixture fixture()

Sub-classes should override to run tests in a different environment.

testConstantCast

@Test
public void testConstantCast()

Test case for Constant expression with nested casts causes a compiler crash.

getCalendarNotTooNear

protected static Calendar getCalendarNotTooNear(int timeUnit)

Returns a Calendar that is the current time, pausing if we are within 2 minutes of midnight or the top of the hour.

参数:

timeUnit - Time unit

返回:

calendar

testJsonInsert

@Test
public void testJsonInsert()

testJsonReplace

@Test
public void testJsonReplace()

testJsonSet

@Test
public void testJsonSet()

currentTimeString

protected static org.apache.calcite.util.Pair<String,org.apache.calcite.runtime.Hook.Closeable> currentTimeString(TimeZone tz)

Returns a time string, in GMT, that will be valid for at least 2 minutes.

For example, at "2005-01-01 12:34:56 PST", returns "2005-01-01 20:". At "2005-01-01 12:34:59 PST", waits a minute, then returns "2005-01-01 21:".

参数:

tz - Time zone

返回:

Time string