Re[2]: Is the Optimizer on 5.0.20 broken?

2006-05-06 Thread Juri Shimon
Hello sheeri, Friday, May 5, 2006, 9:25:18 PM, you wrote: sk> You're comparing apples to oranges -- your where clauses are sk> different. The first query uses the primary key because you're sk> actually comparing 'account' to something. The second query doesn't sk> because you're using the 'str

Is the Optimizer on 5.0.20 broken?

2006-05-05 Thread Juri Shimon
Hello All, I have a next problem. After upgrade from 4.1 branch to 5.0, the productivity of our applications has decreases too much. Below is a tipical case. Table 'account' has primary(department,account) and 40777 records. Table 'payment' primary(department,account,year,month) and 3831797 reco

Re: How to get result set from stored procedure?

2006-04-25 Thread Juri Shimon
Hello Juri, Tuesday, April 25, 2006, 5:49:25 PM, you wrote: JS> mysql=mysql_init(NULL); JS> mysql_real_connect(mysql, NULL, "User", "pwd", "test", MYSQL_PORT, NULL, 0); JS> mysql_query(mysql, "call test()"); JS> results to error: "PROCEDURE test.test can't return a result set in the given cont

How to get result set from stored procedure?

2006-04-25 Thread Juri Shimon
Hello mysql, May be, I'm a stupid... create procedure test () select 1; mysql> call test(); +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.05 sec) In C: mysql=mysql_init(NULL); mysql_real_connect(mysql, NULL, "User", "pwd", "test", MYSQL_PORT, NULL, 0); mysql_query(mysql, "call test(

5.0.16. Bug in union?

2006-02-14 Thread Juri Shimon
Hello mysql, Union on zerofilled fields eats 'zerofilling'. How to repeat: > create table a (id integer zerofill); > insert into a values(1),(2),(3); > select * from a; ++ | id | ++ | 01 | | 02 | | 03 | ++ > select * from a u

5.0.16. Bug in triggers?

2005-12-26 Thread Juri Shimon
Hello mysql, When trigger on table uses select from same table, then bulk insert into this table cause error. How to repeat: create table t(i int not null, j int not null, n numeric(15,2), primary key(i,j)); create table s(i int not null, n numeric(15,2), primary key(i)); delimiter // crea

MySQL 5.0.13-rc: BUG in substring functions?

2005-10-06 Thread Juri Shimon
Hello All! left(),right(),mid(),etc functions + with fixed point return value for function (or out parameter for sp) --- result has been truncated How to repeat: mysql> drop function if exists test; mysql> drop function if exists test1; mysql> delimiter // mysq

5.0.6: SP & mysqldump

2005-06-07 Thread Juri Shimon
Hello mysql, Is mysqldump from 5.0 dumping a stored procedures? If it isn't, then when (if planned)? -- Best regards, Juri mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Re[2]: mysqldump + enum + default + umlaut

2004-10-21 Thread Juri Shimon
Hello miguel, Tuesday, October 19, 2004, 10:52:03 PM, you wrote: ms> Hi, ms> Thank you for reporting this bug, I already opened the below ms> bug report: ms> http://bugs.mysql.com/bug.php?id=6165 > How to repeat: > create table t0 (id int not null auto_increment primary key, > foo enum('a','b'

4.1.3-5. Bugs alive!

2004-09-23 Thread Juri Shimon
Hello mysql, Using 'int not null' make next enum (using cp1251) corrupted in mysqldump output on W2000. Is this a known issue? How-to-repeat: --- drop table if exists t1; drop table if exists t2; create table t1 (a int, b enum('А','Б')) DEFAULT CHARACTER SET cp1251; creat

BUG in 4.1.3 "SHOW CREATE TABLE": enum vs int

2004-07-03 Thread Juri Shimon
Hello mysql, This bug make impossible to use backup with 'mysqldump','mysql' pair. How-to-repeat: --- drop table if exists t1; drop table if exists t2; create table t1 (a int, b enum('А','Б')) DEFAULT CHARACTER SET cp1251; create table t2 (a int not null, b enum('А','Б'))

Re: international LIKE in 4.1.1-alpha

2004-04-15 Thread Juri Shimon
> I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2. Where I can get it? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

international LIKE in 4.1.1-alpha

2004-04-15 Thread Juri Shimon
Hi! Win2000, MySql 4.1.1-alpha, cp1251 select 'ГОНЧАРА' like '%ГОНЧАРА%'-> 1 select 'ОЛЕСЯ ГОНЧАРА' like '%ГОНЧАРА%'-> 0 It's a pity 8( Hint : select 'ОЛЕСЯ ГОНЧАРА' like '%%ГОНЧАРА%'-> 1(change leading % to %%) Variables: character_set_system=utf8 character_set_server=cp1251

libmySQL.dll 4.1.1

2003-12-19 Thread Juri Shimon
Hi! Was 'mysql_connect' purposely excluding from libmySQL.dll export clause or by accident? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

2003-12-18 Thread Juri Shimon
- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 1:36 PM Subject: Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ? > You can use: > SELECT SUBSTRING_INDEX(CONVERT(USER() USING cp1251),'@',1); > SELECT SUBSTRING_INDEX(USER(),_u

Re: Invalid ENUM values after upgrading from 4.0 to 4.1

2003-12-17 Thread Juri Shimon
I have the same problem with cp1251 and, seems, it's a bug. I have posted correspoding message two days ago. Without any reply 8((( I migrate 3.23.55 -> 4.1.1 and I don't know about existing such problem in 4.0. Look in your .frm - your field is in correct charset. More of, inserts and updates of

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

2003-12-17 Thread Juri Shimon
Thanks for reply! > >> 1. mysql -u root -e "create database t; show create database t; drop database t" > >> 2. mysql -u root -e "use_mysql; create database t; show create database t; drop database t" > >> 1.| t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER SET cp1251 */ > >> 2.| t

Re: MySQL 4.1.1 Internationalization (ENUM)

2003-12-10 Thread Juri Shimon
Hi! > > > > create table t(a enum ('','ÐÐÐ','ÐÑÐ')); > > > > show create table t; > > > > CREATE TABLE `t` ( > > > > `a` enum('','???','???') default NULL > > > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 > > firstly, upgrade you mysql to current stable version (4.0.16). I need 4.1, not 4.0

Re: MySQL 4.1.1 Internationalization (ENUM)

2003-12-10 Thread Juri Shimon
Hi! > > > create table t(a enum ('','ÃÃÃ','ÃÃÃ')); > > show create table t; > > CREATE TABLE `t` ( > > `a` enum('','???','???') default NULL > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251 > > But a bug in what? > CREATE TABLE `t` ( > `a` enum('','ÃÃÃ','ÃÃÃ') default NULL > ) TYPE=MyISAM

BUGS: MySQL 4.1.1 Internationalization (ENUM)

2003-12-10 Thread Juri Shimon
Hi! create table t(a enum ('','ÃÃÃ','ÃÃÃ')); show create table t; CREATE TABLE `t` ( `a` enum('','???','???') default NULL ) TYPE=MyISAM DEFAULT CHARSET=cp1251 and this is a bug! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

MySQL 4.1.1 and internationalization

2003-12-10 Thread Juri Shimon
Hi! How I can set server variable "character_set_system" to cp1251 ? I can use xxx'char' construction - but I need a downward compatibility. I can select USER() and parse result on clientside - but I wan't rewrite existing client apps. > mysql -u root -e "select substring_index(USER(),

Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

2003-12-10 Thread Juri Shimon
- Original Message - From: "Juri Shimon" <[EMAIL PROTECTED]> To: "Victoria Reznichenko" <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 12:56 PM Subject: Re: Bug in 4.1.1 Internationalization on Windows2000 ? > Hi! > > > > > Wh

Bug in 4.1.1 Internationalization on Windows2000 ?

2003-12-10 Thread Juri Shimon
Hi! Is this a bug? in my.cnf: [mysqld-4.1] skip-locking default-character-set=cp1251 default_collation=cp1251_general_ci key_buffer=16M skip-innodb skip-bdb after server start: > show variables like '%character_set%' character_set_servercp1251 character_set_systemutf8 chara

Re: MySQL 4.1.1 with cp1251

2003-12-10 Thread Juri Shimon
Hi! > Latin1 is the default as i know. > Let's check: > 2.3.3 Typical configure Options > 4.7 MySQL Localisation and International Usage I know this. BUT, when I set def char set = cp1251 and do CREATE DATABASE lalala I get new database created in latin1 Is this a bug? -- MySQL General Mail

MySQL 4.1.1 with cp1251

2003-12-09 Thread Juri Shimon
Hi! In my.cnf: [mysqld] ... default-character-set=cp1251 default_collation=cp1251_general_ci ... Then, after >show variables like '%character%' I have: character_set_servercp1251 character_set_clientcp1251 character_set_connectioncp1251 character_set_resultscp1251 character_s

Bug with uppercased database in 3.23.55?

2003-02-19 Thread Juri Shimon
Hi! Is it a bug? C:\mysql>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 3.23.55-max-nt mysql> create database R; Query OK, 1 row affected (0.06 sec) mysql> grant all privileges on `R%`.* to b; Query OK, 0 rows affected

Access denied 3.23.55

2003-02-18 Thread Juri Shimon
Hi! Is it a bug? C:\mysql>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 3.23.55-max-nt mysql> create database R; Query OK, 1 row affected (0.06 sec) mysql> grant all privileges on `R%`.* to b; Query OK, 0 rows affected