~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/warnings.test

  • Committer: Brian Aker
  • Date: 2008-10-02 19:18:43 UTC
  • mto: (438.4.1 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 435.
  • Revision ID: brian@tangent.org-20081002191843-tw3nnufik8qwf9rz
Removed UNSIGNED from parser.

Show diffs side-by-side

added added

removed removed

Lines of Context:
61
61
# Warnings from basic INSERT, UPDATE and ALTER commands
62
62
#
63
63
 
64
 
create table t1(a int NOT NULL, b int unsigned, c char(5));
 
64
create table t1(a int NOT NULL, b int, c char(5));
65
65
insert into t1 values(NULL,100,'mysql'),(10,-1,'mysql ab'),(500,256,'open source'),(20,NULL,'test');
66
66
alter table t1 modify c char(4);
67
67
alter table t1 add d char(2);
176
176
delimiter //;
177
177
CREATE PROCEDURE sp1()
178
178
BEGIN
179
 
declare x numeric unsigned zerofill;
 
179
declare x numeric zerofill;
180
180
SELECT f1 into x from t2 limit 1;
181
181
END//
182
182
delimiter ;//