Can not create view with quoted name if: 1) it has length = 16, and 2) starts
from 15 non-ascii characters and 3) last character is '#'
---------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5215
URL: http://tracker.firebirdsql.org/browse/CORE-5215
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation, Engine
Affects Versions: 3.0.0, 4.0 Initial
Reporter: Pavel Zotov
Attachments:
can-not-create-view-with-quoted-name-when-final-char-is-#.PNG,
can-not-create-view-with-quoted-name-when-final-char-is-#.sql.7z
I use connection charset = win1252 and want to create view with strange name:
1) first 15 characters are from win1252 and all are non-ascii: ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎ
2) 16th character is from top-row of keyboard when SHIFT key is down:
!@#$%^&*...
All fine except ONE character - #
Script in attachment.
Console output (chcp 1252; see also in attached screenshot):
===
Statement failed, SQLSTATE = 42S02
unsuccessful metadata update
-RECREATE VIEW ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎ# failed
-SQL error code = -607
-Invalid command
-View ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎ# does not exist
===
OS: Windows XP.
WI-V3.0.0.32496
WI-T4.0.0.150
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
