apache / apache/netbeans

Database update table bug

Open
#8,505 5 comments 0 reactions 0 assignees View on GitHub
kind:bug SQL
Dominant language
Java
Stars
3.1k
Forks
935
Avg merge
2d 3h
Merged PRs (30d)
17

Description

### Apache NetBeans version

Apache NetBeans 25

### What happened

![Image](https://github.com/user-attachments/assets/f7091b9e-d288-4c39-b9e3-52a3804dbc2f)
table alias error

UPDATE "isms"."TSOSOA1 t"

### Language / Project Type / NetBeans Component

_No response_

### How to reproduce

excute "select * from table t where t.aaa='xxxx' "
modify some data
click commit records button
will show the error
and the update sql will be : update "table t"
the correct sql is : update table ,no t

### Did this work correctly in an earlier version?

No / Don't know

### Operating System

windows11

### JDK

jdk1.8

### Apache NetBeans packaging

Apache NetBeans binary zip

### Anything else

_No response_

### Are you willing to submit a pull request?

No

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the issue in Apache NetBeans 25 with the reported SELECT, table alias, and commit-records action, then inspect the generated UPDATE statement. Done means the update targets the table without incorrectly including the alias and the commit completes without the reported error.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.