On Wed, Jun 06, 2012 at 12:55:42PM +0000, Molenaar, Gijs wrote:
I have an issue with getting all the Django tests working with MonetDB. Django assumes a database can have a column with a hyphen in it's name, as long as it is correctly escaped.
It is this specific test which should generate valid SQL when passed trough the MonetDB Django backend: https://github.com/django/django/blob/master/tests/modeltests/reserved_names...
Does MonetDB support a hyphen in it's column name, if so, how do I escape this correctly?
I guess, MonetDB does not allow hyphens in identifiers, even when quoted: sql>create table t (a-b int); 42000!syntax error, unexpected '-' in: "create table t (a-" sql>create table t ("a-b" int); Invalid identifier 'a-b' Stefan
-- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |