[GH-ISSUE #769] paste SQL statements wrongly #445

Closed
opened 2026-02-26 23:59:33 +03:00 by kerem · 6 comments
Owner

Originally created by @saulperez2905 on GitHub (Sep 27, 2018).
Original GitHub issue: https://github.com/electerm/electerm/issues/769

electerm version:

0.24.20

operating system(linux, macos, or windows?):

Windows

Expected Behavior

Current Behavior

when opening the Electerm and then, from the PowerShell terminal that Electerm uses, the connection to the Database is made using the SQLPLUS application (in no time we connect to a linux, everything is done from Windows). Once connected to the database, SQL statements are pasted, "electerm" pastes them continuously as if it were a single line.

Possible Solution

Steps to Reproduce

1.open electerm
2.From the power shell I run: sqlplus sys/oracle@NAME_DB as sysdba

PS C:\Users\sperez\Documents\Electerm_sael\electerm-0.24.20-win-x64>
PS C:\Users\sperez\Documents\Electerm_sael\electerm-0.24.20-win-x64>sqlplus sys/oracle@NAME_DB as sysdba
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL>

  1. I need to paste the following questions:
    COLUMN COMP_NAME FORMAT a35 word_wrapped
    COLUMN VERSION FORMAT a15 word_wrapped
    COLUMN STATUS FORMAT a10 word_wrapped
    SELECT COMP_NAME
    , VERSION
    , STATUS
    FROM SYS.DBA_REGISTRY;

  2. But when you paste the query, you paste it in a single line and obviously it is an error

SQL> COLUMN COMP_NAME FORMAT a35 word_wrappedCOLUMN VERSION FORMAT a15 word_wrappedCOLUMN STATUS FORMAT a10 word_wrappedSELECT COMP_NAME , VERSION , STATUSFROM SYS.DBA_REGISTRY;
SP2-0735: unknown COLUMN option beginning "word_wrapp..."
SQL>

  1. I attached an example of how it results from powershell in the windows programs
    2018-09-27 13_18_48-000171

Context (Environment)

Detailed Description

Suggestions?

Originally created by @saulperez2905 on GitHub (Sep 27, 2018). Original GitHub issue: https://github.com/electerm/electerm/issues/769 <!--- Provide some basic info --> ## electerm version: 0.24.20 ## operating system(linux, macos, or windows?): Windows ## Expected Behavior <!--- Tell me what should happen --> ## Current Behavior <!--- Tell me what happens instead of the expected behavior --> when opening the Electerm and then, from the PowerShell terminal that Electerm uses, the connection to the Database is made using the SQLPLUS application (in no time we connect to a linux, everything is done from Windows). Once connected to the database, SQL statements are pasted, "electerm" pastes them continuously as if it were a single line. ## Possible Solution <!--- Not obligatory, but suggest a fix/reason for the bug, --> ## Steps to Reproduce <!--- Provide a link to a live example, or an unambiguous set of steps to --> <!--- reproduce this bug. Include code to reproduce, if relevant --> 1.open electerm 2.From the power shell I run: sqlplus sys/oracle@NAME_DB as sysdba PS C:\Users\sperez\Documents\Electerm_sael\electerm-0.24.20-win-x64> PS C:\Users\sperez\Documents\Electerm_sael\electerm-0.24.20-win-x64>sqlplus sys/oracle@NAME_DB as sysdba Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production SQL> 4. I need to paste the following questions: COLUMN COMP_NAME FORMAT a35 word_wrapped COLUMN VERSION FORMAT a15 word_wrapped COLUMN STATUS FORMAT a10 word_wrapped SELECT COMP_NAME , VERSION , STATUS FROM SYS.DBA_REGISTRY; 5. But when you paste the query, you paste it in a single line and obviously it is an error SQL> COLUMN COMP_NAME FORMAT a35 word_wrappedCOLUMN VERSION FORMAT a15 word_wrappedCOLUMN STATUS FORMAT a10 word_wrappedSELECT COMP_NAME , VERSION , STATUSFROM SYS.DBA_REGISTRY; SP2-0735: unknown COLUMN option beginning "word_wrapp..." SQL> 6. I attached an example of how it results from powershell in the windows programs ![2018-09-27 13_18_48-000171](https://user-images.githubusercontent.com/28075454/46166195-32cce700-c258-11e8-99d7-70a0b9f56ae7.jpg) ## Context (Environment) <!--- How has this issue affected you? What are you trying to accomplish? --> <!--- Providing context helps us come up with a solution that is most useful in the real world --> ## Detailed Description <!--- Provide a detailed description of the change or addition you are proposing --> ## Suggestions? <!--- Not a bug report, just some thoughts or suggestions? It is totally OK and welcome too -->
kerem 2026-02-26 23:59:33 +03:00
  • closed this issue
  • added the
    bug
    label
Author
Owner

@zxdong262 commented on GitHub (Sep 28, 2018):

Thank you for the feedback. I will handle it tonight, around 12hour from now, I believe I know the source of the bug.

<!-- gh-comment-id:425282964 --> @zxdong262 commented on GitHub (Sep 28, 2018): Thank you for the feedback. I will handle it tonight, around 12hour from now, I believe I know the source of the bug.
Author
Owner

@saulperez2905 commented on GitHub (Sep 28, 2018):

Thanks for the help

El jue., 27 de sep. de 2018 7:27 p. m., ZHAO Xudong <
notifications@github.com> escribió:

Thank you for the feedback. I will handle it tonight, around 12hour from
now, I believe I know the source of the bug.


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/electerm/electerm/issues/769#issuecomment-425282964,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AaxlvmeEF3d6mbWCFjX1koj7fe2Q3CcUks5ufWzWgaJpZM4W9NM3
.

<!-- gh-comment-id:425487633 --> @saulperez2905 commented on GitHub (Sep 28, 2018): Thanks for the help El jue., 27 de sep. de 2018 7:27 p. m., ZHAO Xudong < notifications@github.com> escribió: > Thank you for the feedback. I will handle it tonight, around 12hour from > now, I believe I know the source of the bug. > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <https://github.com/electerm/electerm/issues/769#issuecomment-425282964>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AaxlvmeEF3d6mbWCFjX1koj7fe2Q3CcUks5ufWzWgaJpZM4W9NM3> > . >
Author
Owner

@zxdong262 commented on GitHub (Sep 29, 2018):

Maybe tonight I can fix it.

<!-- gh-comment-id:425598128 --> @zxdong262 commented on GitHub (Sep 29, 2018): Maybe tonight I can fix it.
Author
Owner

@zxdong262 commented on GitHub (Sep 29, 2018):

New version released, let me how it works.@saulperez2905

<!-- gh-comment-id:425644579 --> @zxdong262 commented on GitHub (Sep 29, 2018): New version released, let me how it works.@saulperez2905
Author
Owner

@saulperez2905 commented on GitHub (Sep 30, 2018):

Hello
I just checked and the problem is still being presented, I send you a screen

De: ZHAO Xudong notifications@github.com
Enviado el: sábado, 29 de setiembre de 2018 08:17
Para: electerm/electerm electerm@noreply.github.com
CC: saulperez2905 sael2905@gmail.com; Mention mention@noreply.github.com
Asunto: Re: [electerm/electerm] paste SQL statements wrongly (#769)

New version released, let me how it works.@saulperez2905 https://github.com/saulperez2905


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub https://github.com/electerm/electerm/issues/769#issuecomment-425644579 , or mute the thread https://github.com/notifications/unsubscribe-auth/Aaxlvnsw_V6gE14jZSFiM2H1tLXvZfc_ks5uf3K4gaJpZM4W9NM3 . https://github.com/notifications/beacon/Aaxlvme1dAFpGO6IjFE2nMHeqbUZxFFpks5uf3K4gaJpZM4W9NM3.gif

<!-- gh-comment-id:425684997 --> @saulperez2905 commented on GitHub (Sep 30, 2018): Hello I just checked and the problem is still being presented, I send you a screen De: ZHAO Xudong <notifications@github.com> Enviado el: sábado, 29 de setiembre de 2018 08:17 Para: electerm/electerm <electerm@noreply.github.com> CC: saulperez2905 <sael2905@gmail.com>; Mention <mention@noreply.github.com> Asunto: Re: [electerm/electerm] paste SQL statements wrongly (#769) New version released, let me how it works.@saulperez2905 <https://github.com/saulperez2905> — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/electerm/electerm/issues/769#issuecomment-425644579> , or mute the thread <https://github.com/notifications/unsubscribe-auth/Aaxlvnsw_V6gE14jZSFiM2H1tLXvZfc_ks5uf3K4gaJpZM4W9NM3> . <https://github.com/notifications/beacon/Aaxlvme1dAFpGO6IjFE2nMHeqbUZxFFpks5uf3K4gaJpZM4W9NM3.gif>
Author
Owner

@zxdong262 commented on GitHub (Sep 30, 2018):

New version released, I believe it it fixed and,
once again, your feedback helped me to find a import bug! Thank you!
.@saulperez2905

<!-- gh-comment-id:425688891 --> @zxdong262 commented on GitHub (Sep 30, 2018): New version released, I believe it it fixed and, once again, your feedback helped me to find a import bug! Thank you! .@saulperez2905
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/electerm#445
No description provided.