Debian Codegraph @

mysql-test/suite/sys_vars/r/max_points_in_geometry_basic.result

raw
1 SET @session_start_value = @@session.max_points_in_geometry;
2 SET @global_start_value = @@global.max_points_in_geometry;
3 '#--------------------FN_DYNVARS_001_01------------------------#'
4 SET @@max_points_in_geometry = DEFAULT;
5 SELECT @@max_points_in_geometry = 65536;
6 @@max_points_in_geometry = 65536
7 1
8 '#---------------------FN_DYNVARS_001_02-------------------------#'
9 SET @@global.max_points_in_geometry = 1000;
10 select @@global.max_points_in_geometry = @@session.max_points_in_geometry;
11 @@global.max_points_in_geometry = @@session.max_points_in_geometry
12 0
13 SET @@session.max_points_in_geometry = 1000;
14 select @@global.max_points_in_geometry = @@session.max_points_in_geometry;
15 @@global.max_points_in_geometry = @@session.max_points_in_geometry
16 1
17 '#--------------------FN_DYNVARS_001_03------------------------#'
18 SET @@max_points_in_geometry = 10;
19 SELECT @@max_points_in_geometry, @@session.max_points_in_geometry,
20 @@max_points_in_geometry=@@session.max_points_in_geometry;
21 @@max_points_in_geometry @@session.max_points_in_geometry @@max_points_in_geometry=@@session.max_points_in_geometry
22 10 10 1
23 SELECT @@max_points_in_geometry, @@global.max_points_in_geometry,
24 @@max_points_in_geometry=@@global.max_points_in_geometry;
25 @@max_points_in_geometry @@global.max_points_in_geometry @@max_points_in_geometry=@@global.max_points_in_geometry
26 10 1000 0
27 '#--------------------FN_DYNVARS_001_04-------------------------#'
28 SET @@max_points_in_geometry = "1";
29 ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry'
30 SET @@max_points_in_geometry = " ";
31 ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry'
32 SET @@max_points_in_geometry = 'abc';
33 ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry'
34 SET @@max_points_in_geometry = NULL;
35 ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry'
36 SET @@max_points_in_geometry = 1;
37 Warnings:
38 Warning 1292 Truncated incorrect max_points_in_geometry value: '1'
39 SELECT @@max_points_in_geometry;
40 @@max_points_in_geometry
41 3
42 SET @@max_points_in_geometry = 67108865;
43 Warnings:
44 Warning 1292 Truncated incorrect max_points_in_geometry value: '67108865'
45 SELECT @@max_points_in_geometry;
46 @@max_points_in_geometry
47 1048576
48 '#----------------------FN_DYNVARS_001_06------------------------#'
49 SELECT @@max_points_in_geometry = VARIABLE_VALUE
50 FROM performance_schema.session_variables
51 WHERE VARIABLE_NAME='max_points_in_geometry';
52 @@max_points_in_geometry = VARIABLE_VALUE
53 1
54 '#---------------------FN_DYNVARS_001_08-------------------------#'
55 SET @@max_points_in_geometry = OFF;
56 ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry'
57 SET @@max_points_in_geometry = ON;
58 ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry'
59 SET @@max_points_in_geometry = TRUE;
60 Warnings:
61 Warning 1292 Truncated incorrect max_points_in_geometry value: '1'
62 SELECT @@max_points_in_geometry;
63 @@max_points_in_geometry
64 3
65 SET @@max_points_in_geometry = FALSE;
66 Warnings:
67 Warning 1292 Truncated incorrect max_points_in_geometry value: '0'
68 SELECT @@max_points_in_geometry;
69 @@max_points_in_geometry
70 3
71 '#---------------------FN_DYNVARS_001_10----------------------#'
72 SET @@max_points_in_geometry = 123456;
73 SELECT @@max_points_in_geometry = @@local.max_points_in_geometry and
74 @@max_points_in_geometry = @@session.max_points_in_geometry;
75 @@max_points_in_geometry = @@local.max_points_in_geometry and
76 @@max_points_in_geometry = @@session.max_points_in_geometry
77 1
78 SET @@max_points_in_geometry = 654321;
79 SELECT @@max_points_in_geometry = @@local.max_points_in_geometry and
80 @@max_points_in_geometry = @@session.max_points_in_geometry;
81 @@max_points_in_geometry = @@local.max_points_in_geometry and
82 @@max_points_in_geometry = @@session.max_points_in_geometry
83 1
84 '#---------------------FN_DYNVARS_001_11----------------------#'
85 SET max_points_in_geometry = 100;
86 SELECT @@max_points_in_geometry=100;
87 @@max_points_in_geometry=100
88 1
89 SELECT local.max_points_in_geometry;
90 ERROR 42S02: Unknown table 'local' in field list
91 SELECT session.max_points_in_geometry;
92 ERROR 42S02: Unknown table 'session' in field list
93 SELECT max_points_in_geometry = @@session.max_points_in_geometry;
94 ERROR 42S22: Unknown column 'max_points_in_geometry' in 'field list'
95 SET @@max_points_in_geometry = @session_start_value;
96 SET @@global.max_points_in_geometry = @global_start_value;