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 of the

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 of the

Re: UDF behaves non-deterministic

2012-11-07 Thread Stefan Kuhn
not, the man page 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 wrote: > > Hi Dan, > > > > thanks for your

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. > <<&

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 t

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) proble

Re: Re: UDF behaves non-deterministic

2012-11-05 Thread Michael Dykman
page 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 wrote: > Hi Dan, > > thanks for your answer. The UDF only contains functions (the one called

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

Re: UDF behaves non-deterministic

2012-11-04 Thread Dan Nelson
the function 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

Re: UDF behaves non-deterministic

2012-11-04 Thread Stefan Kuhn
low (Pentium III 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: >

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,'

UDF behaves non-deterministic

2012-11-04 Thread Stefan Kuhn
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 ov

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 > http://fossies.org/dox/glibc-2.16.0/sysdeps_2mach

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Martin Gainty
ous ne pouvons accepter aucune 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 t

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

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Martin Gainty
n'aura pas n'importe 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? &g

UDF writing to unix socket - segfaults?

2012-08-07 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

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 optio

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 thre

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: termin

Re: udf return column name not value

2010-03-15 Thread chamila gayan
Sent: Monday, March 15, 2010 12:58 AM > To: mysql@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); > retur

RE: udf return column name not value

2010-03-15 Thread Gavin Towey
, 2010 12:58 AM To: mysql@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

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' wha

Re: UDF - Sequence Numbers

2010-03-09 Thread Johnny Withers
t that's a small > price to pay for correctness. > > Regards, > Gavin Towey > > -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

RE: UDF - Sequence Numbers

2010-03-08 Thread Gavin Towey
-- 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 a table that holds recor

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 f

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 Antony T Curtis
Java Package and I want 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

Re: JAVA UDF HOW

2008-06-05 Thread Abhayjeet Singh Grewal
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- >>> &g

Re: JAVA UDF HOW

2008-06-04 Thread Antony T Curtis
ge and I want 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 Ha

Re: JAVA UDF HOW

2008-06-04 Thread Dan Nelson
I don't think that's possible 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

Re: JAVA UDF HOW

2008-06-04 Thread Abhayjeet Singh Grewal
<[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/docs/cd/E10391_01/doc.910/e10363/oimadm.htm#CIAEFFAD > > ? > Martin > - Original Message - From:

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.

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? &g

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 wi

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 clien

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 f

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 tha

RE: udf configuration

2006-07-19 Thread Jimmy Guerrero
6 6:10 PM > 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

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.

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.

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,

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. T

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(fra

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((fl

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. >>> Puttin

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

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 li

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

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 t

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

[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 a

Re: rcs udf for MySQL

2005-08-16 Thread SGreen
ser defined functions > > http://www.cs.purdue.edu/homes/trinkle/RCS/ > > 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

Re: rcs udf for MySQL

2005-08-16 Thread Jason Pyeron
d 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

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

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: 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 di

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 doe

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: UDF failure

2005-07-06 Thread Greg Fischer
> > >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 on 5.0.7. >

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

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 sa

RE: UDF request?

2005-04-11 Thread SGreen
re doing below) I don't necessarily get the same > >> 'marginals' (or to randomly pick the same rows from either side of the > >> join) . This is analagous to sampling with replacement. > >> > >> Do you see what I mean? > >> > >> &

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

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

RE: UDF request?

2005-04-08 Thread Dan Bolser
>> >> Do you see what I mean? >> >> >> >> >> > >> >SELECT >> > Dept, >> > Gender, >> > AVG(Spending) >> >FROM >> > table_one a >> >CROSS JOIN >> > table_two b >> >WHERE (a

RE: UDF request?

2005-04-08 Thread SGreen
ROM > > 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

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 (pote

RE: UDF request?

2005-04-08 Thread Dan Bolser
ean? > >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

RE: UDF request?

2005-04-07 Thread Sean Nolan
ssage -- 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 followi

RE: UDF request?

2005-04-07 Thread Sean Nolan
ssage -- 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 followi

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

RE: Central UDF project at mysql.com?

2005-03-30 Thread Tom Crimmins
ical difference. > Also a central project would be a way to boost visibility for > different UDF projects, for example good (ongoing) work could be > showcased in the MySQL news letter. > > >> Still, having them all in one place could be nothing but a good >> thing. &

Re: Central UDF project at mysql.com?

2005-03-30 Thread Dan Bolser
;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 projects, fo

Re: Central UDF project at mysql.com?

2005-03-30 Thread Mark Papadakis
TED]> 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 > mainta

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 an

Re: Queries inside UDF

2005-03-25 Thread sguazt sguazt
From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'mysql@lists.mysql.com '" To: "'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 PRO

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 '" 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

Re: Queries inside UDF

2005-03-17 Thread sguazt sguazt
Hi! From: Philippe Poelvoorde <[EMAIL PROTECTED]> Reply-To: "'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

Re: Queries inside UDF

2005-03-17 Thread Philippe Poelvoorde
ed by the number of queries there's the load of network communication: ( + ) * 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: + When I tried

RE: Queries inside UDF

2005-03-16 Thread sguazt sguazt
f queries there's the load of network communication: ( + ) * 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: + When I tried UDF I'm said

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 d

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 tryi

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 > &g

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 executi

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, sup

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 cont

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 use

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 c

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

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 e

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 read_buffer_si

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:

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

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 wha

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 #includ

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 the

  1   2   >