Closed
Description
Introduction
If I use select with multiple case when construct I do not get the expected behavior. I tested with severla older versions but it has the same problem. Tried some workaround but this time I have no clue to mitigate the problem.
This is no special problem with one component and testing against a database works as expected.
To Reproduce
List of steps to reproduce the behavior. Include the sql file you are using and the eventual relevant parts of your database schema
select
'text' as component;
select
'The value of y: ' || $y as contents;
select
case
when $x = 't1'
then 'value of x: ' || $x || ' - value of y: ' || $y
when $x = 't2'
then 'value of x: ' || $x || ' - value of y: ' || $y
else
'Unknown'
end as contents,
TRUE as break;
--
select
'divider' as component;
--
select
'text' as component;
select
'The value of y is ' || $y as contents;
select
case $x
when 't1'
then 'value of x: ' || $x || ' - value of y: ' || $y
when 't2'
then 'value of x: ' || $x || ' - value of y: ' || $y
--when $z = 't3'
-- then 'text t3: ' || $y
else
'Unknown'
end as contents,
TRUE as break;
--
select
'divider' as component;
--
select
'debug' as component;
select $x as x;
select $y as y;
--select $z as z;Actual behavior
Different output - I attache some screenshots
your error message here
Screenshots
Expected behavior
A clear and concise description of what you expected to happen.
Version information
- OS:
- Database [e.g. SQLite, Postgres]
- SQLPage Version [found when hovering the default footer of pages]:
Additional context
Add any other context about the problem here.