View Issue Details

IDProjectCategoryView StatusLast Update
0000972HopperGeneralpublic2017-10-19 14:56
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version2.0 
Summary0000972: Support for binary data in variables
DescriptionSupport for binary data in variables
TagsNo tags attached.
DBMS Version

Activities

Martijn Tonies

2014-09-10 14:35

administrator   ~0000305

DELIMITER $$

 

DROP PROCEDURE IF EXISTS test0 $$

CREATE DEFINER=`root`@`localhost` PROCEDURE test0 ()

    SQL SECURITY INVOKER

BEGIN

  DECLARE xid BINARY(16);

 

  SET xid = UNHEX(REPLACE(uuid(), '-', ''));

 

END $$

 

DELIMITER ;

Martijn Tonies

2014-09-10 14:35

administrator   ~0000306

DELIMITER $$

 

DROP PROCEDURE IF EXISTS test1 $$

CREATE DEFINER=`root`@`localhost` PROCEDURE test1 ()

    SQL SECURITY INVOKER

BEGIN

 

  CALL test1b(UNHEX(REPLACE(uuid(), '-', '')));

 

END $$

 

DELIMITER ;

 

DELIMITER $$

 

DROP PROCEDURE IF EXISTS test1b $$

CREATE DEFINER=`root`@`localhost` PROCEDURE test1b (

  id BINARY(16)

)

    SQL SECURITY INVOKER

BEGIN

  SELECT id;

END $$

 

DELIMITER ;

Issue History

Date Modified Username Field Change
2014-07-25 17:04 Martijn Tonies New Issue
2014-07-25 17:05 Martijn Tonies Assigned To => Martijn Tonies
2014-07-25 17:05 Martijn Tonies Status new => acknowledged
2014-09-10 14:35 Martijn Tonies Note Added: 0000305
2014-09-10 14:35 Martijn Tonies Note Added: 0000306
2014-09-15 14:23 Martijn Tonies Status acknowledged => assigned
2017-08-09 11:33 Martijn Tonies Status assigned => resolved
2017-08-09 11:33 Martijn Tonies Fixed in Version => 2.0
2017-08-09 11:33 Martijn Tonies Resolution open => fixed
2017-10-19 14:56 Martijn Tonies Status resolved => closed