Aes Encryption Test Run Report

DateOct 05, 2023 13:11
Duration9m 43s
Framework TestFlows 1.9.230315.1003122

Artifacts

Test artifacts can be found at https://altinity-test-reports.s3.amazonaws.com/index.html#clickhouse/23.3.13.7.altinitystable/6416627213/testflows/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.3/f040635d5f373c5e4be08e5fbec2622a9889adde/package_aarch64/clickhouse-common-static_23.3.13.7.altinitystable_arm64.deb
version23.3.13.7.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash19e8624c5e4ccc65b128d27b19836c0570e53991
job.id6416627213
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/6416627213
archaarch64
stressFalse
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.3/f040635d5f373c5e4be08e5fbec2622a9889adde/package_aarch64/clickhouse-common-static_23.3.13.7.altinitystable_arm64.deb
collect_service_logsTrue

Summary

77.6%OK
22.4%Known

Statistics

Units OK Fail Error XFail XError
Suites
13
13
Features
13
13
Scenarios
68
67
1
Examples
5728
4427
1235
66
Steps
53653
52019
1568
66

Known Fails

Test NameResultMessage
/aes encryption/compatibility/select/decrypt uniqueXFail 1s 212ms
https://github.com/ClickHouse/ClickHouse/issues/18249
AssertionError
Traceback (most recent call last):
  File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
    self._bootstrap_inner()
  File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "/usr/lib/python3.10/threading.py", line 953, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/aes_encryption/../aes_encryption/tests/compatibility/feature.py", line 14, in feature
    Feature(run=load("aes_encryption.tests.compatibility.select", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/aes_encryption/../aes_encryption/tests/compatibility/select.py", line 225, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/aes_encryption/../aes_encryption/tests/compatibility/select.py", line 176, in decrypt_unique
    encrypted_secret = node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/aes_encryption/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 23.3.13):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Invalid mode: aes-128-cfb128: While processing hex(encrypt('aes-128-cfb128', '[HIDDEN]')). (BAD_ARGUMENTS)
(query: SELECT hex(encrypt('aes-128-cfb128', 'secret', '1111111111111111'))
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/aes_encryption/../helpers/cluster.py', line 780 in 'query'

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

Results

Test Name Result Duration
/aes encryption OK 9m 43s
/aes encryption/encrypt OK 2m 25s
/aes encryption/encrypt/aad parameter types and length OK 4s 194ms
/aes encryption/decrypt OK 5m 48s
/aes encryption/decrypt/aad parameter types and length OK 4s 166ms
/aes encryption/encrypt_mysql OK 2m 22s
/aes encryption/encrypt_mysql/encryption OK 2m 12s
/aes encryption/decrypt_mysql OK 4m 44s
/aes encryption/decrypt_mysql/decryption OK 2m 12s
/aes encryption/compatibility OK 8m 37s
/aes encryption/compatibility/insert OK 2m 2s
/aes encryption/compatibility/insert/aes decrypt mysql using input table function OK 20s 430ms
/aes encryption/decrypt/decryption OK 2m 5s
/aes encryption/encrypt/encryption OK 2m 7s
/aes encryption/compatibility/insert/aes decrypt mysql using materialized view OK 147ms
/aes encryption/compatibility/insert/aes encrypt mysql using input table function OK 17s 136ms
/aes encryption/compatibility/insert/aes encrypt mysql using materialized view OK 25s 782ms
/aes encryption/compatibility/insert/decrypt using input table function OK 17s 68ms
/aes encryption/compatibility/insert/decrypt using materialized view OK 142ms
/aes encryption/compatibility/insert/encrypt using input table function OK 17s 454ms
/aes encryption/compatibility/insert/encrypt using materialized view OK 24s 410ms
/aes encryption/compatibility/select OK 54s 557ms
/aes encryption/compatibility/select/decrypt OK 18s 986ms
/aes encryption/decrypt/invalid ciphertext OK 1m 27s
/aes encryption/encrypt/invalid key or iv length for gcm OK 1s 308ms
/aes encryption/encrypt_mysql/invalid parameters OK 1s 696ms
/aes encryption/decrypt_mysql/invalid ciphertext OK 1m 19s
/aes encryption/encrypt/invalid key or iv length for mode non gcm OK 6s 516ms
/aes encryption/encrypt_mysql/invalid plaintext data type OK 2s 806ms
/aes encryption/encrypt_mysql/iv parameter types OK 507ms
/aes encryption/encrypt_mysql/key or iv length for mode OK 3s 782ms
/aes encryption/encrypt/invalid parameters OK 2s 81ms
/aes encryption/encrypt_mysql/key parameter types OK 396ms
/aes encryption/encrypt_mysql/mode parameter types OK 174ms
/aes encryption/compatibility/select/decrypt multiple OK 34s 356ms
/aes encryption/encrypt_mysql/return value OK 181ms
/aes encryption/encrypt_mysql/syntax OK 157ms
/aes encryption/encrypt_mysql/unsupported modes OK 714ms
/aes encryption/encrypt/invalid plaintext data type OK 2s 622ms
/aes encryption/encrypt/iv parameter types OK 377ms
/aes encryption/encrypt/key parameter types OK 367ms
/aes encryption/encrypt/mode parameter types OK 230ms
/aes encryption/encrypt/return value OK 179ms
/aes encryption/encrypt/syntax OK 85ms
/aes encryption/compatibility/select/decrypt unique XFail 1s 212ms
/aes encryption/compatibility/mysql OK 5m 40s
/aes encryption/compatibility/mysql/table engine OK 1m 45s
/aes encryption/compatibility/mysql/table engine/decrypt OK 52s 505ms
/aes encryption/decrypt_mysql/invalid parameters OK 1s 803ms
/aes encryption/decrypt_mysql/iv parameter types OK 379ms
/aes encryption/decrypt_mysql/key or iv length for mode OK 3s 945ms
/aes encryption/decrypt/invalid key or iv length for gcm OK 2s 86ms
/aes encryption/decrypt_mysql/key parameter types OK 376ms
/aes encryption/decrypt_mysql/mismatched iv OK 1s 817ms
/aes encryption/decrypt/invalid key or iv length for mode non gcm OK 6s 369ms
/aes encryption/decrypt_mysql/mismatched key OK 3s 629ms
/aes encryption/decrypt_mysql/mismatched mode OK 59s 715ms
/aes encryption/decrypt/invalid parameters OK 2s 302ms
/aes encryption/decrypt/iv parameter types OK 380ms
/aes encryption/decrypt/key parameter types OK 386ms
/aes encryption/decrypt/mismatched aad OK 371ms
/aes encryption/compatibility/mysql/table engine/encrypt OK 53s 408ms
/aes encryption/decrypt/mismatched iv OK 1s 991ms
/aes encryption/decrypt/mismatched key OK 3s 702ms
/aes encryption/decrypt/mismatched mode OK 1m 52s
/aes encryption/compatibility/mysql/database engine OK 1m 48s
/aes encryption/compatibility/mysql/database engine/decrypt OK 53s 667ms
/aes encryption/decrypt_mysql/mode parameter types OK 177ms
/aes encryption/decrypt_mysql/return value OK 173ms
/aes encryption/decrypt_mysql/syntax OK 109ms
/aes encryption/decrypt_mysql/unsupported modes OK 681ms
/aes encryption/compatibility/mysql/database engine/encrypt OK 55s 274ms
/aes encryption/decrypt/mode parameter types OK 178ms
/aes encryption/decrypt/return value OK 181ms
/aes encryption/decrypt/syntax OK 88ms
/aes encryption/compatibility/mysql/table function OK 1m 11s
/aes encryption/compatibility/mysql/table function/decrypt OK 35s 110ms
/aes encryption/compatibility/mysql/table function/encrypt OK 36s 482ms
/aes encryption/compatibility/mysql/dictionary OK 53s 591ms
/aes encryption/compatibility/mysql/dictionary/decrypt OK 52s 307ms
/aes encryption/compatibility/mysql/dictionary/parameter values OK 1s 267ms

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122