Skip to main content

Search

Welcome to Tibero GTS!

Fix for the Issue Where Trailing Space at the End of the "SQL> " Prompt Disappears

Issue Information

Issue Number701147b
IssueWhen SET TRIMSPOOL ON is enabled, only the trailing spaces on the last line of multi-line output are removed, while trailing spaces on preceding lines are not removed. This behavior occurs regardless of the SET TRIMOUT ON/OFF setting, as it always executes as if SET TRIMOUT is ON.
CauseA logic error occurred in the TRIMSPOOL-related function, and the logic that checks the TRIMOUT setting to branch processing was omitted.
SolutionsFixed the issue where trailing spaces after the SQL prompt disappear when SET TRIMOUT is ON, ensuring that spaces are properly displayed when entering commands.
Occurrence DateJuly 26, 2023
Versions Requiring Patch6FS07PS
7FS02PS



 

Patch Information

Patch NameFS02PS_701147b
Major Version7
Minor VersionFS02PS
Version TitleFix for the Issue Where Trailing Space at the End of the "SQL> " Prompt Disappears
Release DateAugust 24, 2026
Compatibilityโ€ข TAC rolling patch: Supported
โ€ข TSC rolling patch: Supported
โ€ข Backup data compatibility: Supported
โ€ข Protocol compatibility: Supported
โ€ข Data format compatibility: Supported
AP Impactโ€ข Plan change: No
โ€ข Result value change: No
โ€ข SQL syntax change: No
โ€ข System object change: No
โ€ข Existing feature change: No
Parameters-
Workaround-