← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/max_allowed_packet_func.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/max_allowed_packet_func.result
 
1
SET @start_max_allowed_packet= @@global.max_allowed_packet;
 
2
SET @start_value= @@global.net_buffer_length;
 
3
drop table if exists t1;
 
4
## Creating new table t1 ##
 
5
CREATE TABLE t1
 
6
(
 
7
id INT NOT NULL auto_increment,
 
8
PRIMARY KEY (id),
 
9
name BLOB
 
10
);
 
11
'#--------------------FN_DYNVARS_070_01-------------------------#'
 
12
## Setting value of max_allowed packet and net_buffer_length to 1024 ## 
 
13
SET @@session.max_allowed_packet = 1024;
 
14
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
 
15
SELECT @@session.max_allowed_packet;
 
16
@@session.max_allowed_packet
 
17
1048576
 
18
SET @@session.net_buffer_length = 1024;
 
19
ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
 
20
SELECT @@session.net_buffer_length;
 
21
@@session.net_buffer_length
 
22
16384
 
23
'#--------------------FN_DYNVARS_070_02-------------------------#'
 
24
## Setting value of max_allowed packet and net_buffer_length to 1024 ##
 
25
SET @@global.max_allowed_packet = 1024;
 
26
Warnings:
 
27
Warning 1708    The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
 
28
SET @@global.net_buffer_length = 1024;
 
29
SELECT @@global.max_allowed_packet;
 
30
@@global.max_allowed_packet
 
31
1024
 
32
SELECT @@global.net_buffer_length;
 
33
@@global.net_buffer_length
 
34
1024
 
35
## Creating new connection test_con1 ##
 
36
## Inserting and fetching data of length greater than 1024 ##
 
37
INSERT into t1(name) values("aaassssssssddddddddffffffgggggggg, askdlfjalsdkjfalksdjflaksdjfalkjdflaksjdflakjdflajsflajflajdfalsjfdlajfladjslfajdflajdsflajsflakjsdfla;kjflsdjkf;aljfa;lkdsfjla;sjlkajffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllakjsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa;;;;;;;;;;;;;;;;;;;;;;;;;;;dsklfjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjkljffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdkskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
 
38
drop table t1;
 
39
SET @@global.max_allowed_packet= @start_max_allowed_packet;
 
40
SET @@global.net_buffer_length= @start_value;