Debian Codegraph @

mysql-test/suite/json/r/json_table_notembedded.result

raw
1 create database db;
2 use db;
3 create table t (a text);
4 insert into t values ('{"foo":"bar"}');
5 create user u@localhost;
6 grant select (a) on db.t to u@localhost;
7 connect con1,localhost,u,,db;
8 select a from t;
9 a
10 {"foo":"bar"}
11 select * from t, json_table(t.a, '$' columns(f varchar(20) path '$.foo')) as jt;
12 a f
13 {"foo":"bar"} bar
14 select * into outfile 'f' from json_table('[]', '$' columns(x for ordinality)) q;
15 ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation
16 connection default;
17 disconnect con1;
18 drop user u@localhost;
19 drop database db;
20 use test;