← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/information_schema.result

  • Committer: Brian Aker
  • Date: 2008-07-06 03:24:37 UTC
  • Revision ID: brian@tangent.org-20080706032437-gfnpob6l1tjccisl
First pass for removing mediumint (3 byte INT type).

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/information_schema.result
211
211
f1      longblob        4294967295      4294967295
212
212
f2      longtext        4294967295      4294967295
213
213
drop table t1;
214
 
create table t1(f1 tinyint, f2 SMALLINT, f3 mediumint, f4 int,
 
214
create table t1(f1 tinyint, f2 SMALLINT, f3 BIGINT, f4 int,
215
215
f5 BIGINT, f6 TINYINT, f7 SMALLINT);
216
216
select column_name, NUMERIC_PRECISION, NUMERIC_SCALE
217
217
from information_schema.columns
219
219
column_name     NUMERIC_PRECISION       NUMERIC_SCALE
220
220
f1      3       0
221
221
f2      5       0
222
 
f3      7       0
 
222
f3      19      0
223
223
f4      10      0
224
224
f5      19      0
225
225
f6      3       0