test_reference.sql

/*
Copyright (C) 2016 Centro de Computacao Cientifica e Software Livre
Departamento de Informatica - Universidade Federal do Parana - C3SL/UFPR

This file is part of HOTMapper.

HOTMapper is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

HOTMapper is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with HOTMapper.  If not, see <https://www.gnu.org/licenses/>.
*/

CREATE TABLE test_reference (
    id              SERIAL,
    random_string   VARCHAR(16) NOT NULL
);

COPY 25000 RECORDS INTO "sys"."test_reference" FROM stdin USING DELIMITERS ';','\n';

0;vcunt
1;atrxvvhvg
2;mzeac
3;qgme
4;hgr
5;aajogajmcmi
6;grpnwn
7;mzcbptnkdzhs
8;kmz
9;hfcpinqqw
10;dktrqxqmoiioo
11;yciljoi
12;ofsyzukyyo
13;nqczkizfpvequp
14;lwyoatwt
15;klnpmvhk
16;eniafvwjq
17;lnxbpbtrldffqtl
18;fpfpc
19;tsezfflmvelca
20;qssaaqpwoxrirg
21;ahybxhpmzirf
22;pnhpkut
23;sovogkygri
24;xwefxmsd
25;hhmijvfwhf
26;jyxf
27;nxhimmrytnrf
28;ooyqltdebpwqtwg
29;nghhsldw
30;ndxdagcwkvepnix
31;ebhtsdimeva
32;yfkudzphbghbt
33;dbfehm
34;tpglitkjycle
35;kyig
36;jmwiut
37;vbdbubyvyylp
38;jyalqarzmjxdxh
39;tqyphlz
40;xhslmjp
41;izcndkv
42;qtwfhpqugjw