← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/mysql_differences.rst

  • Committer: Brian Aker
  • Date: 2011-02-12 08:20:19 UTC
  • mto: This revision was merged to the branch mainline in revision 2161.
  • Revision ID: brian@tangent.org-20110212082019-09gs5y1b0pxoaesb
Merge in optimizer pieces.

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/mysql_differences.rst
112
112
 
113
113
INFORMATION_SCHEMA
114
114
------------------
 
115
 
115
116
The INFORMATION_SCHEMA provides access to database metadata.
116
117
 
117
118
The INFORMATION_SCHEMA in Drizzle is strictly ANSI compliant. If you write
166
167
queries. Our INFORMATION_SCHEMA implementation does not have the drawbacks
167
168
of the MySQL implementation.
168
169
 
 
170
Here are some specific SHOW differences:
 
171
 
169
172
 * SHOW ENGINES: use DATA_DICTIONARY
 
173
 * SHOW CREATE TABLE: specifies the AUTO_INCREMENT at CREATE/ALTER TABLE time,
 
174
   not the current AUTO_INCREMENT
 
175
 * SHOW TABLE STATUS: only shows tables in the current table cache
 
176
 * SHOW [ENGINE] STATUS: use the DATA_DICTIONARY tables for that engine
170
177
 
171
178
Removed commands
172
179
----------------
176
183
 * CREATE FUNCTION
177
184
 * CONVERT
178
185
 * SET NAMES
 
186
 * Multi-table delete and multi-table update code was removed and can be accomplished through subqueries. More detailed information can be found in the :doc:`dml` section.
179
187
 
180
188
Operators Removed
181
189
-----------------
182
190
 
183
 
Bit operators: 
184
 
* &&
185
 
* >>
186
 
* <<
187
 
* ~
188
 
* ^
189
 
* |
190
 
* &
 
191
Bit operators
 
192
 * &&
 
193
 * >>
 
194
 * <<
 
195
 * ~
 
196
 * ^
 
197
 * '|'
 
198
 * &
191
199
 
192
200
Removed functions
193
201
-----------------
198
206
 
199
207
Keywords removed
200
208
----------------
 
209
 
201
210
 * BIT_AND
202
211
 * BIT_OR
203
212
 * BIT_XOR