1SET @session_start_value = @@session.max_points_in_geometry; 2SET @global_start_value = @@global.max_points_in_geometry; 3'#--------------------FN_DYNVARS_001_01------------------------#' 4SET @@max_points_in_geometry = DEFAULT; 5SELECT @@max_points_in_geometry = 65536; 6@@max_points_in_geometry = 65536 71 8'#---------------------FN_DYNVARS_001_02-------------------------#' 9SET @@global.max_points_in_geometry = 1000; 10select @@global.max_points_in_geometry = @@session.max_points_in_geometry; 11@@global.max_points_in_geometry = @@session.max_points_in_geometry 120 13SET @@session.max_points_in_geometry = 1000; 14select @@global.max_points_in_geometry = @@session.max_points_in_geometry; 15@@global.max_points_in_geometry = @@session.max_points_in_geometry 161 17'#--------------------FN_DYNVARS_001_03------------------------#' 18SET @@max_points_in_geometry = 10; 19SELECT @@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 2210 10 1 23SELECT @@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 2610 1000 0 27'#--------------------FN_DYNVARS_001_04-------------------------#' 28SET @@max_points_in_geometry = "1"; 29ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry' 30SET @@max_points_in_geometry = " "; 31ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry' 32SET @@max_points_in_geometry = 'abc'; 33ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry' 34SET @@max_points_in_geometry = NULL; 35ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry' 36SET @@max_points_in_geometry = 1; 37Warnings: 38Warning 1292 Truncated incorrect max_points_in_geometry value: '1' 39SELECT @@max_points_in_geometry; 40@@max_points_in_geometry 413 42SET @@max_points_in_geometry = 67108865; 43Warnings: 44Warning 1292 Truncated incorrect max_points_in_geometry value: '67108865' 45SELECT @@max_points_in_geometry; 46@@max_points_in_geometry 471048576 48'#----------------------FN_DYNVARS_001_06------------------------#' 49SELECT @@max_points_in_geometry = VARIABLE_VALUE 50FROM INFORMATION_SCHEMA.SESSION_VARIABLES 51WHERE VARIABLE_NAME='max_points_in_geometry'; 52@@max_points_in_geometry = VARIABLE_VALUE 531 54'#---------------------FN_DYNVARS_001_08-------------------------#' 55SET @@max_points_in_geometry = OFF; 56ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry' 57SET @@max_points_in_geometry = ON; 58ERROR 42000: Incorrect argument type to variable 'max_points_in_geometry' 59SET @@max_points_in_geometry = TRUE; 60Warnings: 61Warning 1292 Truncated incorrect max_points_in_geometry value: '1' 62SELECT @@max_points_in_geometry; 63@@max_points_in_geometry 643 65SET @@max_points_in_geometry = FALSE; 66Warnings: 67Warning 1292 Truncated incorrect max_points_in_geometry value: '0' 68SELECT @@max_points_in_geometry; 69@@max_points_in_geometry 703 71'#---------------------FN_DYNVARS_001_10----------------------#' 72SET @@max_points_in_geometry = 123456; 73SELECT @@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 771 78SET @@max_points_in_geometry = 654321; 79SELECT @@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 831 84'#---------------------FN_DYNVARS_001_11----------------------#' 85SET max_points_in_geometry = 100; 86SELECT @@max_points_in_geometry=100; 87@@max_points_in_geometry=100 881 89SELECT local.max_points_in_geometry; 90ERROR 42S02: Unknown table 'local' in field list 91SELECT session.max_points_in_geometry; 92ERROR 42S02: Unknown table 'session' in field list 93SELECT max_points_in_geometry = @@session.max_points_in_geometry; 94ERROR 42S22: Unknown column 'max_points_in_geometry' in 'field list' 95SET @@max_points_in_geometry = @session_start_value; 96SET @@global.max_points_in_geometry = @global_start_value; 97