congxuebin opened a new issue, #761:
URL: https://github.com/apache/cloudberry/issues/761
### Apache Cloudberry version
Cloudberry Database 1.0.0+782d9b79 build
commit:782d9b799e72079c9170b8934a1950b8459ac25e
### What happened
## Failed Test Cases
```
AOCOAlterColumnTestCase.test_alter_part_add_part ... 706.37 ms ... FAIL
AOCOAlterColumnTestCase.test_alter_rollback ... 132.12 ms ... FAIL
AOCOAlterColumnTestCase.test_alter_table_check_negative ... 133.01 ms ...
FAIL
AOCOAlterColumnTestCase.test_alter_table_constraint_negative ... 132.08 ms
... FAIL
```
======================================================================
```
FAIL: AOCOAlterColumnTestCase.test_alter_part_add_part
----------------------------------------------------------------------
Traceback (most recent call last):
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 489, in
implied_test_function
result = my_self.run_test()
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 668, in run_test
self._run_and_verify_sql_file(sql_file, self._current_optimizer_mode)
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 733, in
_run_and_verify_sql_file
ans_file))
AssertionError: Failed with optimizer off: diffs during execution of sql:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/sql/alter_part_add_part.sql,
out_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/output/alter_part_add_part_planner.out,
ans_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/expected/alter_part_add_part.ans
======================================================================
FAIL: AOCOAlterColumnTestCase.test_alter_rollback
----------------------------------------------------------------------
Traceback (most recent call last):
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 489, in
implied_test_function
result = my_self.run_test()
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 668, in run_test
self._run_and_verify_sql_file(sql_file, self._current_optimizer_mode)
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 733, in
_run_and_verify_sql_file
ans_file))
AssertionError: Failed with optimizer off: diffs during execution of sql:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/sql/alter_rollback.sql,
out_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/output/alter_rollback_planner.out,
ans_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/expected/alter_rollback.ans
======================================================================
FAIL: AOCOAlterColumnTestCase.test_alter_table_check_negative
----------------------------------------------------------------------
Traceback (most recent call last):
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 489, in
implied_test_function
result = my_self.run_test()
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 668, in run_test
self._run_and_verify_sql_file(sql_file, self._current_optimizer_mode)
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 733, in
_run_and_verify_sql_file
ans_file))
AssertionError: Failed with optimizer off: diffs during execution of sql:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/sql/alter_table_check_negative.sql,
out_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/output/alter_table_check_negative_planner.out,
ans_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/expected/alter_table_check_negative.ans
======================================================================
FAIL: AOCOAlterColumnTestCase.test_alter_table_constraint_negative
----------------------------------------------------------------------
Traceback (most recent call last):
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 489, in
implied_test_function
result = my_self.run_test()
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 668, in run_test
self._run_and_verify_sql_file(sql_file, self._current_optimizer_mode)
File "/code/cbdb_testrepo_src/mpp/models/sql_tc.py", line 733, in
_run_and_verify_sql_file
ans_file))
AssertionError: Failed with optimizer off: diffs during execution of sql:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/sql/alter_table_constraint_negative.sql,
out_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/output/alter_table_constraint_negative_planner.out,
ans_file:
/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/expected/alter_table_constraint_negative.ans
----------------------------------------------------------------------
Ran 61 tests in 238.192s
FAILED (failures=4)
I saw this message in test output.
psql:/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/aoco_alter/aoco_alter_sql_test/output/alter_part_add_part_planner.sql:40:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
### What you think should happen instead
_No response_
### How to reproduce
Run the following command against TINC environment
```
/code/cbdb_testrepo_src/test_framework/tinc.py discover
mpp/gpdb/tests/storage/aoco_alter
```
### Operating System
centos7
### Anything else
_No response_
### Are you willing to submit PR?
- [ ] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
