Got It; Thank You; Re: Mysql Bug 04/01/11

[Thomas Dineen]

Got It; Thank You, Thank You, Thank You



On 4/1/2011 11:28 PM, Claudio Nanni wrote:


Hi Thomas,
Did you run the post install script?

http://kae.li/iiikj

Claudio

On Apr 2, 2011 2:20 AM, "Thomas Dineen" > wrote:

Re: Mysql Bug 04/01/11

[Reindl Harald]

Am 02.04.2011 13:11, schrieb Claudio Nanni:
> Reindl Harald,
> 
> I would appreciate if you could please lower your tones.
> and keep this list as professional as it has always been, this is not a
> nerds forum.
>
> *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't
> find file: './mysql/host.frm' (errno: 13)
> *Solution*: RTFM
> Next time breathe 10 times deep, and reply!

WTF?

"Keep in mind that I have approximately 50  hours into this Mysql server install
and still no results!" and not look ONE TIME in the basic-manual in this
50 hours is the wrong way, everytime, everywhere and with every software

peopole spent many hours to writing documentation!

this is the start BEFORE mailing-list:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

yes, is something unclear after that there is a starting-point for questions
but not "i do not read docs, say me exactly where the problem is"





signature.asc
Description: OpenPGP digital signature

Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

[Reindl Harald]

Am 02.04.2011 02:18, schrieb Thomas Dineen:

> The following error occurs:
> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: 
> './mysql/host.frm' (errno: 13)

BTW: you know google?
"Can't find file: './mysql/host.frm' (errno: 13)"

http://bugs.mysql.com/bug.php?id=1279
so this is a permissions-problem

i guess there is a data-dir in the tar.gz you "installed"
as root and you did not change its permissions

> Keep in mind that I have tried several dozen experiments over many late hours
> with a version host.frm from a older version of mysql with NO success! I have
> tried putting it in every possible location. Using 777 file permissions.

you should not blind copy files without any idea what you are doing

> root@Sun# pwd
> /usr/local/mysql
> root@Sun# ls
> bin infoman mysql-test  var
> host.frmlib my.cnf  share
> include libexec mysql   sql-bench

delete the host.from from here and everywhere you placed it
and please open your eyes if you too lazy read documentations

you see the folder "var"?
_

RTFM (google: "mysql /usr/local default datadir"):
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

If you get Errcode 13 (which means Permission denied) when starting mysqld, 
this means that the privileges of the
data directory or its contents do not permit server access. In this case, you 
change the permissions for the
involved files and directories so that the server has the right to use them. 
You can also start the server as root,
but this raises security issues and should be avoided.

On Unix, change location into the data directory and check the ownership of the 
data directory and its contents to
make sure the server has access. For example, if the data directory is 
/usr/local/mysql/var, use this command:

shell> ls -la /usr/local/mysql/var

If the data directory or its files or subdirectories are not owned by the login 
account that you use for running
the server, change their ownership to that account. If the account is named 
mysql, use these commands:

shell> chown -R mysql /usr/local/mysql/var
shell> chgrp -R mysql /usr/local/mysql/var




signature.asc
Description: OpenPGP digital signature

Re: Mysql Bug 04/01/11

[Claudio Nanni]

Reindl Harald,

I would appreciate if you could please lower your tones.
and keep this list as professional as it has always been, this is not a
nerds forum.
There is always someone that knows more than you but he's not "shouting" at
you everytime you say something wrong.
If you think that a question is not worth answering just dont answer,
while if you answer do it in a useful way, so that all the community can
only improve from it,
do you find this useful?

*Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't
find file: './mysql/host.frm' (errno: 13)
*Solution*: RTFM

Next time breathe 10 times deep, and reply!

This is just my opinion.

Sincerely,

Claudio




2011/4/2 Reindl Harald 

>
> Am 02.04.2011 02:18, schrieb Thomas Dineen:
> >> Gentlemen:
> >>
> >> - Keep in mind that I have approximately 50  hours into this Mysql
> server install and still no
> >> results!
>
> what have you done the whole time?
> have you tried RTFM?
>
> we are not here to guide a blind one trough a basic setup
> because at the end you have something running and understodd
> nothing!
>
> sounds like you never before had used mysql and missing
> all the basics from the first chapters in the well written documentation
>
> >> - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz
> >>
> >> - When installed and started with the following command:
> >> /usr/local/mysql/bin/mysqld_safe --user=mysql &
> >>
> >> The following error occurs:
> >> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
>
> you should read the manuals or use a operating system with packages
> which are idiot-proof, fedora does this for you:
>
> if [ ! -d "$datadir/mysql" ] ; then
>  # First, make sure $datadir is there with correct permissions
>  if [ ! -e "$datadir" -a ! -h "$datadir" ]
>  then
>  mkdir -p "$datadir" || exit 1
>  fi
>  chown mysql:mysql "$datadir"
>  chmod 0755 "$datadir"
>  [ -x /sbin/restorecon ] && /sbin/restorecon "$datadir"
>  # Now create the database
>  action $"Initializing MySQL database: " /usr/bin/mysql_install_db
> --datadir="$datadir" --user=mysql
>  ret=$?
>  chown -R mysql:mysql "$datadir"
>  if [ $ret -ne 0 ] ; then
>  return $ret
>  fi
> fi
>
> >> 1) Please identify where the missing file can be found,
> >> keeping in mind that I just installed and have no backup
> >> (of the current rev.)
>
> they CAN NOT BE FOUND if you have a fresh install and not used
> "mysql_install_db"
> and WHERE they are created depends on your configuration as said yesterday
>
> let me guess: you even have not spent any second for your my.cnf?
> > [mysqld]
> > datadir = /where/ever/you/want/your/databases/jesus/christ
>
> on my system typing mysql_ followed with 2 x TAB brings a list of commands
> since you think you must not use a environments package-system why
> in the world do you not look in your bin-folder at /usr/local/mysql/
> and read some docs to understand that the mysql-database is the userdb
>
> [root@srv-rhsoft:~]$ mysql_
> mysql_client_test   mysql_convert_table_format
>  mysql_fix_extensionsmysql_secure_installation
> mysql_tzinfo_to_sql mysql_upgrade_replication   mysql_zap
> mysql_configmysql_find_rows mysql_install_db
>  mysql_setpermission
> mysql_upgrade   mysql_waitpid
>
>


-- 
Claudio

Re: Mysql Bug 04/01/11

[Reindl Harald]

Am 02.04.2011 02:18, schrieb Thomas Dineen:
>> Gentlemen:
>> 
>> - Keep in mind that I have approximately 50  hours into this Mysql server 
>> install and still no
>> results!

what have you done the whole time?
have you tried RTFM?

we are not here to guide a blind one trough a basic setup
because at the end you have something running and understodd
nothing!

sounds like you never before had used mysql and missing
all the basics from the first chapters in the well written documentation

>> - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz
>> 
>> - When installed and started with the following command:
>> /usr/local/mysql/bin/mysqld_safe --user=mysql &
>> 
>> The following error occurs:
>> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: 
>> './mysql/host.frm' (errno: 13)

you should read the manuals or use a operating system with packages
which are idiot-proof, fedora does this for you:

if [ ! -d "$datadir/mysql" ] ; then
 # First, make sure $datadir is there with correct permissions
 if [ ! -e "$datadir" -a ! -h "$datadir" ]
 then
  mkdir -p "$datadir" || exit 1
 fi
 chown mysql:mysql "$datadir"
 chmod 0755 "$datadir"
 [ -x /sbin/restorecon ] && /sbin/restorecon "$datadir"
 # Now create the database
 action $"Initializing MySQL database: " /usr/bin/mysql_install_db 
--datadir="$datadir" --user=mysql
 ret=$?
 chown -R mysql:mysql "$datadir"
 if [ $ret -ne 0 ] ; then
  return $ret
 fi
fi

>> 1) Please identify where the missing file can be found, 
>> keeping in mind that I just installed and have no backup 
>> (of the current rev.)

they CAN NOT BE FOUND if you have a fresh install and not used 
"mysql_install_db"
and WHERE they are created depends on your configuration as said yesterday

let me guess: you even have not spent any second for your my.cnf?
> [mysqld]
> datadir = /where/ever/you/want/your/databases/jesus/christ

on my system typing mysql_ followed with 2 x TAB brings a list of commands
since you think you must not use a environments package-system why
in the world do you not look in your bin-folder at /usr/local/mysql/
and read some docs to understand that the mysql-database is the userdb

[root@srv-rhsoft:~]$ mysql_
mysql_client_test   mysql_convert_table_format  mysql_fix_extensions
mysql_secure_installation
mysql_tzinfo_to_sql mysql_upgrade_replication   mysql_zap
mysql_configmysql_find_rows mysql_install_db
mysql_setpermission
mysql_upgrade   mysql_waitpid



signature.asc
Description: OpenPGP digital signature

Re: Mysql Bug 04/01/11

[Jigal van Hemert]

Hi,

On 2-4-2011 2:18, Thomas Dineen wrote:

Can't find file: './mysql/host.frm' (errno: 13)


http://tinyurl.com/3sc3ydx

--
Kind regards / met vriendelijke groet,

Jigal van Hemert.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Mysql Bug 04/01/11

[Claudio Nanni]

Hi Thomas,
Did you run the post install script?

http://kae.li/iiikj

Claudio
On Apr 2, 2011 2:20 AM, "Thomas Dineen"  wrote:

Re: mySQL Bug Report

[Gleb Paharenko]

Hello.





I don't know the relationships between program articlebot and MySQL.

But error message tells me to ask you to check if you have MyODBC 

properly configured and whether your MySQL server is running. See:



  http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html



There is a description how to test your settings if you're using

Windows:



  http://dev.mysql.com/doc/mysql/en/dsn-on-windows.html











>After installing mySQL along with a program called articlebot, I tried to

>run the application and I keep getting this message:

>

> 

>

>"An unhandled exception has occurred in a component in your application.

>Click continue and application will ignore this error and attempt to

>continue.

>

> 

>

>ERROR [HY000] [MySQL] [ODBC 3.51 Driver]Can't connect to MySQL server on

>local host (10061)

>

>ERROR [HY000] [MySQL] [ODBC 3.51 Driver]Can't connect to MySQL server on

>local host (10061)"

>

> 

>

>I thought I had installed it correctly, but apparently I didn't.  Any idea

>what went wrong and how I would go about fixing it?



"Kari White" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[Matthijs van der Klip]

On Mon, 1 Aug 2005, Heikki Tuuri wrote:
> unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and 
> later.


Hi Heikki,

Thanks for your response. The fix seems to consists only of a few lines:

http://mysql.bkbits.net:8080/mysql-4.1/[EMAIL PROTECTED]|[EMAIL PROTECTED]


It looks like this could be easily applied to MySQL 4.0:

http://mysql.bkbits.net:8080/mysql-4.0/anno/sql/[EMAIL 
PROTECTED]|src/|src/sql|hist/sql/ha_innodb.cc|diffs/sql/[EMAIL PROTECTED]


Is this an option? Or is MySQL 4.0 falling into the 'discontinued' range 
of products nowadays?

I could apply the patch myself, but I'd rather use the official binaries 
from the MySQL site than rolling my own package.


Best regards,

-- 
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[Heikki Tuuri]

Matthis,

unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and 
later.


Regards,

Heikki

- Alkuperäinen viesti - 
Lähettäjä: "Matthijs van der Klip" <[EMAIL PROTECTED]>

Vastaanottaja: "MySQL mailing list" 
Kopio: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Lähetetty: Monday, August 01, 2005 5:08 PM
Aihe: mysql bug 9670 OPTIMIZE TABLE crashes



Hi,

I am experiencing assertion failures described in the following bugreport:

http://bugs.mysql.com/bug.php?id=9670


The bug has been closed, but I'm running the most current 4.0.25 version
of MySQL. The report mentions downgrading to 4.0.23 or upgrading to 4.1.
Is this really neccessary or should this bug already be fixed in 4.0.25?


Best regards,

--
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[Matthijs van der Klip]

On Mon, 1 Aug 2005, Mikhail Entaltsev wrote:
> in the bug report Heikki Tuuri wrote:
> ***
> [13 Apr 20:59] Heikki Tuuri
> The bug was introduced in 4.0.24 and 4.1.10. The fix will be in 4.1.12 and
> 5.0.5.
> ***


Hi Mikhail,

Thank you for your quick response. I had noticed myself that the fix 
seemed to address only 4.1 and 5.0, but I'd like to hear an official 
statement that this bug will not be fixed in 4.0.


Best regards,

-- 
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[Mikhail Entaltsev]

Matthijs,

in the bug report Heikki Tuuri wrote:
***
[13 Apr 20:59] Heikki Tuuri
The bug was introduced in 4.0.24 and 4.1.10. The fix will be in 4.1.12 and
5.0.5.
***
Best regards,
Mikhail.


- Original Message - 
From: "Matthijs van der Klip" <[EMAIL PROTECTED]>
To: "MySQL mailing list" 
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 01, 2005 4:08 PM
Subject: mysql bug 9670 OPTIMIZE TABLE crashes


> Hi,
>
> I am experiencing assertion failures described in the following bugreport:
>
> http://bugs.mysql.com/bug.php?id=9670
>
>
> The bug has been closed, but I'm running the most current 4.0.25 version
> of MySQL. The report mentions downgrading to 4.0.23 or upgrading to 4.1.
> Is this really neccessary or should this bug already be fixed in 4.0.25?
>
>
> Best regards,
>
> -- 
> Matthijs van der Klip
> System Administrator
> Spill E-Projects
> The Netherlands
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug

[Gleb Paharenko]

Hello.





Have you been at:

  http://dev.mysql.com/doc/mysql/en/starting-server.html



Check the error log:

  http://dev.mysql.com/doc/mysql/en/error-log.html







Maurizio Dudine <[EMAIL PROTECTED]> wrote:

> SEND-PR: -*- send-pr -*-

> SEND-PR: Lines starting with `SEND-PR' will be removed

> automatically, as

> SEND-PR: will all comments (text enclosed in `<' and

> `>').

> SEND-PR:

> From: maurizio

> To: mysql@lists.mysql.com

> Subject: [Cannot start mysql]

> 

>>Description:

><1. I have installed the six packages (see Manual)

> with the YAST 2.

> 2. I have typed mysqld_install_db

> 3. When I try to open mysql typing "mysql"I get the

> message "Cannot connect to local Mysql server through

>  socket var/lib/mysql/mysql.sock

> 4. I looked for the socket and there is no

> mysql.sock anywhere on my machine

> 5. If I type "safe_mysqld" the answer is "Starting

> mysql-max demon with database from /var/lib/mysql

>  050720 mysqld ended" >

>>How-To-Repeat:

> (multiple lines)>

>>Fix:

> (multiple lines)>

> 

>>Submitter-Id:  

>>Originator:Maurizio Dudine

>>Organization:

> 

>>MySQL support: [none | licence | email support |

> extended email support ]

>>Synopsis:  

>>Severity:  <[ non-critical | serious | critical ] (one

> line)>

>>Priority:  <[ low | medium | high ] (one line)>

>>Category:  mysql

>>Class: <[ sw-bug | doc-bug | change-request |

> support ] (one line)>

>>Release:   mysql-3.23.48 (Source distribution)

> 

>>Environment:

>

> System: Linux linux 2.4.18-4GB #1 Wed Mar 27 13:57:05

> UTC 2002 i686 unknown

> Architecture: i686

> 

> Some paths:  /usr/bin/perl /usr/bin/make

> /usr/bin/gmake /usr/bin/gcc /usr/bin/cc

> GCC: Reading specs from

> /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs

> gcc version 2.95.3 20010315 (SuSE)

> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++' 

> CXXFLAGS='-O2 -march=i486 -mcpu=i686

> -D_FILE_OFFSET_BITS=64  -D_LARGEFILE_SOURCE   
>   

> -felide-constructors-fno-exceptions   
>   

> -fno-rtti'  LDFLAGS=''

> LIBC: 

> -rwxr-xr-x1 root root  1394238 mar 23 

> 2002 /lib/libc.so.6

> -rw-r--r--1 root root 25361424 mar 23 

> 2002 /usr/lib/libc.a

> -rw-r--r--1 root root  178 mar 23 

> 2002 /usr/lib/libc.so

> -rw-r--r--1 root root   869190 mar 23 

> 2002 /usr/lib/libc-client.a

> lrwxrwxrwx1 root root   20 jul 19

> 12:17 /usr/lib/libc-client.so -> libc-client.so.2001a

> -rwxr-xr-x1 root root   725296 mar 23 

> 2002 /usr/lib/libc-client.so.2001a

> Configure command: ./configure  --disable-shared

> --with-mysqld-ldflags=-static

> --with-client-ldflags=-static --without-berkeley-db

> --without-innodb --enable-assembler

> --enable-large-files --infodir=/usr/share/info

> --libdir=/usr/lib --libexecdir=/usr/sbin

> --localstatedir=/var/lib/mysql --mandir=/usr/share/man

> --prefix=/usr --sysconfdir=/etc

> --with-mysqld-user=mysql --without-debug

> --datadir=/usr/share --includedir=/usr/include

> --with-extra-charsets=complex

> --with-unix-socket-path=/var/lib/mysql/mysql.sock

> --with-libwrap

> 

> 

> 

> 

>

> __ 

> Renovamos el Correo Yahoo! 

> Nuevos servicios, m$s seguridad 

> http://correo.yahoo.es

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql bug

[Dathan Vance Pattishall]

Not a bug look /etc/my.cnf
Your default sock file might be in /tmp and the client is configure to
look at /var/lib/mysql

-->-Original Message-
-->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, September 09, 2003 2:08 PM
-->To: [EMAIL PROTECTED]
-->Subject: Mysql bug
-->
-->Hello,
-->
-->I can't connect to mysql, the message is :
-->"can't connect  problem with /var/lib/mysql.sock" or something
like
-->that
-->(sorry i forgot to write it and actually also have problems to
connect
-->with
-->ADSL to internet under Linux so i send you this from windows).
-->
-->Can you help me ? Thanks.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql BUG, again ;)

[Boyd Lynn Gerber]

On Tue, 29 Jul 2003, Dyego Souza do Carmo wrote:
>
>I would like to know if you could fix the bug I reported to you
>some days ago.
>
>The error is: "ERROR 1030: Got error 139 from table handler" after
>running an update command using several blobs.
>
>Now I am using mySql 4.0.15 and Linux. If you try to do the same
>with mySql 4.0.14, the record that is updated is simple deleted.

Please post your bugs to http://bugs.mysql.com It is a tracking system for
bugs.

> My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
> using InnoDB tables ;)
>
> InnoDB,MyISAM,SQL
>
>
>
>
> -
>   ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento
> -
>  E S C R I B A   I N F O R M A T I C A
> -
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> --ICQ   : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311
> look: cannot open my eyes Fax   : +55 041 296-6640
> -
>Reply: [EMAIL PROTECTED]
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>

-- 
Boyd Gerber, Software Engineer & Support Specialist
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql BUG, again ;)

[Heikki Tuuri]

Dyego,

but now it works right.

[EMAIL PROTECTED]:~/mysql-standard-4.0.8-gamma-pc-linux-i686/bin> perror 139
Error code 139:  Unknown error 139
139 = Too big row (>= 16 M)

The error message text above is wrong, though :). This has nothing to do
with 16 MB.

You should not put THAT many BLOBs in the same row. Split the table
vertically into several. InnoDB-4.0.14 stores the first 512 bytes of each
BLOB into the clustered index record. If you have > 14 BLOBs, then the
clustered index record will be > 8000 bytes long, and you get the error
above.

Regards,

Heikki


Subject: mysql BUG, again ;)
From: Dyego Souza do Carmo
Date: Tue, 29 Jul 2003 09:40:17 -0300



Hi,

   I would like to know if you could fix the bug I reported to you
   some days ago.

   The error is: "ERROR 1030: Got error 139 from table handler" after
   running an update command using several blobs.

   Now I am using mySql 4.0.15 and Linux. If you try to do the same
   with mySql 4.0.14, the record that is updated is simple deleted.

My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
using InnoDB tables ;)

InnoDB,MyISAM,SQL




-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento
-
 E S C R I B A   I N F O R M A T I C A


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySql BUG

[Sinisa Milivojevic]

Dyego Souza do Carmo writes:
> Hi,
> 
> 
> Try to do the following:
> 

[skip]

> 
> 
> -
>   ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
> -
>  E S C R I B A   I N F O R M A T I C A
> -
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> --ICQ   : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311  
> look: cannot open my eyes Fax   : +55 041 296-6640
> -
>Reply: [EMAIL PROTECTED]
> 

Hi!


Your attachment was stripped off.

Please upload it to:

ftp://support.mysql.com:/pub/mysql/secret

and let us know it's filename.

-- 

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
   <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql: bug in update (?)

[Paul DuBois]

At 14:51 +0300 6/8/03, Dmitry Kosoy wrote:
Hi,

I have a table with 2 fields (among others) with type timestamp ("warndate"
and "date").
I run the following update: update dbowner where warndate = now().
This update affects not only on the field "warndate" but on the field "date"
as well.
After it the both fields got the current date and time value.
I changed the name of field "date" to another and got the same result.
I got the same behavior in many mysql versions include 4.0.12.
This is how the TIMESTAMP column type works.  You'll find this section
of the manual to be of interest:
http://www.mysql.com/doc/en/DATETIME.html

Regards,
  Dmitry


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql: bug in update (?)

[O'K Web Design]

Hi

Your problem lies in your columns.  A timestamp field has the special
property of recording when a record is created or modified.  However, only
the first timestamp column in a row is treated this way.  I hope this helps.
Mike


- Original Message -
From: "Dmitry Kosoy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: June 8, 2003 7:51 AM
Subject: mysql: bug in update (?)


>
> Hi,
>
> I have a table with 2 fields (among others) with type timestamp
("warndate"
> and "date").
> I run the following update: update dbowner where warndate = now().
> This update affects not only on the field "warndate" but on the field
"date"
> as well.
> After it the both fields got the current date and time value.
> I changed the name of field "date" to another and got the same result.
>
> I got the same behavior in many mysql versions include 4.0.12.
>
> Regards,
>   Dmitry
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Bug Database

[Sunil Gavaskar]

hi,
 Thanks for the mail.
Ive got the link from Mr.Zak Greant-MySql Company.
The link is bugs.mysql.com
But Im not getting any result for my search here!!!:-))

Regards
Sunil Gavaskar
Egor Egorov wrote:


On Thursday 20 February 2003 17:39, Sunil Gavaskar wrote:

 

   I need to know the link for Mysql Bug Database.
I tried a lot in google...but not yet got it.
somebody send me the link plz...
   


There is no bugs tracking database for MySQL.



 





-
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: Mysql Bug Database

[Egor Egorov]

On Thursday 20 February 2003 17:39, Sunil Gavaskar wrote:

> I need to know the link for Mysql Bug Database.
> I tried a lot in google...but not yet got it.
> somebody send me the link plz...

There is no bugs tracking database for MySQL.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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: Mysql Bug Database

[Sunil Gavaskar]

hi,
  can u just mail me the link that i asked for...
thanks
regards
sunil gavaskar
Sunil Gavaskar wrote:


Hello,
   I need to know the link for Mysql Bug Database.
I tried a lot in google...but not yet got it.
somebody send me the link plz...

Thanks a lot in advance

regards
sunil gavaskar



-
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





-
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: MySQL BUG

[Bill Kratochvil]

MsgBox 1 --> Data provider or other service returned an E_FAIL status.


Been there, done that (so have a lot of people via my research).   Not
so much a MySql thing as it is a Microsoft thing - I was seeing similar
messages with not only MySql, but also Microsoft SQL (ADO and E_FAIL).  

Like Peter Simard, I decided to dump MyODBC and moved to VbMyQL from
http://www.icarz.com/mysql .   This decision came after a frustrating
evolution process (over a period of two months).  I started with RDO
and worked my way up to ADO 2.7.   With ADO 2.7 I was finally able to
get stability (something I've been very used to with Visual Foxpro).
Although 2.7 offered the highest reliability I still got errors - if a
date range was not valid (Foxpro uses empty dates) *OR* a memo field
(longtext) field was blank then I would get the E_FAIL status every
time.   My work around was to ensure that FOXPRO did not write an empty
memo field or date (date set to 1900/01/01 and memos to ""). This was a
flakey solution at best because if a client had one of these scenerios
then my database utility manager (for support folks) would not permit my
utility to access the data because of the dreaded E_FAIL message

I suspect if you replace all your LONGTEXT fields with a chr(20), if
they are empty, your problem will go away - flakey

Once I converted to ICARZ's VbMyQL I was able to actually focus on
programming, versus debugging and now have the beginning of an open
source MySql manager in the works (VB6).   I have not experienced *any*
crashes or errors.   As soon as I figure out how GNU works and can give
proper credit where credit is due (icarz) I'll be publishing the utility
and source.   It does'n't offer all the bells and whistles of ADO but at
least it works ;)

Bill Kratochvil
QuickCARE Developer
www.QuickCARE.com

P.S.  Visual Foxpro works seemlessly with MySql - havn't had any
problems since we started evaluating it (starting January we're moving
to a client/server SQL/MySql backend).   I almost canned the VB6 MySql
management utility (started thinking about doing it in Fox) but now that
I have a stable development environment for the data it's back on track
- I am really impressed with Visual Basic - I've only been working with
it for a few months but I trust the power of the open source utility
that I'm developing might pull on seasoned veterans (to improve it and
my code).  


-Original Message-
From: deep kapasi [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 20, 2002 8:51 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: MySQL BUG


Hi,
 
I am facing strange problem while accessing a LONGTEXT
field. 
 
I've been using VisualBasic 6.0 & MySQL 4.0.4 via ADO
2.0 by using MyODBC 3.51.04 on WIN2k Server (SP 2).

Pls follow the below steps to generate a bug -->
'/'
1. Create a Table for testing
'* Script to generate the table and insert a record *'
USE TEST;
CREATE TABLE Testing
(
 ID   INT   NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 msg  LONGTEXT  NOT NULL ,
 fld2 INT   NOT NULL
) TYPE=InnoDB;

INSERT INTO Testing(msg,fld2)
VALUES("",1);

2. Create a VB Project
'* VB CODE * '
'Step to create a VB project
'a. Open a new VB project
'b. Add reference of ADO 2.0 
'c. By default New form will be added to the project
'd. Copy the below code in it

Option Explicit
 
Private mcnn As New ADODB.Connection
 
Private Sub Form_Load()
On Error GoTo DispError
Dim rst As New ADODB.Recordset
Dim strSQL  As String
 
'change below connection string as per your db
settings
mcnn.Open "Driver={MySQL ODBC 3.51
Driver};SERVER=server;DB=test;UID=root;PWD=;OPTION=3"
strSQL = "SELECT * FROM Testing"

'*** Method 1.  Client side recordset ***'
'   If 'msg' field has blank string - below
code will give error while trying
'   to access Recordcount property, and
strangely Recordpointer is at EOF
'   If 'msg' field has value other than blank
string & NULL then it will run properly
With rst
Set .ActiveConnection = mcnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open Source:=strSQL, Options:=adCmdText
 'Normally below statement should return 1 but
on my m/c
 'it generates E_FAIL status error.
MsgBox .RecordCount 
 'it will display -1 as record pointer is at
EOF, Strange?
MsgBox "Record pointer: " & .AbsolutePosition 
 
End With
Set rst = Nothing ''

'*** Method 2.  Server side recordset ***'
'   If 'msg' field has blank string -
below code will return NULL
'   If 'msg' field has value other than
blank string & NULL then it will return blank string
Set rst = mcnn.Execute(CommandText:=strSQL,
Options:=adCmdText)
MsgBox "Msg: " &
IIf(IsNull(rst.Fields("msg").Value), "",
r

Re: MySQL bug?

[Gerald Clark]

Maybe a simple
mysqladmin flush-logs
would have done it.

Mark Dieterich wrote:

>Jeremy,
>
>What would I do without the internet???  I restarted mysql by hand and
>the discrepency immediately went away.  I should have thought about
>that.
>
>Thanks!
>
>Mark
>
>On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote:
>
>>Are you deleting any logs and not restarting the server after deleting?
>>We had this problem with httpd logs.  We'd move them off, but they were
>>still open at the old file system location until a httpd restart.
>>
>
>-
>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
>
>



-
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: MySQL bug?

[Mark Dieterich]

Jeremy,

What would I do without the internet???  I restarted mysql by hand and
the discrepency immediately went away.  I should have thought about
that.

Thanks!

Mark

On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote:
> Are you deleting any logs and not restarting the server after deleting?
> We had this problem with httpd logs.  We'd move them off, but they were
> still open at the old file system location until a httpd restart.

-
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: Re: Re: MySQL bug? - problems with character-set latvian.conf [1/3]

[Andis]

From: "Andis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>,
	"Victoria Reznichenko" <[EMAIL PROTECTED]>
References: <001d01c2394e$85803740$[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <003601c239ea$f0f7d720$[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <001001c23a13$5ba93280$[EMAIL PROTECTED]>   "Victoria Reznichenko" <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
Subject: Re: Re: Re: MySQL bug? - problems with character-set
Date: Fri, 2 Aug 2002 17:57:53 +0300
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="=_NextPart_000_002C_01C23A4E.20042D80"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.

This is a multi-part message in MIME format.

--=_NextPart_000_002C_01C23A4E.20042D80
Content-Type: text/plain;
	charset="iso-8859-4"
Content-Transfer-Encoding: 7bit

Here is my conf file. Also I send my Excel file, where with yellow is marked
symbols which is used in Latvian language. Of course, also we use such
symbols as W, X, Y etc. This means, for right sorting all symbols with ascii
code from 32 to 255 better is include in character-set definition. I hope,
that you'll see xls file as I see :)).

Andis

- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 3:41 PM
Subject: Re: Re: Re: MySQL bug? - problems with character-set


> Andis,
> Friday, August 02, 2002, 1:57:12 PM, you wrote:
>
> A> I created character-set myself. Here, in Latvia, we use windows-1257.
> A> Problem is, when I use MySQL under Linux, conversation occurs better.
Under
> A> windows98 I have problems as I wrote before. Cheracter-set I created
myself,
> A> because included isn't correct.
>
> Seems, your to_lower[] array is not correct. Unfortunately, I don't
> know Latvian language and can't tell you what is wrong :(
>
> You say that included character set is not correct. Do you mean
> cp1257 ? If so, can you explain what is wrong with character set?
> Can you provide your own character set with explanation of changes
> that you did?
>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> 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
>
>

--=_NextPart_000_002C_01C23A4E.20042D80
Content-Type: application/octet-stream;
	name="latvian.conf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="latvian.conf"

# Configuration file for the latvian character set.
# Created for case-sensitive record search=0A=
# Created accord with windows-1257 (iso-8859-4) codepage=0A=
# Created by Andis Grasis & Rihards Grasis=0D e-mail:[EMAIL PROTECTED]=0A=

# The ctype array must have 257 elements.
  00
  20  20  20  20  20  20  20  20  20  28  28  28  28  28  20  20
  20  20  20  20  20  20  20  20  20  20  20  20  20  20  20  20
  48  10  10  10  10  10  10  10  10  10  10  10  10  10  10  10
  84  84  84  84  84  84  84  84  84  84  10  10  10  10  10  10
  10  81  81  81  81  81  81  01  01  01  01  01  01  01  01  01
  01  01  01  01  01  01  01  01  01  01  01  10  10  10  10  10
  10  82  82  82  82  82  82  02  02  02  02  02  02  02  02  02
  02  02  02  02  02  02  02  02  02  02  02  10  10  10  10  20
  01  20  10  20  10  10  00  00  20  10  20  10  20  10  10  10
  20  10  10  10  10  10  10  10  20  00  20  10  20  10  10  20
  48  20  10  10  10  20  10  10  10  10  01  10  10  10  10  01
  10  10  10  10  10  10  10  10  10  10  02  10  10  10  10  02
  01  01  01  01  01  01  01  01  01  01  01  01  01  01  01  01
  01  01  01  01  01  01  01  10  01  01  01  01  01  01  01  02
  02  02  02  02  02  02  02  02  02  02  02  02  02  02  02  02
  02  02  02  02  02  02  02  10  02  02  02  02  02  02  02  10

# The to_lower array must have 256 elements.
  00  01  02  03  04  05  06  07  08  09  0A  0B  0C  0D  0E  0F
  10  11  12  13  14  15  16  17  18  19  1A  1B  1C  1D  1E  1F
  20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
  30  31  32  3

Re: Re: Re: MySQL bug? - problems with character-set

[Victoria Reznichenko]

Andis,
Friday, August 02, 2002, 1:57:12 PM, you wrote:

A> I created character-set myself. Here, in Latvia, we use windows-1257.
A> Problem is, when I use MySQL under Linux, conversation occurs better. Under
A> windows98 I have problems as I wrote before. Cheracter-set I created myself,
A> because included isn't correct.

Seems, your to_lower[] array is not correct. Unfortunately, I don't
know Latvian language and can't tell you what is wrong :(

You say that included character set is not correct. Do you mean
cp1257 ? If so, can you explain what is wrong with character set?
Can you provide your own character set with explanation of changes
that you did?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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: Re: MySQL bug? - problems with character-set

[Andis]

I created character-set myself. Here, in Latvia, we use windows-1257.
Problem is, when I use MySQL under Linux, conversation occurs better. Under
windows98 I have problems as I wrote before. Cheracter-set I created myself,
because included isn't correct.

Andis



- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 1:05 PM
Subject: Re: Re: MySQL bug? - problems with character-set


> Andis,
> Friday, August 02, 2002, 9:07:54 AM, you wrote:
>
> A> It's just a simple example, because I don't want send latvian-specific
> A> symbols. This problem occurs with latvian-specific symbols only.
> A> Configuration file I cheked some 4-5 times. I'm confused now.
>
> To convert correctly from upper case to lower case and vice versa you
should specify proper character set.
>
> If you look into *.conf files in the charsets dir you can see 4 arrays
there. Two of them,
> to_lower[] and to_upper[], contain the lowercase and uppercase
> characters corresponding to each member of the character set.
>
> What character set do you use in MySQL? And what character set is used for
Latvian language?
>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> 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
>
>


-
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: Re: MySQL bug? - problems with character-set

[Victoria Reznichenko]

Andis,
Friday, August 02, 2002, 9:07:54 AM, you wrote:

A> It's just a simple example, because I don't want send latvian-specific
A> symbols. This problem occurs with latvian-specific symbols only.
A> Configuration file I cheked some 4-5 times. I'm confused now.

To convert correctly from upper case to lower case and vice versa you should specify 
proper character set.

If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of 
them,
to_lower[] and to_upper[], contain the lowercase and uppercase
characters corresponding to each member of the character set.

What character set do you use in MySQL? And what character set is used for Latvian 
language?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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: MySQL bug? - problems with character-set

[Andis]

Hi!

It's just a simple example, because I don't want send latvian-specific
symbols. This problem occurs with latvian-specific symbols only.
Configuration file I cheked some 4-5 times. I'm confused now.

Regards from Latvia!

Andis Grasis

- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 01, 2002 4:41 PM
Subject: Re: MySQL bug? - problems with character-set


> Andis,
> Thursday, August 01, 2002, 2:28:12 PM, you wrote:
>
> AG> I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat
7.3 with
> AG> such SQL:
>
> AG> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS')
>
> AG> and recieved different results (of course, I used same config file
with
> AG> case-sensitive configuration).
> AG> Result under Linux looks better, under window - wrong, because result
> AG> contain lower-case and upper-case symbols together
> AG> It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'
> AG> Now I feel confused, hov I can test, is my conf file.
>
> Strange ..
> on my w2k and RedHat 7.1 box I got correct results:
>
> mysql> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS');
> +--+
> | lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') |
> +--+
> | here i tiped in specific my language characters  |
> +--+
> 1 row in set (0.00 sec)
>
>
> What Windows do you use? How did you install MySQL from binary or from
source?
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> 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
>
>


-
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: MySQL bug? - problems with character-set

[Victoria Reznichenko]

Andis,
Thursday, August 01, 2002, 2:28:12 PM, you wrote:

AG> I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with
AG> such SQL:

AG> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS')

AG> and recieved different results (of course, I used same config file with
AG> case-sensitive configuration).
AG> Result under Linux looks better, under window - wrong, because result
AG> contain lower-case and upper-case symbols together
AG> It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'
AG> Now I feel confused, hov I can test, is my conf file.

Strange ..
on my w2k and RedHat 7.1 box I got correct results:

mysql> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS');
+--+
| lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') |
+--+
| here i tiped in specific my language characters  |
+--+
1 row in set (0.00 sec)


What Windows do you use? How did you install MySQL from binary or from source?

-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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: MySQL Bug - bug list rejected

[Roger Baklund]

* Chris Beasley
> I tried posting this on the bug list and it rejected it.
>
> I've got this bug in a php script of mine and I think it's
> because of MySQL.
> I have a value I am inserting into a database and above and below
> my query I
> can echo out the value and it is correct, but the query keeps
> assuming it is
> "127"  No matter what I do, I've renamed the variable, renamed the field,
> changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
> making up this number, there is no place it could get it.

This is a classic. :)

Your field is defined as a TINYINT, an signed single byte datatype with a
max value of 127.

You should redifine the field type to a SMALLINT, probably even a UNSIGNED
SMALLINT.

http://www.mysql.com/doc/C/o/Column_types.html >

--
Roger


-
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: MySQL Bug - bug list rejected

[Gurhan Ozen]

I don't think this is a bug, you probably choose TINYINT datatype for the
column, and the maximum value a TINYINT column can have is 127, so anything
over 127 will automatically be changed to 127 silently by MySQL. Choose an
appropriate column datatype for your field.
See: http://www.mysql.com/doc/C/o/Column_types.html
Gurhan

- Original Message -
From: "Chris Beasley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 23, 2002 10:46 AM
Subject: MySQL Bug - bug list rejected


> I tried posting this on the bug list and it rejected it.
>
> I've got this bug in a php script of mine and I think it's because of
MySQL.
> I have a value I am inserting into a database and above and below my query
I
> can echo out the value and it is correct, but the query keeps assuming it
is
> "127"  No matter what I do, I've renamed the variable, renamed the field,
> changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
> making up this number, there is no place it could get it.
>
> More detailed explanation is here:
>
> http://www.sitepointforums.com/showthread.php?s=&postid=477502
>
> Check out the thread, if I don't have absolute proof of a MySQL bug then I
> don't think such proof would be possible to get.
>
> Chris Beasley
>
>
> -
> 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
>


-
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: MySQL Bug - bug list rejected

[Jocelyn Fournier]

Hi,

Your column comid is probably declared as a tinyint which has a range
between -128 and 127 (for not UNSIGNED column).
If you want to allow larger values, change the column type accordingly.

(Take a look here :

http://www.mysql.com/doc/C/o/Column_types.html
)

Regards,
  Jocelyn Fournier
- Original Message -
From: "Chris Beasley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 23, 2002 4:46 PM
Subject: MySQL Bug - bug list rejected


> I tried posting this on the bug list and it rejected it.
>
> I've got this bug in a php script of mine and I think it's because of
MySQL.
> I have a value I am inserting into a database and above and below my query
I
> can echo out the value and it is correct, but the query keeps assuming it
is
> "127"  No matter what I do, I've renamed the variable, renamed the field,
> changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
> making up this number, there is no place it could get it.
>
> More detailed explanation is here:
>
> http://www.sitepointforums.com/showthread.php?s=&postid=477502
>
> Check out the thread, if I don't have absolute proof of a MySQL bug then I
> don't think such proof would be possible to get.
>
> Chris Beasley
>
>
> -
> 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
>
>
>
>


-
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: Mysql Bug Report, Random crashes, reason unknown

[Egor Egorov]

Gavin,
Monday, April 22, 2002, 6:29:08 PM, you wrote:

GW> Description:
GW> MySQL Crashes often.
GW> How-To-Repeat:
GW> Don't know
GW> Fix:
GW> Don't know

GW>Submitter-Id:  Gavin Woodhatch
GW>Originator:
GW>Organization:  NetZone Ltd.
GW>MySQL support: [none]
GW>Synopsis:  Random MySQL crashes (1-2 every 24h)
GW>Severity:  [ serious ]
GW>Priority:  [ medium ]
GW>Category:  mysql
GW>Class: [ sw-bug ]
GW>Release:   mysql-3.23.49a (Official MySQL Binary)

GW>Environment:
GW> System: Linux db1 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown
GW> Architecture: i686


GW> I hope someone can help us on this one .. i guess i am lost.
GW> The distribution  we are using is SuSE 7.3

Signal 4 means "illegal instruction", when your binary is not
compatible with your architecture... Signal 11 means "Segmentation fault", when 
the program cames out of it's address space. 

In your case, the combination of these two most likely means broken hardware as SIGILL 
is _very_ unlikely to happen, if not impossible.

GW> Thanks for your Help in advance.
GW> Gavin Woodhatch
GW> NetZone Ltd.





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
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: MySQL Bug

[Miguel Angel Solorzano]

At 21:22 11/04/02 -0500, John D Armstrong wrote:
Hi!
>On my computer both old 'stable' releases and new alpha downloads of
>MySQL report this error:
>
>020411 21:21:31  Can't find messagefile
>'c:\mysqin\share\english\errmsg.sys'
>020411 21:21:31  Aborting
>
>Although I have checked several times for the files existence. Any Idea?

The message error shows that you had installed on another directory
than the default c:\mysql, so you need to have the my.cnf or my.ini
file with:

[mysqld]
basedir=c:\mysqin
datadir=c:\mysqin\data

Regards,
Miguel



-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
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: mysql bug

[Timo Maier]

Hi Sinisa!

>Thank you for your bug report.
Thank /you/ for MySQL (:

tam
-- 
eCS 1.00, Ducati 750SS '92 up and running
http://tam.belchenstuermer.de/

-
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: mysql bug

[Sinisa Milivojevic]

Thank you for your bug report.

This bug is now fixed in 3.23.50, which  will very soon be available.

This  is a  patch   that  fixes a bug :

--- 1.12/sql/item.ccWed May 23 02:32:52 2001
+++ 1.13/sql/item.ccFri Mar 22 14:03:42 2002
@@ -59,12 +59,28 @@
   }
 }
 
-bool Item::eq(const Item *item) const  // Only doing this on conds
+/*
+  This function is only called when comparing items in the WHERE clause
+*/
+
+bool Item::eq(const Item *item, bool binary_cmp) const
 {
   return type() == item->type() && name && item->name &&
 !my_strcasecmp(name,item->name);
 }
 
+bool Item_string::eq(const Item *item, bool binary_cmp) const
+{
+  if (type() == item->type())
+  {
+if (binary_cmp)
+  return !stringcmp(&str_value, &item->str_value);
+return !sortcmp(&str_value, &item->str_value);
+  }
+  return 0;
+}
+
+
 /*
   Get the value of the function as a TIME structure.
   As a extra convenience the time structure is reset on error!
@@ -202,7 +218,7 @@
   return result_field->val_int();
 }
 
-bool Item_field::eq(const Item *item) const
+bool Item_field::eq(const Item *item, bool binary_cmp) const
 {
   return item->type() == FIELD_ITEM && ((Item_field*) item)->field == field;
 }
@@ -245,7 +261,8 @@
   str->append('\'');
 }
 
-bool Item_null::eq(const Item *item) const { return item->type() == type(); }
+bool Item_null::eq(const Item *item, bool binary_cmp) const
+{ return item->type() == type(); }
 double Item_null::val() { null_value=1; return 0.0; }
 longlong Item_null::val_int() { null_value=1; return 0; }
 /* ARGSUSED */

--- 1.12/sql/item.h Wed Oct 31 18:27:48 2001
+++ 1.13/sql/item.h Fri Mar 22 14:03:42 2002
@@ -56,7 +56,7 @@
   virtual void save_org_in_field(Field *field)
 { (void) save_in_field(field); }
   virtual bool send(String *str);
-  virtual bool eq(const Item *) const;
+  virtual bool eq(const Item *, bool binary_cmp) const;
   virtual Item_result result_type () const { return REAL_RESULT; }
   virtual enum Type type() const =0;
   virtual double val()=0;
@@ -109,7 +109,7 @@
   {}
   Item_field(Field *field);
   enum Type type() const { return FIELD_ITEM; }
-  bool eq(const Item *item) const;
+  bool eq(const Item *item, bool binary_cmp) const;
   double val();
   longlong val_int();
   String *val_str(String*);
@@ -138,7 +138,7 @@
   Item_null(char *name_par=0)
 { maybe_null=null_value=TRUE; name= name_par ? name_par : (char*) "NULL";}
   enum Type type() const { return NULL_ITEM; }
-  bool eq(const Item *item) const;
+  bool eq(const Item *item, bool binary_cmp) const;
   double val();
   longlong val_int();
   String *val_str(String *str);
@@ -247,6 +247,7 @@
   void make_field(Send_field *field);
   enum Item_result result_type () const { return STRING_RESULT; }
   bool basic_const_item() const { return 1; }
+  bool eq(const Item *item, bool binary_cmp) const;
   Item *new_item() { return new Item_string(name,str_value.ptr(),max_length); }
   String *const_string() { return &str_value; }
   inline void append(char *str,uint length) { str_value.append(str,length); }
@@ -306,7 +307,8 @@
   Item_ref(Item **item, char *table_name_par,char *field_name_par)
 :Item_ident(NullS,table_name_par,field_name_par),ref(item) {}
   enum Type type() const   { return REF_ITEM; }
-  bool eq(const Item *item) const  { return (*ref)->eq(item); }
+  bool eq(const Item *item, bool binary_cmp) const
+  { return (*ref)->eq(item, binary_cmp); }
   ~Item_ref() { if (ref) delete *ref; }
   double val()
   {

--- 1.46/sql/item_func.cc   Thu Dec 27 02:04:27 2001
+++ 1.47/sql/item_func.cc   Fri Mar 22 14:03:42 2002
@@ -148,7 +148,7 @@
   str->append(')');
 }
 
-bool Item_func::eq(const Item *item) const
+bool Item_func::eq(const Item *item, bool binary_cmp) const
 {
   /* Assume we don't have rtti */
   if (this == item)
@@ -160,7 +160,7 @@
   func_name() != item_func->func_name())
 return 0;
   for (uint i=0; i < arg_count ; i++)
-if (!args[i]->eq(item_func->args[i]))
+if (!args[i]->eq(item_func->args[i], binary_cmp))
   return 0;
   return 1;
 }
@@ -1882,7 +1882,7 @@
   str->append(')');
 }
 
-bool Item_func_get_user_var::eq(const Item *item) const
+bool Item_func_get_user_var::eq(const Item *item, bool binary_cmp) const
 {
   /* Assume we don't have rtti */
   if (this == item)
@@ -2135,7 +2135,7 @@
   return 1;
 }
 
-bool Item_func_match::eq(const Item *item) const
+bool Item_func_match::eq(const Item *item, bool binary_cmp) const
 {
   if (item->type() != FUNC_ITEM)
 return 0;
@@ -2146,7 +2146,7 @@
   Item_func_match *ifm=(Item_func_match*) item;
 
   if (key == ifm->key && table == ifm->table &&
-  key_item()->eq(ifm->key_item()))
+  key_item()->eq(ifm->key_item(), binary_cmp))
 return 1;
 
   return 0;

--- 1.24/sql/item_func.hThu Dec 27 02:04:27 2001
+++ 1.25/sql/item_func.hFri Mar 22 14:03:42 2002
@@ -98,7 +98,7 @@
   void make_field(Send_field *field);
   table_map used_tables() const;
  

Re: mysql bug

[Benjamin Pflugmann]

Hello.

On Wed, Dec 19, 2001 at 05:13:02AM -0800, [EMAIL PROTECTED] wrote:
> Dear Sir/Madam
> I downloaded mysql3.23max version actaually i want to
> use Innodb type for my tables in the properties its
> showing Innodb is disabled to enable that i ve to give
> some path in 'my.cnf' file according to Manual but im
> not getting the my.cnf file any where in that folder i
> searche all the computer but i didnt get that my.cnf
> file  what happend to that my.cnf file please let
> meknow about that my.cnf file 

There is no default my.cnf file installed. You have to create your own
one. There come some sample config files with the distribution called
e.g. my-small.cnf (medium, large and huge). You can copy one of them
to start with.

For more information about the config file, have a look at the fine
manual: http://www.mysql.com/doc/O/p/Option_files.html

> please mail me back
> thanks and regards
> kiran.

Bye,

Benjamin.

-- 
[EMAIL PROTECTED]

-
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: MYSQL bug with if and datetime fields

[Michael Widenius]

Hi!

> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:

Sinisa> Arturs Aboltins writes:
>> From: [EMAIL PROTECTED]
>> To:   [EMAIL PROTECTED]
>> Subject: MYSQL bug with if and datetime fields
>> 
>> >Description:
>> In queries where datetime field is in "WHERE" condition, the same
>> field
>> in "IF" statement causes incorrect query result.
>> >How-To-Repeat:
mysql> select * from test ;
>> +--+-+
>> | id   | dt  |
>> +--+-+
>> |1 | 2001-08-14 00:00:00 |
>> |2 | 2001-08-15 00:00:00 |
>> |3 | 2001-08-16 00:00:00 |
>> +--+-+
>> 3 rows in set (0.00 sec)
>> 
mysql> select * from test where dt='2001-08-14 00:00:00' and dt =
>> if(id=1,'2001-08-14 00:00:00','1999-08-15');
>> Empty set (0.95 sec)
>> 

Sinisa> Please try the above with 3.23.41. I think that it was fixed
Sinisa> meanwhile. 



The reason the above is failing is that the WHERE is optimized to:

t1.dt = 2001081400 and 2001081400 = if((t1.id = 1),'2001-08-14 
00:00:00','1999-08-15')

Because 'if' returns a string in this case, the later query doesn't
match :(

I will try to disable this with optimization for datetime in the
future.

In the mean time, you can fid this by either doing:

select * from test where dt=2001081400 and 
dt=if(id=1,2001081400,1999081500);

or:

select * from test where dt='2001-08-14 00:00:00' and concat(dt) =
if(id=1,'2001-08-14 00:00:00','1999-08-15');

The extra concat() will disable this optimization.

Regards,
Monty


-
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: MYSQL bug with if and datetime fields

[Sinisa Milivojevic]

Arturs Aboltins writes:
> From: [EMAIL PROTECTED]
> To:   [EMAIL PROTECTED]
> Subject: MYSQL bug with if and datetime fields
> 
> >Description:
>   In queries where datetime field is in "WHERE" condition, the same
> field
>   in "IF" statement causes incorrect query result.
> >How-To-Repeat:
> #---
> -
>   mysql> select * from test ;
>   +--+-+
>   | id   | dt  |
>   +--+-+
>   |1 | 2001-08-14 00:00:00 |
>   |2 | 2001-08-15 00:00:00 |
>   |3 | 2001-08-16 00:00:00 |
>   +--+-+
>   3 rows in set (0.00 sec)
>  
>   mysql> select * from test where dt='2001-08-14 00:00:00' and dt =
> if(id=1,'2001-08-14 00:00:00','1999-08-15');
>   Empty set (0.95 sec)
>  

Please try the above with 3.23.41. I think that it was fixed
meanwhile. 
 

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


-
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: Mysql bug, doesnt use INDEX for ORDER BY!!

[Gunnar von Boehn]

On Mon, 16 Jul 2001, Benjamin Pflugmann wrote:
>
>If I understand it correctly, this is a known and fixed bug:
>
>>From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html:
>--
>F.2.3 Changes in release 3.23.38
>
>[...]
>* Changed optimizer so that queries like SELECT * FROM
>  table_name,table_name2 ... ORDER BY key_part1 LIMIT # will use
>  index on key_part1 instead of filesort.
>[...]
>--
>
>Since 3.23.30, as you said you use, MySQL has experienced a lot of
>improvement, so you may want to upgrade to the current release 3.23.39.

Very good, I'm very happy that this is fixed :-) 


>Btw, it is always a good idea to upgrade to a recent version before
>reporting bugs. If that is not possible, please check the archives or
>the changes history whether the bug has been fixed meanwhile.

ups, shame on me.
I will consider this in future.



regards Gunnar

-
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: Mysql bug, doesnt use INDEX for ORDER BY!!

[Benjamin Pflugmann]

Hi.


On Fri, Jul 13, 2001 at 02:10:54PM +0200, [EMAIL PROTECTED] wrote:
> On Don, 12 Jul 2001, Gerald Clark wrote:
> 
> >It may be the DESC that prohibits the use of the index.
> >Try an normal ascending order.
> 
> Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not.
> I think maybe that this is  a real _bug_ in mysql.  :-(
> 
> Does somebody know if this will be fixed sometimes?

If I understand it correctly, this is a known and fixed bug:

>From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html:
--
F.2.3 Changes in release 3.23.38

[...]
* Changed optimizer so that queries like SELECT * FROM
  table_name,table_name2 ... ORDER BY key_part1 LIMIT # will use
  index on key_part1 instead of filesort.
[...]
--

Since 3.23.30, as you said you use, MySQL has experienced a lot of
improvement, so you may want to upgrade to the current release 3.23.39.

Btw, it is always a good idea to upgrade to a recent version before
reporting bugs. If that is not possible, please check the archives or
the changes history whether the bug has been fixed meanwhile.

Bye,

Benjamin.


-
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: Mysql bug, doesnt use INDEX for ORDER BY!!

[Gunnar von Boehn]

Hello,

On Don, 12 Jul 2001, Gerald Clark wrote:

>It may be the DESC that prohibits the use of the index.
>Try an normal ascending order.

Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not.
I think maybe that this is  a real _bug_ in mysql.  :-(


Does somebody know if this will be fixed sometimes?


best regards
Gunnar von Boehn

-
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: Mysql Bug Report about Latin5 in 3.23.38max

[Sinisa Milivojevic]

Mysql Bug Report about Latin5 in 3.23.38max

I downloaded Mysql Win32 sources and saw that :=20
in share directory , in Index file there is #30 latin5 line.=20
but in directory this file does not exist.=20
all other files are correct and exist but
there is not latin5 file???


Yusuf Incekara
Regards


Thank you for your report.

We shall investigate a matter.

Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
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: MYSQL Bug on Solaris 8

[Lu, Ping]

Usually you need to set your environment variable LD_LIBRARY_PATH to include
the libstdc++.so.2 location (/usr/local/lib maybe ?) when you start mysqld. 

Ping Lu
Cable & Wireless Global
Network Tools and Analysis Group, USA
W: +1-703-292-2359
E: [EMAIL PROTECTED]


> -Original Message-
> From: Arif Chowdhury [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 3:12 PM
> To: [EMAIL PROTECTED]
> Subject: MYSQL Bug on Solaris 8
> 
> 
> Hi there,
> 
> I installed mysql 3.22.32 on Solaris 8 and everytime I am 
> trying to run mysqld it gives me the following error
> ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: 
> libstdc++.so.2.10.0: open failed: No such file or directory 
> 
> Please Advise,
> 
> My email address is [EMAIL PROTECTED]  
> 
> Thanks in advance,
> 
> Arif
> 
> 

-
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