# ----------------------------------------------------------------------------
# Test for MDEV-
36108 : Variable substitutions in mysqltest
# ----------------------------------------------------------------------------
# ----------------------------------------------------------------------------
# Test absolute value function
# ----------------------------------------------------------------------------
# Basic abs() function tests
abs(
10 ) ->
10 ;
abs(-
10 ) ->
10 ;
abs(
0 ) ->
0 ;
abs(
123456789 ) ->
123456789 ;
abs(-
987654321 ) ->
987654321 ;
abs(NULL) ->
;
abs(
5 -
10 ) ->
5 ;
abs(
10 -
5 ) ->
5 ;
abs(-(-
25 )) ->
25 ;
abs(-
2147483648 ) ->
2147483648 ;
abs(
2147483647 ) ->
2147483647 ;
abs(
1 ==
1 ) ->
1 ;
abs(
1 ==
0 ) ->
0 ;
abs(-((
5 * -
3 ) + (
2 -
8 ))) ->
21 ;
abs(((
10 -
25 ) * (
3 +
2 ))) ->
75 ;
abs(((
2 -
6 ) * (-
4 +
1 ))) ->
12 ;
abs((((-
5 *
6 ) +
10 ) - (
8 * -
2 ))) ->
4 ;
abs(((((
3 -
9 ) *
2 ) +
4 ) -
1 )) ->
9 ;
abs(((-
100 +
50 ) * (
2 -
5 ))) ->
150 ;
abs(((-
3 * (
2 +
4 )) + (
18 /
3 ))) ->
12 ;
abs(((((
10 -
5 ) * -
3 ) +
4 ) * -
2 )) ->
22 ;
abs((((-
2 * -
2 ) - (
5 *
3 )) +
20 )) ->
9 ;
# ----------------------------------------------------------------------------
# Test conversion functions (conv, bin, oct, hex)
# ----------------------------------------------------------------------------
# Basic conv() function tests
conv(
10 ,
10 ,
2 ) ->
1010
conv(
255 ,
10 ,
16 ) -> FF
conv(FF,
16 ,
10 ) ->
255
conv(
1010 ,
2 ,
10 ) ->
10
conv(
64 ,
10 ,
8 ) ->
100
conv(
77 ,
8 ,
10 ) ->
63
# ----------------------------------------------------------------------------
# Test shortcut functions bin(), oct(), hex()
# ----------------------------------------------------------------------------
# Testing bin() function
bin(
10 ) ->
1010
bin(
255 ) ->
11111111
bin(
0 ) ->
0
# Testing oct() function
oct(
64 ) ->
100
oct(
512 ) ->
1000
# Testing hex() function
hex(
255 ) -> FF
hex(
4095 ) -> FFF
# ----------------------------------------------------------------------------
# Test extended base support (bases
2 -
62 )
# ----------------------------------------------------------------------------
# Testing extended bases
conv(ZZ,
36 ,
10 ) ->
1295
# ----------------------------------------------------------------------------
# Test signed vs unsigned interpretation
# ----------------------------------------------------------------------------
# Testing signed vs unsigned interpretation
conv(-
1 ,
10 ,
16 ) -> FFFFFFFFFFFFFFFF
conv(-
1 ,
10 , -
16 ) -> -
1
conv(-
10 ,
10 ,
2 ) ->
1111111111111111111111111111111111111111111111111111111111110110
conv(-
10 ,
10 , -
2 ) -> -
1010
conv(-
255 ,
10 ,
16 ) -> FFFFFFFFFFFFFF01
conv(-
255 ,
10 , -
16 ) -> -FF
conv(-
1234 , -
10 ,
2 ) ->
1111111111111111111111111111111111111111111111111111101100101110
conv(-
1234 , -
10 , -
2 ) -> -
10011010010
# ----------------------------------------------------------------------------
# Edge cases
and boundary conditions
# ----------------------------------------------------------------------------
# Testing edge cases
and boundaries
conv(
0 ,
10 ,
2 ) ->
0
conv(
0 ,
16 ,
10 ) ->
0
conv(
9223372036854775807 ,
10 ,
16 ) ->
7 FFFFFFFFFFFFFFF
conv(~
0 ,
10 ,
2 ) ->
1111111111111111111111111111111111111111111111111111111111111111
conv(
7 FFFFFFFFFFFFFFF,
16 ,
10 ) ->
9223372036854775807
conv(
777777777777777777777 ,
8 ,
10 ) ->
9223372036854775807
conv(
1111111111111111111111111111111111111111111111111111111111111111 ,
2 ,
10 ) ->
18446744073709551615
conv(
9223372036854775807 ,
10 ,
2 ) ->
111111111111111111111111111111111111111111111111111111111111111
conv(
18446744073709551615 ,
10 ,
16 ) -> FFFFFFFFFFFFFFFF
conv(
18446744073709551615 ,
10 ,
2 ) ->
1111111111111111111111111111111111111111111111111111111111111111
conv(-~
0 ,
10 ,
2 ) ->
1
conv(
0000123 ,
10 ,
16 ) ->
7 B
# ----------------------------------------------------------------------------
# Test
case sensitivity in conversion
# ----------------------------------------------------------------------------
# Testing
case sensitivity
conv(AbCd,
16 ,
10 ) ->
43981
conv(abcd,
16 ,
10 ) ->
43981
conv(ABCD,
16 ,
10 ) ->
43981
# ----------------------------------------------------------------------------
# Test with variables
and expressions
# ----------------------------------------------------------------------------
# Testing with variables
and expressions
conv(FF,
16 ,
10 ) ->
255
# ----------------------------------------------------------------------------
#
Error cases - Invalid bases
# ----------------------------------------------------------------------------
# Testing
error cases - Invalid bases
# Base too small (<
2 )
mysqltest: At line
1 : conv() from_base must be between
2 and 62 , got
1
# Base too large (>
62 for our parser, >
36 for MariaDB)
mysqltest: At line
1 : conv() from_base must be between
2 and 62 , got
63
# Zero base
mysqltest: At line
1 : conv() from_base must be between
2 and 62 , got
0
# ----------------------------------------------------------------------------
#
Error cases - Invalid characters for base
# ----------------------------------------------------------------------------
# Testing
error cases - Invalid characters
# Character
not valid for base
8
mysqltest: At line
1 : invalid number
'189' for base
8
# Character
not valid for base
16
mysqltest: At line
1 : invalid number
'XYZ' for base
16
# Special characters
mysqltest: At line
1 : invalid number
'@#$' for base
36
# ----------------------------------------------------------------------------
#
Error cases - Function argument count
# ----------------------------------------------------------------------------
# Testing
error cases - Wrong argument count
# Too few arguments for conv
mysqltest: At line
1 : conv() expects
3 arguments (N, from_base, to_base), got
2
# Too many arguments for conv
mysqltest: At line
1 : conv() expects
3 arguments (N, from_base, to_base), got
4
# Too many arguments for bin
mysqltest: At line
1 : bin() expects
1 argument, got
2
# No arguments for hex
mysqltest: At line
1 : hex() expects
1 argument, got
0
# ----------------------------------------------------------------------------
# Overflow cases
# ----------------------------------------------------------------------------
# Testing overflow cases
# Number too large for
64 -bit
mysqltest: At line
1 : Range
error :
99999999999999999999999999999999 value out of range for I
nteger type1 : Range error : value out of range for Integer typeREPLACE functionREPLACE function testsreplace ("hello world" , "world" , "mariadb" ) -> "hello mariadb" replace ("hello hello hello" , "hello" , "hi" ) -> "hi hi hi" replace ("test string" , "test" , "" ) -> " string" replace ("no change" , "missing" , "replacement" ) -> "no change" REPLACE with empty stringsREPLACE with empty stringsreplace ("hello world" , "" , "test" ) -> "hello world" replace ("hello world" , "hello" , "" ) -> " world" replace ("" , "test" , "replacement" ) -> "" REPLACE with special charactersREPLACE with special charactersreplace ("a+b=c" , "+" , "-" ) -> "a-b=c" replace ("test\nstring" , "\n" , " " ) -> "test string" replace ("quoted 'string'" , "'" , "" ) -> "quoted string" replace ('quoted "string"' , '"' , "" ) -> "quoted string" REPLACE with variablesREPLACE with variablesreplace ("hello world" , "world" , "mariadb" ) -> "hello mariadb" replace ("test test test" , "test" , "mariadb" ) -> "mariadb mariadb mariadb" REPLACE edge casesREPLACE edge casesreplace ("aaa" , "aa" , "b" ) -> "ba" replace ("aaaa" , "aa" , "b" ) -> "bb" replace ("test" , "test" , "test" ) -> "test" replace ("" , "" , "something" ) -> "" "hello" , -7 , -7 ) -> "" "hello" , -7 , -6 ) -> "" "hello" , -7 , -5 ) -> "" "hello" , -7 , -4 ) -> "" "hello" , -7 , -3 ) -> "" "hello" , -7 , -2 ) -> "" "hello" , -7 , -1 ) -> "" "hello" , -7 , 0 ) -> "" "hello" , -7 , 1 ) -> "" "hello" , -7 , 2 ) -> "" "hello" , -7 , 3 ) -> "" "hello" , -7 , 4 ) -> "" "hello" , -7 , 5 ) -> "" "hello" , -7 , 6 ) -> "" "hello" , -7 , 7 ) -> "" "hello" , -6 , -7 ) -> "" "hello" , -6 , -6 ) -> "" "hello" , -6 , -5 ) -> "" "hello" , -6 , -4 ) -> "" "hello" , -6 , -3 ) -> "" "hello" , -6 , -2 ) -> "" "hello" , -6 , -1 ) -> "" "hello" , -6 , 0 ) -> "" "hello" , -6 , 1 ) -> "" "hello" , -6 , 2 ) -> "" "hello" , -6 , 3 ) -> "" "hello" , -6 , 4 ) -> "" "hello" , -6 , 5 ) -> "" "hello" , -6 , 6 ) -> "" "hello" , -6 , 7 ) -> "" "hello" , -5 , -7 ) -> "" "hello" , -5 , -6 ) -> "" "hello" , -5 , -5 ) -> "" "hello" , -5 , -4 ) -> "" "hello" , -5 , -3 ) -> "" "hello" , -5 , -2 ) -> "" "hello" , -5 , -1 ) -> "" "hello" , -5 , 0 ) -> "" "hello" , -5 , 1 ) -> "h" "hello" , -5 , 2 ) -> "he" "hello" , -5 , 3 ) -> "hel" "hello" , -5 , 4 ) -> "hell" "hello" , -5 , 5 ) -> "hello" "hello" , -5 , 6 ) -> "hello" "hello" , -5 , 7 ) -> "hello" "hello" , -4 , -7 ) -> "" "hello" , -4 , -6 ) -> "" "hello" , -4 , -5 ) -> "" "hello" , -4 , -4 ) -> "" "hello" , -4 , -3 ) -> "" "hello" , -4 , -2 ) -> "" "hello" , -4 , -1 ) -> "" "hello" , -4 , 0 ) -> "" "hello" , -4 , 1 ) -> "e" "hello" , -4 , 2 ) -> "el" "hello" , -4 , 3 ) -> "ell" "hello" , -4 , 4 ) -> "ello" "hello" , -4 , 5 ) -> "ello" "hello" , -4 , 6 ) -> "ello" "hello" , -4 , 7 ) -> "ello" "hello" , -3 , -7 ) -> "" "hello" , -3 , -6 ) -> "" "hello" , -3 , -5 ) -> "" "hello" , -3 , -4 ) -> "" "hello" , -3 , -3 ) -> "" "hello" , -3 , -2 ) -> "" "hello" , -3 , -1 ) -> "" "hello" , -3 , 0 ) -> "" "hello" , -3 , 1 ) -> "l" "hello" , -3 , 2 ) -> "ll" "hello" , -3 , 3 ) -> "llo" "hello" , -3 , 4 ) -> "llo" "hello" , -3 , 5 ) -> "llo" "hello" , -3 , 6 ) -> "llo" "hello" , -3 , 7 ) -> "llo" "hello" , -2 , -7 ) -> "" "hello" , -2 , -6 ) -> "" "hello" , -2 , -5 ) -> "" "hello" , -2 , -4 ) -> "" "hello" , -2 , -3 ) -> "" "hello" , -2 , -2 ) -> "" "hello" , -2 , -1 ) -> "" "hello" , -2 , 0 ) -> "" "hello" , -2 , 1 ) -> "l" "hello" , -2 , 2 ) -> "lo" "hello" , -2 , 3 ) -> "lo" "hello" , -2 , 4 ) -> "lo" "hello" , -2 , 5 ) -> "lo" "hello" , -2 , 6 ) -> "lo" "hello" , -2 , 7 ) -> "lo" "hello" , -1 , -7 ) -> "" "hello" , -1 , -6 ) -> "" "hello" , -1 , -5 ) -> "" "hello" , -1 , -4 ) -> "" "hello" , -1 , -3 ) -> "" "hello" , -1 , -2 ) -> "" "hello" , -1 , -1 ) -> "" "hello" , -1 , 0 ) -> "" "hello" , -1 , 1 ) -> "o" "hello" , -1 , 2 ) -> "o" "hello" , -1 , 3 ) -> "o" "hello" , -1 , 4 ) -> "o" "hello" , -1 , 5 ) -> "o" "hello" , -1 , 6 ) -> "o" "hello" , -1 , 7 ) -> "o" "hello" , 0 , -7 ) -> "" "hello" , 0 , -6 ) -> "" "hello" , 0 , -5 ) -> "" "hello" , 0 , -4 ) -> "" "hello" , 0 , -3 ) -> "" "hello" , 0 , -2 ) -> "" "hello" , 0 , -1 ) -> "" "hello" , 0 , 0 ) -> "" "hello" , 0 , 1 ) -> "" "hello" , 0 , 2 ) -> "" "hello" , 0 , 3 ) -> "" "hello" , 0 , 4 ) -> "" "hello" , 0 , 5 ) -> "" "hello" , 0 , 6 ) -> "" "hello" , 0 , 7 ) -> "" "hello" , 1 , -7 ) -> "" "hello" , 1 , -6 ) -> "" "hello" , 1 , -5 ) -> "" "hello" , 1 , -4 ) -> "" "hello" , 1 , -3 ) -> "" "hello" , 1 , -2 ) -> "" "hello" , 1 , -1 ) -> "" "hello" , 1 , 0 ) -> "" "hello" , 1 , 1 ) -> "h" "hello" , 1 , 2 ) -> "he" "hello" , 1 , 3 ) -> "hel" "hello" , 1 , 4 ) -> "hell" "hello" , 1 , 5 ) -> "hello" "hello" , 1 , 6 ) -> "hello" "hello" , 1 , 7 ) -> "hello" "hello" , 2 , -7 ) -> "" "hello" , 2 , -6 ) -> "" "hello" , 2 , -5 ) -> "" "hello" , 2 , -4 ) -> "" "hello" , 2 , -3 ) -> "" "hello" , 2 , -2 ) -> "" "hello" , 2 , -1 ) -> "" "hello" , 2 , 0 ) -> "" "hello" , 2 , 1 ) -> "e" "hello" , 2 , 2 ) -> "el" "hello" , 2 , 3 ) -> "ell" "hello" , 2 , 4 ) -> "ello" "hello" , 2 , 5 ) -> "ello" "hello" , 2 , 6 ) -> "ello" "hello" , 2 , 7 ) -> "ello" "hello" , 3 , -7 ) -> "" "hello" , 3 , -6 ) -> "" "hello" , 3 , -5 ) -> "" "hello" , 3 , -4 ) -> "" "hello" , 3 , -3 ) -> "" "hello" , 3 , -2 ) -> "" "hello" , 3 , -1 ) -> "" "hello" , 3 , 0 ) -> "" "hello" , 3 , 1 ) -> "l" "hello" , 3 , 2 ) -> "ll" "hello" , 3 , 3 ) -> "llo" "hello" , 3 , 4 ) -> "llo" "hello" , 3 , 5 ) -> "llo" "hello" , 3 , 6 ) -> "llo" "hello" , 3 , 7 ) -> "llo" "hello" , 4 , -7 ) -> "" "hello" , 4 , -6 ) -> "" "hello" , 4 , -5 ) -> "" "hello" , 4 , -4 ) -> "" "hello" , 4 , -3 ) -> "" "hello" , 4 , -2 ) -> "" "hello" , 4 , -1 ) -> "" "hello" , 4 , 0 ) -> "" "hello" , 4 , 1 ) -> "l" "hello" , 4 , 2 ) -> "lo" "hello" , 4 , 3 ) -> "lo" "hello" , 4 , 4 ) -> "lo" "hello" , 4 , 5 ) -> "lo" "hello" , 4 , 6 ) -> "lo" "hello" , 4 , 7 ) -> "lo" "hello" , 5 , -7 ) -> "" "hello" , 5 , -6 ) -> "" "hello" , 5 , -5 ) -> "" "hello" , 5 , -4 ) -> "" "hello" , 5 , -3 ) -> "" "hello" , 5 , -2 ) -> "" "hello" , 5 , -1 ) -> "" "hello" , 5 , 0 ) -> "" "hello" , 5 , 1 ) -> "o" "hello" , 5 , 2 ) -> "o" "hello" , 5 , 3 ) -> "o" "hello" , 5 , 4 ) -> "o" "hello" , 5 , 5 ) -> "o" "hello" , 5 , 6 ) -> "o" "hello" , 5 , 7 ) -> "o" "hello" , 6 , -7 ) -> "" "hello" , 6 , -6 ) -> "" "hello" , 6 , -5 ) -> "" "hello" , 6 , -4 ) -> "" "hello" , 6 , -3 ) -> "" "hello" , 6 , -2 ) -> "" "hello" , 6 , -1 ) -> "" "hello" , 6 , 0 ) -> "" "hello" , 6 , 1 ) -> "" "hello" , 6 , 2 ) -> "" "hello" , 6 , 3 ) -> "" "hello" , 6 , 4 ) -> "" "hello" , 6 , 5 ) -> "" "hello" , 6 , 6 ) -> "" "hello" , 6 , 7 ) -> "" "hello" , 7 , -7 ) -> "" "hello" , 7 , -6 ) -> "" "hello" , 7 , -5 ) -> "" "hello" , 7 , -4 ) -> "" "hello" , 7 , -3 ) -> "" "hello" , 7 , -2 ) -> "" "hello" , 7 , -1 ) -> "" "hello" , 7 , 0 ) -> "" "hello" , 7 , 1 ) -> "" "hello" , 7 , 2 ) -> "" "hello" , 7 , 3 ) -> "" "hello" , 7 , 4 ) -> "" "hello" , 7 , 5 ) -> "" "hello" , 7 , 6 ) -> "" "hello" , 7 , 7 ) -> "" "hello world" , 1 , 5 ) -> "hello" "hello world" , 7 ) -> "world" "hello world" , 1 , 3 ) -> "hel" "hello world" , 7 , 5 ) -> "world" "hello world" , -5 ) -> "world" "hello world" , -5 , 3 ) -> "wor" "hello world" , -10 , 5 ) -> "ello " "hello world" , -20 ) -> "" "hello world" , 1 , 0 ) -> "" "hello world" , 1 , 20 ) -> "hello world" "hello world" , 12 ) -> "" "hello world" , 0 ) -> "" "hello world" , 0 , 5 ) -> "" "hello world" , 7 , 5 ) -> "world" "hello world" , -5 ) -> "world" "" , 1 ) -> "" "a" , 1 , 5 ) -> "a" "hello" , 1 , -1 ) -> "" "hello" , 5 , 1 ) -> "o" replace (substr("hello world" , 1 , 5 ), "hello" , "hi" ) -> "hi" replace ("hello world" , "world" , "mariadb" ), 7 ) -> "mariadb" replace (substr("test test test" , 1 , 9 ), "test" , "check" ) -> "check check" replace ("hello world" , "world" , "mariadb" )) -> "HELLO MARIADB" replace (" hello world " , "world" , "mariadb" ))) -> "13" "HELLO WORLD" ), "world" ) -> 7 "o" ), upper("hello world" )) -> 5 "hello world" ), 1 , 5 )) -> "OLLEH" 1 : h (upper: H, lower: h)2 : e (upper: E, lower: e)3 : l (upper: L, lower: l)4 : l (upper: L, lower: l)5 : o (upper: O, lower: o)"HelloWorld" -> Processed: HeLLoWoRLDError cases for REPLACE functionerror cases for REPLACE function1 : replace () expects 3 arguments (str, from, to), got 1 1 : replace () expects 3 arguments (str, from, to), got 2 1 : replace () expects 3 arguments (str, from, to), got 4 1 : replace () arguments must be strings1 : replace () arguments must be strings1 : replace () arguments must be stringsError cases for SUBSTR functionerror cases for SUBSTR function1 : substr() expects 2 or 3 arguments (str, start [, length]), got 1 1 : substr() expects 2 or 3 arguments (str, start [, length]), got 4 1 : substr() first argument must be a string1 : substr() start position must be numeric1 : substr() length must be numeric"hello world" , "world" ) -> 7 "hello world" , "hello" ) -> 1 "hello world" , "o" ) -> 5 "hello world" , "xyz" ) -> 0 "hello world" , "" ) -> 1 "hello" , "h" ) -> 1 "hello" , "e" ) -> 2 "hello" , "l" ) -> 3 "hello" , "o" ) -> 5 "hello" , "x" ) -> 0 "hello" , "l" ) -> 3 "hello hello" , "hello" ) -> 1 "aaa" , "aa" ) -> 1 "" , "hello" ) -> 0 "hello" , "" ) -> 1 "" , "" ) -> 1 "a+b=c" , "+" ) -> 2 "test\nstring" , "\n" ) -> 5 "quoted 'string'" , "'" ) -> 8 'quoted "string"' , '"' ) -> 8 "test@example.com" , "@" ) -> 5 "hello world" , "world" ) -> 7 "hello world" , "o" ) -> 5 "hello" , "hello" ) -> 1 "hello" , "hellox" ) -> 0 "hello" , "h" ) -> 1 "hello" , "o" ) -> 5 "a" , "a" ) -> 1 case sensitivitycase sensitivity"Hello World" , "hello" ) -> 1 "Hello World" , "HELLO" ) -> 1 "hello world" , " " ) -> 6 " hello " , "hello" ) -> 3 "hello world" , " " ) -> 6 "hello\tworld" , "\t" ) -> 6 "hello world" , substr("world test" , 1 , 5 )) -> 7 replace ("hello world" , "world" , "mariadb" ), "mariadb" ) -> 7 "hello world" , "world" ) + 5 -> 12 "hello world" , "hello" ) * 2 -> 2 "hello world" , "hello" ) > 0 && instr("hello world" , "world" ) > 0 -> 1 "hello world" , "hello" ) > 0 || instr("hello world" , "xyz" ) > 0 -> 1 "hello world" , substr("world test" , 1 , 5 )) -> 7 replace ("hello world" , "world" , "mariadb" ), "mariadb" ) -> 7 error caseserror cases for INSTR function1 : instr() expects 2 arguments (str, substr), got 1 't produce any output 't produce any output 't produce any output 'world' , 'hello world' ) -> 7 'o' , 'hello world' ) -> 5 'o' , 'hello world' , 6 ) -> 8 'xyz' , 'hello world' ) -> 0 '' , 'hello world' ) -> 1 'hello' , '' ) -> 0 '' , '' ) -> 1 'l' , 'hello world' , 1 ) -> 3 'l' , 'hello world' , 4 ) -> 4 'l' , 'hello world' , 10 ) -> 10 '' , 'hello world' ) -> 1 'hello' , '' ) -> 0 '' , '' ) -> 1 '+' , 'a+b=c' ) -> 2 '@' , 'test@example.com' ) -> 5 '.' , 'file.txt' ) -> 5 "world" , "hello world" ) -> 7 'o' , "hello world" , 6 ) -> 8 'hello' , 'hello world' ) -> 1 'world' , 'hello world' ) -> 7 'xyz' , 'hello world' ) -> 0 'o' , 'hello world' , 1 ) -> 5 'o' , 'hello world' , 20 ) -> 0 Error cases for LOCATE functionerror cases for LOCATE function1 : locate() expects 2 or 3 arguments (substr, str [, start]), got 1 1 : locate() expects 2 or 3 arguments (substr, str [, start]), got 4 't produce any output 't produce any output 1 : locate() start position must be numeric'HELLO WORLD' ) -> hello world'Hello World' ) -> hello world'hello world' ) -> hello world'ABC123' ) -> abc123'' ) -> 'MIXED Case 123' ) -> mixed case 123 'SPECIAL@#$%' ) -> special@#$%'' ) -> 'TEST@EXAMPLE.COM' ) -> test@example.com'FILE.TXT' ) -> file.txt'HELLO-WORLD_123' ) -> hello-world_123"HELLO WORLD" ) -> hello world'A' ) -> a'a' ) -> a'123' ) -> 123 'MiXeD cAsE' ) -> mixed case 'hello world' ) -> HELLO WORLD'Hello World' ) -> HELLO WORLD'HELLO WORLD' ) -> HELLO WORLD'abc123' ) -> ABC123'' ) -> 'mixed case 123' ) -> MIXED CASE 123 'special@#$%' ) -> SPECIAL@#$%'' ) -> 'test@example.com' ) -> TEST@EXAMPLE.COM'file.txt' ) -> FILE.TXT'hello-world_123' ) -> HELLO-WORLD_123"hello world" ) -> HELLO WORLD'a' ) -> A'A' ) -> A'123' ) -> 123 'MiXeD cAsE' ) -> MIXED CASE 'hello' ) -> olleh'hello world' ) -> dlrow olleh'12345' ) -> 54321 '' ) -> 'a' ) -> a'ab' ) -> ba'ABC123' ) -> 321 CBA' hello world ' ) -> hello world'hello world' ) -> hello world' ' ) -> '' ) -> ' hello' ) -> hello'hello ' ) -> hello' hello world ' ) -> hello world' hello world' ) -> hello world'hello world' ) -> hello world' ' ) -> '' ) -> ' hello world' ) -> hello world'hello world' ) -> hello world' hello' ) -> hello'hello world ' ) -> hello world'hello world' ) -> hello world' ' ) -> '' ) -> ' hello world ' ) -> hello world'hello world' ) -> hello world'hello ' ) -> hello'hello' , 10 , '*' ) -> *****hello'hello' , 5 , '*' ) -> hello'hello' , 3 , '*' ) -> hel'hello' , 10 , ' ' ) -> hello'' , 5 , '*' ) -> *****'hello' , 10 , 'ab' ) -> ababahello'hello' , 0 , '*' ) -> 'hello' , 10 , '*' ) -> hello*****'hello' , 5 , '*' ) -> hello'hello' , 3 , '*' ) -> hel'hello' , 10 , ' ' ) -> hello '' , 5 , '*' ) -> *****'hello' , 10 , 'ab' ) -> helloababa'hello' , 0 , '*' ) -> 'hello' ) -> 5 'hello world' ) -> 11 '' ) -> 0 '12345' ) -> 5 ' hello ' ) -> 9 'a' ) -> 1 'special@#$%' ) -> 11 and Latin charactersand Latin characters tests'Björn' ) -> 6 'björn' ) -> BJöRN'BJÖRN' ) -> bj�rn'Björn' ) -> nr��jB'ö' , 'Björn' ) -> 3 'Björn' , 1 , 3 ) -> Bj�' Björn ' ) -> Björn'Björn' , ' ' , 'Müller' ) -> Björn Müllerreplace ('Björn Müller' , 'Müller' , 'Schmidt' ) -> Björn Schmidt'Björn Müller' , 'Müller' ) -> 8 'Björn' , 10 , '*' ) -> ****Björn'Björn' , 10 , '*' ) -> Björn****'Khåled Rïyad' ) -> 14 'josé maría' ) -> JOSé MARíA'José María' , 1 , 4 ) -> Jos�and symbolsand symbols tests'path' , '/' , 'to' , '/' , 'file.txt' ) -> path/to/file.txt'user@domain.com' , 'domain.com' ) -> 6 'path/to/file.txt' ) -> 16 '.' , 'file.txt' ) -> 5 '/' , 'path/to/file.txt' ) -> 5 'test@example.com' ) -> TEST@EXAMPLE.COM'TEST@EXAMPLE.COM' ) -> test@example.com'file' , 8 , '.' ) -> ....file'path' , 10 , '/' ) -> path//////replace ('file.txt' , 'txt' , 'doc' ) -> file.docreplace ('path/to/file.txt' , 'file.txt' , 'document.doc' ) -> path/to/document.doc'path/to/file.txt' ) -> txt.elif/ot/htap'path/to/file.txt' , 1 , 4 ) -> path' path/to/file.txt ' ) -> path/to/file.txt' hello world ' )) -> 11 'MiXeD CaSe' )) -> MIXED CASE 'hi' , 5 , '*' )) -> ih***'o' , upper('hello world' )) -> 5 ' hello world ' ), 1 , 5 ) -> hello'hello' , ' ' , 'world' )) -> 11 'hello' )) -> OLLEH'hello ' ), 10 , '*' ) -> *****hello'hello' ), length('world' ), length('test' )) -> 4 'hello world' , 'h' ), instr('hello world' , 'w' ), instr('hello world' , 'o' )) -> 7 'hello' , 1 , 2 )), 3 ) -> HEHEHE'HELLO WORLD' ), 7 , 5 , upper('mariadb' )) -> hello MARIADB'-' , upper('hello' ), lower('WORLD' ), reverse('test' )) -> HELLO-world-tset' hello ' ), 'hello' ), 'default' ) -> default'test' , 'test' ), upper('backup' )) -> BACKUP'www' , '.' , 'mariadb' , '.' , 'org' ), '.' , 2 ) -> www.mariadb'a' ,'b' ,'c' ) -> abc42 , 'a' ) -> 42 a1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , '1' , 'a' ) -> 123456789101 a'' ) -> 'å' , 'ñ' , 'ç' , 'ü' , 'é' , 'ö' , 'ß' , 'æ' , 'ø' , 'î' , 'ë' , 'ä' , 'ï' , 'ô' , 'à' , 'ù' , 'ê' , 'â' , 'ý' , 'þ' , 'ð' , 'ł' , 'ś' , 'ż' , 'ź' , 'ć' ) -> åñçüéößæøîëäïôàùêâýþðłśżźć'' , 1 ) -> 1 'www.mariadb.org' , '.' , 2 ) -> www.mariadb'www.mariadb.org' , '.' , -2 ) -> mariadb.org'www.mariadb.org' , '.' , 0 ) -> 'www.mariadb.org' , '' , 1 ) -> 'www.mariadb.org' , '' , -1 ) -> 'mariadb' , '.' , 0 ) -> 'mariadb' , '.' , -1 ) -> mariadb'mariadb' , '.' , 1 ) -> mariadb'mariadb' , 'A' , 1 ) -> mariadb'mariadb' , 'A' , -1 ) -> mariadb'mariadb' , 'A' , 0 ) -> 'mariadb' , 'z' , 2 ) -> mariadb'' , 'z' , -2 ) -> 'mariadb' , 'ar' , 0 ) -> 'abc' ,'b' ) -> 2 'abc' ,'x' ) -> 0 'abc' ,'' ) -> 1 '' ,'a' ) -> 0 '' ,'' ) -> 1 'BJÖRN' ,'N' ) -> 6 'ABC' ,'(?-i)b' ) -> 0 'ABC' ,'(?i)b' ) -> 2 'ab12cd' ,'[0-9]+' ) -> 12 'ab12cd' ,'' ) -> 'abcd' ,'[0-9]+' ) -> '' ,'[0-9]+' ) -> '' ,'' ) -> 'See https://mariadb.org/en/foundation/ for details' ,'https?://[^/]*' ) -> https://mariadb.org'ABC' ,'b' ) -> B'ABC' ,'(?i)b' ) -> B'ABC' ,'b' ,'x' ) -> AxC'ab12cd' ,'[0-9]' ,'' ) -> abcd'<html><head><title>title</title><body>body</body></htm>' , '<.+?>' ,' ' ) -> title body 'James Bond' ,'^(.*) (.*)$' ,'\2, \1' ) -> Bond, James'ABC' ,'b' ,'-' ) -> A-C'ABC' ,'(?-i)b' ,'-' ) -> ABC'ABC' ,'(?i)b' ,'-' ) -> A-C'ABC' ,'b' ,'' ) -> AC'ABC' ,'(?-i)b' ,'' ) -> ABC'ABC' ,'' ,'' ) -> ABC'ABC' ,'' ,'A' ) -> ABC'' ,'.' ,'x' ) -> 'ABC' ,'b' ,'$' ) -> A$C'ABC' ,'b' ,'$A' ) -> A$AC'ABCC' ,'C$' ,'D' ) -> ABCD'ABC$' ,'\$' ,'D' ) -> ABCD1 , 2 , 3 ) -> 1 'a' , 'b' , 'c' ) -> a1 , 2 ) -> 'a' , 1 , 'b' ) -> 0 1 , 'a' , 'b' ) -> 0 'z' , '-2' , 'a' ) -> -2 'z' , -2 , 'a' ) -> -2 ' -4a' , -1 , 'b' ) -> -4 ' ' , 10 , 'b' ) -> 0 ' -0 ' , 10 , 'b' ) -> 0 '' , 10 , '-b' ) -> 0 18446744073709551615 , 18446744073709551614 , 18446744073709551613 ) -> 18446744073709551613 18446744073709551615 , -1 , 18446744073709551613 ) -> -1 1 , 2 , 3 ) -> 3 'a' , 'b' , 'c' ) -> c1 , 2 ) -> 'a' , 1 , 'b' ) -> 1 1 , 'a' , 'b' ) -> 1 'z' , '-2' , 'a' ) -> z'z' , -2 , 'a' ) -> 0 ' -4a' , -1 , 'b' ) -> 0 ' ' , 10 , 'b' ) -> 10 ' -0 ' , 10 , 'b' ) -> 10 '' , 10 , '-b' ) -> 10 18446744073709551615 , 18446744073709551614 , 18446744073709551613 ) -> 18446744073709551615 18446744073709551615 , -1 , 18446744073709551613 ) -> 18446744073709551615 3 .14 , 2 .71 , 3 .15 ) -> 3 .15 10 , -5 , -20 ) -> -5 'apple' , 'banana' , 'cherry' ) -> cherry'100' , '20' , '3' ) -> 3 'MariaDB ' ,4 ) -> MariaDB MariaDB MariaDB MariaDB 'a' , 0 ) -> 'a' , 1 ) -> a'' , 0 ) -> 'a' , -1 ) -> 'a' , 18446744073709551615 ) -> '' , 4 ) -> '' , -1 ) -> 'a32423413' , 10 ) -> a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413a32423413'a' , 'a' ) -> 'a' , 'b' ) -> a'a' , NULL) -> a'a' ) -> 'a' ) -> a'a' , 'b' ) -> a'a' , 'b' , 'c' ) -> a'a' , NULL, 'b' ) -> a'a' ) -> a'a' , NULL, 'b' ) -> a'a' ) -> a'a' , NULL) -> a'a' , 'b' ) -> a'a' , 'a' ) -> a'Hello World' , 2 , 3 , 'Xyz' ) -> HXyzo World'Hello World' , 2 , 3 , '' ) -> Ho World'Hello World' , 2 , 3 , NULL) -> 'Hello World' , 0 , 0 , 'Xyz' ) -> Hello World'Hello World' , 0 , 0 , '' ) -> Hello World'Quadratic' , 3 , 4 , 'What' ) -> QuWhattic'Quadratic' , -1 , 4 , 'What' ) -> Quadratic'Quadratic' , 3 , 100 , 'What' ) -> QuWhat'Quadratic' , -32 , -100 , 'wow' ) -> Quadratic'Quadratic' , 32 , 100 , 'wow' ) -> Quadratic'Quadratic' , 1 , 8 , 'wow' ) -> wowc'Quadratic' , 1 , 1000 , 'wow' ) -> wow'Quadratic' , 4 , 2 , 'wow' ) -> Quawowatic'Quadratic' , 4 , 2 , '' ) -> Quaatic'' , 4 , 2 , 'wow' ) -> 'Quadratic' , 4 , -2 , 'wow' ) -> Quawow'Quadratic' , 4 , 0 , 'wow' ) -> Quawowdratic'-' , 'a' , 'b' , 'c' ) -> a-b-c'#' , 'a' , 'b' , 'c' , 'd' , 'e' , 'f' , 'g' , 'h' , 'i' , 'j' , 'k' , 'l' , 'm' , 'n' , 'o' , 'p' , 'q' , 'r' , 's' , 't' , 'u' , 'v' , 'w' , 'x' , 'y' , 'z' ) -> a#b#c#d#e#f#g#h#i#j#k#l#m#n#o#p#q#r#s#t#u#v#w#x#y#z' ,' , 'a' ) -> a'' , 'abc' , 'def' , 'ghi' ) -> abcdefghi'' , 'abc' ) -> abc'&' , 'abc' ) -> abc' ,' , '' ) -> '&' , 'abc' , NULL) -> abc'...' , 'abc' , NULL, 'def' ) -> abc...def'abc' , NULL, 'def' ) -> 'test string' , 'string' ) -> string'test string' , 'string' ) -> test string'string' , 3 ) -> stringstringstring'test string' , 5 , 6 , 'value' ) -> testvalueg' ' , 'test string' , 'string' , 'value' ) -> test string string value'value' ) -> value'value' ) -> value'test string' , 'string' ) -> test string'Björn' , 'Müller' , 'Schmidt' ) -> Björn'Björn' , 'Müller' , 'Schmidt' ) -> Schmidt'ö' , 5 ) -> ööööö'Björn Müller' , 7 , 6 , 'Schmidt' ) -> BjörnSchmidter' ' , 'José' , 'María' , 'González' ) -> José María González'François' ) -> François'Håkon' , 'Olsen' ) -> Håkon'test@example.com' , 'user@domain.com' ) -> test@example.com123 , 'abc' , 456 ) -> 0 123 , 'abc' , 456 ) -> 456 'test' , 3 ) -> testtesttest'test123' , 5 , 3 , 'ABC' ) -> testABC'-' , 'prefix' , 123 , 'suffix' ) -> prefix-123 -suffix123 , 'fallback' ) -> 123 456 , 'backup' ) -> 456 123 , 456 ) -> 123 1 , 2 , 3 ) + 10 -> 11 1 , 2 , 3 ) * 5 -> 15 'ab' , 4 )) -> 8 'hello world' , 7 , 5 , 'mariadb' )) -> HELLO MARIADB' ' , 'hello' , 'world' , 'test' )) -> 16 'default' ) == 'default' -> 1 'found' ) != 'missing' -> 1 'same' , 'same' ) -> 0 returns empty stringnot NULL1 +2 , 2 *2 , 3 +1 ) -> 3 1 +2 , 2 *2 , 3 +1 ) -> 4 'x' , 2 +3 ) -> xxxxx'hello' , 1 +1 , 2 *1 , 'hi' ) -> hhilo'testing' , 2 , 3 , 'xyz' ) -> txyzing'hello' ), length('world' ), length('test' )) -> 4 'hello' ), length('world' ), length('test' )) -> 5 'ab' ), 3 ) -> ABABAB'hello world' ), 7 , 5 , lower('MARIADB' )) -> HELLO mariadb' ' , upper('hello' ), lower('WORLD' )) -> HELLO world'same' , 'same' ), 'default' ) -> default'test' , 'test' ), 'backup' ) -> backup37859 : Mysqltest hex() not working for string values"abc" ) -> 616263 "255" ) -> 323535 '' ) -> 10 .6 tests Messung V0.5 in Prozent C=99 H=100 G=99
¤ Dauer der Verarbeitung: 0.24 Sekunden
(vorverarbeitet am 2026-10-08)
¤ *© Formatika GbR, Deutschland
