recimo da imam tablicu ovako kreiranu i napunjenu:
Code:
CREATE TABLE `test`
(
`IDTest` INT NOT NULL AUTO_INCREMENT,
`TestKolona` INT NULL,
PRIMARY KEY (`IDTest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
INSERT INTO `test` (TestKolona) VALUES (4);
INSERT INTO `test` (TestKolona) VALUES (2);
INSERT INTO `test` (TestKolona) VALUES (NULL);
CREATE TABLE `test`
(
`IDTest` INT NOT NULL AUTO_INCREMENT,
`TestKolona` INT NULL,
PRIMARY KEY (`IDTest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
INSERT INTO `test` (TestKolona) VALUES (4);
INSERT INTO `test` (TestKolona) VALUES (2);
INSERT INTO `test` (TestKolona) VALUES (NULL);
Pokušavam natjerati slijedeći upit da radi, ali neće pa neće:
Code:
SELECT
IDTest
, CAST(COALESCE(TestKolona, 3) AS INT) AS TestKolona
FROM test;
SELECT
IDTest
, CAST(COALESCE(TestKolona, 3) AS INT) AS TestKolona
FROM test;
Naime COALESCE u ovom slučaju iz nekog razloga ne vraća INT, pa mi se ta kolona ne mapira dobro u aplikaciji, što sam htio popraviti CAST-om u int.
Gdje sam pogriješio?
Marko
http://www.dropbox.com/referrals/NTQ0MTI2NDc5
https://www.agronomija.info/
Failure is not an option. It comes bundled with your Microsoft product.
https://www.agronomija.info/
Failure is not an option. It comes bundled with your Microsoft product.