MySQL Forums
Forum List  »  Partitioning

Can partition a table with the name "users" but not with "Users"
Posted by: Sepp Maier
Date: January 29, 2009 12:08PM

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)
);

Options: ReplyQuote


Subject
Views
Written By
Posted
Can partition a table with the name "users" but not with "Users"
3780
January 29, 2009 12:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.