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
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
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
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(
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
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
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
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
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'
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
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('А','Б'))
> 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]
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
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]
- 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
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
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
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
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
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://
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(),
- 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
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
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
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
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
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
27 matches
Mail list logo