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
Bad error messages on SELECT ? FROM [CORE218] #547
Comments
Commented by: Alice F. Bird (firebirds) Date: 2005-12-12 18:46 "expression evaluation not supported" actually means that an Now about your first examples. Provided that CAST could work |
Commented by: Alice F. Bird (firebirds) Date: 2003-08-28 19:06 Upon further experiments, found more incorrect messages / 4) SELECT 'a' + 1 FROM t => expression evaluation not supported CREATE TABLE t1 (id INTEGER, s VARCHAR(100)); 5) SELECT * FROM t1 WHERE s=1 => ok (1 gets converted to string) |
Modified by: Alice F. Bird (firebirds)description: SFID: 796675# Given CREATE TABLE t (id INTEGER); the following statements give corresponding errors: 1) SELECT ? FROM t => Data type unknown While 1) is technically correct, it is misleading in a Tested with FB 1.0.3 and 1.5RC5 on Windows, using IBX => SFID: 796675# Given CREATE TABLE t (id INTEGER); the following statements give corresponding errors: 1) SELECT ? FROM t => Data type unknown While 1) is technically correct, it is misleading in a Tested with FB 1.0.3 and 1.5RC5 on Windows, using IBX |
Modified by: @pcisarVersion: 1.5 RC5 [ 10020 ] Version: 1.0.3 [ 10006 ] Component: Engine [ 10000 ] SF_ID: 796675 => |
Modified by: @pcisarassignee: Dmitry Yemanov [ dimitr ] => |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @pcisarWorkflow: jira [ 10242 ] => Firebird [ 14472 ] |
Commented by: @dyemanov Testing against v2.5: (1) is correct, and the CAST trick does work nowadays. I cannot see any "cannot transliterate" errors. So IMHO only (2) and (3) deserve fixing, I'd prefer to guess the parameter type based on the ID column. |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Submitted by: askln (askln)
SFID: 796675#
Submitted By: askln
Given
CREATE TABLE t (id INTEGER);
the following statements give corresponding errors:
1) SELECT ? FROM t => Data type unknown
2) SELECT id + ? FROM t => expression evaluation not
supported
3) SELECT id * ? FROM t => Array/BLOB/DATE data types
not allowed in arithmetic
While 1) is technically correct, it is misleading in a
sense that user believes that something like SELECT
CAST(? AS INTEGER) might work, which of course does not :)
So I think that only the second message is correct.
Tested with FB 1.0.3 and 1.5RC5 on Windows, using IBX
and IBO.
The text was updated successfully, but these errors were encountered: