Bug report #17214

Oracle Table list acting strange

Added by Richard Duivenvoorde about 7 years ago. Updated over 5 years ago.

Status:Open
Priority:Normal
Assignee:Jürgen Fischer
Category:Data Provider/Oracle
Affected QGIS version:3.4.5 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:25113

Description

Testing viewing Oracle tables here in current master 6cd8b4c83e

After making a succesfull connection you get presented a (tree) table of all layers.

Some strange things happening here:

- if your table does not have a primary key (that is the column Primary key column is emtpy), you can double click in the cell (of that table): you are then presented with a Query Builder window, BUT adding a Field name then does not work. Looks like there should not be a Query Builder there?

- if you click one row (select a table), then the Add button will be enabled. BUT if you select click another row, it is ADDED to the selection (so you have to rows selected)
I think that is strange, normally you select another row, and maybe can add rows to the selection by using the shift button or so?

- if you have 2 rows selected, and DEselect one row, then the 'Add' button is disabled and connot be used anymore... selecting a second row again enables the button...
Looks like the enabling/disabling is not in sync with what you see?

oraclemsg.png - Message you get if you try to select a column via het query builder (51.4 KB) Richard Duivenvoorde, 2017-09-28 11:15 AM

oraclemsg2.png (23 KB) Richard Duivenvoorde, 2017-09-28 11:24 AM

History

#1 Updated by Richard Duivenvoorde about 7 years ago

Attached a screenie where I just disabled a second row, seeing a DISabled add button

Not this one is in 2.18.3, so it is not a regression.

#2 Updated by Giovanni Manghi over 5 years ago

  • Status changed from Open to Feedback

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

#3 Updated by Richard Duivenvoorde over 5 years ago

  • Status changed from Feedback to Open

#4 Updated by Giovanni Manghi over 5 years ago

  • Affected QGIS version changed from master to 3.4.5

Also available in: Atom PDF