Bug #84138 ST_AsBinary doesn't accept second parameter
Submitted: 9 Dec 2016 7:47 Modified: 9 Dec 2016 14:18
Reporter: Norvald Ryeng Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S3 (Non-critical)
Version:8.0.1 OS:Any
Assigned to: CPU Architecture:Any

[9 Dec 2016 7:47] Norvald Ryeng 
Description:
WL#9432 added an axis order parameter to ST_AsWKB, but forgot to update the parameter list of alias ST_AsBinary.

How to repeat:
mysql> SELECT ST_AsText(ST_GeomFromWKB(ST_AsWKB(@g,'blah')));  
ERROR 3560 (22023): The string 'blah' is not a valid key = value pair
in function st_aswkb.

mysql> SELECT ST_AsText(ST_GeomFromWKB(ST_AsBinary(@g,'blah')));  
ERROR 1582 (42000): Incorrect parameter count in the call to native
function 'ST_AsBinary'

Suggested fix:
Add the proper declaration in func_array in item_create.cc.
[9 Dec 2016 14:18] Paul DuBois 
Posted by developer:
 
Fixed in 8.0.1.

Bug affects no released version. No changelog entry needed.