On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan
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
> challenges... How
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 suc
> 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
ommands 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'
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 1
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
>
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):
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 DETERMINIS
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 becau
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
't add space between function name and "(".But fact not like this.
Please note example in my reference.
> - Original Message -
> From: "Gleb Paharenko" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, December 30, 2005 2:04 AM
> Subject: Re: cre
T_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 &qu
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 " () RET
Matt
- 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 n
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
/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 sh
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 e
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
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 a
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,
>>
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 l
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 t
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
Thx a 10e6
Tim.
> -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 o
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 .
Sinisa 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
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";
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
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:
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
ress. I wrote a
> UDF for mysql, 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 libra
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: unsupport
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
t
33 matches
Mail list logo
