Re: [Maria-discuss] Giving up on dynamic columns

2015-03-01 Thread Federico Razzoli
May I give you a general suggestion? By default, MySQL/MariaDB tends to hide problems. Your case is an obvious example: as far as I understand your application doesn't check for warnings, everything seems to work, but data are truncated and dynamic columns are invalid. I generally suggest to u

Re: [Maria-discuss] Giving up on dynamic columns

2015-03-01 Thread Tom Worster
so it turns out the problem is my incompetence. i thought blob allowed long values. i've been using mysql since 3.something and i still don't know much about its abundance of types. i retract my comments and crawl back into my hole. ___ Mailing list:

Re: [Maria-discuss] Giving up on dynamic columns

2015-03-01 Thread Tom Worster
who is truncating columns? On 3/1/15, 3:27 PM, "Sergei Golubchik" wrote: >Hi, Tom! > >On Mar 01, Tom Worster wrote: >> I discovered this showstopper on Friday while working with real data in >> development of a new app. I managed to narrow it down today and filed >>the >> bug report. >> >> http

Re: [Maria-discuss] Giving up on dynamic columns

2015-03-01 Thread Elena Stepanova
Hi Tom, On 01.03.2015 22:38, Tom Worster wrote: I discovered this showstopper on Friday while working with real data in development of a new app. I managed to narrow it down today and filed the bug report. https://mariadb.atlassian.net/browse/MDEV-7650 Looks like Maria saves an illegally forma

Re: [Maria-discuss] Giving up on dynamic columns

2015-03-01 Thread Sergei Golubchik
Hi, Tom! On Mar 01, Tom Worster wrote: > I discovered this showstopper on Friday while working with real data in > development of a new app. I managed to narrow it down today and filed the > bug report. > > https://mariadb.atlassian.net/browse/MDEV-7650 > > Looks like Maria saves an illegally fo

[Maria-discuss] Giving up on dynamic columns

2015-03-01 Thread Tom Worster
I discovered this showstopper on Friday while working with real data in development of a new app. I managed to narrow it down today and filed the bug report. https://mariadb.atlassian.net/browse/MDEV-7650 Looks like Maria saves an illegally formatted dyncol string if a dynamic column is longer th

[Maria-discuss] myisam_use_mmap unstable in MariaDB 10.0.x

2015-03-01 Thread Reindl Harald
historical: http://lists.mysql.com/mysql/226361 after it turned out to be stable in 2013/2014 upgrade to MariaDB 10.0.17 yesterday and the logs started with "table corrupt", "table not closed properly" and so on for tables which where not only read this time not with 'mysqld got signal 11' bu