Rather then blog about these which I hope are simply *incomplete* code making it into the main development branch here is some immediate user experiences of the most basic nature.
Playing some more with the most current Drizzle 1317 build. drizzle> select * from schema_names; +--------------------+ | SCHEMA_NAME | +--------------------+ | data_dictionary | | information_schema | +--------------------+ 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. drizzle> select * from information_schema.tables; ERROR 1146 (42S02): Table 'information_schema.tables' doesn't exist There is still some backward compatibility of SHOW commands, SHOW GLOBAL STATUS revealing the 51 rows reported in Drizzle’s Data Dictionary and Global Status but there is no companion SHOW GLOBAL STATEMENTS command for example. 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. Another command is DESC. While nice I don’t actually use it much, and if it only half works, it’s inconsistent. drizzle> desc global_statements; Empty set (0 sec) But wait 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? drizzle> select * from data_dictionary.global_statements; drizzle> select * from data_dictionary.GLOBAL_STATEMENTS; It also seems that the DESC command has morphed from the older MySQL output. What's missing is the *length* of types! mysql> DESC INFORMATION_SCHEMA.GLOBAL_STATUS; +----------------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------+------+-----+---------+-------+ | VARIABLE_NAME | varchar(64) | NO | | | | | VARIABLE_VALUE | varchar(20480) | YES | | NULL | | +----------------+----------------+------+-----+---------+-------+
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
