drop schema if exists eq_all_subquery cascade;
create schema eq_all_subquery;
set current_schema to 'eq_all_subquery';
set dolphin.b_compatibility_mode to on;
set dolphin.sql_mode to 'sql_mode_full_group,pipes_as_concat,ansi_quotes,no_zero_date';
drop table if exists test_multi_type_table;
CREATE TABLE test_multi_type_table(`int1` tinyint, `uint1` tinyint unsigned, `int2` smallint, `uint2` smallint unsigned, `int4` integer, `uint4` integer unsigned, `int8` bigint, `uint8` bigint unsigned, `float4` float4, `float8` float8, `numeric` decimal(20, 6), `bit1` bit(1), `bit64` bit(64), `boolean` boolean, `date` date, `time` time, `time(4)` time(4), `datetime` datetime, `datetime(4)` datetime(4) default '2022-11-11 11:11:11', `timestamp` timestamp, `timestamp(4)` timestamp(4) default '2022-11-11 11:11:11', `year` year, `char` char(100), `varchar` varchar(100), `binary` binary(100), `varbinary` varbinary(100), `tinyblob` tinyblob, `blob` blob, `mediumblob` mediumblob, `longblob` longblob, `text` text, `enum_t` enum('a', 'b', 'c'), `set_t` set('a', 'b', 'c'), `json` json);
INSERT INTO test_multi_type_table VALUES(1,1,1,1,1,1,1,1,1,1,1,b'1',b'1',true,'2023-02-05', '19:10:50', '19:10:50.3456', '2023-02-05 19:10:50', '2023-02-05 19:10:50.456', '2023-02-05 19:10:50', '2023-02-05 19:10:50.456', '2023', '1.23a', '1.23a', '1.23a', '1.23a', '1.23a', '1.23a', '1.23a', '1.23a', '1.23a', 'a', 'b,c', json_object('a',1,'b',1));
CREATE TABLE test_multi_type SELECT
`int1` = any (select `int1` from test_multi_type_table) AS `int1_eq_any_int1`,
`uint1` = any (select `uint1` from test_multi_type_table) AS `uint1_eq_any_uint1`,
`int2` = any (select `int2` from test_multi_type_table) AS `int2_eq_any_int2`,
`uint2` = any (select `uint2` from test_multi_type_table) AS `uint2_eq_any_uint2`,
`int4` = any (select `int4` from test_multi_type_table) AS `int4_eq_any_int4`,
`uint4` = any (select `uint4` from test_multi_type_table) AS `uint4_eq_any_uint4`,
`int8` = any (select `int8` from test_multi_type_table) AS `int8_eq_any_int8`,
`uint8` = any (select `uint8` from test_multi_type_table) AS `uint8_eq_any_uint8`,
`float4` = any (select `float4` from test_multi_type_table) AS `float4_eq_any_float4`,
`float8` = any (select `float8` from test_multi_type_table) AS `float8_eq_any_float8`,
`numeric` = any (select `numeric` from test_multi_type_table) AS `numeric_eq_any_numeric`,
`bit1` = any (select `bit1` from test_multi_type_table) AS `bit1_eq_any_bit1`,
`bit64` = any (select `bit64` from test_multi_type_table) AS `bit64_eq_any_bit64`,
`boolean` = any (select `boolean` from test_multi_type_table) AS `boolean_eq_any_boolean`,
`date` = any (select `date` from test_multi_type_table) AS `date_eq_any_date`,
`time` = any (select `time` from test_multi_type_table) AS `time_eq_any_time`,
`time(4)` = any (select `time(4)` from test_multi_type_table) AS `time(4)_eq_any_time(4)`,
`datetime` = any (select `datetime` from test_multi_type_table) AS `datetime_eq_any_datetime`,
`datetime(4)` = any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_eq_any_datetime(4)`,
`timestamp` = any (select `timestamp` from test_multi_type_table) AS `timestamp_eq_any_timestamp`,
`timestamp(4)` = any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_eq_any_timestamp(4)`,
`year` = any (select `year` from test_multi_type_table) AS `year_eq_any_year`,
`char` = any (select `char` from test_multi_type_table) AS `char_eq_any_char`,
`varchar` = any (select `varchar` from test_multi_type_table) AS `varchar_eq_any_varchar`,
`binary` = any (select `binary` from test_multi_type_table) AS `binary_eq_any_binary`,
`varbinary` = any (select `varbinary` from test_multi_type_table) AS `varbinary_eq_any_varbinary`,
`tinyblob` = any (select `tinyblob` from test_multi_type_table) AS `tinyblob_eq_any_tinyblob`,
`blob` = any (select `blob` from test_multi_type_table) AS `blob_eq_any_blob`,
`mediumblob` = any (select `mediumblob` from test_multi_type_table) AS `mediumblob_eq_any_mediumblob`,
`longblob` = any (select `longblob` from test_multi_type_table) AS `longblob_eq_any_longblob`,
`text` = any (select `text` from test_multi_type_table) AS `text_eq_any_text`,
`enum_t` = any (select `enum_t` from test_multi_type_table) AS `enum_t_eq_any_enum_t`,
`set_t` = any (select `set_t` from test_multi_type_table) AS `set_t_eq_any_set_t`,
`json` = any (select `json` from test_multi_type_table) AS `json_eq_any_json`,
`int1` >= any (select `int1` from test_multi_type_table) AS `int1_ge_any_int1`,
`uint1` >= any (select `uint1` from test_multi_type_table) AS `uint1_ge_any_uint1`,
`int2` >= any (select `int2` from test_multi_type_table) AS `int2_ge_any_int2`,
`uint2` >= any (select `uint2` from test_multi_type_table) AS `uint2_ge_any_uint2`,
`int4` >= any (select `int4` from test_multi_type_table) AS `int4_ge_any_int4`,
`uint4` >= any (select `uint4` from test_multi_type_table) AS `uint4_ge_any_uint4`,
`int8` >= any (select `int8` from test_multi_type_table) AS `int8_ge_any_int8`,
`uint8` >= any (select `uint8` from test_multi_type_table) AS `uint8_ge_any_uint8`,
`float4` >= any (select `float4` from test_multi_type_table) AS `float4_ge_any_float4`,
`float8` >= any (select `float8` from test_multi_type_table) AS `float8_ge_any_float8`,
`numeric` >= any (select `numeric` from test_multi_type_table) AS `numeric_ge_any_numeric`,
`bit1` >= any (select `bit1` from test_multi_type_table) AS `bit1_ge_any_bit1`,
`bit64` >= any (select `bit64` from test_multi_type_table) AS `bit64_ge_any_bit64`,
`boolean` >= any (select `boolean` from test_multi_type_table) AS `boolean_ge_any_boolean`,
`date` >= any (select `date` from test_multi_type_table) AS `date_ge_any_date`,
`time` >= any (select `time` from test_multi_type_table) AS `time_ge_any_time`,
`time(4)` >= any (select `time(4)` from test_multi_type_table) AS `time(4)_ge_any_time(4)`,
`datetime` >= any (select `datetime` from test_multi_type_table) AS `datetime_ge_any_datetime`,
`datetime(4)` >= any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_ge_any_datetime(4)`,
`timestamp` >= any (select `timestamp` from test_multi_type_table) AS `timestamp_ge_any_timestamp`,
`timestamp(4)` >= any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_ge_any_timestamp(4)`,
`year` >= any (select `year` from test_multi_type_table) AS `year_ge_any_year`,
`char` >= any (select `char` from test_multi_type_table) AS `char_ge_any_char`,
`varchar` >= any (select `varchar` from test_multi_type_table) AS `varchar_ge_any_varchar`,
`binary` >= any (select `binary` from test_multi_type_table) AS `binary_ge_any_binary`,
`varbinary` >= any (select `varbinary` from test_multi_type_table) AS `varbinary_ge_any_varbinary`,
`tinyblob` >= any (select `tinyblob` from test_multi_type_table) AS `tinyblob_ge_any_tinyblob`,
`blob` >= any (select `blob` from test_multi_type_table) AS `blob_ge_any_blob`,
`mediumblob` >= any (select `mediumblob` from test_multi_type_table) AS `mediumblob_ge_any_mediumblob`,
`longblob` >= any (select `longblob` from test_multi_type_table) AS `longblob_ge_any_longblob`,
`text` >= any (select `text` from test_multi_type_table) AS `text_ge_any_text`,
`enum_t` >= any (select `enum_t` from test_multi_type_table) AS `enum_t_ge_any_enum_t`,
`set_t` >= any (select `set_t` from test_multi_type_table) AS `set_t_ge_any_set_t`,
`json` >= any (select `json` from test_multi_type_table) AS `json_ge_any_json`,
`int1` > any (select `int1` from test_multi_type_table) AS `int1_gt_any_int1`,
`uint1` > any (select `uint1` from test_multi_type_table) AS `uint1_gt_any_uint1`,
`int2` > any (select `int2` from test_multi_type_table) AS `int2_gt_any_int2`,
`uint2` > any (select `uint2` from test_multi_type_table) AS `uint2_gt_any_uint2`,
`int4` > any (select `int4` from test_multi_type_table) AS `int4_gt_any_int4`,
`uint4` > any (select `uint4` from test_multi_type_table) AS `uint4_gt_any_uint4`,
`int8` > any (select `int8` from test_multi_type_table) AS `int8_gt_any_int8`,
`uint8` > any (select `uint8` from test_multi_type_table) AS `uint8_gt_any_uint8`,
`float4` > any (select `float4` from test_multi_type_table) AS `float4_gt_any_float4`,
`float8` > any (select `float8` from test_multi_type_table) AS `float8_gt_any_float8`,
`numeric` > any (select `numeric` from test_multi_type_table) AS `numeric_gt_any_numeric`,
`bit1` > any (select `bit1` from test_multi_type_table) AS `bit1_gt_any_bit1`,
`bit64` > any (select `bit64` from test_multi_type_table) AS `bit64_gt_any_bit64`,
`boolean` > any (select `boolean` from test_multi_type_table) AS `boolean_gt_any_boolean`,
`date` > any (select `date` from test_multi_type_table) AS `date_gt_any_date`,
`time` > any (select `time` from test_multi_type_table) AS `time_gt_any_time`,
`time(4)` > any (select `time(4)` from test_multi_type_table) AS `time(4)_gt_any_time(4)`,
`datetime` > any (select `datetime` from test_multi_type_table) AS `datetime_gt_any_datetime`,
`datetime(4)` > any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_gt_any_datetime(4)`,
`timestamp` > any (select `timestamp` from test_multi_type_table) AS `timestamp_gt_any_timestamp`,
`timestamp(4)` > any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_gt_any_timestamp(4)`,
`year` > any (select `year` from test_multi_type_table) AS `year_gt_any_year`,
`char` > any (select `char` from test_multi_type_table) AS `char_gt_any_char`,
`varchar` > any (select `varchar` from test_multi_type_table) AS `varchar_gt_any_varchar`,
`binary` > any (select `binary` from test_multi_type_table) AS `binary_gt_any_binary`,
`varbinary` > any (select `varbinary` from test_multi_type_table) AS `varbinary_gt_any_varbinary`,
`tinyblob` > any (select `tinyblob` from test_multi_type_table) AS `tinyblob_gt_any_tinyblob`,
`blob` > any (select `blob` from test_multi_type_table) AS `blob_gt_any_blob`,
`mediumblob` > any (select `mediumblob` from test_multi_type_table) AS `mediumblob_gt_any_mediumblob`,
`longblob` > any (select `longblob` from test_multi_type_table) AS `longblob_gt_any_longblob`,
`text` > any (select `text` from test_multi_type_table) AS `text_gt_any_text`,
`enum_t` > any (select `enum_t` from test_multi_type_table) AS `enum_t_gt_any_enum_t`,
`set_t` > any (select `set_t` from test_multi_type_table) AS `set_t_gt_any_set_t`,
`json` > any (select `json` from test_multi_type_table) AS `json_gt_any_json`,
`int1` <= any (select `int1` from test_multi_type_table) AS `int1_le_any_int1`,
`uint1` <= any (select `uint1` from test_multi_type_table) AS `uint1_le_any_uint1`,
`int2` <= any (select `int2` from test_multi_type_table) AS `int2_le_any_int2`,
`uint2` <= any (select `uint2` from test_multi_type_table) AS `uint2_le_any_uint2`,
`int4` <= any (select `int4` from test_multi_type_table) AS `int4_le_any_int4`,
`uint4` <= any (select `uint4` from test_multi_type_table) AS `uint4_le_any_uint4`,
`int8` <= any (select `int8` from test_multi_type_table) AS `int8_le_any_int8`,
`uint8` <= any (select `uint8` from test_multi_type_table) AS `uint8_le_any_uint8`,
`float4` <= any (select `float4` from test_multi_type_table) AS `float4_le_any_float4`,
`float8` <= any (select `float8` from test_multi_type_table) AS `float8_le_any_float8`,
`numeric` <= any (select `numeric` from test_multi_type_table) AS `numeric_le_any_numeric`,
`bit1` <= any (select `bit1` from test_multi_type_table) AS `bit1_le_any_bit1`,
`bit64` <= any (select `bit64` from test_multi_type_table) AS `bit64_le_any_bit64`,
`boolean` <= any (select `boolean` from test_multi_type_table) AS `boolean_le_any_boolean`,
`date` <= any (select `date` from test_multi_type_table) AS `date_le_any_date`,
`time` <= any (select `time` from test_multi_type_table) AS `time_le_any_time`,
`time(4)` <= any (select `time(4)` from test_multi_type_table) AS `time(4)_le_any_time(4)`,
`datetime` <= any (select `datetime` from test_multi_type_table) AS `datetime_le_any_datetime`,
`datetime(4)` <= any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_le_any_datetime(4)`,
`timestamp` <= any (select `timestamp` from test_multi_type_table) AS `timestamp_le_any_timestamp`,
`timestamp(4)` <= any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_le_any_timestamp(4)`,
`year` <= any (select `year` from test_multi_type_table) AS `year_le_any_year`,
`char` <= any (select `char` from test_multi_type_table) AS `char_le_any_char`,
`varchar` <= any (select `varchar` from test_multi_type_table) AS `varchar_le_any_varchar`,
`binary` <= any (select `binary` from test_multi_type_table) AS `binary_le_any_binary`,
`varbinary` <= any (select `varbinary` from test_multi_type_table) AS `varbinary_le_any_varbinary`,
`tinyblob` <= any (select `tinyblob` from test_multi_type_table) AS `tinyblob_le_any_tinyblob`,
`blob` <= any (select `blob` from test_multi_type_table) AS `blob_le_any_blob`,
`mediumblob` <= any (select `mediumblob` from test_multi_type_table) AS `mediumblob_le_any_mediumblob`,
`longblob` <= any (select `longblob` from test_multi_type_table) AS `longblob_le_any_longblob`,
`text` <= any (select `text` from test_multi_type_table) AS `text_le_any_text`,
`enum_t` <= any (select `enum_t` from test_multi_type_table) AS `enum_t_le_any_enum_t`,
`set_t` <= any (select `set_t` from test_multi_type_table) AS `set_t_le_any_set_t`,
`json` <= any (select `json` from test_multi_type_table) AS `json_le_any_json`,
`int1` < any (select `int1` from test_multi_type_table) AS `int1_lt_any_int1`,
`uint1` < any (select `uint1` from test_multi_type_table) AS `uint1_lt_any_uint1`,
`int2` < any (select `int2` from test_multi_type_table) AS `int2_lt_any_int2`,
`uint2` < any (select `uint2` from test_multi_type_table) AS `uint2_lt_any_uint2`,
`int4` < any (select `int4` from test_multi_type_table) AS `int4_lt_any_int4`,
`uint4` < any (select `uint4` from test_multi_type_table) AS `uint4_lt_any_uint4`,
`int8` < any (select `int8` from test_multi_type_table) AS `int8_lt_any_int8`,
`uint8` < any (select `uint8` from test_multi_type_table) AS `uint8_lt_any_uint8`,
`float4` < any (select `float4` from test_multi_type_table) AS `float4_lt_any_float4`,
`float8` < any (select `float8` from test_multi_type_table) AS `float8_lt_any_float8`,
`numeric` < any (select `numeric` from test_multi_type_table) AS `numeric_lt_any_numeric`,
`bit1` < any (select `bit1` from test_multi_type_table) AS `bit1_lt_any_bit1`,
`bit64` < any (select `bit64` from test_multi_type_table) AS `bit64_lt_any_bit64`,
`boolean` < any (select `boolean` from test_multi_type_table) AS `boolean_lt_any_boolean`,
`date` < any (select `date` from test_multi_type_table) AS `date_lt_any_date`,
`time` < any (select `time` from test_multi_type_table) AS `time_lt_any_time`,
`time(4)` < any (select `time(4)` from test_multi_type_table) AS `time(4)_lt_any_time(4)`,
`datetime` < any (select `datetime` from test_multi_type_table) AS `datetime_lt_any_datetime`,
`datetime(4)` < any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_lt_any_datetime(4)`,
`timestamp` < any (select `timestamp` from test_multi_type_table) AS `timestamp_lt_any_timestamp`,
`timestamp(4)` < any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_lt_any_timestamp(4)`,
`year` < any (select `year` from test_multi_type_table) AS `year_lt_any_year`,
`char` < any (select `char` from test_multi_type_table) AS `char_lt_any_char`,
`varchar` < any (select `varchar` from test_multi_type_table) AS `varchar_lt_any_varchar`,
`binary` < any (select `binary` from test_multi_type_table) AS `binary_lt_any_binary`,
`varbinary` < any (select `varbinary` from test_multi_type_table) AS `varbinary_lt_any_varbinary`,
`tinyblob` < any (select `tinyblob` from test_multi_type_table) AS `tinyblob_lt_any_tinyblob`,
`blob` < any (select `blob` from test_multi_type_table) AS `blob_lt_any_blob`,
`mediumblob` < any (select `mediumblob` from test_multi_type_table) AS `mediumblob_lt_any_mediumblob`,
`longblob` < any (select `longblob` from test_multi_type_table) AS `longblob_lt_any_longblob`,
`text` < any (select `text` from test_multi_type_table) AS `text_lt_any_text`,
`enum_t` < any (select `enum_t` from test_multi_type_table) AS `enum_t_lt_any_enum_t`,
`set_t` < any (select `set_t` from test_multi_type_table) AS `set_t_lt_any_set_t`,
`json` < any (select `json` from test_multi_type_table) AS `json_lt_any_json`,
`int1` <> any (select `int1` from test_multi_type_table) AS `int1_lg_any_int1`,
`uint1` <> any (select `uint1` from test_multi_type_table) AS `uint1_lg_any_uint1`,
`int2` <> any (select `int2` from test_multi_type_table) AS `int2_lg_any_int2`,
`uint2` <> any (select `uint2` from test_multi_type_table) AS `uint2_lg_any_uint2`,
`int4` <> any (select `int4` from test_multi_type_table) AS `int4_lg_any_int4`,
`uint4` <> any (select `uint4` from test_multi_type_table) AS `uint4_lg_any_uint4`,
`int8` <> any (select `int8` from test_multi_type_table) AS `int8_lg_any_int8`,
`uint8` <> any (select `uint8` from test_multi_type_table) AS `uint8_lg_any_uint8`,
`float4` <> any (select `float4` from test_multi_type_table) AS `float4_lg_any_float4`,
`float8` <> any (select `float8` from test_multi_type_table) AS `float8_lg_any_float8`,
`numeric` <> any (select `numeric` from test_multi_type_table) AS `numeric_lg_any_numeric`,
`bit1` <> any (select `bit1` from test_multi_type_table) AS `bit1_lg_any_bit1`,
`bit64` <> any (select `bit64` from test_multi_type_table) AS `bit64_lg_any_bit64`,
`boolean` <> any (select `boolean` from test_multi_type_table) AS `boolean_lg_any_boolean`,
`date` <> any (select `date` from test_multi_type_table) AS `date_lg_any_date`,
`time` <> any (select `time` from test_multi_type_table) AS `time_lg_any_time`,
`time(4)` <> any (select `time(4)` from test_multi_type_table) AS `time(4)_lg_any_time(4)`,
`datetime` <> any (select `datetime` from test_multi_type_table) AS `datetime_lg_any_datetime`,
`datetime(4)` <> any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_lg_any_datetime(4)`,
`timestamp` <> any (select `timestamp` from test_multi_type_table) AS `timestamp_lg_any_timestamp`,
`timestamp(4)` <> any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_lg_any_timestamp(4)`,
`year` <> any (select `year` from test_multi_type_table) AS `year_lg_any_year`,
`char` <> any (select `char` from test_multi_type_table) AS `char_lg_any_char`,
`varchar` <> any (select `varchar` from test_multi_type_table) AS `varchar_lg_any_varchar`,
`binary` <> any (select `binary` from test_multi_type_table) AS `binary_lg_any_binary`,
`varbinary` <> any (select `varbinary` from test_multi_type_table) AS `varbinary_lg_any_varbinary`,
`tinyblob` <> any (select `tinyblob` from test_multi_type_table) AS `tinyblob_lg_any_tinyblob`,
`blob` <> any (select `blob` from test_multi_type_table) AS `blob_lg_any_blob`,
`mediumblob` <> any (select `mediumblob` from test_multi_type_table) AS `mediumblob_lg_any_mediumblob`,
`longblob` <> any (select `longblob` from test_multi_type_table) AS `longblob_lg_any_longblob`,
`text` <> any (select `text` from test_multi_type_table) AS `text_lg_any_text`,
`enum_t` <> any (select `enum_t` from test_multi_type_table) AS `enum_t_lg_any_enum_t`,
`set_t` <> any (select `set_t` from test_multi_type_table) AS `set_t_lg_any_set_t`,
`json` <> any (select `json` from test_multi_type_table) AS `json_lg_any_json`,
`int1` != any (select `int1` from test_multi_type_table) AS `int1_ne_any_int1`,
`uint1` != any (select `uint1` from test_multi_type_table) AS `uint1_ne_any_uint1`,
`int2` != any (select `int2` from test_multi_type_table) AS `int2_ne_any_int2`,
`uint2` != any (select `uint2` from test_multi_type_table) AS `uint2_ne_any_uint2`,
`int4` != any (select `int4` from test_multi_type_table) AS `int4_ne_any_int4`,
`uint4` != any (select `uint4` from test_multi_type_table) AS `uint4_ne_any_uint4`,
`int8` != any (select `int8` from test_multi_type_table) AS `int8_ne_any_int8`,
`uint8` != any (select `uint8` from test_multi_type_table) AS `uint8_ne_any_uint8`,
`float4` != any (select `float4` from test_multi_type_table) AS `float4_ne_any_float4`,
`float8` != any (select `float8` from test_multi_type_table) AS `float8_ne_any_float8`,
`numeric` != any (select `numeric` from test_multi_type_table) AS `numeric_ne_any_numeric`,
`bit1` != any (select `bit1` from test_multi_type_table) AS `bit1_ne_any_bit1`,
`bit64` != any (select `bit64` from test_multi_type_table) AS `bit64_ne_any_bit64`,
`boolean` != any (select `boolean` from test_multi_type_table) AS `boolean_ne_any_boolean`,
`date` != any (select `date` from test_multi_type_table) AS `date_ne_any_date`,
`time` != any (select `time` from test_multi_type_table) AS `time_ne_any_time`,
`time(4)` != any (select `time(4)` from test_multi_type_table) AS `time(4)_ne_any_time(4)`,
`datetime` != any (select `datetime` from test_multi_type_table) AS `datetime_ne_any_datetime`,
`datetime(4)` != any (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_ne_any_datetime(4)`,
`timestamp` != any (select `timestamp` from test_multi_type_table) AS `timestamp_ne_any_timestamp`,
`timestamp(4)` != any (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_ne_any_timestamp(4)`,
`year` != any (select `year` from test_multi_type_table) AS `year_ne_any_year`,
`char` != any (select `char` from test_multi_type_table) AS `char_ne_any_char`,
`varchar` != any (select `varchar` from test_multi_type_table) AS `varchar_ne_any_varchar`,
`binary` != any (select `binary` from test_multi_type_table) AS `binary_ne_any_binary`,
`varbinary` != any (select `varbinary` from test_multi_type_table) AS `varbinary_ne_any_varbinary`,
`tinyblob` != any (select `tinyblob` from test_multi_type_table) AS `tinyblob_ne_any_tinyblob`,
`blob` != any (select `blob` from test_multi_type_table) AS `blob_ne_any_blob`,
`mediumblob` != any (select `mediumblob` from test_multi_type_table) AS `mediumblob_ne_any_mediumblob`,
`longblob` != any (select `longblob` from test_multi_type_table) AS `longblob_ne_any_longblob`,
`text` != any (select `text` from test_multi_type_table) AS `text_ne_any_text`,
`enum_t` != any (select `enum_t` from test_multi_type_table) AS `enum_t_ne_any_enum_t`,
`set_t` != any (select `set_t` from test_multi_type_table) AS `set_t_ne_any_set_t`,
`json` != any (select `json` from test_multi_type_table) AS `json_ne_any_json`
from test_multi_type_table;
\x
select * from test_multi_type;
drop table test_multi_type;
CREATE TABLE test_multi_type SELECT
`int1` = all (select `int1` from test_multi_type_table) AS `int1_eq_all_int1`,
`uint1` = all (select `uint1` from test_multi_type_table) AS `uint1_eq_all_uint1`,
`int2` = all (select `int2` from test_multi_type_table) AS `int2_eq_all_int2`,
`uint2` = all (select `uint2` from test_multi_type_table) AS `uint2_eq_all_uint2`,
`int4` = all (select `int4` from test_multi_type_table) AS `int4_eq_all_int4`,
`uint4` = all (select `uint4` from test_multi_type_table) AS `uint4_eq_all_uint4`,
`int8` = all (select `int8` from test_multi_type_table) AS `int8_eq_all_int8`,
`uint8` = all (select `uint8` from test_multi_type_table) AS `uint8_eq_all_uint8`,
`float4` = all (select `float4` from test_multi_type_table) AS `float4_eq_all_float4`,
`float8` = all (select `float8` from test_multi_type_table) AS `float8_eq_all_float8`,
`numeric` = all (select `numeric` from test_multi_type_table) AS `numeric_eq_all_numeric`,
`bit1` = all (select `bit1` from test_multi_type_table) AS `bit1_eq_all_bit1`,
`bit64` = all (select `bit64` from test_multi_type_table) AS `bit64_eq_all_bit64`,
`boolean` = all (select `boolean` from test_multi_type_table) AS `boolean_eq_all_boolean`,
`date` = all (select `date` from test_multi_type_table) AS `date_eq_all_date`,
`time` = all (select `time` from test_multi_type_table) AS `time_eq_all_time`,
`time(4)` = all (select `time(4)` from test_multi_type_table) AS `time(4)_eq_all_time(4)`,
`datetime` = all (select `datetime` from test_multi_type_table) AS `datetime_eq_all_datetime`,
`datetime(4)` = all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_eq_all_datetime(4)`,
`timestamp` = all (select `timestamp` from test_multi_type_table) AS `timestamp_eq_all_timestamp`,
`timestamp(4)` = all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_eq_all_timestamp(4)`,
`year` = all (select `year` from test_multi_type_table) AS `year_eq_all_year`,
`char` = all (select `char` from test_multi_type_table) AS `char_eq_all_char`,
`varchar` = all (select `varchar` from test_multi_type_table) AS `varchar_eq_all_varchar`,
`binary` = all (select `binary` from test_multi_type_table) AS `binary_eq_all_binary`,
`varbinary` = all (select `varbinary` from test_multi_type_table) AS `varbinary_eq_all_varbinary`,
`tinyblob` = all (select `tinyblob` from test_multi_type_table) AS `tinyblob_eq_all_tinyblob`,
`blob` = all (select `blob` from test_multi_type_table) AS `blob_eq_all_blob`,
`mediumblob` = all (select `mediumblob` from test_multi_type_table) AS `mediumblob_eq_all_mediumblob`,
`longblob` = all (select `longblob` from test_multi_type_table) AS `longblob_eq_all_longblob`,
`text` = all (select `text` from test_multi_type_table) AS `text_eq_all_text`,
`enum_t` = all (select `enum_t` from test_multi_type_table) AS `enum_t_eq_all_enum_t`,
`set_t` = all (select `set_t` from test_multi_type_table) AS `set_t_eq_all_set_t`,
`json` = all (select `json` from test_multi_type_table) AS `json_eq_all_json`,
`int1` >= all (select `int1` from test_multi_type_table) AS `int1_ge_all_int1`,
`uint1` >= all (select `uint1` from test_multi_type_table) AS `uint1_ge_all_uint1`,
`int2` >= all (select `int2` from test_multi_type_table) AS `int2_ge_all_int2`,
`uint2` >= all (select `uint2` from test_multi_type_table) AS `uint2_ge_all_uint2`,
`int4` >= all (select `int4` from test_multi_type_table) AS `int4_ge_all_int4`,
`uint4` >= all (select `uint4` from test_multi_type_table) AS `uint4_ge_all_uint4`,
`int8` >= all (select `int8` from test_multi_type_table) AS `int8_ge_all_int8`,
`uint8` >= all (select `uint8` from test_multi_type_table) AS `uint8_ge_all_uint8`,
`float4` >= all (select `float4` from test_multi_type_table) AS `float4_ge_all_float4`,
`float8` >= all (select `float8` from test_multi_type_table) AS `float8_ge_all_float8`,
`numeric` >= all (select `numeric` from test_multi_type_table) AS `numeric_ge_all_numeric`,
`bit1` >= all (select `bit1` from test_multi_type_table) AS `bit1_ge_all_bit1`,
`bit64` >= all (select `bit64` from test_multi_type_table) AS `bit64_ge_all_bit64`,
`boolean` >= all (select `boolean` from test_multi_type_table) AS `boolean_ge_all_boolean`,
`date` >= all (select `date` from test_multi_type_table) AS `date_ge_all_date`,
`time` >= all (select `time` from test_multi_type_table) AS `time_ge_all_time`,
`time(4)` >= all (select `time(4)` from test_multi_type_table) AS `time(4)_ge_all_time(4)`,
`datetime` >= all (select `datetime` from test_multi_type_table) AS `datetime_ge_all_datetime`,
`datetime(4)` >= all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_ge_all_datetime(4)`,
`timestamp` >= all (select `timestamp` from test_multi_type_table) AS `timestamp_ge_all_timestamp`,
`timestamp(4)` >= all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_ge_all_timestamp(4)`,
`year` >= all (select `year` from test_multi_type_table) AS `year_ge_all_year`,
`char` >= all (select `char` from test_multi_type_table) AS `char_ge_all_char`,
`varchar` >= all (select `varchar` from test_multi_type_table) AS `varchar_ge_all_varchar`,
`binary` >= all (select `binary` from test_multi_type_table) AS `binary_ge_all_binary`,
`varbinary` >= all (select `varbinary` from test_multi_type_table) AS `varbinary_ge_all_varbinary`,
`tinyblob` >= all (select `tinyblob` from test_multi_type_table) AS `tinyblob_ge_all_tinyblob`,
`blob` >= all (select `blob` from test_multi_type_table) AS `blob_ge_all_blob`,
`mediumblob` >= all (select `mediumblob` from test_multi_type_table) AS `mediumblob_ge_all_mediumblob`,
`longblob` >= all (select `longblob` from test_multi_type_table) AS `longblob_ge_all_longblob`,
`text` >= all (select `text` from test_multi_type_table) AS `text_ge_all_text`,
`enum_t` >= all (select `enum_t` from test_multi_type_table) AS `enum_t_ge_all_enum_t`,
`set_t` >= all (select `set_t` from test_multi_type_table) AS `set_t_ge_all_set_t`,
`json` >= all (select `json` from test_multi_type_table) AS `json_ge_all_json`,
`int1` > all (select `int1` from test_multi_type_table) AS `int1_gt_all_int1`,
`uint1` > all (select `uint1` from test_multi_type_table) AS `uint1_gt_all_uint1`,
`int2` > all (select `int2` from test_multi_type_table) AS `int2_gt_all_int2`,
`uint2` > all (select `uint2` from test_multi_type_table) AS `uint2_gt_all_uint2`,
`int4` > all (select `int4` from test_multi_type_table) AS `int4_gt_all_int4`,
`uint4` > all (select `uint4` from test_multi_type_table) AS `uint4_gt_all_uint4`,
`int8` > all (select `int8` from test_multi_type_table) AS `int8_gt_all_int8`,
`uint8` > all (select `uint8` from test_multi_type_table) AS `uint8_gt_all_uint8`,
`float4` > all (select `float4` from test_multi_type_table) AS `float4_gt_all_float4`,
`float8` > all (select `float8` from test_multi_type_table) AS `float8_gt_all_float8`,
`numeric` > all (select `numeric` from test_multi_type_table) AS `numeric_gt_all_numeric`,
`bit1` > all (select `bit1` from test_multi_type_table) AS `bit1_gt_all_bit1`,
`bit64` > all (select `bit64` from test_multi_type_table) AS `bit64_gt_all_bit64`,
`boolean` > all (select `boolean` from test_multi_type_table) AS `boolean_gt_all_boolean`,
`date` > all (select `date` from test_multi_type_table) AS `date_gt_all_date`,
`time` > all (select `time` from test_multi_type_table) AS `time_gt_all_time`,
`time(4)` > all (select `time(4)` from test_multi_type_table) AS `time(4)_gt_all_time(4)`,
`datetime` > all (select `datetime` from test_multi_type_table) AS `datetime_gt_all_datetime`,
`datetime(4)` > all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_gt_all_datetime(4)`,
`timestamp` > all (select `timestamp` from test_multi_type_table) AS `timestamp_gt_all_timestamp`,
`timestamp(4)` > all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_gt_all_timestamp(4)`,
`year` > all (select `year` from test_multi_type_table) AS `year_gt_all_year`,
`char` > all (select `char` from test_multi_type_table) AS `char_gt_all_char`,
`varchar` > all (select `varchar` from test_multi_type_table) AS `varchar_gt_all_varchar`,
`binary` > all (select `binary` from test_multi_type_table) AS `binary_gt_all_binary`,
`varbinary` > all (select `varbinary` from test_multi_type_table) AS `varbinary_gt_all_varbinary`,
`tinyblob` > all (select `tinyblob` from test_multi_type_table) AS `tinyblob_gt_all_tinyblob`,
`blob` > all (select `blob` from test_multi_type_table) AS `blob_gt_all_blob`,
`mediumblob` > all (select `mediumblob` from test_multi_type_table) AS `mediumblob_gt_all_mediumblob`,
`longblob` > all (select `longblob` from test_multi_type_table) AS `longblob_gt_all_longblob`,
`text` > all (select `text` from test_multi_type_table) AS `text_gt_all_text`,
`enum_t` > all (select `enum_t` from test_multi_type_table) AS `enum_t_gt_all_enum_t`,
`set_t` > all (select `set_t` from test_multi_type_table) AS `set_t_gt_all_set_t`,
`json` > all (select `json` from test_multi_type_table) AS `json_gt_all_json`,
`int1` <= all (select `int1` from test_multi_type_table) AS `int1_le_all_int1`,
`uint1` <= all (select `uint1` from test_multi_type_table) AS `uint1_le_all_uint1`,
`int2` <= all (select `int2` from test_multi_type_table) AS `int2_le_all_int2`,
`uint2` <= all (select `uint2` from test_multi_type_table) AS `uint2_le_all_uint2`,
`int4` <= all (select `int4` from test_multi_type_table) AS `int4_le_all_int4`,
`uint4` <= all (select `uint4` from test_multi_type_table) AS `uint4_le_all_uint4`,
`int8` <= all (select `int8` from test_multi_type_table) AS `int8_le_all_int8`,
`uint8` <= all (select `uint8` from test_multi_type_table) AS `uint8_le_all_uint8`,
`float4` <= all (select `float4` from test_multi_type_table) AS `float4_le_all_float4`,
`float8` <= all (select `float8` from test_multi_type_table) AS `float8_le_all_float8`,
`numeric` <= all (select `numeric` from test_multi_type_table) AS `numeric_le_all_numeric`,
`bit1` <= all (select `bit1` from test_multi_type_table) AS `bit1_le_all_bit1`,
`bit64` <= all (select `bit64` from test_multi_type_table) AS `bit64_le_all_bit64`,
`boolean` <= all (select `boolean` from test_multi_type_table) AS `boolean_le_all_boolean`,
`date` <= all (select `date` from test_multi_type_table) AS `date_le_all_date`,
`time` <= all (select `time` from test_multi_type_table) AS `time_le_all_time`,
`time(4)` <= all (select `time(4)` from test_multi_type_table) AS `time(4)_le_all_time(4)`,
`datetime` <= all (select `datetime` from test_multi_type_table) AS `datetime_le_all_datetime`,
`datetime(4)` <= all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_le_all_datetime(4)`,
`timestamp` <= all (select `timestamp` from test_multi_type_table) AS `timestamp_le_all_timestamp`,
`timestamp(4)` <= all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_le_all_timestamp(4)`,
`year` <= all (select `year` from test_multi_type_table) AS `year_le_all_year`,
`char` <= all (select `char` from test_multi_type_table) AS `char_le_all_char`,
`varchar` <= all (select `varchar` from test_multi_type_table) AS `varchar_le_all_varchar`,
`binary` <= all (select `binary` from test_multi_type_table) AS `binary_le_all_binary`,
`varbinary` <= all (select `varbinary` from test_multi_type_table) AS `varbinary_le_all_varbinary`,
`tinyblob` <= all (select `tinyblob` from test_multi_type_table) AS `tinyblob_le_all_tinyblob`,
`blob` <= all (select `blob` from test_multi_type_table) AS `blob_le_all_blob`,
`mediumblob` <= all (select `mediumblob` from test_multi_type_table) AS `mediumblob_le_all_mediumblob`,
`longblob` <= all (select `longblob` from test_multi_type_table) AS `longblob_le_all_longblob`,
`text` <= all (select `text` from test_multi_type_table) AS `text_le_all_text`,
`enum_t` <= all (select `enum_t` from test_multi_type_table) AS `enum_t_le_all_enum_t`,
`set_t` <= all (select `set_t` from test_multi_type_table) AS `set_t_le_all_set_t`,
`json` <= all (select `json` from test_multi_type_table) AS `json_le_all_json`,
`int1` < all (select `int1` from test_multi_type_table) AS `int1_lt_all_int1`,
`uint1` < all (select `uint1` from test_multi_type_table) AS `uint1_lt_all_uint1`,
`int2` < all (select `int2` from test_multi_type_table) AS `int2_lt_all_int2`,
`uint2` < all (select `uint2` from test_multi_type_table) AS `uint2_lt_all_uint2`,
`int4` < all (select `int4` from test_multi_type_table) AS `int4_lt_all_int4`,
`uint4` < all (select `uint4` from test_multi_type_table) AS `uint4_lt_all_uint4`,
`int8` < all (select `int8` from test_multi_type_table) AS `int8_lt_all_int8`,
`uint8` < all (select `uint8` from test_multi_type_table) AS `uint8_lt_all_uint8`,
`float4` < all (select `float4` from test_multi_type_table) AS `float4_lt_all_float4`,
`float8` < all (select `float8` from test_multi_type_table) AS `float8_lt_all_float8`,
`numeric` < all (select `numeric` from test_multi_type_table) AS `numeric_lt_all_numeric`,
`bit1` < all (select `bit1` from test_multi_type_table) AS `bit1_lt_all_bit1`,
`bit64` < all (select `bit64` from test_multi_type_table) AS `bit64_lt_all_bit64`,
`boolean` < all (select `boolean` from test_multi_type_table) AS `boolean_lt_all_boolean`,
`date` < all (select `date` from test_multi_type_table) AS `date_lt_all_date`,
`time` < all (select `time` from test_multi_type_table) AS `time_lt_all_time`,
`time(4)` < all (select `time(4)` from test_multi_type_table) AS `time(4)_lt_all_time(4)`,
`datetime` < all (select `datetime` from test_multi_type_table) AS `datetime_lt_all_datetime`,
`datetime(4)` < all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_lt_all_datetime(4)`,
`timestamp` < all (select `timestamp` from test_multi_type_table) AS `timestamp_lt_all_timestamp`,
`timestamp(4)` < all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_lt_all_timestamp(4)`,
`year` < all (select `year` from test_multi_type_table) AS `year_lt_all_year`,
`char` < all (select `char` from test_multi_type_table) AS `char_lt_all_char`,
`varchar` < all (select `varchar` from test_multi_type_table) AS `varchar_lt_all_varchar`,
`binary` < all (select `binary` from test_multi_type_table) AS `binary_lt_all_binary`,
`varbinary` < all (select `varbinary` from test_multi_type_table) AS `varbinary_lt_all_varbinary`,
`tinyblob` < all (select `tinyblob` from test_multi_type_table) AS `tinyblob_lt_all_tinyblob`,
`blob` < all (select `blob` from test_multi_type_table) AS `blob_lt_all_blob`,
`mediumblob` < all (select `mediumblob` from test_multi_type_table) AS `mediumblob_lt_all_mediumblob`,
`longblob` < all (select `longblob` from test_multi_type_table) AS `longblob_lt_all_longblob`,
`text` < all (select `text` from test_multi_type_table) AS `text_lt_all_text`,
`enum_t` < all (select `enum_t` from test_multi_type_table) AS `enum_t_lt_all_enum_t`,
`set_t` < all (select `set_t` from test_multi_type_table) AS `set_t_lt_all_set_t`,
`json` < all (select `json` from test_multi_type_table) AS `json_lt_all_json`,
`int1` <> all (select `int1` from test_multi_type_table) AS `int1_lg_all_int1`,
`uint1` <> all (select `uint1` from test_multi_type_table) AS `uint1_lg_all_uint1`,
`int2` <> all (select `int2` from test_multi_type_table) AS `int2_lg_all_int2`,
`uint2` <> all (select `uint2` from test_multi_type_table) AS `uint2_lg_all_uint2`,
`int4` <> all (select `int4` from test_multi_type_table) AS `int4_lg_all_int4`,
`uint4` <> all (select `uint4` from test_multi_type_table) AS `uint4_lg_all_uint4`,
`int8` <> all (select `int8` from test_multi_type_table) AS `int8_lg_all_int8`,
`uint8` <> all (select `uint8` from test_multi_type_table) AS `uint8_lg_all_uint8`,
`float4` <> all (select `float4` from test_multi_type_table) AS `float4_lg_all_float4`,
`float8` <> all (select `float8` from test_multi_type_table) AS `float8_lg_all_float8`,
`numeric` <> all (select `numeric` from test_multi_type_table) AS `numeric_lg_all_numeric`,
`bit1` <> all (select `bit1` from test_multi_type_table) AS `bit1_lg_all_bit1`,
`bit64` <> all (select `bit64` from test_multi_type_table) AS `bit64_lg_all_bit64`,
`boolean` <> all (select `boolean` from test_multi_type_table) AS `boolean_lg_all_boolean`,
`date` <> all (select `date` from test_multi_type_table) AS `date_lg_all_date`,
`time` <> all (select `time` from test_multi_type_table) AS `time_lg_all_time`,
`time(4)` <> all (select `time(4)` from test_multi_type_table) AS `time(4)_lg_all_time(4)`,
`datetime` <> all (select `datetime` from test_multi_type_table) AS `datetime_lg_all_datetime`,
`datetime(4)` <> all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_lg_all_datetime(4)`,
`timestamp` <> all (select `timestamp` from test_multi_type_table) AS `timestamp_lg_all_timestamp`,
`timestamp(4)` <> all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_lg_all_timestamp(4)`,
`year` <> all (select `year` from test_multi_type_table) AS `year_lg_all_year`,
`char` <> all (select `char` from test_multi_type_table) AS `char_lg_all_char`,
`varchar` <> all (select `varchar` from test_multi_type_table) AS `varchar_lg_all_varchar`,
`binary` <> all (select `binary` from test_multi_type_table) AS `binary_lg_all_binary`,
`varbinary` <> all (select `varbinary` from test_multi_type_table) AS `varbinary_lg_all_varbinary`,
`tinyblob` <> all (select `tinyblob` from test_multi_type_table) AS `tinyblob_lg_all_tinyblob`,
`blob` <> all (select `blob` from test_multi_type_table) AS `blob_lg_all_blob`,
`mediumblob` <> all (select `mediumblob` from test_multi_type_table) AS `mediumblob_lg_all_mediumblob`,
`longblob` <> all (select `longblob` from test_multi_type_table) AS `longblob_lg_all_longblob`,
`text` <> all (select `text` from test_multi_type_table) AS `text_lg_all_text`,
`enum_t` <> all (select `enum_t` from test_multi_type_table) AS `enum_t_lg_all_enum_t`,
`set_t` <> all (select `set_t` from test_multi_type_table) AS `set_t_lg_all_set_t`,
`json` <> all (select `json` from test_multi_type_table) AS `json_lg_all_json`,
`int1` != all (select `int1` from test_multi_type_table) AS `int1_ne_all_int1`,
`uint1` != all (select `uint1` from test_multi_type_table) AS `uint1_ne_all_uint1`,
`int2` != all (select `int2` from test_multi_type_table) AS `int2_ne_all_int2`,
`uint2` != all (select `uint2` from test_multi_type_table) AS `uint2_ne_all_uint2`,
`int4` != all (select `int4` from test_multi_type_table) AS `int4_ne_all_int4`,
`uint4` != all (select `uint4` from test_multi_type_table) AS `uint4_ne_all_uint4`,
`int8` != all (select `int8` from test_multi_type_table) AS `int8_ne_all_int8`,
`uint8` != all (select `uint8` from test_multi_type_table) AS `uint8_ne_all_uint8`,
`float4` != all (select `float4` from test_multi_type_table) AS `float4_ne_all_float4`,
`float8` != all (select `float8` from test_multi_type_table) AS `float8_ne_all_float8`,
`numeric` != all (select `numeric` from test_multi_type_table) AS `numeric_ne_all_numeric`,
`bit1` != all (select `bit1` from test_multi_type_table) AS `bit1_ne_all_bit1`,
`bit64` != all (select `bit64` from test_multi_type_table) AS `bit64_ne_all_bit64`,
`boolean` != all (select `boolean` from test_multi_type_table) AS `boolean_ne_all_boolean`,
`date` != all (select `date` from test_multi_type_table) AS `date_ne_all_date`,
`time` != all (select `time` from test_multi_type_table) AS `time_ne_all_time`,
`time(4)` != all (select `time(4)` from test_multi_type_table) AS `time(4)_ne_all_time(4)`,
`datetime` != all (select `datetime` from test_multi_type_table) AS `datetime_ne_all_datetime`,
`datetime(4)` != all (select `datetime(4)` from test_multi_type_table) AS `datetime(4)_ne_all_datetime(4)`,
`timestamp` != all (select `timestamp` from test_multi_type_table) AS `timestamp_ne_all_timestamp`,
`timestamp(4)` != all (select `timestamp(4)` from test_multi_type_table) AS `timestamp(4)_ne_all_timestamp(4)`,
`year` != all (select `year` from test_multi_type_table) AS `year_ne_all_year`,
`char` != all (select `char` from test_multi_type_table) AS `char_ne_all_char`,
`varchar` != all (select `varchar` from test_multi_type_table) AS `varchar_ne_all_varchar`,
`binary` != all (select `binary` from test_multi_type_table) AS `binary_ne_all_binary`,
`varbinary` != all (select `varbinary` from test_multi_type_table) AS `varbinary_ne_all_varbinary`,
`tinyblob` != all (select `tinyblob` from test_multi_type_table) AS `tinyblob_ne_all_tinyblob`,
`blob` != all (select `blob` from test_multi_type_table) AS `blob_ne_all_blob`,
`mediumblob` != all (select `mediumblob` from test_multi_type_table) AS `mediumblob_ne_all_mediumblob`,
`longblob` != all (select `longblob` from test_multi_type_table) AS `longblob_ne_all_longblob`,
`text` != all (select `text` from test_multi_type_table) AS `text_ne_all_text`,
`enum_t` != all (select `enum_t` from test_multi_type_table) AS `enum_t_ne_all_enum_t`,
`set_t` != all (select `set_t` from test_multi_type_table) AS `set_t_ne_all_set_t`,
`json` != all (select `json` from test_multi_type_table) AS `json_ne_all_json`
from test_multi_type_table;
select * from test_multi_type;
drop schema eq_all_subquery cascade;
reset current_schema;
