Mihai Budiu created CALCITE-5760:
------------------------------------
Summary: SqlOperatorTest::testDateTrunc does not validate results
Key: CALCITE-5760
URL: https://issues.apache.org/jira/browse/CALCITE-5760
Project: Calcite
Issue Type: Bug
Components: tests
Affects Versions: 1.34.0
Reporter: Mihai Budiu
I was trying to reproduce a bug where DATE_TRUNC returns an incorrect result
when truncating a constant date to a MILLENNIUM.
I found test cases for DATE_TRUNC in SqlOperatorTest; these test cases do
specify the expected result, e.g.:
f.checkScalar("date_trunc(date '2015-02-19', isoyear)",
"2014-12-29", "DATE NOT NULL");
However, the test fixture uses AbstractSqlTester::check, which ignores the
result!
As a proof, one can replace the results with arbitrary strings and the tests
will still pass.
I presume that this is not the intent of the test writers. How could this test
be fixed to also check the results?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
