xref: /OpenGrok/opengrok-indexer/src/test/resources/sources/sql/test.sql (revision 2bcacabbe843448903326d34ff21a265b5f37596)
1*2bcacabbSAdam HornacekCREATE TABLE foo (
2*2bcacabbSAdam Hornacek   col1 INT NOT NULL PRIMARY KEY,
3*2bcacabbSAdam Hornacek   col2 VARCHAR(100)
4*2bcacabbSAdam Hornacek);
5*2bcacabbSAdam Hornacek
6*2bcacabbSAdam HornacekSELECT * FROM foo;
7*2bcacabbSAdam Hornacek
8*2bcacabbSAdam HornacekINSERT INTO foo (col1, col2) VALUES (1, 'something'), (5, 'something else');
9*2bcacabbSAdam Hornacek
10*2bcacabbSAdam Hornacek-- This is an SQL comment with a email address: username@example.com
11*2bcacabbSAdam HornacekDELETE FROM foo WHERE id=5;
12*2bcacabbSAdam Hornacek
13*2bcacabbSAdam HornacekSELECT COUNT(col1) FROM foo;
14*2bcacabbSAdam Hornacek
15*2bcacabbSAdam Hornacek-- This en an SQL comment with strange characters: <, > and &
16*2bcacabbSAdam HornacekDROP TABLE "foo";
17*2bcacabbSAdam Hornacek
18*2bcacabbSAdam HornacekCREATE TABLE "foo""";
19*2bcacabbSAdam Hornacek
20*2bcacabbSAdam Hornacek/* Other supported comment */
21*2bcacabbSAdam HornacekSELECT 123.45 + 543E-2 FROM DUAL;
22*2bcacabbSAdam Hornacek
23*2bcacabbSAdam Hornacek/* /* Comment inside comment */ */
24*2bcacabbSAdam Hornacek
25*2bcacabbSAdam Hornacek-- Text values:
26*2bcacabbSAdam HornacekINSERT INTO foo(col2) VALUES ('this'), ('and this'), ('and '' too');
27