title: UDF result error
body: <p>I try to install "mysqludf_sys".
  But i got this error:</p>
  
  <pre><code>ERROR 1126 (HY000) at line 29: Can't open shared library 'lib_mysqludf_sys.so' (errno: 0 /usr/lib/mysql/plugin/lib_mysqludf_sys.so: cannot open shared object file: No such file or directory)
  ERROR: unable to install the UDF
  </code></pre>
  
  <p>So, i tried to solve it with the following mofification in Makefile:</p>
  
  <pre><code>LIBDIR=/usr/lib to LIBDIR=/usr/lib/mysql/plugin
  </code></pre>
  
  <p>Also make sure that gcc has the -fPIC option ie:</p>
  
  <pre><code>gcc -fPIC -Wall -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o $(LIBDIR)/lib_mysqludf_sys.so
  </code></pre>
  
  <p>But when i test sys_eval, i get:</p>
  
  <pre><code>mysql&gt; SELECT sys_eval('id');
  +----------------+
  | sys_eval('id') |
  +----------------+
  |                |
  +----------------+
  1 row in set (0.02 sec)
  </code></pre>
  
  <p>I should get:</p>
  
  <pre><code>mysql&gt; SELECT sys_eval('id');
  +-------------------------------------------------+
  | sys_eval('id')                                  |
  +-------------------------------------------------+
  | uid=105(mysql) gid=108(mysql) groups=108(mysql) |
  +-------------------------------------------------+
  1 row in set (0.01 sec)
  </code></pre>
  
  <p>I have tested "sys_exec" also to create a file, but no result</p>
  
  <p>So, what should i do to  run correctly these functions ?
  Regards</p>