View Issue Details

IDProjectCategoryView StatusLast Update
0007994VALENTINA STUDIOTool - SQL Editorpublic2017-07-04 17:27
ReporterakeretAssigned ToViktor Markvardt 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSMac OS OS Version10.10
Product Version7.2.x 
Target Version7.3.xFixed in Version7.3.x 
Summary0007994: 'Format SQL' should not add SPACE between func name and '(' symbol.
DescriptionReformating SQL query with the "Format SQL" function inserts additional blanks to the SUM() function and makes the SQL query invalid.
Before: SUM(...)
After: SUM (...)

Kernel error: Error( 1630 ) 42000: "FUNCTION <schema name>.SUM does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual"

Steps To ReproduceOpen SQL Editor
- Create SQL query including SUM() function
- Use "Format SQL" function
- Execute SQL query
-> 21:56:12 Kernel error: Error( 1630 ) 42000: "FUNCTION <schema name>.SUM does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual"
TagsNo tags attached.
Working with DB:mySQL Server
Version of your DBMariaDB 10.1

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-06-28 20:04 akeret New Issue
2017-07-04 11:58 Viktor Markvardt Status new => resolved
2017-07-04 11:58 Viktor Markvardt Fixed in Version => 7.3.x
2017-07-04 11:58 Viktor Markvardt Resolution open => fixed
2017-07-04 11:58 Viktor Markvardt Assigned To => Viktor Markvardt
2017-07-04 14:46 Ruslan Zasukhin Summary Using "Format SQL" function makes SQL command invalid (7.3) => 'Format SQL' should not add SPACE between func name and '(' symbol.
2017-07-04 17:27 Ruslan Zasukhin Target Version => 7.3.x