>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
