[SOLVED] sqlite nested comment, /* -- */ (sqlitebrowser..)

kaz2100 · 10-04-2016, 06:22 AM

Hya

to whom it may concern

Software used
sqlitebrowser, sqlite

Problem
After commenting out several lines for debug, things went wrong. (completely zero output)

Documentation reads
This page reads

Quote:

Comments do not nest.

Why I am posting here
Nested comment like

Code:

/*--having count(*) > 1
--order by 1
*/

works. But

Code:

/*--having count(*) > 1
--order by 1*/

chokes.

My understanding was that "nested comment" meant

Code:

/* ... /* ... */ ... */

While

Code:

-- ... -- ...

works!

Closing remark
Have a happy penguin.

robertdaleweir · 10-12-2016, 04:29 PM

Quote:

Originally Posted by kaz2100

Hya

to whom it may concern

Software used
sqlitebrowser, sqlite

Problem
After commenting out several lines for debug, things went wrong. (completely zero output)

Documentation reads
This page reads

Why I am posting here
Nested comment like

Code:

/*--having count(*) > 1
--order by 1
*/

works. But

Code:

/*--having count(*) > 1
--order by 1*/

chokes.

My understanding was that "nested comment" meant

Code:

/* ... /* ... */ ... */

While

Code:

-- ... -- ...

works!

Closing remark
Have a happy penguin.

Hi kaz2100
I think the reason that the second code you setout did not work is because you never had a space
just before the '*/' .

Code:

/*--having count(*) > 1
--order by 1*/

Try it by putting a space before the */ such as

Code:

/*--having count(*) > 1
--order by 1 */

Although not necessary it probably would be good style to leave a space also after the '/*' such as

Code:

/*  --having count(*) > 1
--order by 1*  /

Cheers...

kaz2100 · 10-20-2016, 01:13 AM

Hya

Thanks for your comment. Apology for delay.

I have not investigated in detail, though I will update as soon as I find something new.

cheers