udf shared library import

2017-03-08 Thread Tim Holme
I was not able to load a function in udf_example.so.  The response to CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; is Error Code: 1126. Can't open shared library 'udf_example.so' (errno: 0 /usr/lib64/mysql/plugin/udf_example.so: cannot open shared object file: No such file or

UDF Not Compiling

2014-07-29 Thread Shahram Ghandeharizadeh
I cannot author a UDF using MySQL. I use the MySQL provided udf_example.cc and compile it using the following command: sudo gcc -shared -fPIC -I /usr/include/mysql -o /usr/lib/mysql/plugin/udf_example.so udf_example.cc Next, I login to mysql, connect to my database, and author one

RE: UDF Not Compiling

2014-07-29 Thread Shahram Ghandeharizadeh
I cannot author a UDF using MySQL. I use the MySQL provided udf_example.cc and compile it using the following command: sudo gcc -shared -fPIC -I /usr/include/mysql -o /usr/lib/mysql/plugin/udf_example.so udf_example.cc Next, I login to mysql, connect to my database, and author one

Re: UDF behaves non-deterministic

2012-11-07 Thread Stefan Kuhn
alternative if one is available. If none are available, you might have to consider a mutex. - michael dykman On Mon, Nov 5, 2012 at 9:28 AM, Stefan Kuhn stef...@web.de wrote: Hi Dan, thanks for your answer. The UDF only contains functions (the one called in sql plus two functions

Aw: Re: UDF behaves non-deterministic

2012-11-05 Thread Stefan Kuhn
Hi Dan, thanks for your answer. The UDF only contains functions (the one called in sql plus two functions called in it). There are no variables outside them and nothing is declared static. All variables inside the functions are declared just like double x=0; etc. I am not an expert on C

Re: Re: UDF behaves non-deterministic

2012-11-05 Thread Michael Dykman
will likely suggest a threadsafe alternative if one is available. If none are available, you might have to consider a mutex. - michael dykman On Mon, Nov 5, 2012 at 9:28 AM, Stefan Kuhn stef...@web.de wrote: Hi Dan, thanks for your answer. The UDF only contains functions (the one called

Re: UDF behaves non-deterministic

2012-11-05 Thread walter harms
can you reduce the UDF just to return 1; ? that should give you a clue what is going on. Random values usualy point to two suspects 1. mixing 32bit and 64bit 2. using void instead of int re, wh Am 04.11.2012 23:23, schrieb Stefan Kuhn: Hi all, I have a weired (for me at least) problem

Re: UDF behaves non-deterministic

2012-11-05 Thread hsv
2012/11/04 22:23 +, Stefan Kuhn select * from table order by udf(column, 'input_value') desc; For my understanding, this should give the same result always. But if for your data function udf returns the same for more arguments there is not enough to fix the order. In that case I have

Re: UDF behaves non-deterministic

2012-11-05 Thread Stefan Kuhn
On Monday 05 November 2012 18:02:28 h...@tbbs.net wrote: 2012/11/04 22:23 +, Stefan Kuhn select * from table order by udf(column, 'input_value') desc; For my understanding, this should give the same result always. But if for your data function udf returns the same for more arguments

UDF behaves non-deterministic

2012-11-04 Thread Stefan Kuhn
and an input value. So I do something like this: select * from table order by udf(column, 'input_value') desc; For my understanding, this should give the same result always. But if I run many statements (execution is from a java program and I can do it in parallel threads) so that they overlap

Re: UDF behaves non-deterministic

2012-11-04 Thread Michael Dykman
A couple of questions present. You mention that selecting from the whole table takes 5-10s so I assume you have a lot of records. is the data not in flux? are you sure? these conflict queries are all on the same server? i would have structured the query like so: select *, udf(column,'value

Re: UDF behaves non-deterministic

2012-11-04 Thread Stefan Kuhn
machine, old, but working) is the data not in flux? are you sure? Yes, I am. I have a test server, where nothing happens. these conflict queries are all on the same server? Yes, one mysql instance on one server i would have structured the query like so: select *, udf(column,'value') AS u

Re: UDF behaves non-deterministic

2012-11-04 Thread Dan Nelson
calculates a score based on a column in a table and an input value. So I do something like this: select * from table order by udf(column, 'input_value') desc; For my understanding, this should give the same result always. But if I run many statements (execution is from a java program and I can do

UDF writing to unix socket - segfaults?

2012-08-08 Thread Per Jessen
I am writing a UDF for sending messages to a local daemon. I've been trying to make it use a UNIX socket, but it keeps segfaulting on connect() or sendto(). I have double and tripled checked everything, but I'm not finding anything. After a day or two, I finally decided to switch to UDP

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Martin Gainty
quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. From: p...@computer.org Subject: UDF writing to unix socket - segfaults? Date: Wed, 8 Aug 2012 08:26:23 +0200

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Per Jessen
Martin Gainty wrote: assuming you worked out the access to network by your code permissions When I open the unix socket, I give it 0777. that means memory heap or stack is being overrun...you would be well advised to download the connect() and sendto() code from the OS vendor I'm running on

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Martin Gainty
responsabilité pour le contenu fourni. From: p...@computer.org Subject: RE: UDF writing to unix socket - segfaults? Date: Wed, 8 Aug 2012 15:39:09 +0200 To: mysql@lists.mysql.com Martin Gainty wrote: assuming you worked out the access to network by your code permissions When I open the unix

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Per Jessen
Martin Gainty wrote: this is pure speculation unless we can get ahold of the source code for your specific version of glibc and determine what the maximum sizes are .. otherwise anything I suggest would be speculative..lets take a look at

Is it it posiible to combine the C++ algorithm code, the MYSQL source code and the UDF code into a single DLL/SO?

2011-09-08 Thread Frank Chang
Good afternoon, We developed a C++ class algorithm and code together with sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single Windows DLL/UNIX-LINUX SO Now we would like to change from SQLite to MySQL to take advantage of MySQL's ability to do parallel writes on separate

Re: Is it it posiible to combine the C++ algorithm code, the MYSQL source code and the UDF code into a single DLL/SO?

2011-09-08 Thread Frank Chang
Good evening, Apparently MySQL supports a single client connection to a local MySQL server Quoting from the MySQL :: MySQL 5.0 Reference Manual :: 4.2.2 Connecting to the MySQL Server URL by Booz-Allen New York City consultants The following table shows the permissible --protocol

Exceptions not caught in UDF written in C++ in MySQL 5.5

2011-08-30 Thread H. Steuer
Hello guys, after upgrading from MySQL 5.1 to 5.5 we encounter a problem that C++ exceptions thrown in an UDF are not catched at all. Even there is a catch (... ) at the end or our try block which avoids exceptions to be thrown outside of the UDF, the server crashes with: terminate called

udf return column name not value

2010-03-15 Thread chamila gayan
CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30)) RETURNS varchar(50) DETERMINISTIC READS SQL DATA begin declare retval varchar(50); select columnname into retval from user where ID = id ; return retval; end; I want get value of related column but it return column name. ex:- ('tom'

RE: udf return column name not value

2010-03-15 Thread Gavin Towey
@lists.mysql.com Subject: udf return column name not value CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30)) RETURNS varchar(50) DETERMINISTIC READS SQL DATA begin declare retval varchar(50); return retval; end; I want get value of related column but it return column name. ex:- ('tom' what I want

Re: udf return column name not value

2010-03-15 Thread chamila gayan
something like this: SET @sql := CONCAT('select ',columnname,' into retval from user where ID=',id); PREPARE mySt FROM @sql; EXECUTE mySt; -Original Message- From: chamila gayan [mailto:cgcham...@gmail.com] Sent: Monday, March 15, 2010 12:58 AM To: mysql@lists.mysql.com Subject: udf

Re: UDF - Sequence Numbers

2010-03-09 Thread Johnny Withers
-Original Message- From: Johnny Withers [mailto:joh...@pixelated.net] Sent: Monday, March 08, 2010 1:31 PM To: MySQL General List Subject: UDF - Sequence Numbers I have two servers, both running 5.0.77-log, one is setup as a master, the other as a replication slave. The database contains

UDF - Sequence Numbers

2010-03-08 Thread Johnny Withers
store_seq_num that holds the sequence number for each loan done in each store. This column needs to work like the auto-increment field; however, it's value is dependent upon which store created the loan. Currently there is a UDF called fnNextStoreSeqNum that returns the next sequence number for the new loan

RE: UDF - Sequence Numbers

2010-03-08 Thread Gavin Towey
Withers [mailto:joh...@pixelated.net] Sent: Monday, March 08, 2010 1:31 PM To: MySQL General List Subject: UDF - Sequence Numbers I have two servers, both running 5.0.77-log, one is setup as a master, the other as a replication slave. The database contains a table that holds records of loans

UDF Question

2008-09-04 Thread Alex Katebi
Hello, I am planning to write a UDF (User Defined Function) that acts like a server side client. This UDF is called by a client first. After that the UDF spwans a thread then exits. Within this spawned thread it will get work from a network socket. After that it will start executing SQL

Re: JAVA UDF HOW

2008-06-05 Thread Abhayjeet Singh Grewal
: Abhay- It seems you are referring to the UDF Oracle specific User-defined forms Have you looked at http://download.oracle.com/docs/cd/E10391_01/doc.910/e10363/oimadm.htm#CIAEFFAD ? Martin - Original Message - From: Abhayjeet Singh Grewal [EMAIL PROTECTED] To: mysql

Re: JAVA UDF HOW

2008-06-05 Thread Antony T Curtis
that package from MYSQL function or procedure. Any help would be much appreciated. Thanks, Abhay On Tue, Jun 3, 2008 at 9:32 PM, Martin [EMAIL PROTECTED] wrote: Abhay- It seems you are referring to the UDF Oracle specific User-defined forms Have you looked at http://download.oracle.com

Re: JAVA UDF HOW

2008-06-04 Thread Abhayjeet Singh Grewal
PROTECTED] wrote: Abhay- It seems you are referring to the UDF Oracle specific User-defined forms Have you looked at http://download.oracle.com/docs/cd/E10391_01/doc.910/e10363/oimadm.htm#CIAEFFAD ? Martin - Original Message - From: Abhayjeet Singh Grewal [EMAIL PROTECTED

Re: JAVA UDF HOW

2008-06-04 Thread Dan Nelson
with plain mysql. A UDF has to be a C or C++ module, according to http://dev.mysql.com/doc/refman/6.0/en/adding-udf.html (applies to all previous versions of mysql, too). There is a project to add support for other languages, though, according to http://forge.mysql.com/projects/project.php?id=239

Re: JAVA UDF HOW

2008-06-04 Thread Antony T Curtis
to call that package from MYSQL function or procedure. Any help would be much appreciated. Thanks, Abhay On Tue, Jun 3, 2008 at 9:32 PM, Martin [EMAIL PROTECTED] wrote: Abhay- It seems you are referring to the UDF Oracle specific User-defined forms Have you looked at http

UDF output

2008-05-05 Thread Rares Vernica
Hello, If you use printf or some similar function inside a UDF function, where does the output goes? Or, how can I make such an output go somewhere? Thanks, Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

jdbc with a UDF

2007-06-05 Thread Dave G
I'm getting what appears to be a java reference back from values I return from a UDF. The values appear find using php, and in the mysql client. The result looks something like: [EMAIL PROTECTED] The result should be a string (some representing floats, others as integers). Any help

Re: jdbc with a UDF

2007-06-05 Thread Dave G
question shortly after emailing the list. Thanks David Godsey Perhaps you could show us the Java code you are using to invoke this UDF? What are you expecting to get back form it? a result set? a return code from a function? What version of of the JDBC driver are you using? - michael On 6

Plot UDF

2007-03-14 Thread Sergei S
Hi, Is there an aggregate UDF that would produce a simple plot (as a BLOB, e.g. in PNG format) from two columns of data? I'm pretty sure it's possible to write, but I don't want to do it if it's available somewhere. I realize that it normally should be done on the client side, in fact I've

Create funtion UDF on MYSQL

2007-01-09 Thread NGUYEN THI NGOC THOI
Hi! can you hep? when create funtion UDF on linux then it have error ERROR 1126 Can't opened shared library (error: 0 feature disabled) i do'nt want use it ,if you knowm this problem,please help me. i hope to receive your mail thank for read

udf return bool?

2006-11-09 Thread Rares Vernica
Hi, Do you know if a UDF can return a boolean value? Thanks, Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: udf configuration resources

2006-07-20 Thread Eric Bergen
Your udf is executing in a threaded environment so you have the option of creating a datastrucutre to store options in that will persist across udf executions. However since you won't be deallocating this structure ever it's essentially leaked memory. What are you doing with udfs that you want

udf configuration

2006-07-19 Thread Yong Lee
Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time. I'm

udf configuration resources

2006-07-19 Thread Yong Lee
Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use of configuration parameters that can be set at run time. I'm

RE: udf configuration

2006-07-19 Thread Jimmy Guerrero
To: mysql@lists.mysql.com Subject: udf configuration Hi all, I hope I have hit the right group for this question. I would like to create a UDF that is configurable at run time. Similar to how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF to make use

Prepared Statement, Select and Calls in C/C++ UDF

2006-04-15 Thread Miroslav Nachev
Hi, I want to make C User Defined Function where to do some data processing using the parameters and the data in the database and to return some BIGINT result after that. My questions are: Q1. Is it possible to use Prepared Statement, Select and Calls in C/C++ UDF? Q2. If, Yes, which MySQL

UDF help, convert BLOB to BIGINT

2006-03-22 Thread David Godsey
I'm in the process of writing my first UDF and would appreciate some help. I am pulling data from a table like: SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength

Re: UDF help, convert BLOB to BIGINT

2006-03-22 Thread SGreen
David Godsey [EMAIL PROTECTED] wrote on 03/22/2006 01:21:07 PM: I'm in the process of writing my first UDF and would appreciate some help. I am pulling data from a table like: SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL

Re: UDF help, convert BLOB to BIGINT

2006-03-22 Thread David Godsey
Just figured it out without a UDF(not documented anywhere that I found). SELECT conv(hex(fdata),16,10) INTO fdata_bigint; So a double conversion seems to work for me. You solution looks like it will work, but since I was able to get it to work without a UDF, I'm not going to test it out. Thanks

Re: UDF Request AGGLOM()

2005-12-05 Thread Arjen Lentz
Hi Dan, Dan Bolser wrote: Who can I prod about setting up a UDF repo at MySQL. I think 'they' should do this ;) Yep it's an existing idea, a very good one, and it's on the todo. Putting such an infrastructure into place will take some time though. I can imagine it isn't trivial to set up

Re: UDF Request AGGLOM()

2005-12-05 Thread dmb
Hi Dan, Dan Bolser wrote: Who can I prod about setting up a UDF repo at MySQL. I think 'they' should do this ;) Yep it's an existing idea, a very good one, and it's on the todo. Putting such an infrastructure into place will take some time though. I can imagine it isn't trivial to set up

Re: UDF

2005-11-22 Thread Gleb Paharenko
Hello. My doubt is: Is it the only way to have UDF server-side in MySQL(4.1.x)? Do I need to learn C/C++ to have a UDF? In my opinion - yes, because UFDs usually uses includes (say, mysql.h) which are written in C/C++. Speaking in general - UDF for MySQL is just a shared library, so

UDF

2005-11-21 Thread Ronan Lucio
Hello, I´m using MySQL-4.1.7 and I need to create a UDF. For all I have understood, I need to create it in C/C++ sintaxe. My doubt is: Is it the only way to have UDF server-side in MySQL(4.1.x)? Do I need to learn C/C++ to have a UDF? Thanks, Ronan -- MySQL General Mailing List For list

rcs udf for MySQL

2005-08-16 Thread Jason Pyeron
Anyone out there heard of a rcs udf (or similar) for MySQL? Google is not being nice to me, too much noise in the results. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron

Re: rcs udf for MySQL

2005-08-16 Thread SGreen
Jason Pyeron [EMAIL PROTECTED] wrote on 08/16/2005 01:01:03 PM: Anyone out there heard of a rcs udf (or similar) for MySQL? Google is not being nice to me, too much noise in the results. -- rcs=? Reaction Conrol System? Rear Cannon Sights? udf = User Defined Function? (just making

Re: rcs udf for MySQL

2005-08-16 Thread Jason Pyeron
of a rcs udf (or similar) for MySQL? Google is not being nice to me, too much noise in the results. -- rcs=? Reaction Conrol System? Rear Cannon Sights? udf = User Defined Function? (just making sure) What is it, what does it do and where did you hear of such a thing? Maybe we could help if we had

Re: rcs udf for MySQL

2005-08-16 Thread SGreen
/ On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote: Jason Pyeron [EMAIL PROTECTED] wrote on 08/16/2005 01:01:03 PM: Anyone out there heard of a rcs udf (or similar) for MySQL? Google is not being nice to me, too much noise in the results. -- rcs=? Reaction Conrol System? Rear Cannon

[sorta off topic] Re: rcs udf for MySQL

2005-08-16 Thread Jason Pyeron
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote: After following your link, I am sure that some RCS systems that use MySQL as a backend *may* use UDFs as part of their persistence logic, but those would be specific to the RCS product you are curious about. There aren't any generic UDFs that will

Re: [sorta off topic] Re: rcs udf for MySQL

2005-08-16 Thread SGreen
Jason Pyeron [EMAIL PROTECTED] wrote on 08/16/2005 04:17:15 PM: On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote: After following your link, I am sure that some RCS systems that use MySQL as a backend *may* use UDFs as part of their persistence logic, but those would be specific to the RCS

Re: [sorta off topic] Re: rcs udf for MySQL

2005-08-16 Thread Jason Pyeron
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote: Now... don't be so hasty. MS SQL has a form of RCS you can use to check in and check out stored procedures and other design elements using Visual Source Safe (VSS). VSS acutally uses extended stored procedures (the mutant cousins of UDFs) to perform

Stored function problems (Was: UDF failure)

2005-07-07 Thread Nic Stevens
Hi, Still having difficulty with stored functions. I downloaded and installed MySQL 5.0.7 and I *still* cannot get stored functions to work. I used the example for hello from section 19.2.1 of the online documentation for MySQL and the example code doesnt work for me either. Below are the

Re: Stored function problems (Was: UDF failure)

2005-07-07 Thread Paul DuBois
At 11:41 -0700 7/7/05, Nic Stevens wrote: Hi, Still having difficulty with stored functions. I downloaded and installed MySQL 5.0.7 and I *still* cannot get stored functions to work. I used the example for hello from section 19.2.1 of the online documentation for MySQL and the example code

Re: Stored function problems (Was: UDF failure)

2005-07-07 Thread Peter Brawley
Nic, At the end of the func, your sproc delimiter // needs to come before restoration of the semi-colon as delimiter, thus: DELIMITER // CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) RETURN CONCAT('Hello, ',s,'!'); // DELIMITER ; PB - Nic Stevens wrote: Hi, Still having

UDF failure

2005-07-06 Thread Nic Stevens
Hello, I'm trying to build a UDF for MySQL 4.1.12. I'm running on Linux (FedoraFC1). My UDF function seemed to blow up the server so I went to the source and tried to build udf_example.cc. Using the precompiled binaries for Linux and using the source distribution for the same version

Re: UDF failure

2005-07-06 Thread Gleb Paharenko
Hello. When attempting to load a new function with the mysql cli client the client complains that the server has gone away and reconnects with connection Check MySQL error log, server could die while loading the UDF. Stored procedures appeared only in 5 version. This works fine for me

Re: UDF failure

2005-07-06 Thread Greg Fischer
and reconnects with connection Check MySQL error log, server could die while loading the UDF. Stored procedures appeared only in 5 version. This works fine for me on 5.0.7. mysql create function hello (s char(20)) returns char(50) RETURN CONCAT('Hello, ',s,'!');// Query OK, 0

Re: UDF Request AGGLOM()

2005-04-11 Thread Dan Bolser
On Mon, 11 Apr 2005, Arjen Lentz wrote: Hi Dan, On Sat, 2005-04-09 at 02:59, Dan Bolser wrote: Who can I prod about setting up a UDF repo at MySQL. I think 'they' should do this ;) Yep it's an existing idea, a very good one, and it's on the todo. Putting such an infrastructure into place

RE: UDF request?

2005-04-11 Thread SGreen
GROUP BY Dept, Gender; Sean - Original Message -- Hi, I have a request for a UDF that I would find really useful. I am duplicating this question on the community list as well as the MySQL list, because I am not sure where best to make this kind of request

Re: UDF Request AGGLOM()

2005-04-10 Thread Arjen Lentz
Hi Dan, On Sat, 2005-04-09 at 02:59, Dan Bolser wrote: Who can I prod about setting up a UDF repo at MySQL. I think 'they' should do this ;) Yep it's an existing idea, a very good one, and it's on the todo. Putting such an infrastructure into place will take some time though. Would a special

RE: UDF request?

2005-04-08 Thread Dan Bolser
WHERE (a.Person * b.Person) % 4 = 3 GROUP BY Dept, Gender; Sean - Original Message -- Hi, I have a request for a UDF that I would find really useful. I am duplicating this question on the community list as well as the MySQL list, because I am not sure where best to make this kind

UDF Request AGGLOM()

2005-04-08 Thread Dan Bolser
Who can I prod about setting up a UDF repo at MySQL. I think 'they' should do this ;) http://lists.mysql.com/community/97 Anyway I am posting this request to 'community' because I still don't know the appropriate place to post UDF related stuff. This is anoter (potentially crazy) idea

RE: UDF request?

2005-04-08 Thread SGreen
? SELECT Dept, Gender, AVG(Spending) FROM table_one a CROSS JOIN table_two b WHERE (a.Person * b.Person) % 4 = 3 GROUP BY Dept, Gender; Sean - Original Message -- Hi, I have a request for a UDF that I would find really useful. I am duplicating

RE: UDF request?

2005-04-08 Thread Dan Bolser
with replacement. Do you see what I mean? SELECT Dept, Gender, AVG(Spending) FROM table_one a CROSS JOIN table_two b WHERE (a.Person * b.Person) % 4 = 3 GROUP BY Dept, Gender; Sean - Original Message -- Hi, I have a request for a UDF that I would

RE: UDF request?

2005-04-07 Thread Sean Nolan
a request for a UDF that I would find really useful. I am duplicating this question on the community list as well as the MySQL list, because I am not sure where best to make this kind of request (see the previous post http://lists.mysql.com/community/97). I think the following syntax would be really cool

RE: UDF request?

2005-04-07 Thread Sean Nolan
a request for a UDF that I would find really useful. I am duplicating this question on the community list as well as the MySQL list, because I am not sure where best to make this kind of request (see the previous post http://lists.mysql.com/community/97). I think the following syntax would be really cool

UDF request?

2005-03-31 Thread Dan Bolser
Hi, I have a request for a UDF that I would find really useful. I am duplicating this question on the community list as well as the MySQL list, because I am not sure where best to make this kind of request (see the previous post http://lists.mysql.com/community/97). I think the following

Central UDF project at mysql.com?

2005-03-30 Thread Dan Bolser
Hi, I searched for previous discussion on this topic, but didn't find any. I would like to see a centralized MySQL hosted UDF archive and development project. The only existing 'archives' seem to be somewhat poorly maintained (sorry), and suffer for their duplicated efforts and being loosely

Re: Central UDF project at mysql.com?

2005-03-30 Thread Mark Papadakis
] wrote: Hi, I searched for previous discussion on this topic, but didn't find any. I would like to see a centralized MySQL hosted UDF archive and development project. The only existing 'archives' seem to be somewhat poorly maintained (sorry), and suffer for their duplicated efforts

Re: Central UDF project at mysql.com?

2005-03-30 Thread Dan Bolser
if the work was a part of 'MySQL' proper and not just different groups of individuals. I know it wouldn't make any *real* difference, but it would make a psychological difference. Also a central project would be a way to boost visibility for different UDF projects, for example good (ongoing) work could

RE: Central UDF project at mysql.com?

2005-03-30 Thread Tom Crimmins
and developing UDF's, especially if the work was a part of 'MySQL' proper and not just different groups of individuals. I know it wouldn't make any *real* difference, but it would make a psychological difference. Also a central project would be a way to boost visibility for different UDF

Re: Queries inside UDF

2005-03-25 Thread sguazt sguazt
From: Philippe Poelvoorde [EMAIL PROTECTED] Reply-To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com Subject: Re: Queries inside UDF Date: Mon, 21 Mar 2005 11:05:39 + sguazt sguazt wrote: Hi! From: Philippe Poelvoorde [EMAIL PROTECTED] Reply

Re: Queries inside UDF

2005-03-21 Thread Philippe Poelvoorde
sguazt sguazt wrote: Hi! From: Philippe Poelvoorde [EMAIL PROTECTED] Reply-To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com To: mysql@lists.mysql.com Subject: Re: Queries inside UDF Date: Thu, 17 Mar 2005 08:22:46 + .. You can actually access a DB within a UDF, but you should do the same

Re: Queries inside UDF

2005-03-17 Thread Philippe Poelvoorde
by the number of queries there's the load of network communication: (Send Queries + Receive Results) * N (where N 1 in general); * do that via SQL+UDF; the advantage of this solution is the load of computation is on DB server ... the load due to the network communication a very minimal: Send Query One

Re: Queries inside UDF

2005-03-17 Thread sguazt sguazt
Hi! From: Philippe Poelvoorde [EMAIL PROTECTED] Reply-To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com To: mysql@lists.mysql.com Subject: Re: Queries inside UDF Date: Thu, 17 Mar 2005 08:22:46 + ... You can actually access a DB within a UDF, but you should do the same than when you're using

Queries inside UDF

2005-03-16 Thread sguazt sguazt
Hi folks! (I hope this is the right list ... if not please tell me where I can submit this post) I would like to create a MySQL UDF (i.e. User Defined Function) that embeds a query; for instance, suppose the UDF is named foobar: mysql SELECT foobar(); When foobar function receives the control

RE: Queries inside UDF

2005-03-16 Thread Tom Crimmins
On Wednesday, March 16, 2005 09:30, sguazt sguazt wrote: Hi folks! (I hope this is the right list ... if not please tell me where I can submit this post) I would like to create a MySQL UDF (i.e. User Defined Function) that embeds a query; for instance, suppose the UDF is named foobar

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
Hi! From: Tom Crimmins [EMAIL PROTECTED] To: sguazt sguazt [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: RE: Queries inside UDF Date: Wed, 16 Mar 2005 10:09:16 -0600 ... Can you explain exactly what you are using this for? What benefit does this provide over just executing the query? You

RE: Queries inside UDF

2005-03-16 Thread SGreen
sguazt sguazt [EMAIL PROTECTED] wrote on 03/16/2005 11:54:26 AM: Hi! From: Tom Crimmins [EMAIL PROTECTED] To: sguazt sguazt [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: RE: Queries inside UDF Date: Wed, 16 Mar 2005 10:09:16 -0600 ... Can you explain exactly what you

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
From: [EMAIL PROTECTED] To: sguazt sguazt [EMAIL PROTECTED] CC: mysql@lists.mysql.com,[EMAIL PROTECTED] Subject: RE: Queries inside UDF Date: Wed, 16 Mar 2005 12:37:59 -0500 I can almost follow the logic of your pseudocode. Can you explain what it is you are trying to compute? It seems as though

RE: Queries inside UDF

2005-03-16 Thread SGreen
Marco, I think I understand why you might want the end date of your projects to be dynamically calculated (assuming that's why you want this calculation to be a UDF?). You would be able to change a starting date, the project's duration, or add or delete a holiday and your ending dates would

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
there's the load of network communication: (Send Queries + Receive Results) * N (where N 1 in general); * do that via SQL+UDF; the advantage of this solution is the load of computation is on DB server ... the load due to the network communication a very minimal: Send Query One Time + Receive Result

compiler warning (UDF code)

2004-10-25 Thread Sergei Skarupo
HI everyone, Sorry if this question doesn't belong here... I tried to compile several open-source UDF's (downloaded from http://mysql-udf.sourceforge.net/) and got a warning. Could someone please elaborate on this: /usr/include/asm/atomic.h:40:2: warning: #warning Using kernel header in

Re: Implementing xml/xpath UDF with libxml2

2004-09-13 Thread Egor Egorov
Joel McConaughy [EMAIL PROTECTED] wrote: I'm trying to implement a UDF that supports xpath evaluation on a column using the gnome libxml2 library. The library is thread-safe EXCEPT for the initialization and deinitialization routines which need to be called on a pre-process basis. My

Implementing xml/xpath UDF with libxml2

2004-09-10 Thread Joel McConaughy
I'm trying to implement a UDF that supports xpath evaluation on a column using the gnome libxml2 library. The library is thread-safe EXCEPT for the initialization and deinitialization routines which need to be called on a pre-process basis. My question: 1. Is there a good place (or any place

Re: MySQL Restarts -UDF

2004-07-22 Thread Philippe Poelvoorde
coolcat2001 wrote: Hi, When an attempt is made to Create a Function that was dropped previously the mysql gets restarted. I have loaded the so into /usr/lib directory. The mysql is statically linked . If the mysql is statically linked, I can't see how you can load an UDF. You can either

MySQL Restarts -UDF

2004-07-21 Thread coolcat2001
Hi, When an attempt is made to Create a Function that was dropped previously the mysql gets restarted. I have loaded the so into /usr/lib directory. The mysql is statically linked . The mysql error log stated that it has got signal 11 has the following key_buffer_size=8388600

mysql restarts when creating UDF.

2004-07-12 Thread Prem Soman
hi, i have a very serious problem, when i try to reinitialise the database and start my application. By reinitilisation i would remove the database i created along with the UDF functions i created. Then when i try to start my application, which creates the database tables and the UDf, MySQL

Re: mysql restarts when creating UDF.

2004-07-12 Thread Philippe Poelvoorde
. By reinitilisation i would remove the database i created along with the UDF functions i created. Then when i try to start my application, which creates the database tables and the UDf, MySQL Restarts . The following error was logged in the error log : Number of processes running now: 0 040712 18:26:33

Strange return behaviour in UDF (bug?)

2004-05-25 Thread Richard Massa
Hi there, I'm getting a strange behaviour when returning a value from my user defined function. When I print the return value inside of the function, I get one answer (the correct one), however mysql reports a different value all together. Is this my programming error or a mysql bug? Here's

MySQLd crash within a UDF on Linux

2004-04-28 Thread frankie
Description: I'm experiencing a Linux-related only problem with a simple UDF which call mysql_real_connect() How-To-Repeat: A very simple function: #include stdio.h #include stdlib.h #include string.h

UDF: how to get chracter set or convert stinrg to another character set

2004-04-10 Thread HIROSE, Masaaki
Hi all, I have two question about UDF(User Defined Function) (MySQL-4.1.1-alpha-Max-log and 4.0.18-log) 1. how to get character_set_* in UDF. I want to get following character_set_* information in UDF. MySQL-4.1.1: character_set_serve character_set_system character_set_database

Mysql UDF

2004-03-30 Thread Prem Soman
HI! I wrote a mysql UDF that works well in older versions of mysql (3.23.*) but the same is not working for new versions like (4.0*) . The server restarts every time i invoke my function . I also compiled and linked with libmysqlclient.so.11, but still the problem persists. how to solve

  1   2   >