#14999: Format Script changes "c" to upper case "C"

JennyNishimura reported Feb 8, 2017 · tariqrahiman last modified Feb 9, 2017

Dev	JennyNishimura
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	Q Analyzer
Version	17.0

In Query Analyzer, type the following statement:

select * from table1 a, table2 b, table3 c

Choose Automate -> Format Script.

In the Beautify Options dialog, check the Uppercase -> Keywords option.

SELECT
    * 
FROM
    table1 a,
    table2 b,
    table3 C

The table alias "c" is formatted to upper case "C".

All Comments (3) Change History

JennyNishimura Feb 8, 2017 · (edited)

Checking lexer.g, the letters "c", "g", "k", and "m" were defined in the keyword list. The following query wouldn't work after Format Script.

select * from track c, artist m
where c.trackartist=m.artistid

Format script changed it to:

SELECT
    * 
FROM
    track C,
    artist M 
WHERE
    C.trackartist=m.artistid

I've removed "c", "g", "k", "m" from the SQL Beautifier's keyword list.

Checking lexer.g, the letters "c", "g", "k", and "m" were defined in the keyword list. The following query wouldn't work after Format Script.

select * from track c, artist m
where c.trackartist=m.artistid

Format script changed it to:

SELECT
    * 
FROM
    track C,
    artist M 
WHERE
    C.trackartist=m.artistid

I've removed "c", "g", "k", "m" from the SQL Beautifier's keyword list.

tariqrahiman Feb 8, 2017

Verified in ADS v17.0.11-9

tariqrahiman Feb 9, 2017

Verified in ADS v18.0.0-preview-57 as well and works fine