can't handle group_concat syntax

[zhenfang Zhang]

Originally reported on Google Code with ID 122

What steps will reproduce the problem?
1. suppose I have a table cnbus
2. there is a column named xid
3. select group_concat(xid) from cnbus -- doesn't work.

What is the expected output? What do you see instead?
expected: a group concat xid string

instead: There is a problem with the syntax of your query (Query was not executed)
select group_concat(xid) from cnbus 

What version of the product are you using? On what operating system?
1.9.2

Please provide any additional information below.

Reported by fangzhzh on 2012-10-20 20:22:03

<hr> * Attachment: ScreenClip.png<br>

[Christopher Kramer]

Thanks for your issue report.

Unfortunately, I am not able to reproduce this issue (see screenshot attached). Could
you please provide:
- the CREATE TABLE statement of your table (see structure tab), especially the data
type of column xid
- SQLite version, SQLite extension and PHP version as displayed on the overview page
of your database (click on the database on the left to see it)

Thanks a lot for your help.

Reported by crazy4chrissi on 2012-10-20 20:49:07

<hr> * Attachment: issue_122.png<br>

[Christopher Kramer]

Could you please provide us some more information?

Reported by crazy4chrissi on 2012-10-30 22:13:51

[Christopher Kramer]

Hmm.... without any more feedback, I guess I am going to close this issue soon as I
am unable to reproduce it.

Reported by crazy4chrissi on 2012-11-15 15:38:27

[Former user]

it's ok in 1.9.4. and it must be fine any version

Reported by ykorotia on 2013-02-27 00:38:13

[Christopher Kramer]

Right. I am closing this issue as no further feedback on this issue has been given and
we are unable to reproduce it.

If somebody still has problems with group_concat, please post here again and I might
reopen the issue.

Reported by crazy4chrissi on 2013-02-27 13:08:11 - Status changed: Invalid