I want to check all my functions and procs into my svn as individual sql files.
When I use these to create my db, the person doing this may not realize the
correct order to run these files and not have dependency challenges... How can
I have procs that depend on functions, or vice versa, get
On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan
bcantw...@firescope.com wrote:
I want to check all my functions and procs into my svn as individual sql
files. When I use these to create my db, the person doing this may not
realize the correct order to run these files and not have dependency
Hello Ted,
I got an error that I don't understand:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3080 to server version:
5.0.18-log
mysql create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02
Ted Yu wrote:
I got an error that I don't understand:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3080 to server version:
5.0.18-log
mysql create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02): Table
to server
version:
5.0.18-log
mysql create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02): Table 'mysql.proc' doesn't
exist
Is this an upgrade from a v4/v4.1 version?
If so, make sure to run the upgrade script for the
mysql
database.
Martijn
Yes. MySQL was upgraded.
What's the name of upgrade script and where is it ?
Check the manual on how to upgrade and what script to run.
I cannot remember the name/place :-)
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
I got an error that I don't understand:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3080 to server version:
5.0.18-log
mysql create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02): Table 'mysql.proc' doesn't
I am trying to create a stored function.
From the docs I saw the code for this function:
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
DETERMINISTIC
RETURN CONCAT('Hello, ',s,'!');
The version from the docs did not contain the DETERMINISTIC keyword.
I added because it would not compile
Anakreon Mejdi wrote:
I am trying to create a stored function.
From the docs I saw the code for this function:
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
DETERMINISTIC
RETURN CONCAT('Hello, ',s,'!');
The version from the docs did not contain the DETERMINISTIC keyword.
I added
Hello.
Sorry. It seems that I've understood your question now. In my opinion,
IGNORE_SPACE not related to CREATE FUNCTION statement, because at:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
for some cases we have to use a space between the name and the following
,ERROR_FOR_DIVISION_BY_ZERO'.
Note,IGNORE_SPACE not include sql mode.
But i still execute statement as follow :
CREATE FUNCTION wangxu.user () RETURNS int(11)
BEGIN
return 1;
END
function name and (.But fact not like this.
Please note example in my reference.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, December 30, 2005 2:04 AM
Subject: Re: create function with space
Hello.
From the manual
I set my sql_mode =
'STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO'.
Note,IGNORE_SPACE not include sql mode.
But i still execute statement as follow :
CREATE FUNCTION wangxu.user () RETURNS int(11)
BEGIN
return 1
- Original Message -
From: George Chelidze
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new udf function which converts time from NTP
format to timestamp. I compile it with the following command:
gcc -Wall -shared -o ntp2timestamp.so
/ld.so.conf file contains this path as well) and execute
the following under mysql:
CREATE FUNCTION ntp2timestamp RETURNS STRING SONAME ntp2timestamp.so;
and I get an error:
ERROR 1126: Can't open shared library 'ntp2timestamp.so' (errno: 22
ntp2timestamp.so: cannot open shared object file
Hi George,
I think the MySQL-Max RPM is dynamically linked (all -max binaries
actually) if you want to give it a try.
Hope that helps.
Matt
- Original Message -
From: George Chelidze
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new
Victoria Reznichenko wrote:
Sameh,
Sunday, July 14, 2002, 3:09:53 PM, you wrote:
SA Can anybody help me figuring how to control granting users
SA permissions to created functions in MySQL like we do for SELECT,
INSERT,
SA ...etc or it is not possible and every one logged in to
Sameh,
Tuesday, July 16, 2002, 9:26:27 AM, you wrote:
SA Victoria Reznichenko wrote:
SA
SA SA Can anybody help me figuring how to control granting users
SA SA permissions to created functions in MySQL like we do for SELECT,
SA INSERT,
SA SA ...etc or it is not possible and every one
Sameh,
Sunday, July 14, 2002, 3:09:53 PM, you wrote:
SA Can anybody help me figuring how to control granting users
SA permissions to created functions in MySQL like we do for SELECT, INSERT,
SA ...etc or it is not possible and every one logged in to MySQL could
SA simply use them like any
Hi,
Can anybody help me figuring how to control granting users
permissions to created functions in MySQL like we do for SELECT, INSERT,
...etc or it is not possible and every one logged in to MySQL could
simply use them like any other native function?
Regards
--
Sameh Attia
Senior System
http://www.mysql.com/doc/P/r/Privileges.html
Sameh Attia wrote:
Hi,
Can anybody help me figuring how to control granting users
permissions to created functions in MySQL like we do for SELECT,
INSERT, ...etc or it is not possible and every one logged in to MySQL
could simply use them
Veysel Harun Sahin wrote:
http://www.mysql.com/doc/P/r/Privileges.html
Sameh Attia wrote:
Hi,
Can anybody help me figuring how to control granting users
permissions to created functions in MySQL like we do for SELECT,
INSERT, ...etc or it is not possible and every one logged in to
ahh sorry for misunderstand. the truth is that i have no idea about the
solution of your problem but i would like to hear from you if you find a
solution.
Sameh Attia wrote:
Veysel Harun Sahin wrote:
http://www.mysql.com/doc/P/r/Privileges.html
Sameh Attia wrote:
Hi,
Can anybody
Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 17:03
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: create function: fails with error 1126
Tim Wuyts writes:
All,
I'm trying to use the UDF functionality, but I keep getting the
same error
when I issue
Tim Wuyts writes:
Hello,
I tried ldd on the .so file:
no output! this is very strange.
I tried to compile this on several other machines, but ldd never gives any
output.
If i replace gcc with c++, ldd does show me the shared libraries, but none
are missing.
If i try to use the .so file
.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 17:14
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: create function: fails with error 1126
[snip]
I must be overlooking something. Where is default-charset_info defined
All,
I'm trying to use the UDF functionality, but I keep getting the same error
when I issue the CREATE FUNCTION command.
This is the error:
mysql CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME udf_example.so;
ERROR 1126: Can't open shared library 'udf_example.so' (errno: 0 ld.so.1:
/usr
Tim Wuyts writes:
All,
I'm trying to use the UDF functionality, but I keep getting the same error
when I issue the CREATE FUNCTION command.
This is the error:
mysql CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME udf_example.so;
ERROR 1126: Can't open shared library 'udf_example.so
, and It compiles fine, but when I try to create the function
in mysql, it tells me that the type is unsupported. i.e.:
mysql CREATE FUNCTION int2ip RETURNS STRING SONAME libudf_int_ip.so;
ERROR 1126: Can't open shared library 'libudf_int_ip.so' (errno: 0
/usr/lib/libudf_int_ip.so: unsupported
On Sat, 17 Nov 2001, Sinisa Milivojevic wrote:
mysql CREATE FUNCTION lookup RETURNS STRING SONAME libudf_example.so;
ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0
/usr/lib/libudf_example.so: unsupported file type)
Hi!
Please check a type of the above ...so file
In the last episode (Nov 17), Troy Bowman said:
On Sat, 17 Nov 2001, Sinisa Milivojevic wrote:
mysql CREATE FUNCTION lookup RETURNS STRING SONAME libudf_example.so;
ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0
/usr/lib/libudf_example.so: unsupported file type
I try to create the function
in mysql, it tells me that the type is unsupported. i.e.:
mysql CREATE FUNCTION int2ip RETURNS STRING SONAME libudf_int_ip.so;
ERROR 1126: Can't open shared library 'libudf_int_ip.so' (errno: 0
/usr/lib/libudf_int_ip.so: unsupported file type)
I figured it might
Hi!
I've compiled the udf_example.cc file into an so, copied it to /usr/lib, but
when i issue a
CREATE FUNCTION lookup RETURN STRING SONAME "udf_example.so";
I get: Error 1041: Out of memory.
I've searched the mailing list and the web, and all the information I get is
that it see
33 matches
Mail list logo