| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 89 | [JBSQL] Bugs | minor | always | 2023-03-23 08:19 | 2023-03-23 08:19 |
| Reporter: | jdebli | Platform: | x64 | ||
| Assigned To: | jorgen.bosman | OS: | Windows | ||
| Priority: | low | OS Version: | 10 | ||
| Status: | assigned | Product Version: | 1.4.0.5 | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | 12.1.0.2.0 | ||||
| Oracle Server Version: | RAC 19c | ||||
| Summary: | XPATH wildcards wordt als comment geïnterpreteert | ||||
| Description: |
Bij een XMLTYPE.EXTRACT kan er in de xpath wildcards gebruikt worden. Deze worden door jbsql geïnterpreteerd als 'start comment' /*. Hierdoor wordt het script / statement niet uitgevoerd en wordt er ook geen enkele syntax parsing gedaan. Om dit te bypassen, kan er in commentaar de 'end comment' */ toegevoegd worden waardoor het wel werkt. |
||||
| Tags: | |||||
| Steps To Reproduce: |
declare begin for rec in (select xmltype.extract(x, '//*:b/text()').getStringVal() x -- */ end comment tag to override from (select xmltype('<a:a xmlns:a="test"><a:b>test</a:b></a:a>') x from dual)) loop dbms_output.put_line('tested...' || rec.x); end loop; end; / |
||||
| Additional Information: |
Zo werkt het niet: xmltype.extract(x, '//*:b/text()').getStringVal() x Zo werkt het wel: xmltype.extract(x, '//*:b/text()').getStringVal() x -- */ end comment tag to override |
||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 88 | [JBSQL] Enhancement Request | feature | always | 2020-05-14 19:52 | 2020-06-26 17:26 |
| Reporter: | jdebli | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | resolved | Product Version: | 1.4.0.5 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | 12.1.0.2.0 | ||||
| Oracle Server Version: | |||||
| Summary: | Check for update option in 'Options' | ||||
| Description: |
Bij fluvius worden de downloads geblokkeerd. Tot gevolg dat er een nieuwe versie wordt gedownload en afgebroken wordt (0 kb). Vanaf dan kan er geen nieuwe sessie van JB/SQL meer gestart worden. |
||||
| Tags: | |||||
| Steps To Reproduce: | Start JB/SQL op met een vorige versie | ||||
| Additional Information: | |||||
| Attached Files: | |||||
| Notes | |
|
(0000021)
jorgen.bosman 2020-06-26 17:26 |
Added check for downloaded size = 0 |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 87 | [JBSQL] Crash | minor | always | 2020-01-07 10:05 | 2020-01-07 10:07 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | resolved | Product Version: | 1.4.0.4 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 1.4.0.5 | ||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | crash when copy from listview after new query has started | ||||
| Description: | When a new query is started, the results from the previous query are still present (which shouldn't be). When trying to copy a value from the list, jbsql crashes | ||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 86 | [JBSQL] Crash | minor | always | 2019-12-20 12:07 | 2019-12-20 12:07 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | resolved | Product Version: | 1.4.0.3 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 1.4.0.4 | ||
| Target Version: | 1.4.0.4 | ||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Crash when finding child records with long contraint names | ||||
| Description: | when a foreign key exists with name > 30 characters, and then finding the child records for a table, jbsql crashes when choosing the child table from the popup list | ||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 85 | [JBSQL] Crash | minor | sometimes | 2019-11-22 14:40 | 2019-11-22 14:42 |
| Reporter: | jorgen.bosman | Platform: | Windows 10 x64 | ||
| Assigned To: | jorgen.bosman | OS: | Windows | ||
| Priority: | normal | OS Version: | 10 x64 | ||
| Status: | resolved | Product Version: | 1.4.0.3 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 1.4.0.4 | ||
| Target Version: | |||||
| Oracle Client Version: | instantclient | ||||
| Oracle Server Version: | |||||
| Summary: | Crash when connecting to Oracle | ||||
| Description: | On some systems with only an instantclient, jbsql crashes when connecting to an Oracle db | ||||
| Tags: | |||||
| Steps To Reproduce: |
Create fresh windows install Download and unzip the oracle instantclient put jbsql.exe in same folder start jbsql connect to oracle db -> crash |
||||
| Additional Information: | |||||
| System Description | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 84 | [JBSQL] Enhancement Request | minor | sometimes | 2019-11-22 14:38 | 2019-11-22 14:42 |
| Reporter: | jorgen.bosman | Platform: | Windows 10 x64 | ||
| Assigned To: | jorgen.bosman | OS: | Windows | ||
| Priority: | normal | OS Version: | 10 x64 | ||
| Status: | resolved | Product Version: | 1.4.0.3 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 1.4.0.4 | ||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Reduce flicker in listview | ||||
| Description: | Since the last version, the results listview has introduced more flickering when queries are executed | ||||
| Tags: | |||||
| Steps To Reproduce: |
execute a query execute a different query |
||||
| Additional Information: | |||||
| System Description | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 80 | [JBSQL] Enhancement Request | minor | have not tried | 2019-06-12 11:49 | 2019-06-12 11:49 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | assigned | Product Version: | 1.4.0.1 | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Add more session info the sql monitor | ||||
| Description: |
Add more details to session monitor: - Session details - Waits - locks - open cursors - rbs usage - statistics - executing plsql |
||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 78 | [JBSQL] Enhancement Request | minor | have not tried | 2019-06-11 09:26 | 2019-06-11 09:26 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | assigned | Product Version: | 1.4.0.0 | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Add Undo/Redo support | ||||
| Description: | Add support for Undo/Redo in main edit window. For example it might happen that you paste something incorrect, undo would be a fast way to remove the unwanted text again | ||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 77 | [JBSQL] Enhancement Request | minor | always | 2019-06-11 09:25 | 2019-06-11 09:25 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | assigned | Product Version: | 1.4.0.0 | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Show matching brace | ||||
| Description: | When cursor is on a brace, highlight the matching brace | ||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 31 | [JBSQL] Enhancement Request | minor | always | 2013-10-14 18:00 | 2019-04-10 11:44 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | assigned | Product Version: | |||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Sytax highlighting | ||||
| Description: | Please add syntax highlighting for entered statements | ||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |
| View Issue Details | |||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 36 | [JBSQL] Enhancement Request | minor | always | 2013-10-22 14:27 | 2019-04-10 11:41 |
| Reporter: | jorgen.bosman | Platform: | |||
| Assigned To: | jorgen.bosman | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | assigned | Product Version: | 1.3.0.0 | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
| Target Version: | |||||
| Oracle Client Version: | |||||
| Oracle Server Version: | |||||
| Summary: | Edit/Delete selected records | ||||
| Description: | Add the possibility to edit or delete selected records from in the listview (on simple queries) | ||||
| Tags: | |||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Attached Files: | |||||
| There are no notes attached to this issue. |