maria-discuss team mailing list archive
Mailing list archive
Re: Giving up on dynamic columns
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
Looks like Maria saves an illegally formatted dyncol string if a dynamic
column is longer than 64kB and is not alphabetically last by name among the
dynamic column in the blob.
Please note that regardless any particular feature, an application
working with real data should either check for warnings which happen
upon DML -- in your case, INSERTs produce "Data truncated for column
'dcols'", -- or, better still, set a strict sql_mode which will convert
these warnings to errors, so the illegal data could never be inserted in
the first place.
Tbh, even is this were fixed tomorrow so I could proceed with my work, I'm
not sure I would use dyncols. My confidence in the feature has been shaken.
It's a pity because the Active Record ORM extension I wrote was working.
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp