New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Problem with column names with Accents and triggers [CORE2227] #2655
Comments
Modified by: @dyemanovsecurity: Developers [ 10012 ] => |
Commented by: @dyemanov What is your connection charset used? |
Commented by: Rui Cruz (rmgdc) ISO8859_1 |
Modified by: Rui Cruz (rmgdc)description: Triggers don't recognize column names with accents. Test case: /* ---------- x ---------------- */ RECREATE TABLE TESTING ( SET TERM §; /* ---------- x ---------------- */ This gives the following error: ISC ERROR CODE:335544343 ISC ERROR MESSAGE: => Triggers don't recognize column names with accents. Test case: /* ---------- x ---------------- */ RECREATE TABLE TESTING ( SET TERM §; /* ---------- x ---------------- */ This gives the following error: ISC ERROR CODE:335544343 ISC ERROR MESSAGE: |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: @pmakowski Firebird version ? because under FB2.1 I can't reproduce it SQL> show trigger TESTING_I; Triggers on Table TESTING: |
Commented by: Rui Cruz (rmgdc) ISQL Version: WI-V2.1.1.17910 Firebird 2.1 ...using IBOConsole or an ODBC driver and any client aplicattion... |
Commented by: Rui Cruz (rmgdc) .. noticed that server version was different from client version and upgrade it.. same problem: |
Commented by: @pmakowski The problem is related to the tool you are using save the file, quit the editor no problem |
Commented by: @asfernandes Philippe, MacOSX build should have a problem, because there is a problem and that test case doesn't work in Windows. |
Commented by: Rui Cruz (rmgdc) Philippe is right.. that test case works using =>ISQL<=. Suggestions? Thanks, |
Commented by: @pmakowski hum, see my other post (test under Vista 32 Firebird 2.1.1) |
Commented by: @asfernandes It doesn't work in isql either. If it's working for you, I believe you are not using a connection charset. |
Modified by: @asfernandesVersion: 2.1.1 [ 10223 ] Version: 2.5 Alpha 1 [ 10224 ] Version: 2.1.0 [ 10041 ] Component: Engine [ 10000 ] |
Commented by: @pmakowski Adriano read what I posted : isn't using a charset ? |
Commented by: @asfernandes > isn't using a charset ? If it's just before RECREATE TABLE, no. Because SET NAMES should be *before* CONNECT or CREATE DATABASE. |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] Fix Version: 2.1.3 [ 10302 ] |
Commented by: @pcisar QA test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Rui Cruz (rmgdc)
Is related to QA241
Triggers don't recognize column names with accents.
Test case:
/* ---------- x ---------------- */
RECREATE TABLE TESTING (
"CÓDIGO" INTEGER
);
SET TERM §;
CREATE TRIGGER TESTING_I FOR TESTING
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW."CÓDIGO" = 1;
END§
/* ---------- x ---------------- */
This gives the following error:
ISC ERROR CODE:335544343
ISC ERROR MESSAGE:
invalid request BLR at offset 22
column CÓDIGO is not defined in table TESTING
Commits: a1628d1 41b4b3a
The text was updated successfully, but these errors were encountered: