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 -- source include/not_embedded.inc
11 # Tests for sys schema
12 # Verify the sys.quote_identifer() function perfoms as expected
13
14 # Passing NULL should return NULL
15 SELECT sys.quote_identifier(NULL);
16
17 # Passing a simple string
18 SELECT sys.quote_identifier('abc');
19
20 # Passing a string containing backticks (`)
21 SELECT sys.quote_identifier('ab`c');
22 SELECT sys.quote_identifier('ab``c');
23 SELECT sys.quote_identifier('ab```c');
24 SELECT sys.quote_identifier('a`b`c');
25 SELECT sys.quote_identifier('a`b``c');