It would seem that you are getting the character corresponding to the ASCII
code 53 as the result of the first query. Try inserting the value for logo
in your table without the quotes round the 53 and see if the results of the
queries become consistent. IMHO this is a bug because the two queries are
returning different interpretations of the stored data.
> -----Original Message-----
> From: TisSoft s.c. [SMTP:[EMAIL PROTECTED]]
> Sent: 26 February 2001 13:20
> To: [EMAIL PROTECTED]
> Subject: Error in "select .... from.... where..." with BDB
>
> >Description:
> I made a table:
> CREATE TABLE parametry (
> SYMBOL varchar(30) DEFAULT '' NOT NULL,
> WART blob DEFAULT '' NOT NULL,
> PRIMARY KEY (SYMBOL),
> UNIQUE SYMBOL (SYMBOL)
> ) type=BerkeleyDB;
>
> then I put some values in it:
>
> INSERT INTO parametry (SYMBOL, WART) VALUES
> ('Datalic',''),
> ('Kod',''),
> ('Kontakt',''),
> ('Konto',''),
> ('logo','53'),
> ('Miasto',''),
> ('Nazwa',''),
> ('NazwaW',''),
> ('NIP',''),
> ('NIPW',''),
> ('Ulica','');
>
> then I do:
> select * FROM parametry WHERE SYMBOL='logo';
>
> and I get:
> +------------+-------+
> | SYMBOL | WART |
> +------------+-------+
> | logo | @| |
> +------------+-------+
>
> but if I do
> select * FROM parametry;
>
> and I get:
> +------------+-------+
> | SYMBOL | WART |
> +------------+-------+
> | Datalic | |
> | Kod | |
> | Kontakt | |
> | Konto | |
> | logo | 53 | - this is correct
> value
> | Miasto | |
> | Nazwa | |
> | NazwaW | |
> | NIP | |
> | NIPW | |
> | Ulica | |
> +------------+-------+
>
> >How-To-Repeat:
> <code/input/activities to reproduce the problem (multiple lines)>
> It happens every time I do it
> >Fix:
>
> >Submitter-Id: [EMAIL PROTECTED]
> >Originator: Sebastian Biniecki
> >Organization: TisSoft
> <organization of PR author (multiple lines)>
> >MySQL support: [none | licence | email support | extended email support ]
> nono
> >Synopsis: <synopsis of the problem (one line)>
> select ... from .... where ... result bad data with BDB
> >Severity: <[ non-critical | serious | critical ] (one line)>
> serious
> >Priority: <[ low | medium | high ] (one line)>
> high
> >Category: mysql
> >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
> sw-bug
> >Release: mysql-3.23.33 (Source distribution)
>
> >Environment:
> System: Linux mymag.g7.pl 2.2.17-21mdk #1 Thu Oct 5 13:16:08 CEST 2000
> i586
> unknown
> Architecture: i586
>
> 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/i586-mandrake-linux/2.95.3/specs
> gcc version 2.95.3 19991030 (prerelease)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 lut 22 22:05 /lib/libc.so.6 ->
> libc-2.1.3.so
> -rwxr-xr-x 1 root root 931668 paĽ 4 18:26 /lib/libc-2.1.3.so
> -rw-r--r-- 1 root root 20749008 paĽ 4 18:25 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 paĽ 4 18:25 /usr/lib/libc.so
> Configure command:
> ./configure --enable-static --prefix=/mysql --with-low-memory
>
>
>
>
> ---------------------------------------------------------------------
> 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
