Debian Codegraph @

mysql-test/suite/sysschema/t/fn_quote_identifier.test

raw
1 ########### suite/sysschema/t/fn_quote_identifier.test #############
2 # #
3 # Testing of of the sys.quote_identifier() function #
4 # #
5 # Creation: #
6 # 2016-05-23 jkrogh Implement this test as part of bug 22011361 #
7 # #
8 ####################################################################
9
10 # Tests for sys schema
11 # Verify the sys.quote_identifer() function perfoms as expected
12
13 # Passing NULL should return NULL
14 SELECT sys.quote_identifier(NULL);
15
16 # Passing a simple string
17 SELECT sys.quote_identifier('abc');
18
19 # Passing a string containing backticks (`)
20 SELECT sys.quote_identifier('ab`c');
21 SELECT sys.quote_identifier('ab``c');
22 SELECT sys.quote_identifier('ab```c');
23 SELECT sys.quote_identifier('a`b`c');
24 SELECT sys.quote_identifier('a`b``c');