Files
sqlpage--sqlpage/tests/sql_test_files/it_works_case_variables.sql
Ophir LOJKINE 668a87764f fix parameter binding order (#825)
* use numbered parameters in sqlite

* implement parameter deduplication

* implement parameter re-duplication for mysql

* Improve error messages on invalid sqlpage function calls. The messages now contain actionable advice.

* simplify extract_set_variable
2025-02-22 14:13:45 +01:00

10 lines
261 B
SQL

-- https://github.com/sqlpage/SQLPage/issues/818
set success = 'It works !';
set failure = 'You should never see this';
select 'text' as component,
case $success
when $success then $success
when $failure then $failure
end AS contents;