#
# Test case migrated from regression test suite:
# ./mysql/queries/100GB/dataValidation/dataval.002.sql
#
# Author: Susil, susil.behera@mariadb.com
#

-- source ../include/have_columnstore.inc

USE tpch1;

# Validate that the customer name is on the right row for all customers.  Count should be 0.
select count(*) from customer where c_custkey != substr(c_name, 10, 99) + 0;