426
426
SET @@SQL_MODE='';
427
427
create function `foo` () returns int return 5;
428
428
show create function `foo`;
429
Function sql_mode Create Function
429
Function sql_mode Create Function character_set_client collation_connection Database Collation
430
430
foo CREATE DEFINER=`root`@`localhost` FUNCTION `foo`() RETURNS int(11)
431
return 5 latin1 latin1_swedish_ci latin1_swedish_ci
432
432
SET @@SQL_MODE='ANSI_QUOTES';
433
433
show create function `foo`;
434
Function sql_mode Create Function
434
Function sql_mode Create Function character_set_client collation_connection Database Collation
435
435
foo CREATE DEFINER=`root`@`localhost` FUNCTION `foo`() RETURNS int(11)
436
return 5 latin1 latin1_swedish_ci latin1_swedish_ci
437
437
drop function `foo`;
438
438
create function `foo` () returns int return 5;
439
439
show create function `foo`;
440
Function sql_mode Create Function
440
Function sql_mode Create Function character_set_client collation_connection Database Collation
441
441
foo ANSI_QUOTES CREATE DEFINER="root"@"localhost" FUNCTION "foo"() RETURNS int(11)
442
return 5 latin1 latin1_swedish_ci latin1_swedish_ci
443
443
SET @@SQL_MODE='';
444
444
show create function `foo`;
445
Function sql_mode Create Function
445
Function sql_mode Create Function character_set_client collation_connection Database Collation
446
446
foo ANSI_QUOTES CREATE DEFINER="root"@"localhost" FUNCTION "foo"() RETURNS int(11)
447
return 5 latin1 latin1_swedish_ci latin1_swedish_ci
448
448
drop function `foo`;
449
449
SET @@SQL_MODE='';
450
450
create table t1 (a int);
451
451
create table t2 (a int);
452
452
create view v1 as select a from t1;
453
453
show create view v1;
455
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1`
454
View Create View character_set_client collation_connection
455
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` latin1 latin1_swedish_ci
456
456
SET @@SQL_MODE='ANSI_QUOTES';
457
457
show create view v1;
459
v1 CREATE ALGORITHM=UNDEFINED DEFINER="root"@"localhost" SQL SECURITY DEFINER VIEW "v1" AS select "t1"."a" AS "a" from "t1"
458
View Create View character_set_client collation_connection
459
v1 CREATE ALGORITHM=UNDEFINED DEFINER="root"@"localhost" SQL SECURITY DEFINER VIEW "v1" AS select "t1"."a" AS "a" from "t1" latin1 latin1_swedish_ci
460
460
create view v2 as select a from t2 where a in (select a from v1);
461
461
drop view v2, v1;
462
462
drop table t1, t2;
477
477
REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_TABLE_OPTIONS,ANSI
478
478
set sql_mode=2147483648;
479
ERROR 42000: Variable 'sql_mode' can't be set to the value of '2147483648'
480
479
select @@sql_mode;
482
REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_TABLE_OPTIONS,ANSI
481
PAD_CHAR_TO_FULL_LENGTH
483
482
SET @@SQL_MODE=@OLD_SQL_MODE;