FilesExpand file tree

 main

/

mysql.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

39 lines (30 loc) · 1.41 KB

 main

/

mysql.js

Top

File metadata and controls

• Code
• Blame

39 lines (30 loc) · 1.41 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

'use strict';

const { expect } = require('chai');

const { Parser } = require('../../');

describe('MySQL SQL extensions', () => {

const parser = new Parser();

it('should parse SQL_CALC_FOUND_ROWS', () => {

const ast = parser.parse('SELECT SQL_CALC_FOUND_ROWS col FROM t');

expect(ast.options).to.eql(['SQL_CALC_FOUND_ROWS']);

});

it('should parse SQL_CACHE/SQL_NO_CACHE', () => {

let ast = parser.parse('SELECT SQL_CACHE col FROM t');

expect(ast.options).to.eql(['SQL_CACHE']);

ast = parser.parse('SELECT SQL_NO_CACHE col FROM t');

expect(ast.options).to.eql(['SQL_NO_CACHE']);

});

it('should parse SQL_SMALL_RESULT/SQL_BIG_RESULT', () => {

let ast = parser.parse('SELECT SQL_SMALL_RESULT col FROM t');

expect(ast.options).to.eql(['SQL_SMALL_RESULT']);

ast = parser.parse('SELECT SQL_BIG_RESULT col FROM t');

expect(ast.options).to.eql(['SQL_BIG_RESULT']);

});

it('should parse SQL_BUFFER_RESULT', () => {

const ast = parser.parse('SELECT SQL_BUFFER_RESULT col FROM t');

expect(ast.options).to.contain('SQL_BUFFER_RESULT');

});

it('should parse multiple options per query', () => {

const ast = parser.parse('SELECT SQL_CALC_FOUND_ROWS SQL_BIG_RESULT SQL_BUFFER_RESULT col FROM t');

expect(ast.options).to.eql(['SQL_CALC_FOUND_ROWS', 'SQL_BIG_RESULT', 'SQL_BUFFER_RESULT']);

});

});