By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `test_table` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`booleanField` BOOLEAN,
PRIMARY KEY (`id`)
);
CREATE PROCEDURE test_procedure1(
IN DATA JSON
)
BEGIN
SET @someBoolean = JSON_UNQUOTE(JSON_EXTRACT(DATA, '$.someBoolean'));
INSERT INTO test_table (
booleanField
) VALUES (
@someBoolean = 'true'
);
SELECT
@someBoolean AS receivedValue,
id,
booleanField
FROM test_table;
END
CREATE PROCEDURE test_procedure2(
IN DATA JSON
)
BEGIN
SET @someBoolean := JSON_UNQUOTE(JSON_EXTRACT(DATA, '$.someBoolean')) = 'true';
INSERT INTO test_table (
booleanField
) VALUES (
@someBoolean
);
SELECT
@someBoolean AS receivedValue,
id,
booleanField
FROM test_table;
END
CALL test_procedure1('{"someBoolean": true}');
CALL test_procedure2('{"someBoolean": true}');
CALL test_procedure1('{"someBoolean": false}');
CALL test_procedure2('{"someBoolean": false}');
| receivedValue | id | booleanField |
|---|---|---|
| true | 1 | 1 |
| receivedValue | id | booleanField |
|---|---|---|
| 1 | 1 | 1 |
| 1 | 2 | 1 |
| receivedValue | id | booleanField |
|---|---|---|
| false | 1 | 1 |
| false | 2 | 1 |
| false | 3 | 0 |
| receivedValue | id | booleanField |
|---|---|---|
| 0 | 1 | 1 |
| 0 | 2 | 1 |
| 0 | 3 | 0 |
| 0 | 4 | 0 |