Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
hum... i saw now the view .frm file it's nice... i don't read the internal source code, but is it easy to extend? don't have a limit like today .frm file? ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launc

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
ops, i don't know how this happen in protobuf, or other languages could we add this in jira? or lauch pad, just to don't forget this feature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsu

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
hi sergei, well i start thinking about the frm file after i had a crash in my server and a aria table was read as a connect table, i removed the .frm and put another one in place, and i get my data back if i had a human readable file, that could be easier to understand but what mariadb guys think

Re: [Maria-developers] deferred_event

2013-07-09 Thread Sergei Golubchik
Hi, nanyi607rao! On Jul 10, nanyi607rao wrote: > Hi guys, > as I know, when replication filter used, the defered events is a > container hold on events(such as Intvar-, Rand-, User_var- > log_event)that be applied delay. why those events need be applied > delay? and what is parent Query mentioned

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Sergei Golubchik
Hi, Roberto! On Jul 10, Roberto Spadim wrote: > > 2)why we "still" with this "old" unireg format? That was in the agenda for *at least* 10 years. May be 15 already. Like "it's simple, let's do it next month, shouldn't take more than a couple of weeks". Still, never happened. > i know that som

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
2013/7/10 Stewart Smith > Roberto Spadim writes: > > well, another doubts that i had some time ago reading unireg source... > > > > 1)why it have a 64k limit? that's a logical limit (a limit in int > variable > > or char or something like it)? or just a "well i think 64k is a good > > 'constant'

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Stewart Smith
Roberto Spadim writes: > well, another doubts that i had some time ago reading unireg source... > > 1)why it have a 64k limit? that's a logical limit (a limit in int variable > or char or something like it)? or just a "well i think 64k is a good > 'constant' limit"? 2^16 is why there's that limit

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Stewart Smith
Roberto Spadim writes: > humm interesting, does mariadb have the same bugs of mysql? or it's updated > like drizzle? Same limitations as MySQL due to FRM file format. -- Stewart Smith pgpCLC5Ocnmjg.pgp Description: PGP signature ___ Mailing list: ht

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
i will put this in discussion list, sorry wrong mail list for this topic 2013/7/10 Roberto Spadim > well, another doubts that i had some time ago reading unireg source... > > 1)why it have a 64k limit? that's a logical limit (a limit in int variable > or char or something like it)? or just a "w

[Maria-developers] deferred_event

2013-07-09 Thread nanyi607rao
Hi guys, as I know, when replication filter used, the defered events is a container hold on events(such as Intvar-, Rand-, User_var- log_event)that be applied delay. why those events need be applied delay? and what is parent Query mentioned in codes? Thanks! 2013-07-10 nanyi607rao___

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
well, another doubts that i had some time ago reading unireg source... 1)why it have a 64k limit? that's a logical limit (a limit in int variable or char or something like it)? or just a "well i think 64k is a good 'constant' limit"? 2)why we "still" with this "old" unireg format? i know that som

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
humm interesting, does mariadb have the same bugs of mysql? or it's updated like drizzle? 2013/7/9 Stewart Smith > Roberto Spadim writes: > > i see that in a near future i will have more than 65535 different values > > inside this enum column, the first solution is change it to varchar, but >

Re: [Maria-developers] More enum values in enum fields

2013-07-09 Thread Stewart Smith
Roberto Spadim writes: > i see that in a near future i will have more than 65535 different values > inside this enum column, the first solution is change it to varchar, but my > problem will be data size > the enum is very optimized in size, a char is 'converted' to a smallint > value Note that t

[Maria-developers] help creating error messages

2013-07-09 Thread Roberto Spadim
hi guys, how could i create a new error / warning message in mariadb? 1) how to add the message text to error list (there's a list, right?) 2) how to return (send) a error to client 3) how to add a message to 'warning list' and after get it with SHOW WARNINGS maybe some example or point lines / fi

Re: [Maria-developers] buildbot config

2013-07-09 Thread Leif Walsh
Thanks! -- Cheers, Leif On Tue, Jul 9, 2013 at 8:55 AM, Daniel Bartholomew wrote: > On Tue, Jul 9, 2013 at 7:35 AM, Leif Walsh wrote: >> Hi, >> >> I'm learning buildbot and I was wondering if I could take a look at the >> master.cfg for buildbot.askmonty.org as a reference for learning common

[Maria-developers] More enum values in enum fields

2013-07-09 Thread Roberto Spadim
Hi guys, i have a problem, that i don't know how to easly solve (ok i know but i want the user easy way) i have a ENUM column with some values (today 248 distinct values) i see that in a near future i will have more than 65535 different values inside this enum column, the first solution is change

Re: [Maria-developers] buildbot config

2013-07-09 Thread Daniel Bartholomew
On Tue, Jul 9, 2013 at 7:35 AM, Leif Walsh wrote: > Hi, > > I'm learning buildbot and I was wondering if I could take a look at the > master.cfg for buildbot.askmonty.org as a reference for learning common > practices and things like that. Is it available somewhere? > It's available in the maria

Re: [Maria-developers] OLAP

2013-07-09 Thread Roberto Spadim
Hi Rich, i just see some guys using OLAP, i don't have a full understand of what's OLAP I think we can do with sql, but i don't know how guys use it, they talk about linq (.net functions), mdx and cubes, check this: http://en.wikipedia.org/wiki/Online_analytical_processing http://en.wikipedia.org/w

[Maria-developers] buildbot config

2013-07-09 Thread Leif Walsh
Hi, I'm learning buildbot and I was wondering if I could take a look at the master.cfg for buildbot.askmonty.org as a reference for learning common practices and things like that. Is it available somewhere? -- Cheers, Leif ___ Mailing list: https://l

Re: [Maria-developers] merge for MySQL56 FSP data types

2013-07-09 Thread Sergei Golubchik
Hi, Alexander! On Jul 05, Alexander Barkov wrote: > > > > I thought you'll make real_type() methods to return MYSQL_TYPE_xxx > > values, not MYSQL_TYPE_xxx2 values. Why wouldn't that work? > > I did not even consider it. > This is my understanding of the things: > > Field::type() is responsible

Re: [Maria-developers] OLAP

2013-07-09 Thread Richard Bensley
Hi Roberto, What do you mean by an OLAP tool exactly? I consider MariaDB to already be a great OLAP tool; dynamic and virtual columns, multi-source replication, stored procedures, triggers, and various optimisation features for things like MRR. If you mean something like report scheduling, there