GeezerVisonThe World Wide Web, restored to 800 pixels of glory. | |||||||||||||||||||||||||||||||||||||||
| Home|About|Gaming cabinet|Archives|How it works|Starter sites | |||||||||||||||||||||||||||||||||||||||
GeezerVison is showing github.com — Fix output length error and output buffer. by jgebal · Pull Request #1255 · utPLSQL/utPLSQL Conversation
Member
When dealing with multibyte strings, the substring limit of 4000 chars is not correct. We need to apply a limit of 4000 bytes to both VARCHAR2 and to CLOB data types. This means we need to have a function to calculate lenght of CLOB in bytes. This is now added and all the conversions/trimming/string-splitting is done using the string length in bytes Additionally, a different approach (with sequences) was introduced into output buffers to avoid the sometime occurring PK violation on the output buffer tables. The new approach may add a but overhead on reading from / saving into buffer, but will definitely address the threat of PK errors.
Sorry, something went wrong. Uh oh!
There was an error while loading. Please reload this page. All reactionsWhen dealing with multibyte strings, the substring limit of 4000 **chars** is not correct. We need to apply a limit of 4000 **bytes** to both VARCHAR2 and to CLOB data types. This means we need to have a function to calculate lenght of CLOB in bytes. This is now added and all the conversions/trimming/string-splitting is done using the string length in **bytes** Additionally, a different approach (with sequences) was introduced into output buffers to avoid the sometime occurring PK violation on the output buffer tables. The new approach may add a but overhead on reading from / saving into buffer, but will definitely address the threat of PK errors. Resolves #1254 Resolves #1128 Replaced all regexp ranges with posix representations to avoid NLS_SORT impact on regex behavior.
|
There was an error while loading. Please reload this page.
Unit Test Results 1 files 2 suites 5m 39s ⏱️ Results for commit b70ee1e. ♻️ This comment has been updated with latest results. |
Sorry, something went wrong.
There was an error while loading. Please reload this page.
There was an error while loading. Please reload this page.
Codecov ReportPatch coverage:
Additional details and impacted files@@ Coverage Diff @@ ## develop #1255 +/- ## =========================================== + Coverage 94.67% 94.80% +0.12% =========================================== Files 111 111 Lines 5374 5372 -2 Branches 33 34 +1 =========================================== + Hits 5088 5093 +5 + Misses 278 271 -7 Partials 8 8
Flags with carried forward coverage won't be shown. Click here to find out more.
☔ View full report in Codecov by Sentry. |
Sorry, something went wrong.
There was an error while loading. Please reload this page.
|
Kudos, SonarCloud Quality Gate passed! |
Sorry, something went wrong.
There was an error while loading. Please reload this page.
There was an error while loading. Please reload this page.
Successfully merging this pull request may close these issues.
ORA-00001: unique constraint (UT.UT_OUTPUT_BUFFER_TMP_PK) violated UT_OUTPUT_CLOB_BUFFER_TMP_PK violation on parallel
There was an error while loading. Please reload this page.