Description

Syntax

BOOLEAN assert_true(BOOLEAN condition, VarcharLiteral errmsg)

当 condition 为 true 时, 返回 true. 否则抛出一个异常，异常信息为 errmsg. errmsg 必须为字面量。

Example

  1. mysql> select assert_true(1, "wrong");
  2. +------------------------------------------+
  3. | assert_true(cast(1 as BOOLEAN), 'wrong') |
  4. +------------------------------------------+
  5. |                                        1 |
  6. +------------------------------------------+
  7. 1 row in set (0.12 sec)
  9. mysql> select assert_true(1, nullable("wrong"));
  10. ERROR 1105 (HY000): errCode = 2, detailMessage = assert_true only accept constant for 2nd argument
  11. mysql> select assert_true(0, "wrong");
  12. ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.8)[INVALID_ARGUMENT][E33] wrong
  13. mysql> select assert_true(null, "wrong");
  14. ERROR 1105 (HY000): errCode = 2, detailMessage = (10.16.10.8)[INVALID_ARGUMENT][E33] wrong

Keywords

  1. ASSERT_TRUE, ASSERT, TRUE