[MDEV-12374] connect.vcol fails on Windows Created: 2017-03-27  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Platform Windows, Storage Engine - Connect, Tests, Virtual Columns
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Olivier Bertrand
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

H:\work\server\xxx\mysql-test>perl mysql-test-run.pl connect.vcol
...
connect.vcol                             [ fail ]
        Test ended at 2017-03-27 19:45:42
 
CURRENT_TEST: connect.vcol
mysqltest: At line 13: query 'select * from t1' failed: 1296: Got error 174 'Fil
e boys.txt is not fixed length, len=282 lrecl=48' from CONNECT
 
The result from queries just before the failure was:
create table t1 (
#linenum int(6) not null default 0 special=rowid,
name char(12) not null,
city char(11) not null,
birth date not null date_format='DD/MM/YYYY',
hired date not null date_format='DD/MM/YYYY' flag=36,
agehired int(3) as (floor(datediff(hired,birth)/365.25))
)
engine=CONNECT table_type=FIX file_name='boys.txt' mapped=YES lrecl=47;
select * from t1;
 
 - saving 'H:/work/server/xxx/mysql-test/var/log/connect.vcol/' to 'H:/work/serv
er/xxx/mysql-test/var/log/connect.vcol/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 20 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.



 Comments   
Comment by Olivier Bertrand [ 2017-03-29 ]

Could you attach this test because I don't have it on any of my machines!

BTW, how a test not existing on my distribution can be executed on 10.2?

Comment by Olivier Bertrand [ 2017-03-29 ]

This probably comes to the data file having Unix like line endings. To fix it, the CREATE TABLE should specify the option ENDING=1.

Generated at Thu Feb 08 07:57:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.