Re: [Maria-developers] per-partition attributes in the CREATE TABLE

2010-06-09 Thread Sergei Golubchik
Hi, kentoku! On May 12, kentoku wrote: > Hi, Sergei! > > My use case is 1. > > - my use case start - > If you create a table using following SQL, > CREATE TABLE tbl_a > (.) > ENGINE=spider > COMMENT='database "auto_test_remote2", table "ta_r3"' > CONNECTION='socket "mysql_1

Re: [Maria-developers] per-partition attributes in the CREATE TABLE

2010-05-12 Thread Henrik Ingo
On Wed, May 12, 2010 at 2:11 PM, kentoku wrote: > Additionally, > for supporting different engines in different partitions, > table options should better to be added engine names like > global/session parameters for avoiding conflicting option names. > > - example start - > > If you create

Re: [Maria-developers] per-partition attributes in the CREATE TABLE

2010-05-12 Thread kentoku
Hi, Sergei! My use case is 1. - my use case start - Currently, Spider and Vertical Partitioning engine can use table level "connection", table level "comment", partition level "comment" and sub-partition level "comment" for engine options. This options have following priority. 1. sub-pa

Re: [Maria-developers] per-partition attributes in the CREATE TABLE

2010-05-12 Thread Michael Widenius
Hi! > "Sergei" == Sergei Golubchik writes: Sergei> Hi, Sergei> we've talked about engine attributes in the CREATE TABLE, Sergei> and that one should be able to specify them per partition as well. Sergei> Now, thinking about it, I'm not quite sure what the semantics shuld be. Sergei> What

Re: [Maria-developers] per-partition attributes in the CREATE TABLE

2010-05-11 Thread Sergei Golubchik
Hi, Henrik! On May 11, Henrik Ingo wrote: > On Tue, May 11, 2010 at 12:05 PM, Sergei Golubchik wrote: > > > > we've talked about engine attributes in the CREATE TABLE, and that > > one should be able to specify them per partition as well. > > > > Now, thinking about it, I'm not quite sure what th

Re: [Maria-developers] per-partition attributes in the CREATE TABLE

2010-05-11 Thread Henrik Ingo
On Tue, May 11, 2010 at 12:05 PM, Sergei Golubchik wrote: > Hi, > > we've talked about engine attributes in the CREATE TABLE, > and that one should be able to specify them per partition as well. > > Now, thinking about it, I'm not quite sure what the semantics shuld be. > > What is your use case ?

[Maria-developers] per-partition attributes in the CREATE TABLE

2010-05-11 Thread Sergei Golubchik
Hi, we've talked about engine attributes in the CREATE TABLE, and that one should be able to specify them per partition as well. Now, thinking about it, I'm not quite sure what the semantics shuld be. What is your use case ? How do you want them to work ? I see different possibilities. Say, the