from:"Cyril Zlachevsky"

Re: [bug] koi8-r codepage bug

2002-09-30 Thread Cyril Zlachevsky


Victoria Reznichenko wrote:
 Cyril,
 Friday, September 27, 2002, 4:19:25 PM, you wrote:
 
 CZ if I build mysql with
 CZ ./configure --with-charset=koi8_ru
 CZ then check (make; make check; make test) failed!
 
 Because MySQL by default uses latin1 character set and you have compiled only
 with koi8_ru.
but if compile MySQL with
./configure --with-charset=koi8_ru --with-extra-charsets=all
check (make; make check; make test) failed too!
That's right?

 
 CZ But if I build mysql with
 CZ ./configure --with-extra-charsets=all 
 CZ and then insert in /etc/my.cfg before mysqld start this strings:
 CZ ---cut---
 CZ [mysqld]
 CZ character-sets-dir=/usr/share/mysql/charsets/
 CZ default-character-set=koi8_ru
 CZ ---cut---
 CZ then all OK and query INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ') not fail!
 
 That's right.
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [bug] koi8-r codepage bug

2002-09-30 Thread Cyril Zlachevsky


Victoria Reznichenko wrote:
 Cyril,
 Monday, September 30, 2002, 3:35:40 PM, you wrote:
 
 
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:

CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!

Because MySQL by default uses latin1 character set and you have compiled only
with koi8_ru.

 CZ but if compile MySQL with
 CZ ./configure --with-charset=koi8_ru --with-extra-charsets=all
 CZ check (make; make check; make test) failed too!
 CZ That's right?
 
 The short answer - nope.
this is bug or feature?

---cut---
# make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
020930 17:18:52  ../sql/mysqld: Shutdown Complete

Installing Slave Databases
020930 17:18:52  ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

 TEST USER   SYSTEM  ELAPSEDRESULT

alias 0.07 0.02 0.12   [ pass ]
alter_table   0.00 0.02 0.07   [ pass ]
analyse   0.01 0.02 0.03   [ pass ]
auto_increment0.03 0.01 0.05   [ pass ]
backup0.02 0.02 0.04   [ pass ]
bdb-crash 0.02 0.01 0.03   [ pass ]
bdb-deadlock       [ skipped ]
bdb        [ skipped ]
bench_count_distinct  0.03 0.00 0.06   [ pass ]
bigint0.03 0.00 0.03   [ pass ]
binary     [ fail ]

Error at line 34: Result length mismatch Below are the diffs between actual 
and expected results:
---
*** r/binary.result Wed Aug 14 01:24:51 2002
--- r/binary.reject Mon Sep 30 17:18:55 2002
***
*** 1,13 
  name
- å
  ä
  ö
  concat(*,name,*)
- *å*
  *ä*
  *ö*
  min(name) min(concat(*,name,*))   max(name)   
max(concat(*,name,*))
! å *å* ö   *ö*
  name
  ä
  å
--- 1,13 
  name
  ä
+ å
  ö
  concat(*,name,*)
  *ä*
+ *å*
  *ö*
  min(name) min(concat(*,name,*))   max(name)   
max(concat(*,name,*))
! ä *ä* ö   *ö*
  name
  ä
  å
***
*** 20,25 
--- 20,26 
  ä *ä* ö   *ö*
  name
  ä
+ å
  ö
  name
  ä
---
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1
---cut--



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [bug] koi8-r codepage bug

2002-09-27 Thread Cyril Zlachevsky


Victoria Reznichenko wrote:
 Cyril,
 Thursday, September 26, 2002, 11:30:39 PM, you wrote:
 
 CZ ---cut---
 mysql DROP TABLE IF EXISTS COUNTRIES;
 CZ Query OK, 0 rows affected (0.02 sec)
 
 mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
 CZ - PRIMARY KEY (Name) );
 CZ Query OK, 0 rows affected (0.00 sec)
 
 mysql INSERT INTO COUNTRIES VALUES ('éÒÌÁÎÄÉÑ');
 CZ Query OK, 1 row affected (0.00 sec)
 
 mysql INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ');
 CZ ERROR 1062: ðÏ×ÔÏÒÑÀÝÅÅÓÑ ÚÎÁÞÅÎÉÅ 'éÓÌÁÎÄÉÑ' ÄÌÑ ËÌÀÞÁ 1
 
 mysql SELECT * FROM COUNTRIES WHERE Name='éÓÌÁÎÄÉÑ';
 CZ +--+
 CZ | Name |
 CZ +--+
 CZ | éÒÌÁÎÄÉÑ |
 CZ +--+
 CZ 1 row in set (0.00 sec)
 CZ ---cut---
 
 I tested your example with koi8_ru and it worked perfectly well for me
 
 mysql DROP TABLE IF EXISTS COUNTRIES;
 Query OK, 0 rows affected (0.01 sec)
 
 mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
 - PRIMARY KEY (Name) );
 Query OK, 0 rows affected (0.04 sec)
 
 mysql INSERT INTO COUNTRIES VALUES ('éÒÌÁÎÄÉÑ');
 Query OK, 1 row affected (0.00 sec)
 
 mysql INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ');
 Query OK, 1 row affected (0.00 sec)
 
 mysql SELECT * FROM COUNTRIES WHERE Name='éÓÌÁÎÄÉÑ';
 +--+
 | Name |
 +--+
 | éÓÌÁÎÄÉÑ |
 +--+
 1 row in set (0.00 sec)
 
 mysql show variables like char%;
 
++-+
 | Variable_name  | Value 
  
|
 
++-+
 | character_set  | koi8_ru   
  
|
 | character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos 
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian 
koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
 
++-+
 2 rows in set (0.01 sec)
 
 
if I build mysql with 
./configure --with-charset=koi8_ru
then check (make; make check; make test) failed!
But if I build mysql with
./configure --with-extra-charsets=all 
and then insert in /etc/my.cfg before mysqld start this strings:
---cut---
[mysqld]
character-sets-dir=/usr/share/mysql/charsets/
default-character-set=koi8_ru
---cut---
then all OK and query INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ') not fail!

-- 
Ó Õ×ÁÖÅÎÉÅÍ
ëÉÒÉÌÌ úÌÁÞÅ×ÓËÉÊ
Don-Link ITSP
WWW   : http://www.phone.dn.ua
office: +380 62 3450119, +380 62 3341698, +380 62 3810593
mobile: +380 67 7072937




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[bug] koi8-r codepage bug

2002-09-26 Thread Cyril Zlachevsky


Please read following text only with koi8-r codepage!

---cut---
mysql DROP TABLE IF EXISTS COUNTRIES;
Query OK, 0 rows affected (0.02 sec)

mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
- PRIMARY KEY (Name) );
Query OK, 0 rows affected (0.00 sec)

mysql INSERT INTO COUNTRIES VALUES ('éÒÌÁÎÄÉÑ');
Query OK, 1 row affected (0.00 sec)

mysql INSERT INTO COUNTRIES VALUES ('éÓÌÁÎÄÉÑ');
ERROR 1062: ðÏ×ÔÏÒÑÀÝÅÅÓÑ ÚÎÁÞÅÎÉÅ 'éÓÌÁÎÄÉÑ' ÄÌÑ ËÌÀÞÁ 1

mysql SELECT * FROM COUNTRIES WHERE Name='éÓÌÁÎÄÉÑ';
+--+
| Name |
+--+
| éÒÌÁÎÄÉÑ |
+--+
1 row in set (0.00 sec)
---cut---

About my system:Red Hat Linux 7.3 with all updates on today
About MySQL server: 3.23.52, build from sources with next params:
---cut---
./configure  --prefix=%{_prefix} --exec-prefix=%{_exec_prefix} 
--bindir=%{_bindir} --datadir=%{_datadir}  --libdir=%{_libdir} --mandir=%{_mandir}  
--infodir=%{_infodir} \
--without-readline \
--enable-shared \
--with-extra-charsets=complex \
--with-bench \
--localstatedir=/var/lib/mysql \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-mysqld-user=mysql \
--with-extra-charsets=all \
--with-innodb \
--with-thread-safe-client \
--enable-assembler
 ---cut---




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[rh linux 7.2] mysql 3.22.32 bug?

2001-11-16 Thread Cyril Zlachevsky


Today I'm discovered strange behavior of SQL query
UPDATE tablename SET value=value+const WHERE ...
UPDATE tablename SET value=value-const WHERE ...
UPDATE tablename SET value=value*const WHERE ...
UPDATE tablename SET value=value/const WHERE ...

I have incorrect results of this queries only in Red Hat Linux 7.2+mysql
3.22.32

On Red Hat 6.2+mysql 3.22.32 or Red Hat 7.2+mysql 3.23.44 all work fine.

---cut---
[root@rh72]# rpm -qa | grep mysql
mysql-server-3.23.44-1
mysql-devel-3.23.44-1
mysql-3.23.44-1

[root@rh72]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.44

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql use donlink
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql CREATE TABLE test(val1 bigint(10),val2 double( 5,3));
Query OK, 0 rows affected (0.00 sec)

mysql SELECT * FROM test;
Empty set (0.00 sec)

mysql INSERT INTO test VALUES(1,2);
Query OK, 1 row affected (0.00 sec)

mysql SELECT * FROM test;
+--+---+
| val1 | val2  |
+--+---+
|1 | 2.000 |
+--+---+
1 row in set (0.00 sec)

mysql UPDATE test SET val1=val1+1, val2=val2+2;
Query OK, 1 row affected (0.00 sec)
óÏÏÔ×ÅÔÓÔ×ÕÀÝÉÈ ÚÁÐÉÓÅÊ: 1  éÚÍÅÎÅÎÏ: 1  ðÒÅÄÕÐÒÅÖÄÅÎÉÊ: 0

mysql SELECT * FROM test;
+--+---+
| val1 | val2  |
+--+---+
|2 | 4.000 |
+--+---+
1 row in set (0.00 sec)

mysql UPDATE test SET val1=val1*2, val2=val2*2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql SELECT * FROM test;
+--+---+
| val1 | val2  |
+--+---+
|4 | 8.000 |
+--+---+
1 row in set (0.00 sec)

mysql quit
Bye
[root@rh72]# /etc/rc.d/init.d/mysqld stop
ïÓÔÁÎÁ×ÌÉ×ÁÅÔÓÑ MySQL: [  ïë  ]
[root@rh72]# rm -rf /var/lib/mysql/donlink/test.*
[root@rh72]# rpm -e mysql mysql-server mysql-devel
[root@rh72]# rpm -ivh /usr/src/redhat/RPMS/i686/mysql-3.22.32-1.i686.rpm 
/usr/src/redhat/RPMS/i686/mysql-devel-3.22.32-1.i686.rpm 
/usr/src/redhat/RPMS/i686/mysql-server-3.22.32-1.i686.rpm
ðÏÄÇÏÔÏ×ËÁ...
   ### [100%]
1:mysql### [ 33%]
2:mysql-devel  ### [ 66%]
3:mysql-server ### [100%]
[root@warp i686]# /etc/rc.d/init.d/mysqld start
úÁÐÕÓËÁÅÔÓÑ MySQL: [  ïë  ]

[root@rh72]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.22.32-log

Type 'help' for help.

mysql use donlink
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql CREATE TABLE test(val1 bigint(10),val2 double( 5,3));
Query OK, 0 rows affected (0.00 sec)

mysql INSERT INTO test VALUES(1,2);
Query OK, 1 row affected (0.00 sec)

mysql SELECT * FROM test;
+--+---+
| val1 | val2  |
+--+---+
|1 | 2.000 |
+--+---+
1 row in set (0.00 sec)

mysql UPDATE test SET val1=val1+1, val2=val2+2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql SELECT * FROM test;
+--+---+
| val1 | val2  |
+--+---+
|2 | 2.000 |
+--+---+
1 row in set (0.00 sec)

mysql UPDATE test SET val1=val1*2, val2=val2*2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql SELECT * FROM test;
+--+---+
| val1 | val2  |
+--+---+
|4 | 0.000 |
+--+---+
1 row in set (0.00 sec)

mysql QUIT
Bye
---cut---

To reporoduce my problem, first oof all you must download my mysql.spec 
files

http://www.phone.dn.ua/pub/mysql-3.22.32-spec.tar.gz (6k) and 
http://www.phone.dn.ua/pub/mysql-3.23.44-spec.tar.gz (6k)

and make rpm with target i686 arch.

Thanks for your help!



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [bug] koi8-r codepage bug

Re: [bug] koi8-r codepage bug

Re: [bug] koi8-r codepage bug

[bug] koi8-r codepage bug

[rh linux 7.2] mysql 3.22.32 bug?

5 matches

Site Navigation

Mail list logo

Footer information