on 2016 Jan 12 5:22 PM
Hello,
I have a small Bugreport for ADS 12.0.0.0, free Table:
A simple SQL Statement executed in ARC32 like "select * from sometable where year(somedatecolumn) = 2016" fails if the Table has an index on somedatecolumn.
SQL to test:
Create Table BUGTEST(
ID AutoInc,
Somedate TimeStamp);
EXECUTE PROCEDURE sp_CreateIndex90( 'BUGTEST', 'BUGTEST.adi', 'PRIMARY', 'Somedate', '', 2, 1024, NULL );
insert into BUGTEST (Somedate) VALUES (now());
select * from BUGTEST where Year(SomeDate) = Year(now())
This SQL should select one column but it does not! If you change "Year(SomeDate) = Year(now())" to "Year(SomeDate) >= Year(now())" or drop the Index on Somedate it works.
This seems like a bug or am I doing something wrong? In all previous versions everything worked correct.
Kind regards,
Wolfgang Hanke
What next release? Service pack 3? ADS 14?
When? 2020? 2021? later?
After the error was first reported here and before upgrading the first user to ADS12 we changed all relating SQLs from "year(col)=x" to "col between x-01-01 00:00:00 and x-12-31 23:59:59".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
62 | |
12 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.