07-05-2025 03:31 AM
hii everyone , i just want to know that in this course outline no. 6.2.3 lab question no. 7 after write the query : SELECT * FROM shapes WHERE color = 'red' . It still show me use color = in where clause . is this problem comes in only my device if yes then give me the solution to resolve it.
07-06-2025 02:48 PM - edited 07-07-2025 02:46 PM
This is not specific to you, effectively there's a problem (regression?) in the test, since start of July many people got the same problem as seen on Stack Overflow or Reddit.
As the post on Stack Overflow got deleted, along with my answer, I'll reproduce it here:
The challenge is bugged.
To display the hint, the page verifies that the reduced structure that will get displayed in the hint (color =, note it is trimmed down, starting with a c and ending with an
If you look closely, you'll see that it is looking for a \s+ after the =, that is, at least one space. Which misses from the trimmed down structural keywords. So it will always fail, not even on your SQL, but on the expression they hardcode as the expected structure of your SQL.
Just hack the page. This validation code is superficial, just for giving a hint, not what will validate that your solution is correct and allow your test to be marked "passed" and saved.
So when the grayed button Next appears, use your browser's inspector to find it in the DOM of the HTML page, and remove its disabled and aria-disabled HTML attributes.
Then you can click on Next: it will save your (correct) answer and get to the next problem.
But it will be tedious: at least the 3 next tests use this bugged validation. I didn't try to go further.
Fix the Javascript (or make clear this is an SQL and DOM hacking assessment).
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide