Bugs item #1841372, was opened at 2007-11-30 02:04 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841372&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: MonetDB5 5.2 >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: mharrison (matt_harrison) Assigned to: Niels Nes (nielsnes) Summary: Sequences can't start with Capital names.... Initial Comment: For some reason, sequences can have capital names... CREATE SEQUENCE "Foo" AS INTEGER; sql>select next value for Foo; !NEXT VALUE FOR: no such sequence 'sys'.'foo' Timer 0.286 msec 0 rows Lowercase works fine sql>CREATE SEQUENCE "foo" AS INTEGER; Timer 383.992 msec 0 rows sql>select next value for foo; +--------------------+ |next_value_for_sys | +====================+ |1 | +--------------------+ Timer 73.789 msec 1 rows ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2007-11-30 11:20 Message: Logged In: YES user_id=963970 Originator: NO The standard prescribes this behaviour. Ideally you should quote all of your identifiers. ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2007-11-30 08:18 Message: Logged In: YES user_id=43556 Originator: NO You use quoted names for your create statements, that means they are used as is. But you do not quote your identifiers in your select next value for call, this means it will 'cast it too lower case and compare it with the sequence names', later is there because upper and lower case names should be triated equally (for unquote identifiers). Could you try that and report if that fails (then that is a bug) else this is the intended semantics. ---------------------------------------------------------------------- Comment By: mharrison (matt_harrison) Date: 2007-11-30 02:19 Message: Logged In: YES user_id=1164236 Originator: YES appears to be an issue with table names as well. So perhaps this is a general bug and not sequence specific. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841372&group_id=56967 ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
