Releases Notes and Announcements

Release Notes

Product Introduction

Overview

Strengths

Use Cases

Purchase Guide

Billing Overview

Billing Mode

Refund

Configuration Adjustments

Getting Started

Preparations

Creating a Private Cluster

Creating a SQL Job

Creating a JAR Job

Creating an ETL Job

Creating a Python Job

Operation Guide

Managing Jobs

Developing Jobs

Monitoring Jobs

Job Logs

Events and Diagnosis

Managing Metadata

Managing Checkpoints

Tuning Jobs

Managing Dependencies

Managing Clusters

Managing Permissions

SQL Developer Guide

Overview

Glossary and Data Types

DDL Statements

DML Statements

Merging MySQL CDC Sources

Connectors

SET Statement

Operators and Built-in Functions

Identifiers and Reserved Words

Python Developer Guide

ETL Developer Guide

Overview

Glossary

Connectors

FAQ

Logic Functions

PDF

Modo Foco

Tamanho da Fonte

Última atualização: 2023-11-08 14:20:13

Logical functions are used to perform logical operations, and the result is a Boolean value.
Three logical statuses are available: TRUE, FALSE, and UNKNOWN (represented by NULL). Therefore, NOT TRUE is not necessarily FALSE; it can also be UNKNOWN.
Function
Description
boolean1 OR boolean2
Returns TRUE if boolean1 or boolean2 is TRUE.
boolean1 AND boolean2
Returns TRUE if boolean1 and boolean2 are both TRUE.
NOT boolean
Returns TRUE if boolean is FALSE; returns FALSE if boolean is TRUE; returns UNKNOWN if boolean is UNKNOWN.
boolean IS FALSE
Returns TRUE if boolean is FALSE; returns FALSE if boolean is UNKNOWN.
boolean IS NOT FALSE
Returns TRUE if boolean is not FALSE; returns TRUE if boolean is UNKNOWN.
boolean IS UNKNOWN
Returns TRUE if boolean is UNKNOWN; otherwise FALSE.
boolean IS NOT UNKNOWN
Returns TRUE if boolean is not UNKNOWN; otherwise FALSE.
﻿

Ajuda e Suporte

Esta página foi útil?

Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.

comentários

tencent cloud

Stream Compute Service

Logic Functions

Ajuda e Suporte

Function	Description
boolean1 OR boolean2	Returns TRUE if `boolean1` or `boolean2` is TRUE.
boolean1 AND boolean2	Returns TRUE if `boolean1` and `boolean2` are both TRUE.
NOT boolean	Returns TRUE if `boolean` is FALSE; returns FALSE if `boolean` is TRUE; returns UNKNOWN if `boolean` is UNKNOWN.
boolean IS FALSE	Returns TRUE if `boolean` is FALSE; returns FALSE if `boolean` is UNKNOWN.
boolean IS NOT FALSE	Returns TRUE if `boolean` is not FALSE; returns TRUE if `boolean` is UNKNOWN.
boolean IS UNKNOWN	Returns TRUE if `boolean` is UNKNOWN; otherwise FALSE.
boolean IS NOT UNKNOWN	Returns TRUE if `boolean` is not UNKNOWN; otherwise FALSE.