#8032: SQLite -d and -s params on related commands

aquaclusters.josekibold reported 2012-12-06T20:40:16Z · last modified 2012-12-13T22:00:35Z

SQLite -d and -s params on related commands

Dev	JennyNishimura
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	App - FluidShell
Version	13.0

This issue shall address the use/meaning of the -d and -s parameters on all related commands when using an SQLite connection.

Scenario: suppose we are connected to an SQLite server named sqlite-server, having a database named my_db, and containing a table named my_table

$ connect -d fictional_db sqlite-server -k new<---The -d seems to have no effect

$ describe -d fictional_db my_table

DATABASE: fictional_db<---The used DB is still the one mentioned in the SQLite connection, however here the DB mentioned after -d is displayed

TABLE NAME: my_table

[...]

$ describe -s fictional_s my_table

describe: 'my_table': Does not exist<---The -s param seems to affect the output

$ list -d fictional_db -s fictional_s database
/tmp/sqlite/my_db<---The -d and -s params have no effect

$ reconnect -d fictional_db<---No effect

$ sqlexport -d fictional_db my_table<---No effect
"col1","col2"
"val1", "val2"

$ sqlexport -s fictional_s my_table

[SQLITE_ERROR] SQL error or missing database (no such table: fictional_s.my_table)

sqlexport: SQL Export failed

$ sqlexport -d fictional_db my_table my_file<---No effect

$ sqlexport -s fictional_s my_table my_file

Error: Row: 1 -- no such table: fictional_s.my_table

SQL import failed

Shouldn't, in all above cases, the -d and -s params have no effect?

Additionally, if one of the params has no effect on the executed command, this should be mentioned in the manual somehow.

For instance in case of the \connect command, the fact that the -auth, -ca, -ct params applly only to certain DB servers is mentioned in the NOTES section of the manual.

All Comments (2) Change History

JennyNishimura 2012-12-07T20:14:26Z

Updated the following commands to ignore the database and schema options for SQLite:
- describe
- list
- sqlexport
- sqlimport

aquaclusters.josekibold 2012-12-13T22:00:35Z

Verified using ADStudio 12 Alpha 5, the -d & -s params are now ignored for all the mentioned cmds.

The documentation proposal was moved to a new issue: #8073.

Closed.

Search Tips

Aqua Data Studio / nhilam

SQLite -d and -s params on related commands

Issue #8032

Completion

Search Tips

Aqua Data Studio / nhilam

Title

SQLite -d and -s params on related commands

Issue #8032

Completion