#8686: Edit and clone rows of a SQLite view in Table Data Editor gives invalid column for " "

tariqrahiman reported 2013-04-17T19:23:07Z · last modified 2013-05-01T00:09:57Z

Edit and clone rows of a SQLite view in Table Data Editor gives invalid column for " "

Dev	JennyNishimura
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	Tools - Table Data Editor
Version	14.0

Version: 13.0-rc-25

Build #: 31956

Build Date: 2013-Apr-16 05:46:38 PM

Edit and clone rows of a SQLite view in Table Data Editor gives invalid column for " "

1. Open the attached sqlite database.

2. Navigate to the views and Edit a view in Table Data Editor

3. Clone a row

4. You get a message as attached Invalid Column for " "

3 attachments

Screen Shot 2013-04-17 at 12.20.23 PM.png

2013-04-17T19:23:07Z

237 KB
campus.db

2013-04-17T19:23:07Z

106 KB
SQLiteView.png

2013-04-17T20:11:34Z

132 KB

All Comments (2) Change History

JennyNishimura 2013-04-17T20:11:34Z

This is a SQLite bug. In ADS 14.0, the SQLite JDBC driver we are planning to use is bundled with SQLite version 3.7.15, which seems to have fixed the problem. See the SQLiteView screenshot. Left hand side is 13.0 and right hand side is 14.0. In 13.0, the column name returned from a view has double quotes.

I am marking this bug as fixed in 14.0.

Note: Even though this issue is resolved, SQLite doesn't allow updating data using a view.

tariqrahiman 2013-05-01T00:09:57Z

Fixed in 14.0-dev-47

Search Tips

Aqua Data Studio / nhilam

Edit and clone rows of a SQLite view in Table Data Editor gives invalid column for " "

3 attachments

Issue #8686

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Edit and clone rows of a SQLite view in Table Data Editor gives invalid column for " "

3 attachments

Issue #8686

Completion