Cannot seem to parse SQL2 query in Markdown with where clause

[johan....@gmail.com]

Hi, 

I'm trying to construct a very simple query in Markdown (slamdown) that looks like this:

Test !``SELECT type FROM `/mydb` where payload.id = "1729016"``

But when I execute this query I get this error:

Parsing a SQL² query embedded in Markdown failed.

The query:

SELECT type FROM `/mydb` where payload.id = "1729016"

Failed to parse with the following error:

Expected EOF

Go back to the previous card and edit the query to fix this error.

If I instead paste the exact same query into a Query card it seems to work. Also if I remove the where clause it seem to work when in Slamdown as well. What might I be doing wrong?

Regards

/Johan

[do...@slamdata.com]

Hi Johan, can you please let me know what version of SlamData you're using. I've tried a similar query on a couple of recent versions of SlamData and have not had any issues. It could be that you're on an old version of SlamData and we've already fixed this issue.

[Johan Haleby]

Thanks for the reply, I'm using version 4.2.4.

--
You received this message because you are subscribed to a topic in the Google Groups "SlamData-User" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/slamdata-user/xafW7G2Hh24/unsubscribe.
To unsubscribe from this group and all its topics, send an email to slamdata-user+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/slamdata-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/slamdata-user/98b3a40f-7ca2-477d-bf6c-8a032980a601%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[do...@slamdata.com]

I tried running the query in 4.2.4 and didn't get the error, so something does seem weird. There were some problems in the MarkDown processing of SQL in that version around variables, although you're not using variables in your posted query, that started with a SQL keyword throwing errors like you show. You could try to escape type in backticks as follows:

test !``SELECT `type` from `/mydb` where payload.id = "1729016"``

Cheers!

On Thursday, October 19, 2017 at 6:55:58 AM UTC-6, Johan Haleby wrote:

Thanks for the reply, I'm using version 4.2.4.

On Wed, Oct 18, 2017 at 11:34 PM, <do...@slamdata.com> wrote:

Hi Johan, can you please let me know what version of SlamData you're using. I've tried a similar query on a couple of recent versions of SlamData and have not had any issues. It could be that you're on an old version of SlamData and we've already fixed this issue.

On Wednesday, October 18, 2017 at 10:58:45 AM UTC-6, johan....@gmail.com wrote:

Hi, 

I'm trying to construct a very simple query in Markdown (slamdown) that looks like this:

Test !``SELECT type FROM `/mydb` where payload.id = "1729016"``

But when I execute this query I get this error:

Parsing a SQL² query embedded in Markdown failed.

The query:

SELECT type FROM `/mydb` where payload.id = "1729016"

Failed to parse with the following error:

Expected EOF

Go back to the previous card and edit the query to fix this error.

If I instead paste the exact same query into a Query card it seems to work. Also if I remove the where clause it seem to work when in Slamdown as well. What might I be doing wrong?

Regards

/Johan

--
You received this message because you are subscribed to a topic in the Google Groups "SlamData-User" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/slamdata-user/xafW7G2Hh24/unsubscribe.

To unsubscribe from this group and all its topics, send an email to slamdata-use...@googlegroups.com.