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).
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..
Sort of… It’s not meant to be a revision control type system, more of an insight into the engine.
You should be using NULL for “dunno” that’s exactly it’s purpose.
you’re very right, it should be NULL. Added to my TODO list.