# test quoteIndent( <string>, [<string quote>], [<boolean force>] )
---
- Statement: SELECT QUOTE_IDENT( 'blah' )
- output: [ ['blah'] ]
---
- Statement: SELECT QUOTE_IDENT('values')
- output: [ ['"values"'] ]
---
- Statement: SELECT QUOTE_IDENT('values', '`')
- output: [ ['`values`'] ]

---
- Statement: SELECT QUOTE_IDENT('foo', '"', TRUE)
- output: [ ['"foo"'] ]
---
- Statement: SELECT QUOTE_IDENT('')
- error: [ 22023 ]
---
- Statement: SELECT QUOTE_IDENT('foo', '++', TRUE)
- error: [ 22023 ]
---
- Statement: select describe_expression(QUOTE_IDENT(CAST (? as VARCHAR(128) COLLATE en_us_ci)))
- output: [['variable MCOMPAT_ VARCHAR(130, UTF8, en_us_ci) NULL']]
---
- Statement: explain verbose select QUOTE_IDENT(CAST (? AS CHAR(12)), CAST(? AS CHAR(1)))
- output: [['Project_Default(QUOTE_IDENT(CAST($1 AS VARCHAR(12)), CAST($2 AS VARCHAR(1))))'],
          ['  ValuesScan_Default([])']]
...
# test quoteIndent( <string>, [<string quote>], [<boolean force>] )
---
- Statement: SELECT QUOTE_IDENT( 'blah' )
- output: [ ['blah'] ]
---
- Statement: SELECT QUOTE_IDENT('values')
- output: [ ['"values"'] ]
---
- Statement: SELECT QUOTE_IDENT('values', '`')
- output: [ ['`values`'] ]

---
- Statement: SELECT QUOTE_IDENT('foo', '"', TRUE)
- output: [ ['"foo"'] ]
---
- Statement: SELECT QUOTE_IDENT('')
- error: [ 22023 ]
---
- Statement: SELECT QUOTE_IDENT('foo', '++', TRUE)
- error: [ 22023 ]
---
- Statement: select describe_expression(QUOTE_IDENT(CAST (? as VARCHAR(128))))
- output: [['variable MCOMPAT_ VARCHAR(130, UTF8, UCS_BINARY) NULL']]
---
- Statement: explain verbose select QUOTE_IDENT(CAST (? AS CHAR(12)), CAST(? AS CHAR(1)))
- output: [['Project_Default(QUOTE_IDENT(CAST($1 AS VARCHAR(12)), CAST($2 AS VARCHAR(1))))'],
          ['  ValuesScan_Default([])']]
...
Fix quote_ident() by removing the collation. Nathan's point is now proven.
Fix quote_ident() by removing the collation. Nathan's point is now
proven. 