Test Scenario: I set the "Maximum column length" to 1000, then run a SQL query over a table having a longtext column with a 10M cell content on it. When the results are displayed on the Text tab, the first two rows ( column names header and the "---" separator) are correctly truncated to lhe length 1000 (you can check this by playing with the END key inside the editor of the Text Tab). Then, depending if the longtext column had new lines chars on its content or not, you'll have one or more table content lines on the Text tab output, but the last line of the table content will have a size of 10M chars (verify with the END key), the chars after the 1000th position being just space chars.
I've performed a debug session on ADS to see if this behaviour is a Netbeans editor issue or not, but on the BaseDocument.insertString() method I receive a String parameter whose length is 10M chars. Below is the stacktrace (obtained with ADS v14-dev11) :
org.netbeans.editor.BaseDocument.insertString(BaseDocument.java:742) \\...\\ .\\हिñçêČάй語简�?한\\.tꄯ∕ꇿꎊ native default.append \\...\\ .\\हिñçêČάй語简�?한\\.pꈌ⠂⠄ꁙ synchronized.a \\...\\ .\\हिñçêČάй語简�?한\\.pꈌ⠂⠄ꁙ synchronized.b com.aquafold.datastudio.queryanalyzer.cꍥ⣿ꏶᝅ.run
Please review the string truncation performed on the caller methods listed on this stack trace. Instead of replacing chars with SPACE chars, the string should be truncated to the desired length.
|
37 KB
|
37 KB
|
37 KB
SVN trunk/r31435 - see attached screenshots for more info.
Test-Data: this screenshot shows the test data with 'Maximum column length' set to -1.
Before-Fix: this screenshot shows the test data with 'Maximum column length' set to 12 before r31435 is applied.
After-Fix: this screenshot shows the test data with 'Maximum column length' set to 12 after r31435 is applied.
Issue #8374 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/31435 |
No time estimate |
1 issue link |
is required by #8369
Issue #8369Query Analyzer: high memory consumption |
SVN trunk/r31435 - see attached screenshots for more info.
Test-Data: this screenshot shows the test data with 'Maximum column length' set to -1.
Before-Fix: this screenshot shows the test data with 'Maximum column length' set to 12 before r31435 is applied.
After-Fix: this screenshot shows the test data with 'Maximum column length' set to 12 after r31435 is applied.