On 26.02.2001 14:19:40 TisSoft s.c. wrote:
> PRIMARY KEY (SYMBOL),
> UNIQUE SYMBOL (SYMBOL)
What's the sense of this? PRIMARY is already UNIQUE, so you don't need to
UNIQUE symbol again.
-
Before posting, please check:
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
('D