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

JennyNishimura reported 2017-02-08T18:13:26Z · last modified 2017-02-09T03:05:09Z

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 2017-02-08T21:56:20Z · (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 2017-02-08T22:52:39Z

Verified in ADS v17.0.11-9

tariqrahiman 2017-02-09T03:05:09Z

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