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": "CREATE TABLE `mytable` (\n `id` int(11) NOT NULL,\n `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP\n);",
"lexer": {
"@type": "PhpMyAdmin\\SqlParser\\Lexer",
"str": "CREATE TABLE `mytable` (\n `id` int(11) NOT NULL,\n `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP\n);",
"len": 119,
"last": 119,
"list": {
"@type": "PhpMyAdmin\\SqlParser\\TokensList",
"tokens": [
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "CREATE",
"value": "CREATE",
"keyword": "CREATE",
"type": 1,
"flags": 3,
"position": 0
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 6
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "TABLE",
"value": "TABLE",
"keyword": "TABLE",
"type": 1,
"flags": 3,
"position": 7
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 12
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`mytable`",
"value": "mytable",
"keyword": null,
"type": 8,
"flags": 2,
"position": 13
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 22
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 23
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 24
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`id`",
"value": "id",
"keyword": null,
"type": 8,
"flags": 2,
"position": 29
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 33
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "int",
"value": "INT",
"keyword": "INT",
"type": 1,
"flags": 11,
"position": 34
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 37
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "11",
"value": 11,
"keyword": null,
"type": 6,
"flags": 0,
"position": 38
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 40
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 41
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 42
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 50
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 51
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`created_at`",
"value": "created_at",
"keyword": null,
"type": 8,
"flags": 2,
"position": 56
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 68
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "timestamp",
"value": "timestamp",
"keyword": "TIMESTAMP",
"type": 1,
"flags": 41,
"position": 69
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 78
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "6",
"value": 6,
"keyword": null,
"type": 6,
"flags": 0,
"position": 79
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 80
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 81
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 82
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 90
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT",
"value": "DEFAULT",
"keyword": "DEFAULT",
"type": 1,
"flags": 35,
"position": 91
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 98
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "CURRENT_TIMESTAMP",
"value": "CURRENT_TIMESTAMP",
"keyword": "CURRENT_TIMESTAMP",
"type": 1,
"flags": 35,
"position": 99
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 116
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 117
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ";",
"value": ";",
"keyword": null,
"type": 9,
"flags": 0,
"position": 118
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": null,
"value": null,
"keyword": null,
"type": 9,
"flags": 0,
"position": null
}
],
"count": 34,
"idx": 34
},
"delimiter": ";",
"delimiterLen": 1,
"strict": false,
"errors": []
},
"parser": {
"@type": "PhpMyAdmin\\SqlParser\\Parser",
"list": {
"@type": "@1"
},
"statements": [
{
"@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement",
"name": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": "mytable",
"column": null,
"expr": "`mytable`",
"alias": null,
"function": null,
"subquery": null
},
"entityOptions": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": []
},
"fields": [
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": "id",
"isConstraint": null,
"type": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
"name": "INT",
"parameters": [
"11"
],
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": []
}
},
"key": null,
"references": null,
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": {
"1": "NOT NULL"
}
}
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": "created_at",
"isConstraint": null,
"type": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
"name": "TIMESTAMP",
"parameters": [
"6"
],
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": []
}
},
"key": null,
"references": null,
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": {
"1": "NOT NULL",
"2": {
"name": "DEFAULT",
"equals": false,
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": null,
"expr": "CURRENT_TIMESTAMP",
"alias": null,
"function": null,
"subquery": null
},
"value": "CURRENT_TIMESTAMP"
}
}
}
}
],
"with": null,
"select": null,
"like": null,
"partitionBy": null,
"partitionsNum": null,
"subpartitionBy": null,
"subpartitionsNum": null,
"partitions": null,
"table": null,
"return": null,
"parameters": null,
"body": [],
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": {
"6": "TABLE"
}
},
"first": 0,
"last": 32
}
],
"brackets": 0,
"strict": false,
"errors": []
},
"errors": {
"lexer": [],
"parser": []
}
}