~vkolesnikov/pbxt/pbxt-preload-test-bug

bug2564_4 REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI CREATE DEFINER="root"@"localhost" FUNCTION "bug2564_4"(x int, y int) RETURNS int(11)

2323

return x || y

2327

return x || y latin1 latin1_swedish_ci latin1_swedish_ci

2324

2328

drop procedure bug2564_1|

2325

2329

drop procedure bug2564_2|

2326

2330

drop function bug2564_3|

3996

4000

return 42;

3997

4001

end */;;

3998

4002

show create function bug14723;;

3999

Function sql_mode Create Function

4003

Function sql_mode Create Function character_set_client collation_connection Database Collation

4000

4004

bug14723 CREATE DEFINER=`root`@`localhost` FUNCTION `bug14723`() RETURNS bigint(20)

4001

4005

main_loop: begin

4002

4006

return 42;

4003

end

4007

end latin1 latin1_swedish_ci latin1_swedish_ci

4004

4008

select bug14723();;

4005

4009

bug14723()

4006

4010

4009

4013

select 42;

4010

4014

end */;;

4011

4015

show create procedure bug14723;;

4012

Procedure sql_mode Create Procedure

4016

Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation

4013

4017

bug14723 CREATE DEFINER=`root`@`localhost` PROCEDURE `bug14723`()

4014

4018

main_loop: begin

4015

4019

select 42;

4016

end

4020

end latin1 latin1_swedish_ci latin1_swedish_ci

4017

4021

call bug14723();;

4018

4022

4019

4023

4402

4406

Table Op Msg_type Msg_text

4403

4407

test.t1 repair status OK

4404

4408

Table Op Msg_type Msg_text

4409

test.t1 backup Warning The syntax 'BACKUP TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead

4405

4410

test.t1 backup status OK

4406

4411

Table Op Msg_type Msg_text

4412

test.t1 restore Warning The syntax 'RESTORE TABLE' is deprecated and will be removed in MySQL 5.2. Please use MySQL Administrator (mysqldump, mysql) instead

4407

4413

test.t1 restore status OK

4408

4414

drop procedure bug13012|

4409

4415

create view v1 as select * from t1|

4418

4424

test.t1 repair status OK

4419

4425

test.t2 repair status OK

4420

4426

test.t3 repair status OK

4421

test.v1 repair error 'test.v1' is not BASE TABLE

4422

Table Op Msg_type Msg_text

4423

test.t1 optimize status OK

4424

test.t2 optimize status OK

4425

test.t3 optimize status OK

4426

test.v1 optimize error 'test.v1' is not BASE TABLE

4427

Table Op Msg_type Msg_text

4428

test.t1 analyze status Table is already up to date

4429

test.t2 analyze status OK

4430

test.t3 analyze status OK

4431

test.v1 analyze error 'test.v1' is not BASE TABLE

4432

Warnings:

4433

Error 1347 'test.v1' is not BASE TABLE

4434

Error 1347 'test.v1' is not BASE TABLE

4435

Error 1347 'test.v1' is not BASE TABLE

4436

call bug13012()|

4437

Table Op Msg_type Msg_text

4438

test.t1 repair status OK

4439

test.t2 repair status OK

4440

test.t3 repair status OK

4441

test.v1 repair error 'test.v1' is not BASE TABLE

4442

Table Op Msg_type Msg_text

4443

test.t1 optimize status OK

4444

test.t2 optimize status OK

4445

test.t3 optimize status OK

4446

test.v1 optimize error 'test.v1' is not BASE TABLE

4447

Table Op Msg_type Msg_text

4448

test.t1 analyze status Table is already up to date

4449

test.t2 analyze status OK

4450

test.t3 analyze status OK

4451

test.v1 analyze error 'test.v1' is not BASE TABLE

4452

Warnings:

4453

Error 1347 'test.v1' is not BASE TABLE

4454

Error 1347 'test.v1' is not BASE TABLE

4455

Error 1347 'test.v1' is not BASE TABLE

4456

call bug13012()|

4457

Table Op Msg_type Msg_text

4458

test.t1 repair status OK

4459

test.t2 repair status OK

4460

test.t3 repair status OK

4461

test.v1 repair error 'test.v1' is not BASE TABLE

4462

Table Op Msg_type Msg_text

4463

test.t1 optimize status OK

4464

test.t2 optimize status OK

4465

test.t3 optimize status OK

4466

test.v1 optimize error 'test.v1' is not BASE TABLE

4467

Table Op Msg_type Msg_text

4468

test.t1 analyze status Table is already up to date

4469

test.t2 analyze status OK

4470

test.t3 analyze status OK

4471

test.v1 analyze error 'test.v1' is not BASE TABLE

4472

Warnings:

4473

Error 1347 'test.v1' is not BASE TABLE

4474

Error 1347 'test.v1' is not BASE TABLE

4475

Error 1347 'test.v1' is not BASE TABLE

4427

test.v1 repair Error 'test.v1' is not BASE TABLE

4428

test.v1 repair error Corrupt

4429

Table Op Msg_type Msg_text

4430

test.t1 optimize status OK

4431

test.t2 optimize status OK

4432

test.t3 optimize status OK

4433

test.v1 optimize Error 'test.v1' is not BASE TABLE

4434

test.v1 optimize error Corrupt

4435

Table Op Msg_type Msg_text

4436

test.t1 analyze status Table is already up to date

4437

test.t2 analyze status OK

4438

test.t3 analyze status OK

4439

test.v1 analyze Error 'test.v1' is not BASE TABLE

4440

test.v1 analyze error Corrupt

4441

call bug13012()|

4442

Table Op Msg_type Msg_text

4443

test.t1 repair status OK

4444

test.t2 repair status OK

4445

test.t3 repair status OK

4446

test.v1 repair Error 'test.v1' is not BASE TABLE

4447

test.v1 repair error Corrupt

4448

Table Op Msg_type Msg_text

4449

test.t1 optimize status OK

4450

test.t2 optimize status OK

4451

test.t3 optimize status OK

4452

test.v1 optimize Error 'test.v1' is not BASE TABLE

4453

test.v1 optimize error Corrupt

4454

Table Op Msg_type Msg_text

4455

test.t1 analyze status Table is already up to date

4456

test.t2 analyze status OK

4457

test.t3 analyze status OK

4458

test.v1 analyze Error 'test.v1' is not BASE TABLE

4459

test.v1 analyze error Corrupt

4460

call bug13012()|

4461

Table Op Msg_type Msg_text

4462

test.t1 repair status OK

4463

test.t2 repair status OK

4464

test.t3 repair status OK

4465

test.v1 repair Error 'test.v1' is not BASE TABLE

4466

test.v1 repair error Corrupt

4467

Table Op Msg_type Msg_text

4468

test.t1 optimize status OK

4469

test.t2 optimize status OK

4470

test.t3 optimize status OK

4471

test.v1 optimize Error 'test.v1' is not BASE TABLE

4472

test.v1 optimize error Corrupt

4473

Table Op Msg_type Msg_text

4474

test.t1 analyze status Table is already up to date

4475

test.t2 analyze status OK

4476

test.t3 analyze status OK

4477

test.v1 analyze Error 'test.v1' is not BASE TABLE

4478

test.v1 analyze error Corrupt

4476

4479

drop procedure bug13012|

4477

4480

drop view v1|

4478

4481

select * from t1 order by data|

4704

4707

create procedure bug15011()

4705

4708

deterministic

4706

4709

begin

4707

declare continue handler for 1582

4710

declare continue handler for 1062

4708

4711

select 'Outer' as 'Handler';

4709

4712

begin

4710

declare continue handler for 1582

4713

declare continue handler for 1062

4711

4714

select 'Inner' as 'Handler';

4712

4715

insert into t3 values (1);

4713

4716

end;

4923

4926

show create table t3|

4924

4927

Table Create Table

4925

4928

t3 CREATE TABLE `t3` (

4926

`j` int(11) DEFAULT NULL

4929

`j` bigint(11) DEFAULT NULL

4927

4930

) ENGINE=PBXT DEFAULT CHARSET=latin1

4928

4931

select * from t3|

4929

4932

5085

5088

CREATE FUNCTION mysqltest2.bug16211_f4() RETURNS CHAR(10) CHARSET koi8r

5086

5089

RETURN ""|

5087

5090

SHOW CREATE FUNCTION bug16211_f1|

5088

Function sql_mode Create Function

5091

Function sql_mode Create Function character_set_client collation_connection Database Collation

5089

5092

bug16211_f1 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f1`() RETURNS char(10) CHARSET utf8

5090

RETURN ""

5093

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5091

5094

SHOW CREATE FUNCTION bug16211_f2|

5092

Function sql_mode Create Function

5095

Function sql_mode Create Function character_set_client collation_connection Database Collation

5093

5096

bug16211_f2 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f2`() RETURNS char(10) CHARSET koi8r

5094

RETURN ""

5097

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5095

5098

SHOW CREATE FUNCTION mysqltest2.bug16211_f3|

5096

Function sql_mode Create Function

5099

Function sql_mode Create Function character_set_client collation_connection Database Collation

5097

5100

bug16211_f3 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f3`() RETURNS char(10) CHARSET utf8

5098

RETURN ""

5101

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5099

5102

SHOW CREATE FUNCTION mysqltest2.bug16211_f4|

5100

Function sql_mode Create Function

5103

Function sql_mode Create Function character_set_client collation_connection Database Collation

5101

5104

bug16211_f4 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f4`() RETURNS char(10) CHARSET koi8r

5102

RETURN ""

5105

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5103

5106

SELECT dtd_identifier

5104

5107

FROM INFORMATION_SCHEMA.ROUTINES

5105

5108

WHERE ROUTINE_SCHEMA = "mysqltest1" AND ROUTINE_NAME = "bug16211_f1"|

5135

5138

ALTER DATABASE mysqltest1 CHARACTER SET cp1251|

5136

5139

ALTER DATABASE mysqltest2 CHARACTER SET cp1251|

5137

5140

SHOW CREATE FUNCTION bug16211_f1|

5138

Function sql_mode Create Function

5141

Function sql_mode Create Function character_set_client collation_connection Database Collation

5139

5142

bug16211_f1 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f1`() RETURNS char(10) CHARSET utf8

5140

RETURN ""

5143

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5141

5144

SHOW CREATE FUNCTION bug16211_f2|

5142

Function sql_mode Create Function

5145

Function sql_mode Create Function character_set_client collation_connection Database Collation

5143

5146

bug16211_f2 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f2`() RETURNS char(10) CHARSET koi8r

5144

RETURN ""

5147

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5145

5148

SHOW CREATE FUNCTION mysqltest2.bug16211_f3|

5146

Function sql_mode Create Function

5149

Function sql_mode Create Function character_set_client collation_connection Database Collation

5147

5150

bug16211_f3 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f3`() RETURNS char(10) CHARSET utf8

5148

RETURN ""

5151

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5149

5152

SHOW CREATE FUNCTION mysqltest2.bug16211_f4|

5150

Function sql_mode Create Function

5153

Function sql_mode Create Function character_set_client collation_connection Database Collation

5151

5154

bug16211_f4 CREATE DEFINER=`root`@`localhost` FUNCTION `bug16211_f4`() RETURNS char(10) CHARSET koi8r

5152

RETURN ""

5155

RETURN "" latin1 latin1_swedish_ci utf8_general_ci

5153

5156

SELECT dtd_identifier

5154

5157

FROM INFORMATION_SCHEMA.ROUTINES

5155

5158

WHERE ROUTINE_SCHEMA = "mysqltest1" AND ROUTINE_NAME = "bug16211_f1"|

5394

5397

drop procedure if exists bug21416|

5395

5398

create procedure bug21416() show create procedure bug21416|

5396

5399

call bug21416()|

5397

Procedure sql_mode Create Procedure

5400

Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation

5398

5401

bug21416 CREATE DEFINER=`root`@`localhost` PROCEDURE `bug21416`()

5399

show create procedure bug21416

5402

show create procedure bug21416 latin1 latin1_swedish_ci latin1_swedish_ci

5400

5403

drop procedure bug21416|

5401

5404

DROP PROCEDURE IF EXISTS bug21414|

5402

5405

CREATE PROCEDURE bug21414() SELECT 1|

5409

5412

set names utf8|

5410

5413

drop database if exists това_е_дълго_име_за_база_данни_нали|

5411

5414

create database това_е_дълго_име_за_база_данни_нали|

5412

INSERT INTO mysql.proc VALUES ('това_е_дълго_име_за_база_данни_нали','това_е_процедура_с_доста_дълго_име_нали_и_още_по_дълго','PROCEDURE','това_е_процедура_с_доста_дълго_име_нали_и_още_по_дълго','SQL','CONTAINS_SQL','NO','DEFINER','','','bad_body','root@localhost',now(), now(),'','')|

5415

5413

5416

call това_е_дълго_име_за_база_данни_нали.това_е_процедура_с_доста_дълго_име_нали_и_още_по_дълго()|

5414

ERROR HY000: Failed to load routine това_е_дълго_име_за_база_данни_нали.. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)

5417

ERROR HY000: Failed to load routine това_е_дълго_име_за_база_данни_нали.това_е_процедура_с_доста_дълго_име_нали_и_още_по_дълго. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)

5415

5418

drop database това_е_дълго_име_за_база_данни_нали|

5416

5419

CREATE TABLE t3 (

5417

5420

Member_ID varchar(15) NOT NULL,

5636

5639

create function pi() returns varchar(50)

5637

5640

return "pie, my favorite desert.";

5638

5641

Warnings:

5639

Note 1581 This function 'pi' has the same name as a native function

5642

Note 1582 This function 'pi' has the same name as a native function

5640

5643

SET @save_sql_mode=@@sql_mode;

5641

5644

SET SQL_MODE='IGNORE_SPACE';

5642

5645

select pi(), pi ();

5685

5688

create function `database`() returns varchar(50)

5686

5689

return "Stored function database";

5687

5690

Warnings:

5688

Note 1581 This function 'database' has the same name as a native function

5691

Note 1582 This function 'database' has the same name as a native function

5689

5692

create function `current_user`() returns varchar(50)

5690

5693

return "Stored function current_user";

5691

5694

Warnings:

5692

Note 1581 This function 'current_user' has the same name as a native function

5695

Note 1582 This function 'current_user' has the same name as a native function

5693

5696

create function md5(x varchar(50)) returns varchar(50)

5694

5697

return "Stored function md5";

5695

5698

Warnings:

5696

Note 1581 This function 'md5' has the same name as a native function

5699

Note 1582 This function 'md5' has the same name as a native function

5697

5700

SET SQL_MODE='IGNORE_SPACE';

5698

5701

select database(), database ();

5699

5702

database() database ()

Older »