storedproc_master.inc

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· INC 代码 · 共 2,828 行 · 第 1/5 页

--error 1064
CREATE PROCEDURE undo()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE union()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE unique()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE unlock()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE unsigned()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE update()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE usage()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE use()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE using()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE utc_date()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE utc_time()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE utc_timestamp()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE values()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE varbinary()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE varchar()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE varcharacter()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE varying()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE when()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE where()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE while()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE with()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE write()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE xor()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE year_month()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE zerofill()
   SELECT * from t1 where f2=f1;


# ------------------------------------------------------------------------------
let $message= Testcase 4.1.15:
              ----------------
Ensure that any invalid function name is never accepted, and that an appropriate
error message is returned when the name is rejected;
--source include/show_msg80.inc


--error 1064
CREATE FUNCTION !_fn1(f1 char) returns char
    return f1;

--error 1064
CREATE FUNCTION char(f1 char) returns char
    return f1;

--error 1064
CREATE FUNCTION char binary(f1 char binary) returns char binary
    return f1;
--error 1064
CREATE FUNCTION char ascii(f1 char ascii) returns char ascii
    return f1;

--error 1064
CREATE FUNCTION char not null(f1 char not null) returns char not null
    return f1;

--error 1064
CREATE FUNCTION char binary not null(f1 char binary not null) returns char binary not null
    return f1;

--error 1064
CREATE FUNCTION char ascii not null(f1 char ascii not null) returns char ascii not null
    return f1;

--error 1064
CREATE FUNCTION tinytext(f1 tinytext) returns tinytext
    return f1;

#FIXME check this is OK:--error 1064
CREATE FUNCTION text(f1 text) returns text
    return f1;
  DROP FUNCTION text;

--error 1064
CREATE FUNCTION mediumtext(f1 mediumtext) returns mediumtext
    return f1;

--error 1064
CREATE FUNCTION longtext(f1 longtext) returns longtext
    return f1;

--error 1064
CREATE FUNCTION tinytext not null(f1 tinytext not null) returns tinytext not null
    return f1;

--error 1064
CREATE FUNCTION text not null(f1 text not null) returns text not null
    return f1;

--error 1064
CREATE FUNCTION mediumtext not null(f1 mediumtext not null) returns mediumtext not null
    return f1;

--error 1064
CREATE FUNCTION longtext not null(f1 longtext not null) returns longtext not null
    return f1;

--error 1064
CREATE FUNCTION tinyblob(f1 tinyblob) returns tinyblob
    return f1;

--error 1064
CREATE FUNCTION blob(f1 blob) returns blob
    return f1;

--error 1064
CREATE FUNCTION mediumblob(f1 mediumblob) returns mediumblob
    return f1;

--error 1064
CREATE FUNCTION longblob(f1 longblob) returns longblob
    return f1;

--error 1064
CREATE FUNCTION tinyblob not null(f1 tinyblob not null) returns tinyblob not null
    return f1;

--error 1064
CREATE FUNCTION blob not null(f1 blob not null) returns blob not null
    return f1;

--error 1064
CREATE FUNCTION mediumblob not null(f1 mediumblob not null) returns mediumblob not null
    return f1;

--error 1064
CREATE FUNCTION longblob not null(f1 longblob not null) returns longblob not null
    return f1;

--error 1064
CREATE FUNCTION binary(f1 binary) returns binary
    return f1;

--error 1064
CREATE FUNCTION binary not null(f1 binary not null) returns binary not null
    return f1;

--error 1064
CREATE FUNCTION tinyint(f1 tinyint) returns tinyint
    return f1;

--error 1064
CREATE FUNCTION tinyint unsigned(f1 tinyint unsigned) returns tinyint unsigned
    return f1;

--error 1064
CREATE FUNCTION tinyint zerofill(f1 tinyint zerofill) returns tinyint zerofill
    return f1;

--error 1064
CREATE FUNCTION tinyint unsigned zerofill(f1 tinyint unsigned zerofill) returns tinyint unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION smallint(f1 smallint) returns smallint
    return f1;

--error 1064
CREATE FUNCTION smallint unsigned(f1 smallint unsigned) returns smallint unsigned
    return f1;

--error 1064
CREATE FUNCTION smallint zerofill(f1 smallint zerofill) returns smallint zerofill
    return f1;

--error 1064
CREATE FUNCTION smallint unsigned zerofill(f1 smallint unsigned zerofill) returns smallint unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION mediumint(f1 mediumint) returns mediumint
    return f1;

--error 1064
CREATE FUNCTION mediumint unsigned(f1 mediumint unsigned) returns mediumint unsigned
    return f1;

--error 1064
CREATE FUNCTION mediumint zerofill(f1 mediumint zerofill) returns mediumint zerofill
    return f1;

--error 1064
CREATE FUNCTION mediumint unsigned zerofill(f1 mediumint unsigned zerofill) returns mediumint unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION int(f1 int) returns int
    return f1;

--error 1064
CREATE FUNCTION int unsigned(f1 int unsigned) returns int unsigned
    return f1;

--error 1064
CREATE FUNCTION int zerofill(f1 int zerofill) returns int zerofill
    return f1;

--error 1064
CREATE FUNCTION int unsigned zerofill(f1 int unsigned zerofill) returns int unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION bigint(f1 bigint) returns bigint
    return f1;

--error 1064
CREATE FUNCTION bigint unsigned(f1 bigint unsigned) returns bigint unsigned
    return f1;

--error 1064
CREATE FUNCTION bigint zerofill(f1 bigint zerofill) returns bigint zerofill
    return f1;

--error 1064
CREATE FUNCTION bigint unsigned zerofill(f1 bigint unsigned zerofill) returns bigint unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION decimal(f1 decimal) returns decimal
    return f1;

--error 1064
CREATE FUNCTION decimal unsigned(f1 decimal unsigned) returns decimal unsigned
    return f1;

--error 1064
CREATE FUNCTION decimal zerofill(f1 decimal zerofill) returns decimal zerofill
    return f1;

--error 1064
CREATE FUNCTION decimal unsigned zerofill(f1 decimal unsigned zerofill) returns decimal unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION numeric(f1 numeric) returns numeric
    return f1;

--error 1064
CREATE FUNCTION numeric unsigned(f1 numeric unsigned) returns numeric unsigned
    return f1;

--error 1064
CREATE FUNCTION numeric zerofill(f1 numeric zerofill) returns numeric zerofill
    return f1;

--error 1064
CREATE FUNCTION numeric unsigned zerofill(f1 numeric unsigned zerofill) returns numeric unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION real(f1 real) returns real
    return f1;

--error 1064
CREATE FUNCTION real unsigned(f1 real unsigned) returns real unsigned
    return f1;

--error 1064
CREATE FUNCTION real zerofill(f1 real zerofill) returns real zerofill
    return f1;

--error 1064
CREATE FUNCTION real unsigned zerofill(f1 real unsigned zerofill) returns real unsigned zerofill
    return f1;

--error 1064
CREATE FUNCTION float(f1 float) returns float
    return f1;

--error 1064
CREATE FUNCTION float unsigned(f1 float unsigned) returns float unsigned
    return f1;

--error 1064
CREATE FUNCTION float zerofill(f1 float zerofill) returns float zerofill
    return f1;

--error 1064
CREATE FUNCTION float unsigned zerofill(f1 float unsigned zerofill) returns float unsigned zerofill
    return f1;

#FIXME check this is OK:--error 1064
CREATE FUNCTION date(f1 date) returns date
    return f1;
DROP FUNCTION date;

#FIXME check this is OK:--error 1064
CREATE FUNCTION time(f1 time) returns time
    return f1;
DROP FUNCTION time;

#FIXME check this is OK:--error 1064
CREATE FUNCTION datetime(f1 datetime) returns datetime
    return f1;
DROP FUNCTION datetime;

#FIXME check this is OK:--error 1064
CREATE FUNCTION timestamp(f1 timestamp) returns timestamp
    return f1;
DROP FUNCTION timestamp;

#FIXME check this is OK:--error 1064
CREATE FUNCTION year(f1 year) returns year
    return f1;
DROP FUNCTION year;

--error 1064
CREATE FUNCTION year(3)(f1 year(3)) returns year(3)
    return f1;

--error 1064
CREATE FUNCTION year(4)(f1 year(4)) returns year(4)
    return f1;

--error 1064
CREATE FUNCTION enum("1enum", "2enum")(f1 enum("1enum", "2enum")) returns enum("1enum", "2enum")
    return f1;

--error 1064
CREATE FUNCTION set("1set", "2set")(f1 set("1set", "2set")) returns set("1set", "2set")
    return f1;


DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(char f1 ) returns char
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(char binary f1 ) returns char binary
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(char ascii f1 ) returns char ascii
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(char not null f1 ) returns char not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(char binary not null f1 ) returns char binary not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(char ascii not null f1 ) returns char ascii not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinytext f1 ) returns tinytext
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(text f1 ) returns text
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(mediumtext f1 ) returns mediumtext
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(longtext f1 ) returns longtext
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinytext not null f1 ) returns tinytext not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(text not null f1 ) returns text not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(mediumtext not null f1 ) returns mediumtext not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(longtext not null f1 ) returns longtext not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinyblob f1 ) returns tinyblob
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(blob f1 ) returns blob
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(mediumblob f1 ) returns mediumblob
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(longblob f1 ) returns longblob
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinyblob not null f1 ) returns tinyblob not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(blob not null f1 ) returns blob not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(mediumblob not null f1 ) returns mediumblob not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(longblob not null f1 ) returns longblob not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(binary f1 ) returns binary
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(binary not null f1 ) returns binary not null
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinyint f1 ) returns tinyint
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinyint unsigned f1 ) returns tinyint unsigned
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinyint zerofill f1 ) returns tinyint zerofill
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(tinyint unsigned zerofill f1 ) returns tinyint unsigned zerofill
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(smallint f1 ) returns smallint
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(smallint unsigned f1 ) returns smallint unsigned
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(smallint zerofill f1 ) returns smallint zerofill
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(smallint unsigned zerofill f1 ) returns smallint unsigned zerofill
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(mediumint f1 ) returns mediumint
    return f1;

DROP FUNCTION IF EXISTS fn1;
--error 1064
CREATE FUNCTION fn1(mediumint unsigned f1 ) returns mediumint unsigned
    return f1;