Re: mysql_prepare is not built in 4.1.1a?

2004-05-28 Thread Sinisa Milivojevic
contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator <___/ www.mysql.com

Re: mysterious "can't connect" error message in our logs(2)

2004-03-25 Thread Sinisa Milivojevic
hen waiting for data, and not on teh connections to the socket. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>

Re: mysqlgui problem - can't connect via tmp/mysql.sock

2004-03-16 Thread Sinisa Milivojevic
lient] and you should put /usr/local/mysql/tmp/mysql.sock there as well as under [mysqld] options header. You should also make /usr/local/mysql/tmp/ directory scannable etc .. by all, plus with temporary attribute. -- Sincerely, -- For technical support contracts, go to https://order.mysql

Re: SubQuery bug in 4.1

2003-08-04 Thread Sinisa Milivojevic
-- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator

Re: Re[2]: mySql BUG

2003-06-11 Thread Sinisa Milivojevic
a look at it. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Deve

Re: mySql BUG

2003-06-11 Thread Sinisa Milivojevic
ds, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator <___/ www.mysql.com Larnaca, C

Re: Problem starting mysql server

2003-05-29 Thread Sinisa Milivojevic
You can not connect as the server is not running, and all possible causes for problems in starting MySQL server are fully explained in our manual. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_

Re: Doing select @a does not work in replication.

2003-04-02 Thread Sinisa Milivojevic
your time, > Scott Wong > Meiko America, INC > Hi! It is actually neither. Replication with user variables is working only in version 4.1. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\

Re: Alias Error in a select statement

2003-03-26 Thread Sinisa Milivojevic
can not reference an alias in the select list. You can do it freely in WHERE, ON , GROUP BY and other clauses. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /__

Re: mysqld dies

2003-03-24 Thread Sinisa Milivojevic
Sorry, we do not accept bug reports in HTML format. Please re-send it in plain text format. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Dev

Re: Mysql hangs on multi table update on innodb table.

2003-03-11 Thread Sinisa Milivojevic
25 for (cur_table= update_tables; cur_table ; cur_table= cur_table->next) { table = cur_table->table; ! if (on_the_fly && table == main_table) continue; // Already updated org_updated= updated; -- __ ___ ___ __ / |/ /_ __/ __/

RE: Mysql hangs on multi table update on innodb table.

2003-03-05 Thread Sinisa Milivojevic
not come up very soon. But should come up with the end of this month. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Sinisa Milivojevic
riella > 4.0.11 will be quite soon, but your problems indicate that it is some system setup error, which would be very fast diagnosed if we would login to your system. Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Sinisa Milivojevic
acts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-02-24 Thread Sinisa Milivojevic
nce for your help, > > Mariella > Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer

Re: Native XADataSource for MySQL

2003-02-21 Thread Sinisa Milivojevic
model or only part of the J2EE model.) > > Frank Gates > [EMAIL PROTECTED] > > HI! We shall definitely add support for XA, but I doubt it will be before 6.0. We have so many other features to implement first. -- Regards, -- For technical support contracts, go to https://orde

RE: Bug with innodb multi-table delete and foreign keys.

2003-02-14 Thread Sinisa Milivojevic
ber of processes running now: 0 > 030213 15:54:20 mysqld restarted > > > regards, > Scott Wong Yes, of course. I have sent just an excerpt. Full patch is rather big and is not appropriate for mail. Plus I am still improving it in order to work under all conditions.

Re: Bug with innodb multi-table delete and foreign keys.

2003-02-13 Thread Sinisa Milivojevic
::send_error(&thd->net, error); else ::send_ok(&thd->net,deleted); return 0; -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

Re: A bug with innodb and non innodb multi-table delete.

2003-02-13 Thread Sinisa Milivojevic
m *)NULL, (ORDER *)NULL, select_lex->options | thd->options | ! SELECT_NO_JOIN_CACHE | SELECT_NO_UNLOCK, result); delete result; } -- __ ___ ___ __ / |/ /_ __/ __/ __

Re: The corrumpion detected on SELECT AFTER UPDATE ON BLOB COLUMN

2003-02-04 Thread Sinisa Milivojevic
|| (select && select->check_quick(safe_update, limit)) || !limit) *** *** 474,479 --- 475,481 tl->shared= table_count++; table->no_keyread=1; table->used_keys=0; + table->copy_blobs=1; table->pos_in_t

Re: mysqld got signal 11; This could be because you hit a bug ....

2003-01-29 Thread Sinisa Milivojevic
to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --

Re: BUG:ALTER TABLE (MySQL 4.1)

2003-01-25 Thread Sinisa Milivojevic
Red ?? Please send us a dump of the table or if it is big, upload it to the usual place. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ La

Re: Slow response with MRG tables.

2003-01-09 Thread Sinisa Milivojevic
e above, please write to [EMAIL PROTECTED] -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

Re: Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

2002-12-14 Thread Sinisa Milivojevic
order to enable safe operation, safe statistics colletion, memory management etc. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EM

Re: MySQL 4.0.5(a) is released

2002-11-29 Thread Sinisa Milivojevic
mbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > Hi! Variable has been removed but the option --safe-show-database remain. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr.

Re: Tuning MySQL Full-text Search

2002-11-27 Thread Sinisa Milivojevic
pile,ChangeSet > > > Just add a charset. Take a look at sql/share/charsets/ -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>

Re: Where is 4.1 source

2002-11-22 Thread Sinisa Milivojevic
___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com

Re: MySQL & Berkeley DB

2002-11-05 Thread Sinisa Milivojevic
OTECTED] or consider taking our support. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL

Re: BUG with dates and BETWEEN operator

2002-10-30 Thread Sinisa Milivojevic
(field,&args[1])) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus

Re: Problem with select.

2002-10-24 Thread Sinisa Milivojevic
_ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --

Re: Bug with Query in MySQL 4.0.4/RedHat 8.0

2002-10-23 Thread Sinisa Milivojevic
a newly introduced bug that caused `ORDER BY ... LIMIT #' to not return all rows. You can check a fix by either waiting for 4.0.5 or by using our BK 4.0 repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivoj

Re: Compiling mysql with correct libraries

2002-10-21 Thread Sinisa Milivojevic
manusl. We currently build our RPM's on updated RH 6.2. -- Regards, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ /

Re: Fwd: Only half of the results shown when using order by on unindexed field

2002-10-19 Thread Sinisa Milivojevic
her wait for 4.0.5 or try to build from our current BK 4.0 repository. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --

Re: 3.22.52 log rotation crash

2002-10-10 Thread Sinisa Milivojevic
Matthew J. Francis writes: > On Thu, 2002-10-10 at 13:23, Sinisa Milivojevic wrote: > > I've pulled the latest 3.23 code with BK and compiled it on the machine > in question. Unfortunately the problem still seems to be there as I can > still knock the server over with the te

Re: 3.22.52 log rotation crash

2002-10-10 Thread Sinisa Milivojevic
fetch code from our BK repository, as explained in our manual. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca,

Re: Fwd: Crash when adding field

2002-09-05 Thread Sinisa Milivojevic
Regarding the above crash after adding the ENUM column, I have tested it and it worked for me. Could you also verify this from our BK 4.0 repository ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTEC

Re: Fwd: Crash when adding field

2002-09-03 Thread Sinisa Milivojevic
" NOT NULL; > > This is a forwarded message > From: Matt Parlane <[EMAIL PROTECTED]> > To: > Date: Tuesday, September 03, 2002, 1:56:12 AM > Subject: Crash when adding field > Thank you for your bug report, but this bug is already fi

Re: Strange behaviour of mysqld after dropping a column

2002-08-28 Thread Sinisa Milivojevic
); + table=open_ltable(thd,table_list,TL_READ); + } + #endif end_temporary: sprintf(tmp_name,ER(ER_INSERT_INFO),(ulong) (copied+deleted), -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PR

Re: Fwd: Re: Re: [Bug in UNION clause]

2002-08-12 Thread Sinisa Milivojevic
Please, re-send me: * mysqldump of the tables * the exact UNION query that you ran -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Dev

Re: BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot

2002-08-03 Thread Sinisa Milivojevic
ARY TABLE tmp_table(i INT); > ERROR 1142: create command denied to user: 'test_user@localhost' for table > > 'tmp_table' > Hi! Thank you for your bug report. Thanks to it, the above bug was fixed and fix will come up in 4.0.3. -- Regards, __ __

Re: Re: Fwd: urgent: problem in deleting multi table

2002-07-29 Thread Sinisa Milivojevic
table->file->ref_length + 1, MEM_STRIP_BUF_SIZE); } } -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\

Re: BUG report (select distinct...) 4.0.2 and latest bk snapshot

2002-07-24 Thread Sinisa Milivojevic
v <[EMAIL PROTECTED]> >Public PGP key: http://sysadminday.org.ru/rathamahata.asc > If the table names are : product_supplier route supplier shop_product_supplier then I have got them. I will test your case today. Is it one bug or two ?? -- Regards

Re: Fwd: MySQL 4.0.2 & my.cnf

2002-07-15 Thread Sinisa Milivojevic
ddr, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0}, {"bootstrap", OPT_BOOTSTRAP, "Used by mysql installation scripts", 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0}, -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic &l

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-09 Thread Sinisa Milivojevic
thd->query,thd->query_length); if (mysql_bin_log.is_open()) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mys

A bug in BDB ALTER TABLE

2002-07-09 Thread Sinisa Milivojevic
y,thd->query_length); if (mysql_bin_log.is_open()) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /__

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-02 Thread Sinisa Milivojevic
In my opinion this is a heavily bug, keeping in mind that restarting > mysql after dropping/adding a column messes up your database ! Can you > please check this ? > > Kind regards, > Ismaël Yes, it looks like a bug. We shall inspect that. -- Regards, __ ___ ___ ____ __ /

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-01 Thread Sinisa Milivojevic
y then you will have no problems with MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_,

Re: Strange behaviour of mysqld after adding/dropping a column

2002-07-01 Thread Sinisa Milivojevic
Two questions : * have you installed MySQL as a service ?? * have you stopeed a service prior to rebooting ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Dev

Re: [mysql option max_user_connections doesn't seem to work]

2002-06-27 Thread Sinisa Milivojevic
gt;Synopsis: > >Severity: > >Priority: > >Category:mysql > >Class: > >Release: mysql-3.23.47 (Source distribution) Hi! I just tested it with 3.23.51 and it worked like a charm. If you have the same problem with our 3.23.51 binary, send u

Re: Fwd: MySQL server completly dies on an UPDATE

2002-06-27 Thread Sinisa Milivojevic
Regards >Jacques Deguest jack deguest jp ', > description='This dummy test for very simple message. This drive scripts are >located ~/dev/List/Email/Message Shoudl their any problems, pls, hesitate contact ;-) >Thanks, Moi, pense Oui,', > url='/1995-12-21-.html&#

Re: Load problems with 3.23.51

2002-06-24 Thread Sinisa Milivojevic
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.51: up 24 days, processed 523,371,775 queries (248/sec. avg) > Using 2.95.* or 3.* is just fine, with proper configuration, as explained in our fine manual. -- Regards, __ ___ ___

Re: Nasty LIMIT/multi-table DELETE bug?

2002-06-22 Thread Sinisa Milivojevic
ransaction_report.partner_id = 1 AND > > confirmed != 1 > > LIMIT > > 50; > > This bug was fixed meanwhile ... Now, with multi-table delete you get a syntax error with LIMIT. This has been done so as LIMIT is ambiguous in delete with more

Re: Re[2]: heap tables

2002-06-18 Thread Sinisa Milivojevic
... Some table handler, like HEAP, use info you specify for max_rows and avg_row_length to determine maxumum number of blocks that could be use for given table. So, your table would be able to accomodate as many rows as would fit in a single block, which in your case is about 12. Regarding last

Re: The report

2002-06-15 Thread Sinisa Milivojevic
ref.key_length, HA_READ_AFTER_KEY); ! if (!error) ! error=table->file->index_prev(table->record[0]) || ! key_cmp(table,key_buff,ref.key,ref.key_length); } if (table->key_read

Re: Re[2]: counting rows ...

2002-06-14 Thread Sinisa Milivojevic
} TABLE_LIST *table; for (table=tables ; table ; table=table->next) + { join.tables++; + if (!thd->used_tables) + { + TABLE *tbl=table->table; + tbl->keys_in_use_for_query=tbl->used_keys= tbl->keys_in_use=0; + } +

Re: Fwd: A column of the SELECT-part of a query returns allways NULL in some cases.

2002-06-08 Thread Sinisa Milivojevic
if (item->type() == Item::FIELD_ITEM) { + if (change) + { + ((Item_field*) item)->result_field->null_ptr=0; + item->maybe_null=0; + } ((Item_field*) item)->field= ((Item_field*) item)->result_field; } -- Regards, __ ___

New additions on MySQL++ page

2002-06-06 Thread Sinisa Milivojevic
fixes * Documentation for installing, configuring and using MySQL++ on Windows operating systems Beside that a patch that enables usage of MySQL++ with GNU 3.* series compiler has been updated with a proper one. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa

RE: Bug with multi-table DELETE in MySQL 4.0.1

2002-06-03 Thread Sinisa Milivojevic
responding table + (void)add_item_to_list(new Item_field(auxi->db,auxi->real_name,"*")); } tables->grant.want_privilege=(SELECT_ACL & ~tables->grant.privilege); if (add_item_to_list(new Item_null())) -- Regards, __ ___ ___ _

Re: Fw: fault tolerance

2002-06-03 Thread Sinisa Milivojevic
Also, keep in mind that this list is dedicated to the internal functioning of MySQL server, not to the general questions of this kind. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/

RE: Bug with multi-table DELETE

2002-06-02 Thread Sinisa Milivojevic
responding table + (void)add_item_to_list(new Item_field(auxi->db,auxi->real_name,"*")); } tables->grant.want_privilege=(SELECT_ACL & ~tables->grant.privilege); if (add_item_to_list(new Item_null())) -- Regards, __ ___ ___ _

Re: multi-table delete bug

2002-05-27 Thread Sinisa Milivojevic
umeropost AND c.date<'2002-01-01' LIMIT 0,30; 0 here . DELETE FROM t2,t3 USING t2 as a,t3 as b,t1 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-05-30'; and 0 here I ran latest mysqld 4.0.2 with these options: --one-t

Re: multi-table delete bug

2002-05-27 Thread Sinisa Milivojevic
27;; Query OK, 4 rows affected (0.01 sec) SELECT * FROM t2 as a,t3 as b,t1 as c WHERE b.numreponse=a.numreponse AND b.topic=c.numeropost AND c.date<'2002-01-01' LIMIT 0,30; Empty set (0.00 sec) DELETE FROM t2,t3 USING t2 as a,t3 as b,t1 as c WHERE b.numreponse=a.numreponse AND b.t

Fixed bug with large UNION's in 4.0.2

2002-05-24 Thread Sinisa Milivojevic
; COPY_INFO info; uint save_time_stamp; + TMP_TABLE_PARAM *tmp_table_param; select_union(TABLE *table_par); ~select_union(); -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ My

Re: Manual at mysql.com

2002-05-17 Thread Sinisa Milivojevic
Luc Foisy writes: > the search query is broken > > Luc Foisy > We shall notify our web team. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB,

Re: link problem

2002-05-09 Thread Sinisa Milivojevic
k > can you help me > HI! First of all, you should use g++. Second, you should link in sqlplus too ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer

Re: problem with libmysqlclient_r.so

2002-04-26 Thread Sinisa Milivojevic
quired in any case when multi-threaded program is made, which uses our C API. In 4.0 it is automatically invoked in my_init() if library is built thread-safe. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PR

Re: How does DISTINCT really work ?

2002-04-26 Thread Sinisa Milivojevic
18 21:22:52 19342002-03-18 10:50:45 19832002-03-18 00:06:59 19342002-03-17 22:57:50 19682002-03-15 16:41:51 19712002-03-14 14:00:35 So, simply, everything is as it should be. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Mil

Re: problem with libmysqlclient_r.so

2002-04-26 Thread Sinisa Milivojevic
t; ___ > Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > ÔÅÌ. +380 562 34-00-44 > No, just -lstrings -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL

Re: problem with libmysqlclient_r.so

2002-04-25 Thread Sinisa Milivojevic
w about this!!! > > > Best regards. > ___ > Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > ÔÅÌ. +380 562 34-00-44 The above crash is caused by using functions, like gethostbyname, which is not thread safe. Thi

Re: problem with libmysqlclient_r.so

2002-04-25 Thread Sinisa Milivojevic
me error caused by your program. If you link your program with our binary libmysqlclient_r, then if you run your program it will die in mysql_real_query, instead in _db_enter. This is most likely a consequence of some error in your program. -- Regards, __ ___ ___ __ / |/ /_

Re: install mysql++ on linux

2002-04-25 Thread Sinisa Milivojevic
start from configure ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com

Re: mysqlgui

2002-04-25 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > To whom it may concern, > > Where can i find the documentation for mysqlgui? > > thanks > > bd > It comes with a package. Read MySQL.help , README and readme.* files. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: mysqlgui and DNS

2002-04-24 Thread Sinisa Milivojevic
use IP address in the host field. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com

Re: problem with libmysqlclient_r.so

2002-04-24 Thread Sinisa Milivojevic
-- Compiler is OK. But your program is multithreaded, so check with `ldd` whether you have linked in libstdc++ ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL

Re: compile problem with 3.23.50

2002-04-24 Thread Sinisa Milivojevic
uilding MySQL with libwrap on Linux. All Linux versions that we tested, had prototypes as in 3.23.50. Can you explain why is your Linux so different ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa

Re: 3.23.50 client needs IP addresses

2002-04-24 Thread Sinisa Milivojevic
osts that access a server in hosts server and tune up name resolution on your Linux . -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

RE: table lock - which connection id own's it

2002-04-23 Thread Sinisa Milivojevic
ary as MySQL server remembers LAST_INSERT_ID() value, for each connection (thread) separately. Simply, this value is not (only) remembered on per-table basis, but also for each thread (connection) separately. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \

Re: problem with libmysqlclient_r.so

2002-04-23 Thread Sinisa Milivojevic
otrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > ÔÅÌ. +380 562 34-00-44 > Does not seem like our bug ! Because last time it crashed in a completely different place. Plus, it is unlikely that it would crash in ping. Check out your compiler version and whether libstdc++ got

Re: Cant connect using socket ''(111) for Mysqlgui on linux

2002-04-23 Thread Sinisa Milivojevic
t field 'SQL command on ..." enter a location of the socket file. If it is defined in any *my.cnf it should pop up there for itself. Then click on 'Save' and re-connect. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic

Re: Question about mysql++ and g++

2002-04-23 Thread Sinisa Milivojevic
cc, or get a different compiler (i dont know any > for linux yet! ) id appreciate it very much! > > ~Mike > > HI! The errors are caused by MySQL++ not seeing MySQL++ include directory. In your Makefile add -I.. directive for include directory and -L.. directive

Re: problem with libmysqlclient_r.so

2002-04-22 Thread Sinisa Milivojevic
> Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > ÔÅÌ. +380 562 34-00-44 > Yes, including libmysys source files . -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /

Re: Inserting a BLOB using MySQL++

2002-04-22 Thread Sinisa Milivojevic
SQL your BLOB in en-escaped, original form. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com ---

Re: problem with libmysqlclient_r.so

2002-04-22 Thread Sinisa Milivojevic
3.23.49 with the same effect > > Will anybody help me? > > Best regards. > ___ > Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > ÔÅÌ. +380 562 34-00-44 > > > > -- Regards, __ __

Re: Specifying Error Log

2002-04-20 Thread Sinisa Milivojevic
e and location of the log. > > Does anyone else have an opinion on this? > -RG > Hi! We have in our WorkLog an entry that would handle the above option, only this is not such a high priority for us and most of our users. -- Regards, -- For technical support contracts, go

Re: licence

2002-04-19 Thread Sinisa Milivojevic
ly informed ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com -

Re: My SQL ++ Bug and Port

2002-04-19 Thread Sinisa Milivojevic
Thank you for your report. Yes, I know about this leak in Windows version. It is due to it's stack limitations. Current developrment branch has this leask fixed already ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL P

Re: licence

2002-04-19 Thread Sinisa Milivojevic
company who sold me the use of MySQL > cover the licence? > > thanks > > Hi! This is a question for [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_

Re: bug in file "ibmysql_r/libmysql.c"

2002-04-16 Thread Sinisa Milivojevic
ptions[]=.." > and those comments; Hi! Thank you for spotting this. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com

Re: How does DISTINCT really work ?

2002-04-15 Thread Sinisa Milivojevic
> It seems to be locked when I make a 'use database' : > > > mysql> use forum > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > > > Regards, > &

Re: Re: unkown table is full

2002-04-12 Thread Sinisa Milivojevic
Richard Clarke writes: > This is mysql 4.0.1-alpha. > > Ric > Please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_

Re: Re: unkown table is full

2002-04-12 Thread Sinisa Milivojevic
ns with last version, please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\__

Re: regarding libmysqlclient and libmysqlclient_r

2002-04-12 Thread Sinisa Milivojevic
.. to mysql_thread.. calls. If that does not help, let us know exactly what is not working and send us the entire code. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sini

Re: VC++ Examples

2002-04-01 Thread Sinisa Milivojevic
s VC++ 6.0. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cypru

Re: SET CHARACTER SET cp1251_koi8 & mediumtext problem?

2002-03-28 Thread Sinisa Milivojevic
ar*) net_store_length((char*) packet->ptr()+packet_length, ! (ulonglong)length); for (const char *end=from+length ; from != end ; from++) *to++= to_map[(uchar) *from]; -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Si

Re: mysqlgui crash caused by infinite loop

2002-03-27 Thread Sinisa Milivojevic
2,&option_types,2)) { > case 1: /* port */ Hi! Thank you, both for your mail fix. This bug was fixed few weeks ago. Fixed version will be released both with 3.23.50 and 4.0.2. Thanks again. --

Re: MySQL C API documentation

2002-03-26 Thread Sinisa Milivojevic
ar the remaining rows in the result set from the server. That is all. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com ---

RE: MYSQL & NGPT

2002-03-23 Thread Sinisa Milivojevic
Pjotr, have you tested a speed of mutexes and the availability of adaptive mutexes ... Testing can be done with super-smack ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ My

Re: MYSQL & NGPT

2002-03-23 Thread Sinisa Milivojevic
Pjotr ! What about URL ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --

Re: mysql bug

2002-03-22 Thread Sinisa Milivojevic
&& !field->table->maybe_null) { Item *ref_item=part_of_refkey(field->table,field); -if (ref_item && ref_item->eq(right_item)) +if (ref_item && ref_item->eq(right_item,1)) { if (right_item->type() ==

Re: Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-22 Thread Sinisa Milivojevic
be out in two weeks or less. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___

  1   2   3   4   5   6   7   8   9   10   >