Surprising behavior of SQLite3 "with" query

Thread Rating:

2 Vote(s) - 1.5 Average
1
2
3
4
5

Thread Modes

Surprising behavior of SQLite3 "with" query

dbman007
Unladen Swallow

Posts: 2

Threads: 1

Joined: Aug 2017

Reputation: 0

Aug-11-2017, 07:47 AM

I agree, but the problem is not the way empty result sets are coped with (they behave the same way for select and with-select) but the value assigned to c.description in both cases. Missing these metadata is particularly annoying with recursive CTE.

Find

Messages In This Thread

Surprising behavior of SQLite3 "with" query - by dbman007 - Aug-10-2017, 05:27 PM

RE: Surprising behavior of SQLite3 "with" query - by nilamo - Aug-10-2017, 06:44 PM

RE: Surprising behavior of SQLite3 "with" query - by dbman007 - Aug-11-2017, 07:47 AM

RE: Surprising behavior of SQLite3 "with" query - by nilamo - Aug-11-2017, 02:29 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Basic SQL query using Py: Inserting or querying sqlite3 database not returning data	marlonbown	3	1,481	Nov-08-2022, 07:16 PM Last Post: marlonbown
	Block of code, scope of variables and surprising exception	arbiel	8	3,563	Apr-06-2020, 07:57 PM Last Post: arbiel
	sqlite3 operational error on insert query	jonesin1974	5	4,411	Jun-26-2018, 03:31 PM Last Post: Larz60+

Users browsing this thread: 1 Guest(s)

View a Printable Version

Surprising behavior of SQLite3 "with" query

User Panel Messages

Announcements