Re: UDF SELECT query spoils the results

2004-01-20 Thread Alexander
The problem was solved: it was up to static variable features, not MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UDF SELECT query spoils the results

2004-01-19 Thread Alexander
Hi all, I've got strange thing with my UDF. My UDF receives 2 text columns as parameters - fields of type "text" (protein or nucleo sequences). It makes by pair comparison and the result is char* - set of output sequences (aligned). Input table is seqTbl: id | seq_type | seq For

Re: UDF on AMD64

2003-12-12 Thread Ollie Gallardo
n. I tried to compile my UDF with the >> gcc on my Opteron system and I got errors. >> Errors: >> /usr/lib64/gcc-lib/amd64-mandrake-linux- gnu/3.3.1/../../../../lib64/crt1.o(.text+0x21): >> In function `_start': >> ../sysdeps/x86_64/elf/start.S:92: undefined referenc

Re: UDF on AMD64

2003-12-11 Thread Dan Nelson
In the last episode (Dec 11), Ollie Gallardo said: > I'm back with another question. I tried to compile my UDF with the gcc on > my Opteron system and I got errors. > Errors: > /usr/lib64/gcc-lib/amd64-mandrake-linux-gnu/3.3.1/../../../../lib64/crt1.o(.text+0x21): >

Re: UDF on AMD64

2003-12-11 Thread Ollie Gallardo
I'm back with another question. I tried to compile my UDF with the gcc on my Opteron system and I got errors. Errors: /usr/lib64/gcc-lib/amd64-mandrake-linux-gnu/3.3.1/../../../../lib64/crt1.o(.text+0x21): In function `_start': ../sysdeps/x86_64/elf/start.S:92: undefined reference to `m

Compiling UDF on Sparc Solaris

2003-12-11 Thread Devin Eyre
Has anyone had any success compiling udf_example.so (and getting it to work) on sparc solaris 8? I've tried it with the Sun Forte compilers, using the configure options mentioned in the on-line manual, and also with gcc 2.95.3. I was able to get it to work easily on Linux using gcc 3.3.1. -- MyS

Re: UDF on AMD64

2003-12-11 Thread Ollie Gallardo
Thanks Dan. I will get to it then. Dan Nelson said: > In the last episode (Dec 11), Ollie Gallardo said: >> I just recently built myself a dual Opteron system and installed mysql >> for AMD64 on it. I previously ran my databases on regular 32 bit >> systems and had my UDF wor

Re: UDF on AMD64

2003-12-11 Thread Dan Nelson
In the last episode (Dec 11), Ollie Gallardo said: > I just recently built myself a dual Opteron system and installed > mysql for AMD64 on it. I previously ran my databases on regular 32 > bit systems and had my UDF working fine. The UDF is written in C. > Before I try and install th

UDF on AMD64

2003-12-11 Thread Ollie Gallardo
Hi, I just recently built myself a dual Opteron system and installed mysql for AMD64 on it. I previously ran my databases on regular 32 bit systems and had my UDF working fine. The UDF is written in C. Before I try and install the UDF on the new system should I recompile it using AMD64 libraries

Re: mysql UDF in windows

2003-12-04 Thread miguel solorzano
At 11:45 4/12/2003 +, Prem Soman wrote: Hi, how can i resolve this and what the prototype for functions that returns integer values. i searched the manual but got no solution. In the \sql\udf_example.cpp you find: #ifdef __WIN__ typedef unsigned __int64 ulonglong; /* Microsofts 64 bit typ

mysql UDF in windows

2003-12-04 Thread Prem Soman
i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that retur

Problem with aggregate UDF avgcost

2003-12-03 Thread Tamara Guseva
Dear colleagues! I need to create my own aggregate UDF, so I decided to test UDF_example from Windows MySQL source. I've created udf_example.dll and udf_example.lib with VC++ 6.0. Then, I haven't any problem with all of udf's, excepting the aggregate udf avgcost. On my "SELECT

Re: RedHat 9, MySQL RPM 4.0.16-0 and UDF...

2003-11-23 Thread Jason Pyeron
rpm -i MySQL-Max.rpm solved it On Sun, 23 Nov 2003, Jason Pyeron wrote: > Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out. > This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes. > > On Sun, 23 Nov 2003, Jason Pyeron wrote: > > > > > I have never seen an error like this one,

Re: RedHat 9, MySQL RPM 4.0.16-0 and UDF...

2003-11-22 Thread Jason Pyeron
Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out. This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes. On Sun, 23 Nov 2003, Jason Pyeron wrote: > > I have never seen an error like this one, are the RPMs setup for dynamic > libraries? > > ERROR 1126: Can't open shared library

RedHat 9, MySQL RPM 4.0.16-0 and UDF...

2003-11-22 Thread Jason Pyeron
I have never seen an error like this one, are the RPMs setup for dynamic libraries? ERROR 1126: Can't open shared library 'diff.so' (errno: 0 /lib/tls/libc.so.6: unexpected reloc type 0x0€$ôç¿_½) Sincerely, Jason Pyeron -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -

UDF

2003-11-17 Thread Arūnas Milašauskas
Hi, Has anybody created UDF's in MySQL? Is there a way to create UDF without compiling MySQL with -with-ldflags=-rdynamic? Maybe they must be simple expresion based without using somewhat wrom mysqld (as said in documentation)? Thanks for advice, Arunas -- MySQL General Ma

Problem with UDF

2003-09-05 Thread Gustavo Castro
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m getting problems trying to add UDFs to my MySQL - In /mysql/sql/tipo.h i´ve declared this data type: typedef struct st_del { int empty; char *table; List keys; }BUFFER_DEL; where List is included from the sql_list.h, a

UDF support on windows

2003-08-29 Thread Marek Lewczyk
Hello, I have found a very interesting UDF function called MyPHP. There is no problems with UDF installation on Linux based machine but my latop and all developing tools are working on windows and I don't know how to install UDF on windows. Can anyone help me with this ?? ML --

Re: UDF Programming Problem

2003-08-14 Thread Ariz Jacinto
Jeremy Zawodny wrote: On Tue, Aug 12, 2003 at 02:32:00PM +0800, Ariz Jacinto wrote: i've created a simple UDF (for testing) that returns a string. my problem is that the string that it returns, contain some of the characters of the longest string in the column. example:

My UDF for Snort/ACID

2003-08-14 Thread Bryan Miller
Well, under the heading of "If you want it done, do it yourself", I wrote the following UDF this afternoon. I needed something to take the 4-byte integers representing IP addresses from Snort/ACID and turn them into fully qualified domain names for reports. This works under Linux. Th

UDF Programming Problem

2003-08-14 Thread Ariz Jacinto
i've created a simple UDF (for testing) that returns a string. my problem is that the string that it returns, contain some of the characters of the longest string in the column. example: Table +-+ |name | +-+ | hello world | | go

Re: UDF Programming Problem

2003-08-14 Thread Murad Nayal
Hello, > > extern "C" __declspec(dllexport) char *echo(UDF_INIT *initid, UDF_ARGS *args, char > *is_null, char *error) > { > return args->args[0]; > } > args->args[0] is not null terminated. This is how I've been handling this. please let me know if there is a better approach (i.e. whether

Re: UDF Programming Problem

2003-08-14 Thread Jeremy Zawodny
On Tue, Aug 12, 2003 at 02:32:00PM +0800, Ariz Jacinto wrote: > i've created a simple UDF (for testing) that returns a string. > my problem is that the string that it returns, contain some > of the characters of the longest string in the column. > >

lookup and reverse_lookup UDF problem

2003-08-11 Thread Bryan Miller
I, like others, am having trouble getting the two UDF's mentioned above to work correctly. I successfully compiled MySQL 4.0.14 dynamically with the -rdynamic flag on Linux 8. I have also compiled the udf_example.cc file using the -shared option. Everything seems to go OK when I'm using the CREA

finding user details inside UDF

2003-07-17 Thread Prem Soman
hi! i heared that its possible to get user details inside the UDf by adding the mysql_priv.h header file. But where will this file be available. i am using MySql 3.23.52 on linux8.0 when i try to compile it says :"mysql_priv" file not found. If i can include this file, i can get

UDF-Functions crashes DB-Engine

2003-07-01 Thread Peter-Ulrich
>Description: since a few days the start of a UDF-Function crashes the DB-Engine which results in a Restart. I have a Version from 2003-06-03 (Bitkeeper-Archive) without any Problems. >How-To-Repeat: starting any UDF-Function >Fix: >

Re: Fwd: data-retrieving udf

2003-03-05 Thread Joseph Bueno
hi, There is an example (udf_example.cc) in 'sql' sub-directory of mysql sources. You can code your functions in C++ but you must declare your UDF entry points as 'extern "C"' Regards, Joseph Bueno Maurizio Oristanio wrote: hi everybody, i'm trying to add a ud

Fwd: data-retrieving udf

2003-03-05 Thread Maurizio Oristanio
hi everybody, i'm trying to add a udf to mysql that itself accesses the database. anybody ever tried that? i want a function to dynamically create a database, symbolic links and tables. i thought it could be as easy as just mix up a "normal udf" with my table-creating thing. bu

UDF and mysql binary distr

2003-02-28 Thread Diana Soares
Hi, For the busy ones, here's my question (then i explain): is it possible to add an UDF to a binary distr (.rpm for RH-8, downloaded from mysql.com) ? I'm having problems in creating an UDF (i create but when a use it mysqld restarts automatically). I've already created UDF f

Error creating an udf

2002-10-18 Thread Karel Antonio Verdecia Ortiz
I read the indications in the MySQL manual about how to create an user defineable function and I implemented a dll (I am working in win2000). When I try to execute the query: CREATE FUNCTION cuadrado RETURNS REAL SONAME 'cuadrado.dll' it shows the message: 1105 - Unknown error I am working

UDF and strlen

2002-10-14 Thread FABIAN VON ROMBERG
Hi, Im experiencing some problems with strlen in a MySql UDF function. My function takes 2 string parameters, when any of them is from a table field, strlen does not return the real length of the string, example: long test(UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error

MySql UDF under WIN32

2002-10-10 Thread FABIAN VON ROMBERG
Hi, I finally could get MySql UDF functions to work under win32 (VC++). The only thing that concerns me is that it nevers returns any error message. It works fine, but none error message is displayed. The function expects 2 strings, if one, more or none is passed, I should get the error

Re: UDF in c++ problem

2002-09-06 Thread Gelu Gogancea
] [EMAIL PROTECTED] - Original Message - From: "Fei Chen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 7:03 PM Subject: UDF in c++ problem > Dear list, > > I have a version of a shared lib, say udf_test

UDF in c++ problem

2002-09-06 Thread Fei Chen
Dear list, I have a version of a shared lib, say udf_test.so, written in C, that loads using "mysql> CREATE FUNCTION ..." without a problem. Now say I create another lib, udf_test1.so, that's written in C++ and includes code from udf_test.so (declared using extern "C"{}), MySQL complains ERROR 11

Re: link under Win32 for udf

2002-09-06 Thread Nick Kostirya
Thank you very much for your answer. I am sorry to have misled you by my incomplete question. I asked you about build MySql from src earlier and that message was mistakingly associated with the previous one. I meant building not dll containing UDF, but MYSQL itself. I built it as specified in

RE: link under Win32 for udf

2002-09-06 Thread Chugh Shalini
: LIBRARY UDF_EXAMPLE DESCRIPTION 'Example Using UDF with VC++' VERSION 1.0 EXPORTS metaphon myfunc_double myfunc_int avgcost - Right Click the udf_example project and select Settings - Click the C/C++ tab - Select Gene

link under Win32 for udf

2002-09-03 Thread Nick Kostirya
Hello. It's anew me. And how linking under Win32 with --with-mysqld-ldflags=-rdynamic? I need UDF. Thanks in advance. Nick. mysql - Before posting, please check: http://www.mysql.com/manual.php (the m

Re: How to Print from UDF to MySQL screen?

2002-07-17 Thread Gerald Clark
print them to a log file, and tail -f logfile from another window. Fei Chen wrote: >Dear all, > >I'm trying to write some UDFs and it will help a lot if I can print >debugging information out directly to the screen so I can see what's going >on. But printf() etc does not print to the mysql cli

How to Print from UDF to MySQL screen?

2002-07-17 Thread Fei Chen
Dear all, I'm trying to write some UDFs and it will help a lot if I can print debugging information out directly to the screen so I can see what's going on. But printf() etc does not print to the mysql client screen. Is there an easy work around? Thanks for any tips, fei

Re: UDF: Funcion definida por el usuario

2002-07-15 Thread Georg Richter
On Monday, 15. July 2002 15:28, Daniel BI wrote: > Hola listeros :) Hola! please write in english, or use the spanish mailing list ([EMAIL PROTECTED]) Thx Georg - Before posting, please check: http://www.mysql.com/manual.

UDF: Funcion definida por el usuario

2002-07-15 Thread Daniel BI
Hola listeros :) acabo de construir e instalar una nueva funcion (muy simple) en MySQL, la ucwords() de PHP. (Hacer mayuscula la primera letra de cada palabra de un texto; funciona solamente con datos char y varchar, es decir hasta 255 characteres). Si les interesa (solamante para linux), les

XPath UDF

2002-07-11 Thread Dave Benjamin
Hello, I have written a UDF for MySQL in C++ that allows you to use XPath expressions in your queries. I'd appreciate any ideas anyone might have about this. It seems like it could be very useful, especially for databases that integrate XML with relational tables. It requires the li

UDF Last Solution

2002-07-09 Thread Miles Roper
Hi All, Well I think I actually managed to fumble my way to a solution to this. I took the example avg_cost UDF function and modified it somewhat (well, hacked it to pieces). I've tried this before but I actually tried to rewrite it, bad mistake. This time I just deleted all the bits I d

RE: UDF, Can anyone please help?

2002-07-09 Thread Miles Roper
Miles Roper Subject: RE: UDF, Can anyone please help? Hi Miles, Then I think that the easiest way is to create a temporary table from this query: Create Temporary Table TempTable Select Max(IDField) >From TheTable Group by Field1; Then your inner join the temporary table with yours: Select t

RE: UDF, Can anyone please help?

2002-07-09 Thread Miles Roper
son [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 9 July 2002 05:37 To: 'Miles Roper'; '[EMAIL PROTECTED]' Subject: RE: UDF, Can anyone please help? So if below is actually what your data looks like, what about: Select Field1, Field2, MAX(IDField) From MyTable Group by Field1 Tha

RE: UDF, Can anyone please help?

2002-07-08 Thread noel . clarkson
So if below is actually what your data looks like, what about: Select Field1, Field2, MAX(IDField) From MyTable Group by Field1 That might get the correct answer for you, but it does however have an extra field in the result (which may or may not be a problem). cheers, noel filter word:mysql

RE: UDF, Can anyone please help?

2002-07-08 Thread Miles Roper
x27;[EMAIL PROTECTED]' Subject: Re: UDF, Can anyone please help? Hi Miles, Could you explain the same thing with a some sample data? I does not need to be your data. I think that what you want to do is this but I am not sure. Field1 Field2 A 1 A 1 A 2 A 3 B 1 B 1 B

Re: UDF, Can anyone please help?

2002-07-08 Thread Francisco Reinaldo
sort by ID > and grab the first row to > get the same thing. This will not work as I need to > do it over several > thousand different groups. So I need the last row > per group. > > I have been trying to write a aggregate last UDF > function in mysql, and > would co

UDF, Can anyone please help?

2002-07-07 Thread Miles Roper
last function in mysql. I know you can do a descending sort by ID and grab the first row to get the same thing. This will not work as I need to do it over several thousand different groups. So I need the last row per group. I have been trying to write a aggregate last UDF function in mysql, and

RE: UDF on win2k??

2002-06-24 Thread Mike Grover
I know version 4.0.1 does. I use Delphi 6 to write my UDF's for it. mike -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 9:20 PM To: [EMAIL PROTECTED] Subject: UDF on win2k?? hi, i checked the manual, but i want a confirmation

UDF on win2k??

2002-06-23 Thread Inandjo Taurel
hi, i checked the manual, but i want a confirmation here: Mysql for window doesn't have UDF, right? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/int

How to compile a UDF under win32?

2002-06-18 Thread Nick Kostirya
Hi, All. Please, tell my how to compile a UDF under win32. For example, udf_example.cc cl /GX /TP /nologo /c udf_example.cc link /nologo /dll /out:udf_example.so udf_example.obj It do not export the functions :-( dumpbin /export udf_example.so DUMPBIN : warning LNK4044: unrecognized

UDF problems

2002-06-06 Thread Elteto Zoltan
Hi all, I have tried several times to integrate the lookup functiction into mysql but with no luck. :( I have REDHAT 7.3 with gcc 2.96 and with mysql-3.23.49 I compiled udf_example.so and copied into /usr/lib folder. When I try to do CREATE FUNCTION lookup RETURNS STRING SONAME "udf_exampl

RE: Help Writing UDF

2002-05-21 Thread Larry Thrall
: Tuesday, May 21, 2002 8:34 AM To: [EMAIL PROTECTED] Subject: Help Writing UDF I was wondering if any one could help me with a about writing UDF's for mysql. If I reallocate more memory for the result string; ie char *myResult; myResult = (char *) calloc(1, resultSize); *res_length = (

Help Writing UDF

2002-05-21 Thread Gav Brown
I was wondering if any one could help me with a about writing UDF's for mysql. If I reallocate more memory for the result string; ie char *myResult; myResult = (char *) calloc(1, resultSize); *res_length = (ulong) resultSize; return myResult; Do I have to free it anywhere - and if so where?

Very very Simple UDF Example...

2002-05-09 Thread Mike Grover
Here is download for Very Simple UDF example for MySQL 4 and Delphi 6. This is by ni means perfect... mike http://www.tctelco.net./~mmgrover/udf.zip - Before posting, please check: http://www.mysql.com

UDF and embedded MySQL

2002-04-30 Thread Joey Mukherjee
I know the documentation says UDF and embedded MySQL server is not allowed, but then it says, some of these limitations can be changed by editing mysql_embed.h. I see in there that it has HAVE_DLOPEN undefined. I assume it is not as simple as uncommenting that line to whether or not UDF will

Example UDF for anyone interested

2002-04-27 Thread Adam Hooper
If anyone's looking for another nice user-defined function example, I've just set one up at work and am happy to share the wealth :). They're really quite cool, and this one is a good deal simpler than udf_example.cc. The function is at: http://www.adamhooper.com:4242/ccode/project_view.php?pro

Re: MySQL UDF questions

2002-04-11 Thread Georg Richter
On Thursday, 11. April 2002 10:26, Fei Chen wrote: > Dear Georg, > > > * notation. Just as normally I can say > select * from myTable; > can I write a UDF to handle > select my_udf(*) from myTable; ? > There is the builtin function > select count(*) from myTable; > B

Re: MySQL UDF questions

2002-04-11 Thread Fei Chen
x27;m wondering is there a shortcut way to specify all the fields from myTable, using the * notation. Just as normally I can say select * from myTable; can I write a UDF to handle select my_udf(*) from myTable; ? There is the builtin function select count(*) from myTable; But the manual does not sa

Re: MySQL UDF questions

2002-04-10 Thread Georg Richter
On Thursday, 11. April 2002 02:11, Fei Chen wrote: > How do I write a UDF to handle a entire tuple, e.g. is it possible to have > select my_udf(*) from myTable; > ? Parmeters in the UDF could also be fields from a table. > Also, is there a way for a UDF to return a data structure,

MySQL UDF questions

2002-04-10 Thread Fei Chen
Dear all, I'm new to writing UDFs in MySQL so please bear with my couple of questions. How do I write a UDF to handle a entire tuple, e.g. is it possible to have select my_udf(*) from myTable; ? Also, is there a way for a UDF to return a data structure, say, a multi dimensional array? Or

PHP in UDF

2002-03-25 Thread Alexander Belyaev
Hello, I am very interesting in this work. Please continue it :) Alexander PS Any chance to get the sources? -- Server version: 4.0.2-alpha-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:cp1251 Server c

PHP in UDF

2002-03-25 Thread Cristian Giussani
Hi I have a first ( very alpha ) version of an UDF that allow users to write they own functions in PHP. In the package there is an example of a function that execute a query and check the results something like: SELECT * FROM table WHERE field1 IN ( SELECT field1 FROM table2 ); The UDF is

RE: UDF

2001-09-20 Thread Will French
What platform are you running on? Must... Have... Details... database > -Original Message- > From: Pavel Popov [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 20, 2001 6:57 AM > To: [EMAIL PROTECTED] > Subject: UDF > > > Hi, All. > > I have trie

UDF

2001-09-20 Thread Pavel Popov
Hi, All. I have tried to add UDF, but has received a error 1105. The beginnings to understand and has found out, I do not have table "func" in base "mysql". Help me, please! What structure it has? -- Best regards, Pavel mai

Fw: UDF parameters

2001-08-06 Thread Igor Brynskich
Hello, Is there a way to get parameters list for compiled UDF without its source available? If there, how can I get this parameters list? Best regards, Igor Brynskich Database - Before posting, please check

Re: Question about UDF

2001-05-29 Thread Mike V. Andreev
Tuesday, May 29, 2001, 6:11:31 PM, you wrote: MVA> conditions: MVA> MySQL-3.23.32 MVA> FreeBSD 4.2-RELEASE MVA> problem: sorry for spam. I'm newbie in this stuff. Now i compiled this example, but it still doesn't work bash-2.04$ mysql -p -u admin mysql> CREATE FUNCTION metaphon RETURNS STRI

Question about UDF

2001-05-29 Thread Mike V. Andreev
nsult this file to see how UDF calling conventions work. [...] == sql/udf_example.cc: ** A dynamicly loadable file should be compiled sharable ** (something like: gcc -shared -o udf_example.so myfunc.cc). ** You can easily get all switches rig

query in UDF??

2001-05-03 Thread Danny Cardonne
hi can i do a query in a udf? if so how? if not then it's more complicated: i want for security reason that a certain user make a query to the database and receive the result, but i don't want the user to modify the query except the where field=variable, so i want to create a functi

Problems with udf functions.

2001-04-26 Thread Christian Hammers
Hello My udf function (inet_aton functionality for 3.21.33 server) does work in 99% percent of all cases, just when I use it on the output of a outer join where some fields are NULL it crashes the server - when giving NULL as argument directly it works: result of a join of 2 very simple tables

Re: UDF kills mysqld with longer strings

2001-04-06 Thread Sinisa Milivojevic
Honza Pazdziora writes: > On Fri, Apr 06, 2001 at 04:52:21PM +0300, Sinisa Milivojevic wrote: > > > > To solve the above you have also to malloc a pointer in _init function > > and free it in _end function. > > Great, works like a charm. Just to make sure: is it OK to use > my_malloc to a

Re: UDF kills mysqld with longer strings

2001-04-06 Thread Honza Pazdziora
On Fri, Apr 06, 2001 at 04:52:21PM +0300, Sinisa Milivojevic wrote: > > To solve the above you have also to malloc a pointer in _init function > and free it in _end function. Great, works like a charm. Just to make sure: is it OK to use my_malloc to allocate and free to free, or should I use som

Re: UDF kills mysqld with longer strings

2001-04-06 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > > UDF working with strings longer than (I believe) 255 bytes kills > the server. Even if the initid->max_length is set to the length of > the string that will be returned, as the manual suggests. > > Please not that

UDF kills mysqld with longer strings

2001-04-06 Thread adelton
>Description: UDF working with strings longer than (I believe) 255 bytes kills the server. Even if the initid->max_length is set to the length of the string that will be returned, as the manual suggests. Please not that in this case, no additional memory is needed -- the function just

Re: Add: Problem removing multiple udf functions ...

2001-03-22 Thread Sinisa Milivojevic
pid 30175 - killed > 010322 05:16:56 mysqld restarted > /usr/local/mysql-3.23.33/libexec/mysqld: Warten auf Verbindungen. > > > > Hi! I have tried dropping an UDF in 3.23.35 and did not have any problem. Please try our binary distro for 3.23.35 o

Add: Problem removing multiple udf functions ...

2001-03-21 Thread Stephan Skusa
z 2001 05:19 An: [MYSQL] Betreff: Problem removing multiple udf functions ... Hello, I've got a problem. If I remove multiple udf-Funktions of one udf-Library i get a 'lost connection' error. I'm using a sql-script deleting for example 4 functions and then recreate them (because of

Problem removing multiple udf functions ...

2001-03-21 Thread Stephan Skusa
Hello, I've got a problem. If I remove multiple udf-Funktions of one udf-Library i get a 'lost connection' error. I'm using a sql-script deleting for example 4 functions and then recreate them (because of an update of the .so) Any ideas?? TIA

Re: UDF Causing mysqld to crash/restart

2001-03-10 Thread Sinisa Milivojevic
Aaron Weiss writes: > Hi, > > I wanted to create a UDF for MySQL that can use the ASpell engine to > generate a string of spelling suggestions, given a single word > parameter. Thus, select aspell('wrd') should return Aspell's suggested > spellings. >

UDF Causing mysqld to crash/restart

2001-03-09 Thread Aaron Weiss
Hi, I wanted to create a UDF for MySQL that can use the ASpell engine to generate a string of spelling suggestions, given a single word parameter. Thus, select aspell('wrd') should return Aspell's suggested spellings. I don't know C very well at all, so I began using an e

UDF Causing mysqld to crash/restart

2001-03-09 Thread Aaron Weiss
Hi, I'm looking for help in an area that I'm without much experience. I want to create a UDF for MySQL that can use the ASpell engine to generate a string of spelling suggestions, given a single word parameter. Thus, select aspell('wrd') should return Aspell's suggested

UDF 'create function' error, or is it just me?

2001-03-08 Thread Geir Rastad
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 seems to only funct

Re: UDF - string problem

2001-02-13 Thread Sinisa Milivojevic
Thomas Kaester writes: > Hello Sinisa and everybody who can help me! > > I try to develop a UDF which returns a string! But I get only 256 characters of the >string! I tried to change my alloc function, so that I only use my_malloc and >my_free! But the result is the same

Urgent-UDF problem

2001-02-12 Thread Thomas Kaester(global)
Hello Sinisa and everybody else, sorry that I contact you directly! But I tried all suggestions and it still doesn't work! The UDF return string has always 256 characters! I've used my_malloc and my_free! Also I allocated the necessary memory in xxx_init()! But it doesn't work

UDF - string problem

2001-02-12 Thread Thomas Kaester
Hello Sinisa and everybody who can help me! I try to develop a UDF which returns a string! But I get only 256 characters of the string! I tried to change my alloc function, so that I only use my_malloc and my_free! But the result is the same! The necessary memory is allocated in xxx_init() and

Re: UDF Problem

2001-02-12 Thread Sinisa Milivojevic
Thomas Kaester(global) writes: > Hello everybody, > > I have a big UDF problem and I hope that anybody can help me! > > In details: > > I have developed an UDF which returns a string which is longer than 256 > characters! But the function only returns the

UDF Problem

2001-02-12 Thread Thomas Kaester(global)
Hello everybody, I have a big UDF problem and I hope that anybody can help me! In details: I have developed an UDF which returns a string which is longer than 256 characters! But the function only returns the first 256 characters and not the whole string. I checked the UDF_INIT struct but the

another bug in substring_index in conjunction with UDF functions?

2001-02-07 Thread Michael Widenius
Hi! >>>>> "ch" == ch <[EMAIL PROTECTED]> writes: >> Description: ch> My udf function and an equal udf function I found in the internet ch> seem to work well as does substring_index. Only when I call them ch> together I get a bug.

UDF

2001-02-06 Thread SuperTruck
Hi, I want to create a function for use as below: select Code, Description, My_NewFunc(Code) from producs order by Description where My_NewFunc: . receives each product code of in "ptoducts" table . proccess a table T1 using the Code parameter to sum the column Quantity1 for the code passed as

another bug in substring_index in conjunction with UDF functions?

2001-02-06 Thread ch
>Description: My udf function and an equal udf function I found in the internet seem to work well as does substring_index. Only when I call them together I get a bug. As my function (quotet below) is so simple that it doubtly has a bug I guess substring_index

Re: Adding UDF functions

2001-01-24 Thread Jeremy D. Zawodny
On Wed, Jan 24, 2001 at 05:20:30PM -0500, Kent Hoover wrote: > > Can I add, activate, and use a new UDF function to an already > existing udf_.so library without restarting MySQL server? Yes. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408)

Adding UDF functions

2001-01-24 Thread Kent Hoover
Can I add, activate, and use a new UDF function to an already existing udf_.so library without restarting MySQL server? Thanks, Kent Hoover - Before posting, please check: http://www.mysql.com/manual.php (the manual

a bug? regarding udf functions and SubString_Index()

2001-01-22 Thread Christian Hammers
Hi Let's look at this: # select SubString_Index("10.0.0.0/24","/",1); 10.0.0.0 # select ewu_aton("10.0.0.0"); 167772160 # select ewu_aton( SubString_Index("10.0.0.0/24","/",1) ); 280239936 Why this? My self written ewu_aton seems to work korrectly when calling it with any normal argument. The

UDF problems

2001-01-11 Thread Thomas Kaester
Hello everybody, I have problems to integrate a UDF into mysql! The systems aborts with the error message: ERROR 1126: Can't open shared library 'FThumbnail.so' (errno: 22 /vol/ibase/Sicherheitskopie/dipl_NWI/Feature/programming/FThumbn) The LD_LIBRARY_PATH is set correctly!

<    1   2