From: Haihao Tang Date: August 17 2009 7:44am Subject: Re: GSoC Week 15 - I_S/P_S storage engine List-Archive: http://lists.mysql.com/soc/446 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00163649a0af244dbc04715193a3 --00163649a0af244dbc04715193a3 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Oh, my god. The test results look ugly. I type it again. TABLE: xxxtable; Sequential scan: SELECT * FROM INFOSCHEMA.xxxtable; Non-sequential scan: SELECT * FROM INFOSCHEMA.xxxtable ORDER BY xxxfield; Index: SELECT * FROM INFOSCHEMA.xxxtable WHERE xxfield = "xxx"; S: support N: not support TABLE Sequential scan Non-sequential scan Index CHARACTER_SETS: S S N COL_CHA_SET_APP: S S N COLLATIONS: S S N COLUMN_PRIVILEGES: S S N ENGINES: S S N GLOBAL_STATUS: S N N GLOBAL_VARIABLES: S N N OPEN_TABLES: S S N PLUGINS: S S N PROCESSLIST: S S N SESSION_STATUS: S N N SESSION_VARIABLES: S N N STATUS: S N N VARIABLES: S N N TABLES: S S S PARTITIONS: S S S TABLE_NAMES: S S Partial Regards, Robin --00163649a0af244dbc04715193a3--