Skip to content

specific query - will make the application not respond anymore #1363

@flcatalin

Description

@flcatalin

Details for the issue

running the query, will make the application not to respond anymore (3.10.1 portable):

WITH RECURSIVE dates(date) AS (
VALUES('2018-04-06')
UNION ALL
SELECT date(date)
FROM dates
WHERE date < '2018-04-10'
)
SELECT date FROM dates;

Useful extra information

correct query is:

WITH RECURSIVE dates(date) AS (
VALUES('2018-04-06')
UNION ALL
SELECT date(date, '+1 day')
FROM dates
WHERE date < '2018-04-10'
)
SELECT date FROM dates;

I'm opening this issue because:

  • DB4S is crashing
  • DB4S has a bug
  • DB4S needs a feature
  • DB4S has another problem

I'm using DB4S on:

  • Windows: ( version: ___ )
  • Linux: ( distro: ___ )
  • Mac OS: ( version: ___ )
  • Other: ___

I'm using DB4S version:

  • 3.10.1
  • 3.10.0
  • 3.9.1
  • Other: ___

I have also:

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions