--source include/have_innodb.inc

SET sql_mode='ORACLE';

CREATE TABLE t (c VARCHAR(16), KEY(c)) ENGINE=InnoDB;

INSERT INTO t VALUES ('foo');

--delimiter $$

CREATE FUNCTION f() RETURN VARCHAR(16)

IS

  v VARCHAR2(16);

BEGIN

  FOR v IN ( SELECT DISTINCT c FROM t )

  LOOP

    IF (v = 'bar') THEN

      SELECT 1 INTO @a;

    END IF;

  END LOOP;

  RETURN 'qux';

END $$

--delimiter ;

SELECT f();

# Cleanup

DROP FUNCTION f;

DROP TABLE t;

#3  <signal handler called>

#4  0x00005594f477e654 in Arg_comparator::set_cmp_func (this=0x7fbda0044cc0, owner_arg=0x7fbda012d648, a1=0x7fbda0044230, a2=0x0) at /data/src/10.3/sql/item_cmpfunc.cc:486

#5  0x00005594f4505d45 in Arg_comparator::set_cmp_func (this=0x7fbda0044cc0, owner_arg=0x7fbda012d648, a1=0x7fbda0044230, a2=0x0, set_null_arg=true) at /data/src/10.3/sql/item_cmpfunc.h:100

#6  0x00005594f477e9f0 in Arg_comparator::set_cmp_func_for_row_arguments (this=0x7fbda012d708) at /data/src/10.3/sql/item_cmpfunc.cc:517

#7  0x00005594f477ea8a in Arg_comparator::set_cmp_func_row (this=0x7fbda012d708) at /data/src/10.3/sql/item_cmpfunc.cc:528

#8  0x00005594f464ceb8 in Type_handler_row::set_comparator_func (this=0x5594f5bb2f40 <type_handler_row>, cmp=0x7fbda012d708) at /data/src/10.3/sql/sql_type.cc:2540

#9  0x00005594f477e731 in Arg_comparator::set_cmp_func (this=0x7fbda012d708, owner_arg=0x7fbda012d648, a1=0x7fbda012d6d8, a2=0x7fbda012d6e0) at /data/src/10.3/sql/item_cmpfunc.cc:494

#10 0x00005594f4505d45 in Arg_comparator::set_cmp_func (this=0x7fbda012d708, owner_arg=0x7fbda012d648, a1=0x7fbda012d6d8, a2=0x7fbda012d6e0, set_null_arg=true) at /data/src/10.3/sql/item_cmpfunc.h:100

#11 0x00005594f477e56c in Item_func::setup_args_and_comparator (this=0x7fbda012d648, thd=0x7fbda0000b00, cmp=0x7fbda012d708) at /data/src/10.3/sql/item_cmpfunc.cc:448

#12 0x00005594f477e5dd in Item_bool_rowready_func2::fix_length_and_dec (this=0x7fbda012d648) at /data/src/10.3/sql/item_cmpfunc.cc:462

#13 0x00005594f47bad48 in Item_func::fix_fields (this=0x7fbda012d648, thd=0x7fbda0000b00, ref=0x7fbda012d800) at /data/src/10.3/sql/item_func.cc:370

#14 0x00005594f48c46cd in sp_prepare_func_item (thd=0x7fbda0000b00, it_addr=0x7fbda012d800, cols=1) at /data/src/10.3/sql/sp_head.cc:354

#15 0x00005594f48cdaf6 in sp_instr_jump_if_not::exec_core (this=0x7fbda012d7b0, thd=0x7fbda0000b00, nextp=0x7fbde0761054) at /data/src/10.3/sql/sp_head.cc:3697

#16 0x00005594f48cc0da in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fbda012d808, thd=0x7fbda0000b00, nextp=0x7fbde0761054, open_tables=true, instr=0x7fbda012d7b0) at /data/src/10.3/sql/sp_head.cc:3109

#17 0x00005594f48cda93 in sp_instr_jump_if_not::execute (this=0x7fbda012d7b0, thd=0x7fbda0000b00, nextp=0x7fbde0761054) at /data/src/10.3/sql/sp_head.cc:3687

#18 0x00005594f48c6997 in sp_head::execute (this=0x7fbda0129b48, thd=0x7fbda0000b00, merge_da_on_success=true) at /data/src/10.3/sql/sp_head.cc:1200

#19 0x00005594f48c826a in sp_head::execute_function (this=0x7fbda0129b48, thd=0x7fbda0000b00, argp=0x0, argcount=0, return_value_fld=0x7fbda0016fa0) at /data/src/10.3/sql/sp_head.cc:1808

#20 0x00005594f47d0810 in Item_func_sp::execute_impl (this=0x7fbda0014d28, thd=0x7fbda0000b00) at /data/src/10.3/sql/item_func.cc:6493

#21 0x00005594f47d05a6 in Item_func_sp::execute (this=0x7fbda0014d28) at /data/src/10.3/sql/item_func.cc:6426

#22 0x00005594f47d65fe in Item_func_sp::val_str (this=0x7fbda0014d28, str=0x7fbde0761a70) at /data/src/10.3/sql/item_func.h:2825

#23 0x00005594f4651bd3 in Type_handler::Item_send_str (this=0x5594f5bb3010 <type_handler_varchar>, item=0x7fbda0014d28, protocol=0x7fbda0001098, buf=0x7fbde0761a40) at /data/src/10.3/sql/sql_type.cc:5136

#24 0x00005594f465554a in Type_handler_string_result::Item_send (this=0x5594f5bb3010 <type_handler_varchar>, item=0x7fbda0014d28, protocol=0x7fbda0001098, buf=0x7fbde0761a40) at /data/src/10.3/sql/sql_type.h:1668

#25 0x00005594f43a54e8 in Item::send (this=0x7fbda0014d28, protocol=0x7fbda0001098, buffer=0x7fbde0761a40) at /data/src/10.3/sql/item.h:772

#26 0x00005594f43a0d46 in Protocol::send_result_set_row (this=0x7fbda0001098, row_items=0x7fbda0005070) at /data/src/10.3/sql/protocol.cc:985

#27 0x00005594f4427f9e in select_send::send_data (this=0x7fbda00169d8, items=...) at /data/src/10.3/sql/sql_class.cc:2927

#28 0x00005594f44c61c6 in JOIN::exec_inner (this=0x7fbda00169f8) at /data/src/10.3/sql/sql_select.cc:3498

#29 0x00005594f44c5c24 in JOIN::exec (this=0x7fbda00169f8) at /data/src/10.3/sql/sql_select.cc:3417

#30 0x00005594f44c6e05 in mysql_select (thd=0x7fbda0000b00, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fbda00169d8, unit=0x7fbda0004818, select_lex=0x7fbda0004f50) at /data/src/10.3/sql/sql_select.cc:3817

#31 0x00005594f44baf2e in handle_select (thd=0x7fbda0000b00, lex=0x7fbda0004750, result=0x7fbda00169d8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:378

#32 0x00005594f448632b in execute_sqlcom_select (thd=0x7fbda0000b00, all_tables=0x0) at /data/src/10.3/sql/sql_parse.cc:6477

#33 0x00005594f447cb00 in mysql_execute_command (thd=0x7fbda0000b00) at /data/src/10.3/sql/sql_parse.cc:3740

#34 0x00005594f4489c5e in mysql_parse (thd=0x7fbda0000b00, rawbuf=0x7fbda0014a98 "SELECT f()", length=10, parser_state=0x7fbde0763610, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7933

#35 0x00005594f447763e in dispatch_command (command=COM_QUERY, thd=0x7fbda0000b00, packet=0x7fbda011dfa1 "", packet_length=10, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1828

#36 0x00005594f447605f in do_command (thd=0x7fbda0000b00) at /data/src/10.3/sql/sql_parse.cc:1370

#37 0x00005594f45cde2a in do_handle_one_connection (connect=0x5594f6e46ad0) at /data/src/10.3/sql/sql_connect.cc:1418

#38 0x00005594f45cdbb7 in handle_one_connection (arg=0x5594f6e46ad0) at /data/src/10.3/sql/sql_connect.cc:1324

#39 0x00005594f4a4f0a8 in pfs_spawn_thread (arg=0x5594f6e63930) at /data/src/10.3/storage/perfschema/pfs.cc:1863

#40 0x00007fbdf1876494 in start_thread (arg=0x7fbde0764700) at pthread_create.c:333

#41 0x00007fbdefc5c93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

SET sql_mode='ORACLE';

CREATE OR REPLACE TABLE t1 (c VARCHAR(16), KEY(c)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('foo');

DELIMITER $$

CREATE OR REPLACE FUNCTION f1() RETURN VARCHAR(16)

IS

  v t1%ROWTYPE;

BEGIN

  IF v = 'bar' THEN

    NULL;

  END IF;

  RETURN 'qux';

END $$

DELIMITER ;

SELECT f1();

ERROR 1241 (21000): Operand should contain 2 column(s

SET sql_mode='ORACLE';

DELIMITER $$

CREATE OR REPLACE FUNCTION f1() RETURN VARCHAR(16)

IS

  v ROW(a INT);

BEGIN

  IF v = 'bar' THEN

    NULL;

  END IF;

  RETURN 'qux';

END $$

DELIMITER ;

SELECT f1();

SET sql_mode=DEFAULT;

DELIMITER $$

CREATE OR REPLACE FUNCTION f1() RETURNS VARCHAR(16)

BEGIN

  DECLARE v ROW(a INT);

  IF v = 'bar' THEN

    RETURN 'eq';

  END IF;

  RETURN 'ne';

END $$

DELIMITER ;

SELECT f1();

SET sql_mode=DEFAULT;

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE v ROW(a INT);

  SELECT v IN ('a','b');

END $$

DELIMITER ;

+----------------+

| v IN ('a','b') |

+----------------+

|           NULL |

+----------------+

SET sql_mode=DEFAULT;

DELIMITER $$

BEGIN NOT ATOMIC

  DECLARE v ROW(a INT);

  SELECT 'a' IN (v,'b');

END $$

DELIMITER ;

ERROR 1241 (21000): Operand should contain 1 column(s)

DROP TABLE t1;

CREATE TABLE t1 (c VARCHAR(16));

INSERT INTO t1 VALUES ('foo');

DROP FUNCTION f1;

CREATE FUNCTION f1 RETURN VARCHAR

IS

  v VARCHAR2(16);

BEGIN

  FOR v IN ( SELECT DISTINCT c FROM t1 )

  LOOP

    IF (v = 'bar') THEN

      RETURN 'eq';

    END IF;

  END LOOP;

  RETURN 'qux';

END;

/

SHOW ERRORS;

LINE/COL ERROR

-------- -----------------------------------------------------------------

7/5	 PL/SQL: Statement ignored

7/11	 PLS-00306: wrong number or types of arguments in call to '='