Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/vendor/phpmyadmin/sql-parser/tests/data/bugs/ |
Upload File : |
{
"query": "INSERT INTO\n tbproject(`id`, `name`, `description`, `create_dt`, `dbtype`, `useclause`, `sync_comments`)\nVALUES\n (NULL, 'testdb', 'Descrizione test', NOW(), 'mySQL', '', 1);",
"lexer": {
"@type": "PhpMyAdmin\\SqlParser\\Lexer",
"str": "INSERT INTO\n tbproject(`id`, `name`, `description`, `create_dt`, `dbtype`, `useclause`, `sync_comments`)\nVALUES\n (NULL, 'testdb', 'Descrizione test', NOW(), 'mySQL', '', 1);",
"len": 175,
"last": 175,
"list": {
"@type": "PhpMyAdmin\\SqlParser\\TokensList",
"tokens": [
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "INSERT",
"value": "INSERT",
"keyword": "INSERT",
"type": 1,
"flags": 35,
"position": 0
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 6
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "INTO",
"value": "INTO",
"keyword": "INTO",
"type": 1,
"flags": 3,
"position": 7
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 11
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "tbproject",
"value": "tbproject",
"keyword": null,
"type": 0,
"flags": 0,
"position": 14
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 23
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`id`",
"value": "id",
"keyword": null,
"type": 8,
"flags": 2,
"position": 24
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 28
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 29
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`name`",
"value": "name",
"keyword": null,
"type": 8,
"flags": 2,
"position": 30
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 36
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 37
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`description`",
"value": "description",
"keyword": null,
"type": 8,
"flags": 2,
"position": 38
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 51
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 52
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`create_dt`",
"value": "create_dt",
"keyword": null,
"type": 8,
"flags": 2,
"position": 53
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 64
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 65
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`dbtype`",
"value": "dbtype",
"keyword": null,
"type": 8,
"flags": 2,
"position": 66
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 74
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 75
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`useclause`",
"value": "useclause",
"keyword": null,
"type": 8,
"flags": 2,
"position": 76
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 87
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 88
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`sync_comments`",
"value": "sync_comments",
"keyword": null,
"type": 8,
"flags": 2,
"position": 89
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 104
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 105
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "VALUES",
"value": "VALUES",
"keyword": "VALUES",
"type": 1,
"flags": 35,
"position": 106
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 112
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 115
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NULL",
"value": "NULL",
"keyword": "NULL",
"type": 1,
"flags": 3,
"position": 116
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 120
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 121
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'testdb'",
"value": "testdb",
"keyword": null,
"type": 7,
"flags": 1,
"position": 122
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 130
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 131
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'Descrizione test'",
"value": "Descrizione test",
"keyword": null,
"type": 7,
"flags": 1,
"position": 132
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 150
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 151
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOW",
"value": "NOW",
"keyword": "NOW",
"type": 1,
"flags": 33,
"position": 152
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 155
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 156
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 157
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 158
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'mySQL'",
"value": "mySQL",
"keyword": null,
"type": 7,
"flags": 1,
"position": 159
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 166
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 167
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "''",
"value": "",
"keyword": null,
"type": 7,
"flags": 1,
"position": 168
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 170
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 171
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "1",
"value": 1,
"keyword": null,
"type": 6,
"flags": 0,
"position": 172
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 173
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ";",
"value": ";",
"keyword": null,
"type": 9,
"flags": 0,
"position": 174
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": null,
"value": null,
"keyword": null,
"type": 9,
"flags": 0,
"position": null
}
],
"count": 54,
"idx": 54
},
"delimiter": ";",
"delimiterLen": 1,
"strict": false,
"errors": []
},
"parser": {
"@type": "PhpMyAdmin\\SqlParser\\Parser",
"list": {
"@type": "@1"
},
"statements": [
{
"@type": "PhpMyAdmin\\SqlParser\\Statements\\InsertStatement",
"into": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\IntoKeyword",
"type": null,
"dest": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": "tbproject",
"column": null,
"expr": "tbproject",
"alias": null,
"function": null,
"subquery": null
},
"columns": [
"id",
"name",
"description",
"create_dt",
"dbtype",
"useclause",
"sync_comments"
],
"values": null,
"fields_options": null,
"fields_keyword": null,
"lines_options": null
},
"values": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\ArrayObj",
"raw": [
"NULL",
"'testdb'",
"'Descrizione test'",
"NOW()",
"'mySQL'",
"''",
"1"
],
"values": [
"NULL",
"testdb",
"Descrizione test",
"NOW()",
"mySQL",
"",
"1"
]
}
],
"set": null,
"select": null,
"with": null,
"onDuplicateSet": null,
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": []
},
"first": 0,
"last": 51
}
],
"brackets": 0,
"strict": false,
"errors": []
},
"errors": {
"lexer": [],
"parser": []
}
}