[SA 9.0.199 Pro] - Auto Complete [FIXED]

[SA 9.0.199 Pro] - Auto Complete [FIXED]

In SQLite, when Auto Complete - Always Fully Qualify Object Names is set to With schema name SA appends the schema name main to temporary tables instead of temp, which in turn leads to no such table errors.

Last edited by gemisigo on Fri Mar 03, 2017 7:55 am; edited 1 time in total

May I ask for a code snippet that can be used to reproduce this issue?

Sure. It's pretty simple:

	Code:
	-- PRAGMA temp_store = 2; DROP TABLE IF EXISTS var_fn; CREATE TEMP TABLE IF NOT EXISTS var_fn (name text PRIMARY KEY ,value text);

Now type SELECT and select var_fn from the popup. With Auto Complete - Always Fully Qualify Object Names set to With schema name I get the following:

	Code:
	SELECT vf."name", vf."value" FROM main.var_fn AS vf

And that fails upon execution with :

	Quote:
	Execute: ODBC Error (1): SQLExecDirectW Client: 0.9995 Server: 3.15.2 SQL State: HY000 no such table: main.var_fn (1); SELECT vf."name", vf."value" FROM main.var_fn AS vf

This one is fixed, thank you very much.