Hi!
Thanks for asking!
On Mar 12, 2010, at 11:50 AM, Ronald Bradford wrote:
However while the new data_dictionary shows 31 tables,
information_schema has ZERO. One would wonder why it’s still there.
If for compatibility where are the tables. just in case they *may*
be some aliases.
Information Schema will be just the ANSI schemas, nothing more. DD
will have a much longer list of schemas to it (which is similar to how
PG/Oracle/MS does it). There is debate about having non-ANSI columns
in the schemas, but the schemas themselves will be limited to just the
standard.
Personally, it’s a new day and a new product, having all this
backward compatibility is not the way to go. SHOW like other things
should be shown the long overdue deprecated and removed door.
I am for keeping some, but not for others. They are just now rewrites,
so the tax on the system is pretty small.
SHOW STATUS is the one I am wondering about longterm.
drizzle> desc GLOBAL_STATEMENTS;
+----------------+---------+-------+---------+-----------------
+-----------+
| Field | Type | Null | Default | Default is NULL | On
Update |
+----------------+---------+-------+---------+-----------------
+-----------+
| VARIABLE_NAME | VARCHAR | FALSE | | FALSE
| |
| VARIABLE_VALUE | VARCHAR | FALSE | | FALSE
| |
+----------------+---------+-------+---------+-----------------
+-----------+
2 rows in set (0 sec)
Since when did this level of case sensitivity exists, in SELECT both
works?
Gotcha, that is a bug.
It also seems that the DESC command has morphed from the older MySQL
output. What's missing is the *length* of types!
Here is the question do you want LENGTH as in number of bytes, or in
number of characters? Just for VARCHAR?
We are just listing the type right now. I can add another column for
length, but what would go there for NUMBER/etc?
Thanks!
-Brian
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
