Build fails on doctest datetime when locale is set to other

[loupipalien]

Description

./gradlew build fails on doctest datetime

• tag: v1.13.2.0
• jdk: Java HotSpot(TM) 64-Bit Server VM (build 14.0.2+12-46, mixed mode, sharing)

Detail

[2022-05-06T13:44:03.906710Z] [BUILD] Starting Elasticsearch process
[2022-05-06T21:44:09,168][INFO ][o.e.n.Node               ] [docTestCluster-0] version[7.10.2], pid[46220], build[oss/tar/747e1cc71def077253878a59143c1f785afa92b9/2021-01-13T00:42:12.435326Z], OS[Mac OS X/10.16/x86_64], JVM[Oracle Corporation/Java HotSpot(TM) 64-Bit Server VM/14.0.2/14.0.2+12-46]
[2022-05-06T21:44:09,172][INFO ][o.e.n.Node               ] [docTestCluster-0] JVM home [/Library/Java/JavaVirtualMachines/jdk-14.0.2.jdk/Contents/Home], using bundled JDK [false]
[2022-05-06T21:44:09,173][INFO ][o.e.n.Node               ] [docTestCluster-0] JVM arguments [-Xshare:auto, -Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouch, -Xss1m, -Djava.awt.headless=true, -Dfile.encoding=UTF-8, -Djna.nosys=true, -XX:-OmitStackTraceInFastThrow, -XX:+ShowCodeDetailsInExceptionMessages, -Dio.netty.noUnsafe=true, -Dio.netty.noKeySetOptimization=true, -Dio.netty.recycler.maxCapacityPerThread=0, -Dio.netty.allocator.numDirectArenas=0, -Dlog4j.shutdownHookEnabled=false, -Dlog4j2.disable.jmx=true, -Djava.locale.providers=SPI,COMPAT, -Xms1g, -Xmx1g, -XX:+UseG1GC, -XX:G1ReservePercent=25, -XX:InitiatingHeapOccupancyPercent=30, -Djava.io.tmpdir=/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/build/testclusters/docTestCluster-0/tmp, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=logs, -XX:ErrorFile=logs/hs_err_pid%p.log, -Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,pid,tags:filecount=32,filesize=64m, -Xms512m, -Xmx512m, -ea, -esa, -XX:MaxDirectMemorySize=268435456, -Des.path.home=/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/build/testclusters/docTestCluster-0/distro/7.10.2-OSS, -Des.path.conf=/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/build/testclusters/docTestCluster-0/config, -Des.distribution.flavor=oss, -Des.distribution.type=tar, -Des.bundled_jdk=true]

...

[2022-05-06T21:44:16,726][INFO ][o.e.n.Node               ] [docTestCluster-0] started
/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/gradlew -p /Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest runRestTestCluster is ready.

> Task :doctest:doctest
/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/user/dql/complex.rst
Doctest: complex.rst ... ok
/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/experiment/ppl/general/datatypes.rst
Doctest: datatypes.rst ... ok
/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/user/dql/aggregations.rst
Doctest: aggregations.rst ... ok
/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/experiment/ppl/functions/datetime.rst
Doctest: datetime.rst ... FAIL

======================================================================
FAIL: /Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/experiment/ppl/functions/datetime.rst
Doctest: datetime.rst
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/Cellar/python@3.9/3.9.2_1/Frameworks/Python.framework/Versions/3.9/lib/python3.9/doctest.py", line 2204, in runTest
    raise self.failureException(self.format_failure(new.getvalue()))
AssertionError: Failed doctest test for datetime.rst
  File "/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/experiment/ppl/functions/datetime.rst", line 0

----------------------------------------------------------------------
File "/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/experiment/ppl/functions/datetime.rst", line 262, in datetime.rst
Failed example:
    ppl_cmd.process("source=people | eval `DAYNAME(DATE('2020-08-26'))` = DAYNAME(DATE('2020-08-26')) | fields `DAYNAME(DATE('2020-08-26'))`")Expected:
    fetched rows / total rows = 1/1
    +-------------------------------+
    | DAYNAME(DATE('2020-08-26'))   |
    |-------------------------------|
    | Wednesday                     |
    +-------------------------------+
Got:
    fetched rows / total rows = 1/1
    +-------------------------------+
    | DAYNAME(DATE('2020-08-26'))   |
    |-------------------------------|
    | 星期三                         |
    +-------------------------------+
----------------------------------------------------------------------
File "/Users/bytedance/code/github.com/opendistro-for-elasticsearch/sql/doctest/../docs/experiment/ppl/functions/datetime.rst", line 483, in datetime.rst
Failed example:
    ppl_cmd.process("source=people | eval `MONTHNAME(DATE('2020-08-26'))` = MONTHNAME(DATE('2020-08-26')) | fields `MONTHNAME(DATE('2020-08-26'))`")Expected:
    fetched rows / total rows = 1/1
    +---------------------------------+
    | MONTHNAME(DATE('2020-08-26'))   |
    |---------------------------------|
    | August                          |
    +---------------------------------+
Got:
    fetched rows / total rows = 1/1
    +---------------------------------+
    | MONTHNAME(DATE('2020-08-26'))   |
    |---------------------------------|
    | 八月                             |
    +---------------------------------+


----------------------------------------------------------------------
Ran 4 tests in 24.890s

FAILED (failures=1)

> Task :doctest:doctest FAILED

FAILURE: Build failed with an exception.