Can partition a table with the name "users" but not with "Users"

[Sepp Maier]

Hello everyone,

I have a problem to name the table "Users" but not "users".
I can create both tables but if I name the table "Users" I can't
insert a value "com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'research.users' doesn't exist". And I can't see the table in different
database explorers. Any ideas? Version MySql-5.1.24-rc-osx.

Thanks,

Sepp

OK:

CREATE TABLE users (
type int(11) NOT NULL,
id bigint(20) NOT NULL,
sectionID bigint(20) NOT NULL
)
ENGINE= InnoDB DEFAULT CHARSET= latin1

PARTITION BY LIST(sectionID) (
PARTITION publication01 VALUES IN (3,5,6,9,17),
PARTITION publication02 VALUES IN (1,2,10,11,19,20)
);


NOT OK:

CREATE TABLE Users (
type int(11) NOT NULL,
id bigint(20) NOT NULL,
sectionID bigint(20) NOT NULL
)
ENGINE= InnoDB DEFAULT CHARSET= latin1

PARTITION BY LIST(sectionID) (
PARTITION publication01 VALUES IN (3,5,6,9,17),
PARTITION publication02 VALUES IN (1,2,10,11,19,20)
);