I am experiencing issues with sstr and other functions like sdist just typing examples from the documentation. I would appreciate any advice.
Many thanks in advance
mysql> SELECT spoint( '( 10.1d, -90d)' );
+---------------------------------------+
| spoint( '( 10.1d, -90d)' ) |
+---------------------------------------+
| PHB0Pkuz7ixJkMY/GC1EVPsh+b88dHA+AA== |
+---------------------------------------+
1 row in set (0,00 sec)
mysql> SELECT sstr(spoint('(10.1d,-90d)'));
ERROR 1123 (HY000): Can't initialize function 'sstr'; sstr() error decoding first parameter. Corrupted or not the correct type.
mysql> SELECT 180 * ( sdist( scircle( '<(0d,20d),2d>' ), scircle( '<(0d,40d),2d>' ) ) ) / pi() AS dist ;
ERROR 1123 (HY000): Can't initialize function 'sdist'; dist() error decoding first parameter. Corrupted or not the correct type.
I am experiencing issues with sstr and other functions like sdist just typing examples from the documentation. I would appreciate any advice.
Many thanks in advance
mysql> SELECT spoint( '( 10.1d, -90d)' );
+---------------------------------------+
| spoint( '( 10.1d, -90d)' ) |
+---------------------------------------+
| PHB0Pkuz7ixJkMY/GC1EVPsh+b88dHA+AA== |
+---------------------------------------+
1 row in set (0,00 sec)
mysql> SELECT sstr(spoint('(10.1d,-90d)'));
ERROR 1123 (HY000): Can't initialize function 'sstr'; sstr() error decoding first parameter. Corrupted or not the correct type.
mysql> SELECT 180 * ( sdist( scircle( '<(0d,20d),2d>' ), scircle( '<(0d,40d),2d>' ) ) ) / pi() AS dist ;
ERROR 1123 (HY000): Can't initialize function 'sdist'; dist() error decoding first parameter. Corrupted or not the correct type.