Developers' Forum

SQL exercise error

 
Picture of Luka Šajn
SQL exercise error
by Luka Šajn - Thursday, 18 October 2018, 12:01 AM
 

When testing the SQL exercises I have noticed an error. If I write:

select * from a where city="Paris";

the CodeRunner yields an error, whereas if I write

select * from a where city like "Paris"

the answer is correct. Does anyone experience the same problem?

Regards, Luka Sajn

Picture of Richard Lobb
Re: SQL exercise error
by Richard Lobb - Thursday, 18 October 2018, 12:07 PM
 

In the sample SQL questions on this site (http://coderunner.org.nz/mod/quiz/view.php?id=194), the following queries both behave as expected on Question 1 (yielding a wrong answer, of course):

select * from customers where city="Paris";

and

select * from customers where city like "Paris"

Obviously in this question selecting from the non-existent table a gives an error.

What question are you testing with and exactly what error do you get? Please include screen dump(s) showing the question, the answer and the result table, and with the test database file attached. If you have changed the template, we'd need to see that, too.

Richard