[MCOL-263] With suspendDatabaseWrite enabled, LDI return an incorrect msg Created: 2016-08-15  Updated: 2016-11-22  Resolved: 2016-11-22

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.0.2
Fix Version/s: 1.0.5

Type: Bug Priority: Minor
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-280 Beta issues Closed
Sprint: 2016-21, 2016-22

 Description   

With suspendDatabaseWrite enabled:

MariaDB [mytest]> load data infile "/tmp/t1.txt" into table t1 fields terminated by "|";
ERROR 1017 (HY000): Can't find file: 't1' (errno: 2 "No such file or directory")

It should return the same messages as DML:

MariaDB [mytest]> insert into t1 values (1);
ERROR 1815 (HY000): Internal error: CAL0002: Writing to the database is disabled.

With suspendDatabaseWrite disabled:

MariaDB [mytest]> load data infile "/tmp/t1.txt" into table t1 fields terminated by "|";
Query OK, 4 rows affected, 1 warning (4.91 sec)
Records: 4 Deleted: 0 Skipped: 0 Warnings: 1

 Comments   
Comment by Daniel Lee (Inactive) [ 2016-11-22 ]

Build verified: 1.0.5-1

mcsadmin> getsoft
getsoftwareinfo Tue Nov 22 10:13:49 2016

Name : mariadb-columnstore-platform
Version : 1.0.5
Release : 1
Architecture: x86_64
Install Date: Tue 22 Nov 2016 10:10:12 AM CST
Group : Applications/Databases
Size : 9990112
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.5-1.src.rpm
Build Date : Mon 21 Nov 2016 07:29:37 PM CST

MariaDB [mytest]> load data infile "/data/qa/autopilot/data/source/dbt3/1g/nation.tbl" into table nation fields terminated by "|";
ERROR 1815 (HY000): Internal error: Writing to the database is disabled.

MariaDB [mytest]> insert into t2 values (1,1,1,1);
ERROR 1815 (HY000): Internal error: CAL0002: Writing to the database is disabled.
MariaDB [mytest]>

Generated at Thu Feb 08 02:19:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.