What VERSION in INFORMATION_SCHEMA.TABLES means (hint: not what you think)
It’s the FRM file format version number.
It’s not the version of the table as one might expect (i.e. after CREATE it’s 1. Then, if you ALTER, it’s 2. Alter again 3 etc).
In Drizzle, we now return 0.
In future, I plan that Drizzle will allow the engine to say what version it is (where 0 is “dunno”).
This’ll be a good step towards being able to cope with multiple versions of a table in use at once (and making sense of this to the user).
November 22nd, 2008 at 12:03 pm
be sure to add in a way to change the version number manually. Its useless to let it increment automatically as multiple ‘ALTER’s can/often happen in a development environment, which consolidate in 1 update on a live environment.
or maybe I’m missing the point..
November 22nd, 2008 at 2:16 pm
Sort of… It’s not meant to be a revision control type system, more of an insight into the engine.
November 22nd, 2008 at 11:08 pm
You should be using NULL for “dunno” that’s exactly it’s purpose.
November 23rd, 2008 at 3:38 am
you’re very right, it should be NULL. Added to my TODO list.